How can I save files inside mysql and access them using php?

[Sina]

Dear gurus,

How can I save files inside Mysql?
i.e I have a couple of files (binary) of size 6 to 8 megs.
I'd like to save these files inside mysql database and use php to allow only selected users with correct users id and password to access the files (to download the files).
So basically I have a login script,
Users login, and they can download the files.

Is this possible at all?
If you could give me a hint or a sample script, I'd appricate it.

Thank you all

 

[KarveR]

head over to

http://www.mysql.com

and read up on blob.
head off to

http://www.devshed.com

or

http://www.webmonkey.com

to find a tutorial in doing same.

If yu et stuck , feel free to drop by and let us all pick out the bugs ***************************************
Party on, dudes!

 

[hos2]

you can also make a table where you put the urls in of the file locations. depending on the user you make a query which file id's the user is allowed to see (which you can perhaps add to the user info)and maken hyperlinks to the physical file locations.


$list = mysql_num_rows($rs);
while($i < $list) {
$row = mysql_fetch_array($rs);
$urldescr=$row[&quot;urldescr&quot;];
$urlid=$row[&quot;urlid&quot;];
$urlsite=$row[&quot;urlsite&quot;];
$urlremarks=$row[&quot;urlremarks&quot;];
$totaal=$row[&quot;totaal&quot;];
print&quot;<td valign=top><img src=/images/thumb/$urlid-big.jpg border=0></td>&quot;;
print&quot;<td valign=top><a href=javascript:l2('$urlsite',$urlid)>$urldescr</a><br>$urlremarks</td>&quot;;
print&quot;<td valign=top><br><a href=whlist.php3?whname=$urldescr>$totaal</a></td>&quot;;
print&quot;</tr>&quot;;
$i++;
}
?>

 

[gerrygerry]

All you have to do is store the binary data into a table (store the filename and the data), then when the user wants the file, print the appropriate file header and then the file's data after it... it works great!

/*
 user wants a the file "test.pdf" (a file you have in your table)
*/

$query = "SELECT data FROM files WHERE filename='test.pdf'";
$results = MYSQL_QUERY($query);
if($file = MYSQL_FETCH_ASSOC($results))
{
 Header("Content-type: application/pdf");
 echo $file['data'];
}
else
{
 echo "file not found!"
}

i didn't test any of the above, but you get the idea, right? lemme know if you need more help -gerrygerry
Go To

http://quickfreewebsite.com!