Page 1 of 1

Uploading pictures to a database

Posted: Wed Aug 03, 2005 6:06 pm
by jayluda
I need people to upload their pictures when they register in a form. Can pictures be uploaded to mysql database. If yes, how?

Posted: Wed Aug 03, 2005 7:25 pm
by feyd
yes.. not a good idea though. It's best to store the files within the file system and let mysql manage a link to it.

mysql managing a link to the picture?

Posted: Wed Aug 03, 2005 7:45 pm
by jayluda
how do i go about it? how does mysql manage a link to it?

Posted: Wed Aug 03, 2005 8:01 pm
by feyd
there've been a lot of posts here about this, please search.

Posted: Thu Aug 04, 2005 4:52 am
by s.dot
If you searched, you might have ran across my tutorial

viewtopic.php?t=35972

It walks you through uploading an image to a database, and if you'd like you could include a query to insert the filename to a database, to use that for your link.

Posted: Thu Aug 04, 2005 8:09 am
by josh
scrotaye wrote:If you searched, you might have ran across my tutorial

viewtopic.php?t=35972

It walks you through uploading an image to a database, and if you'd like you could include a query to insert the filename to a database, to use that for your link.
Just read your tutorial, don't like to bump old things so I'll say it here:
You really should be checking mime types not extensions, you should say that in your tutorial too.