saving images in mysql

hello,

does anyone know of a sample code to upload images and save them into a mysql database?
i think im gonna use BLOB for this.

thanks.

Hi,

try to look this thread

see you

ok so far...

but how do i get the temporary uploaded file to read?

i tried that:

$ft=$_FILES["image"]["tmp_name"];

$data = addslashes(fread(fopen($ft, "rb"), filesize($ft)));

$query="INSERT INTO images(id,pid,data,alt,desc) VALUES ('','$row[id]','$data','','')";

but:
fread(): supplied argument is not a valid stream resource

What PHP are you using?

The autoglobal $_FILES exists as of PHP 4.1.0 .
For oldest try just $image...

4.3.0 on windows here

with $image alone it works so far... only i get an mysql error. seems as if the bytestream contains some unwanted characters.

its supposed to be of blob type, right?

1) The error is in insert or with select ?
2) Can you post the error ?

ok... the error was something else. sorry.

now i dont get errors. not at insert and not at select, but the image doesnt show up.

how can i check if the binary data was really inserted in the blob?

edit: from the size of the database it looks like it is saved.
so the problem is probably with the select.

See this article on this site.