Page 1 of 1

searching for stored image in sql

Posted: Thu Jul 03, 2008 2:33 pm
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"

searching for stored image in sql

Posted: Thu Jul 03, 2008 3:05 pm
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.

Re: searching for stored image in sql

Posted: Tue Jul 08, 2008 12:44 pm
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.