Look here http://www.mysql.com/doc/en/BLOB.html
Actually, if you don't care if the images can be view from outside the DB, you can do what I do.
I simplely put the name of the file in a varchar field, then let the browser do the work for you.
This is good for files that are referenced from multiple entries (ie, individual products each referencing the same series image)
but, blob can work fine.
Adam Voigt wrote:
I just use a TEXT field, and am doing so with 25k images, without issue.
On Tue, 2003-07-15 at 18:45, Javier wrote:
Hi everybody, I've trying to store a into a MSSQL Server (7 or 2k) using an example I found on the web (www.php.net).
Is it possible that PHP (4.3.2) just store 4k of data? Because after inserting a test image with:
$oDatos is an object that handles queries.
// storing a file
$datastring = join('',file("logo2.jpg"));
$data = unpack("H*hex", $datastring);
$oDatos->query( "insert into temp_test (test) values ( 0x" . $data['hex'] .")" );
A select will return a 4K file. Is it possible?
$row = $oDatos->getData("select test from temp_test"); //file://$row = mssql_fetch_assoc($result); $fp = fopen('copy.jpg','w');
So... is there anyway to store a file that it is larger than 4K? Or am I missing something? :)
Thanks.
--
*** s2r - public key: (http://leeloo.mine.nu/s2r-gmx.sig)
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
