By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

How to save file to database using external folders

P: 4
Leave the images themselves in an image folder and store its name in the MySQL table.

how exactly does one do that?
Aug 24 '11 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 100+
P: 2,327
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.
Aug 24 '11 #2

P: 4
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?
Aug 24 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.