Jump to content


Photo

Downloading files from database


  • Please log in to reply
1 reply to this topic

#1 chico1st

chico1st
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 20 August 2006 - 04:53 AM

okay i have a pdf document in a database which i am downloading using this code.

to take it out i use this code:
print "<a href='download.php?id=$id'>PDF!</a>";

where download.php is :
<?php
if(isset($_GET['id']))
{
// if id is set then get the file with the id from database

include "../../Lib.php";
$dbConn = connectToSpy();

$id    = $_GET['id'];
$query = "SELECT name, type, size, content " .
        "FROM document WHERE documentID = '$id'";

$result = mysql_query($query, $dbConn) or die('Error, image retrieve failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);


header("Content-type: $type");
echo $content;

exit;
}

?>

But i was wondering how i can make a link that directly makes you download the file instead of opening it?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 20 August 2006 - 05:46 PM

You just need to write out the appropriate content headers.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users