Leave the images themselves in an image folder and store its name in the MySQL table.
how exactly does one do that?
how exactly does one do that?
-
Last edited by Niheel; Aug 24 '11, 06:23 AM. Reason: old thread, moved your question into it's own thread. -
Coetsee, you would create a column in your database called file and in that store the file name.
Once a user uploads a file through the form you can either parse the file and grab the file name to insert it into your table or you can get really creative and create a random file name system and rename the files once they're upload and save the string as your file name.
Then in your application when you need to pull the file you can query for the file name from a folder you've chosen to store your files.
How you upload, parse and save the file name is really dependent on the programming language you use.niheel @ bytes -
Thank you for your reply Niheel. I use Microsoft Access 2007 for the forms and write the data to a linked MySQL Database. Im not sure how to incorporate Visual Basic so that I can choose the files I want to store and then save them to a location folder on the server. Any suggestions?Comment
Comment