Uploading images in MySQL DB using PHP Script

[Rubal Jain]

Hello,

How do I upload images under MySQL DB using PHP Script. Any Sample
script to upload and retrive images to MySQL DB would be appreciated.

Thanks

Rubal Jain
www.Rubal.Net

[Norman Peelman]

"Rubal Jain" <ru*******@yahoo.com> wrote in message
news:7a*************************@posting.google.co m...

Hello,

How do I upload images under MySQL DB using PHP Script. Any Sample
script to upload and retrive images to MySQL DB would be appreciated.

Thanks

Rubal Jain
www.Rubal.Net

Use something like this if you want to store the image as a BLOB:

Store--
UPDATE tablename SET blobfieldname = LOAD_FILE('path:/to/image/image.jpg')
WHERE fieldid = $id LIMIT 1

Retrieve--
$myimg = mysql_fetch_array(mysql_query("SELECT blobfieldname FROM tablename
WHERE fielid = $id LIMIT 1"));

// $myimg[0] now holds your image. send approriate header and simply echo it
to display in browser

Norm

--
Avatar hosting at www.easyavatar.com

[Rubal Jain]

A Complete source would be appreciated..

Thanks

[Norman Peelman]

"Rubal Jain" <ru*******@yahoo.com> wrote in message
news:7a**************************@posting.google.c om...

A Complete source would be appreciated..

Thanks

I'm not sure what you need but I gave you the SQL queries to put an image
into the database and then get and display it. If you need a complete script
then you may need to learn quite a bit more.

--
Avatar hosting at www.easyavatar.com