Downloading a file from MySQL

Downloading a file from MySQL

am 26.05.2007 00:25:29 von Ben C

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;
}

?>


Download File From MySQL




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
";
}
else
{
while(list($id, $name) = mysql_fetch_array($result))
{
?>


}
}
include 'library/closedb.php';
?>



---- Code End ----

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php