searching for stored image in sql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
azhan
Forum Commoner
Posts: 68
Joined: Fri Jun 27, 2008 6:05 am

searching for stored image in sql

Post by azhan »

Hey guys,

Recently i've found a php script regarding with uploading as well retrieving back the image from the sql and both script works. I was wondering where could i find the stored image? i've been searching the data in the mysql folder in C and all i found is pix.frm and pix.myd ( pix is my table name for storing images). Is there any special folder that sql stored all of these images or blob files?

It is because im intended to browse all my stored images in sql and would like to delete, edit, rename etc.

HELP ME!

ps: Do i need to paste all of my codes here?

thanks
Azhan
________________
http://www.productcoverdesign.com- "Cheapest E-cover Design"
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

searching for stored image in sql

Post by jaoudestudios »

The images are probably stored in a directory but just referenced to from the database. I doubt that the files have been converted to base64 and store as a string in the database.

Pasting the code should determine where the files are stored.
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: searching for stored image in sql

Post by Ollie Saunders »

A database such as MySQL doesn't store it's data in a form that you can browse in the filesystem. So no, there aren't any files or folders that you can look in to see the data.

In order to interact with the database you will have to start the MySQL client or write a PHP script and then send SQL commands. I would suggest you read a bit about databases and SQL in general.
Post Reply