millwardt Posted February 14, 2007 Share Posted February 14, 2007 Hi Guys, Hoping somebody is able to help me, I'm fairly new to PHP! I have a script for uploading files and inserting them into a MySQL table as blobs which works fine. I can preview the file types in the MySQL browser and they are perfect, however when I download the files, there seem to be some issues. PDF and MP3 work fine, and are displayed / played. Images - JPEG GIF and PNG tell me that the files are corrupted, as do Microsoft Word documents - however they are not corrupt in the database. Any ideas on how to solve this? Thanks Quote Link to comment Share on other sites More sharing options...
s0c0 Posted February 14, 2007 Share Posted February 14, 2007 I can't tell you how to solve your specific problem, but I can give you a best practice. Best practice for storing large files such as images and audio in a database is don't do it. Instead store a link to the file in the database. Experienced database admins will tell you this and most experienced and inexperienced people (like myself) on this forum will tell you this. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.