Using PHP to retrieve and display file from MySQL database

From: Date: Sat, 26 May 2007 01:42:56 +0000
Subject: Using PHP to retrieve and display file from MySQL database
Groups: php.general 
Request: Send a blank email to php-general+get-255673@lists.php.net to get a copy of this message
I am trying to download a file from MySQL and display it using the following PHP script, but it isn't displaying the file just a list of files in the database. Please help. ---- Code Begin ---- <? 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"> </head> <body> <? 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 End ----

« previous php.general (#255673) next »