STORING PICS IN MYSQL

[l0ve2hat3]

I have pictures already uploaded in a folder in a server.  What I need to do is convert the files to store them in a mysql database. 

 

could I use file_get_contents to do this?

 

[Northern Flame]

what you do is store the names in your database

and then use a mysql_query() to get the

names from your database then just echo something

like this:

 

$query = mysql_query("SELECT * FROM images");

 

while($image = mysql_fetch_object($query)){

echo "<img src='/folder/". $image->name ."' />";

}

 

[Rohan Shenoy]

Its difficult to store image files in the MySQL database.

Instead just save the url of the image and retrive it as Northen Flame directed in above post.

[benphp]

From what I understand, this is a bad idea. It's possible to do it, but not at all the best way to manage images. Use the above suggestion about storing just the filename/path.

 

[rameshfaj]

There is one alternative to the above mentioned ideas.You can make the database field to hold BLOB rather than varchar and when u store the image in the database it will be stored in binary format.There are many tutorials online about storing BLOB object in database,why dont u try one?

[gdfhghjdfghgfhf]

yep i just went through one of these tutorials about storing images in mysql in BLOB format

 

i also saw a script that will do exactly what you want: take all images you have in a folder and put them in database

 

just search on google with revealent keywords and you will find it

[benphp]

I'm still not sure why you would want to store the images IN the database. There must be a reason, but I can't think of one. If you do, and your images are large, or there are a lot of them, you're asking for trouble.