An Image into MySQL

[asolell]

Hi all,

I have an image file that is in a directory (Linux OS).

/home/www/test/loadimage/mypic.jpg

I have an Image table

CREATE TABLE Image (
Id int(11) DEFAULT '0' NOT NULL,
Image mediumblob NOT NULL,
PRIMARY KEY (Id)
);

How do I load the image into the database?

[dnszero]

Haven't tried it but I think you should be able to just read the whole file into a variable and then insert that in to your table as per usual.

$filename = "/home/www/test/loadimage/mypic.jpg";
$fd = fopen ($filename, "r");
$image = fread ($fd, filesize ($filename));
fclose ($fd);

$sql = "INSERT INTO Image VALUES ('', '$image');

[asolell]

Yeap.. it worked!

Thanks,

-Alon.