curbyourdesign Posted January 27, 2007 Share Posted January 27, 2007 Ok well i'm sure there is plenty of places to find this, but it seems its hard to find a simple answer to my question. I've created a way to upload files to a database using this [url=http://www.php-mysql-tutorial.com/php-mysql-upload.php]http://www.php-mysql-tutorial.com/php-mysql-upload.php[/url]. Its an easy to follow and understand. My question is, where could i modify the code in this tutorial to make it to where i can upload images. To clarify, you can upload any file you want, but it only displays as a text link. It would be nice to upload an image and it display as an image link. Look this webpage that i built [url=http://www.mcneesesga.com/redesign/senate.php]http://www.mcneesesga.com/redesign/senate.php[/url]. You will see the text links under the place that i assigned. If anyone knows a simple way or a easy way to do this, let me know ASAP! Thanks,Patrick EustiscurbyourdesignCreative Director Quote Link to comment https://forums.phpfreaks.com/topic/35974-uploading-to-a-mysql-database-using-php/ Share on other sites More sharing options...
cursed Posted January 27, 2007 Share Posted January 27, 2007 you could specify what types u want, andyou could do <img url="$variable">? Quote Link to comment https://forums.phpfreaks.com/topic/35974-uploading-to-a-mysql-database-using-php/#findComment-170611 Share on other sites More sharing options...
curbyourdesign Posted January 27, 2007 Author Share Posted January 27, 2007 thanks. this is the code for my download.php page. Where do i need to place the <img url="$variable">?[code]<?if(isset($_GET['id'])){ include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; $query = "SELECT name, type, size, content FROM upload WHERE id = '$id'"; $result = mysql_query($query) or die('Error, query failed'); list($name, $type, $size, $content) = mysql_fetch_array($result); header("Content-Disposition: attachment; filename=$name"); header("Content-length: $size"); header("Content-type: $type"); echo $content; include 'library/closedb.php'; exit;}?><html><head><title>Download File From MySQL</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link href="index.css" rel="stylesheet" type="text/css"></head><body class="bdytxt"><?include 'library/config.php';include 'library/opendb.php';$query = "SELECT id, name FROM upload";$result = mysql_query($query) or die('Error, query failed');if(mysql_num_rows($result) == 0){ echo "Database is empty <br>";} else{ while(list($id, $name) = mysql_fetch_array($result)) {?> <a href="download.php?id=<?=$id;?>"><?=$name;?></a> <br><? }}include 'library/closedb.php';?></body></html>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/35974-uploading-to-a-mysql-database-using-php/#findComment-170653 Share on other sites More sharing options...
fenway Posted January 30, 2007 Share Posted January 30, 2007 You're going to need to serve this image; and it's src, not url. Quote Link to comment https://forums.phpfreaks.com/topic/35974-uploading-to-a-mysql-database-using-php/#findComment-172915 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.