Store Images in MySQL Database

Question

I want to know how to store images and files in a MySQL Database.

I want to get images and files like that www.example/rsrc.php/example-image.jpg

example on Facebook: facebook-example.com/rsrc.php/v2/yw/r/svhh826BLKd.png

Storing images in the database is a bad idea. Store references to where they're stored on the filesystem or an object store like Amazon S3. — tadman, Sep 12 '13 at 16:55
I have a social network, and i want to make it like facebook rsrc.php file :) any way, i want to make a CDN for the profile pictures and every picture in my network — Zuckerberg MFSN, Sep 12 '13 at 17:20

johnny · Answer 1 · 2013-09-12T18:23:54.373

14

Create a BLOB column in database table,

probably mediumblob.

but it is good to keep the photo in directory and keep the path in the database. Cheers

 CREATE TABLE tblname(ID INT,IMAGE BLOB);

INSERT INTO tblname(ID,IMAGE) VALUES(1,LOAD_FILE('C:/test.txt'));

added the answer from the comments to this question in the answer box..

edited Sep 12 '13 at 18:23

answered Sep 12 '13 at 16:57

johnny

How do i create that BLOB column table ? :) – Zuckerberg MFSN Sep 12 '13 at 17:09
CREATE TABLE tblname(ID INT ,IMAGE BLOB); – johnny Sep 12 '13 at 18:20
for testing you can insert with this. INSERT INTO tblname(ID,IMAGE) VALUES(1,LOAD_FILE('C:/test.txt')); – johnny Sep 12 '13 at 18:21
Okay, how to get the photo in php ? the photo were placed in the DB ? – Zuckerberg MFSN Sep 12 '13 at 21:49
1

suppose this is ur html tag and want to display image database using PHP. hope it hepls. – johnny Sep 13 '13 at 12:01

1 Answers1