how can we store image in database (mysql with php)

Question

Possible Duplicate:
How can I store and retrieve images from a MySQL database using PHP?

i want store and fetch image from mysql database. is anybody i have knowledge about this.

Thanks in advance. Ravi Sharma

A Google search with that string produces any number of solutions. — Naltharial, Jul 11 '11 at 11:00

score 0 · Answer 1 · answered Jul 11 '11 at 10:58

0

You can store images in a Blob-type column.

Check out the comprehensive tutorial here

answered Jul 11 '11 at 10:58

Rick

172
11

score 0 · Accepted Answer · answered Jul 11 '11 at 10:59

0

You can store the image contents (use file_get_contents function) into field of type BLOB. Another solution to decode binary data with function base64_encode and store in simple TEXT type field.

answered Jul 11 '11 at 10:59

Gedrox

3,512
1
19
29

score 0 · Answer 3 · answered Jul 11 '11 at 10:59

0

You do not want to store images in your database. You want to use the filesystem and only store image meta data in the database, like the filesystem path.

answered Jul 11 '11 at 10:59

wonk0

12,881
1
19
14

how can we store image in database (mysql with php)

3 Answers3