An Image into MySQL

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?

Read the contents of the file,

$img=file("filenam.gif");

insert $file into table.

( This is just off the top of my head, you may have to do somehting different , like binary read, or open a socket )

I know you have to open a socket and read() it if the image is on a remote server.

Yep I was right,

You need to read the file into a string like this:

$filename = "/path/to/somepic.gif";
$fd = fopen ($filename, "rb");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);

then put $content into your table.

Yeap! It worked!

Thanks,

-Alon.