Hello, can anyone help me how to upload images to my database using mysql. i was also wondering if i should create new table for images or i can use the table for the other property information (i need it for real estate site)
coopster
1:36 pm on Feb 4, 2009 (gmt 0)
If you are going to store them in the database you may find that keeping them in their own table will likely improve query performance. Don't forget to store a filename.extension and/or the mime type along with the binary large object itself -- you may need that information in the future, possible for sending appropriate headers with the image data.
As far as the upload process, MySQL does not do the file upload, a server-side scripting language works hand-in-hand with a browser request to handle file uploads [php.net].
