Using PHP to retrieve and display file from MySQL database
| From: | benc11@gmail.com | 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 ----