Jump to content

Archived

This topic is now archived and is closed to further replies.

d-shade

Saving images in mysql on to server?

Recommended Posts

Hello Ive been using a modified photo gallery script that saves images into the mysql database. I didn't have too much of an issue at first but now that database is starting to get pretty big and thought maybe I would start running into problem.

So im wondering if there is a way i can make some sort of automated script to go through all the table and dump all the images into folders and also create a new table. with all the info put into it.

these are the feilds im using in my table
Id, Views, Bytes, Format, Caption, Comment, ShotAt, PublishedAt, Width, Height, Image, Thumbnail

the biggest problem im having right now is trying to get the images saved onto the server.
the Image and Thumbnails are both blob feilds and both contain image data.

Share this post


Link to post
Share on other sites
[code=php:0]$result=mysql_query("SELECT * FROM `table`");
while($myrow=mysql_fetch_assoc($result)) {
  $im=imagecreatefromstring($myrow['Image']);
  imagejpeg($im,$myrow['Id'].".jpg",80);
}[/code]

will save all the images to the scripts current directory. after you're satisfied that all the images have been successfully extracted, you can use phpmyadmin to drop the image field across the entire database.

Share this post


Link to post
Share on other sites
alright thanks.
Ill try it out

Update:
It worked out great! Finally got all the images off the mysql database.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.