File upload / download question - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Lafaso870 · 03-25-2011, 02:46 AM

Greetings!
on my site, I have a form for clients to send detailed instructions for projects that I am working on. This information is stored in a mysql db so I can go in and look at the current project information.

What I'm attempting to do is allow users to upload files that need worked on... this file could be anything from an image that needs altered to a spreadsheet. I need to be able to accommodate every file type.

I'm able to store these files in as a BLOB, but am having a heck of a time retrieving and downloading them. I've found very little helpful information about file handling with mysql.

Any help on this would be great! a shove in the right direction!

Also, I was wondering if perhaps simply uploading the files and saving them to the server would be a viable approach? certainly would be simpler. If I did that, would there be security issues involved with people uploading potentially malicious files?

Thanks!

chunnilal · 04-08-2011, 12:05 PM

Security Issue shud not be a concern, as u can always secure the directory u are using.
But still it is not advisable to use flat file system.
DBMS is always a better approach as that enhances the scalability.

chunnilal · 04-08-2011, 12:06 PM

As for SQL, can u post the cod u are using to download the files frm db....
Let us see if we can modify that to give an optimum output