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 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">? 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] 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. 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
Archived
This topic is now archived and is closed to further replies.