Forums

This topic is locked

Uploading an Image to MySQL

Posted 23 Nov 2006 17:52:38
1
has voted
23 Nov 2006 17:52:38 John Hopper posted:
Hey there

1st post for me so forgive me if this has already been asked - I looked but couldn't find anything!

I'm trying to build a large site for a client at present, and the gallery section requires the ability for each member to upload a selection of photos.

Now I'm a fairly experienced PHP developer but I've never had to store pics in a database before. I've found numerous tutorials online but to be honest they're hard to follow at best even for someone who has an idea of what they're doing.

I know how to do the actual uploading, but I cannot get Dreamweaver MX to set the file field as any other type than 'Text' etc. What type does it need to be for a BLOB and how do I ger Dreamweaver to do this?

The client is adament that the photos must be stored in the database and as he's paying he's the boss - so storing only the filename is not an option.

Can anyone help - I'd really appreciate it!

Thanks in advance

John H

Reply to this topic