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 there1st 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