Blob gif file in a database field

Anon

Hi, I need to display the file size of Blob image from a field in the database.

Is there a way to reconvert the binary field to a file and display the size ?

Thanks

Or the only way is to store the file size at the upload time in a column once the fread is done ?

flipis

Try this one:

$query = "SELECT binary_field FROM table WHERE id = 1"; //Example only
$DoIt = mysql_query($query,$Connection);
$result = mysql_result($DoIt);

$temp = fopen("temp.gif","w");
fputs($temp,$result,strlen($result));
fclose($temp);

$size = filesize("temp.gif");
echo "File size -->".$size;
unlink("temp.gif");

Hope it works

fLIPIS

rbenfield

Personally I think you would be better off storing the file in the filesystem instead of in the database. I understand of course that there are some advantages to storing them in the database. And I know too, that many people feel strongly one way or the other, so please don't take offense if you are very Pro Blob. I just think it is more efficient to use the filesystem and store only the path and filename in the db.

just my $.02,
Richard

flipis

What i do actually, is that. I store the paths to the images in a config file, and the file name corresponding to a row of data in th DB. I think it is better trying not to store EVERYTHING in the DB, because, after a time, a table can contain 600.000 rows, and that's A LOT of them, when you try to do a complex SQL query. The server tends to hang up, but, if not that, queries run very slow (unless you have a great machine)

Personally, i do not store the binary data on the DB, especially if it is very large in size. You do it, fine, but just take a look at the script i gave you. It's much easier replacing it with

$file = "images/".$result;
$size = filesize($file);

fLIPIS