Write image file to database as BLOB (PHP)

Question

I want to enter some image file that is in ../img/test.jpg into the database

If I do $image = file_get_contents('../img/test.jpg')

And then mysql command "INSERT into table(picture) VALUES ('$image')" it doesn't work.

Any suggestions?

And “doesn’t work” means what? Do you get any error messages? — Gumbo
– Gumbo, Commented Jul 13, 2009 at 7:49

Greg · Accepted Answer · 2009-07-13 16:48:06Z

6

You need to escape it properly:

mysql_query('INSERT INTO table (picture) VALUES ("'
    . mysql_real_escape_string($image) . '")');

edited Jul 13, 2009 at 16:48

answered Jul 13, 2009 at 7:53

Greg

323k55 gold badges378 silver badges338 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Greg Over a year ago

Oops, fixed. Too used to "?" style

bucabay · Accepted Answer · 2009-07-13 16:41:34Z

-2

Keep the image on the filesystem. You're making MySQL work too hard sending the image through a socket to your PHP script. Then you make Apache work too hard while PHP is blocking waiting for the image data from MySQL.

I don't see a valid reason why you want to save it as a mysql Blob. It gets written to the filesystem anyway by mysql.

Just save the path in MySQL.

answered Jul 13, 2009 at 16:41

bucabay

5,3032 gold badges28 silver badges37 bronze badges

1 Comment

h0mayun Over a year ago

those who down voted this answer could write a comment and explain why this answer is not good

Collectives™ on Stack Overflow

Write image file to database as BLOB (PHP)

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related