Downloading a file from MySQL

From: Date: Fri, 25 May 2007 22:25:29 +0000
Subject: Downloading a file from MySQL
Groups: php.general 
Request: Send a blank email to php-general+get-255670@lists.php.net to get a copy of this message
I am trying to download a file from MySQL using the following code, but it doesn't display a file just a list of files in the database. Anyone have any suggestions? ---- 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 (#255670) next »