File uploads...

Credo

Well, I've finally got my file uploading working, now I'm having two problems:

First One is on the upload. I can upload a picture or a file with an average size of 300, 400k. works great. I open the database, and the file's there, and the file size in the database is consistent with the original file I uploaded. The problem is that I'm going to be using this database/website to upload files approx. 2 - 4Mb in size. I've tried uploading files about 1.3Mb in size, and I get the "or die ('query error') portion of the insert - won't take the file. Is there a setting or something I'm missing? as of now, I have no checks on file sizes, so I know my code isn't restricting the file size. I've got the field type of the database set to BLOB. I've even tried LONGBLOB, and LONGTEXT with no avail. Is it a PHP issue, or MySQL issue?

Second problem is that no matter what I upload, the file seems corrupt after download. file size/extension is still the same from before uploading to the database, but none of the files I download work. I can't open pictures, and I can't open zipped files. Does anyone have ANY suggestions or know of any fixes for this?

Thanks very much in advance!
~C.

rajavel

for the first one check the max_input_time & max_execution_time in your phpinfo()

check for the file permissions for the second one...........

Credo

Originally posted by rajavel
for the first one check the max_input_time & max_execution_time in your phpinfo()

check for the file permissions for the second one...........

The files are being kept in the MySQL database, so every query is running under the "root" login for that specific database. i don't see how it could be permissions...

mdojet

On my site, I have a file upload section too. Pictures work and so does uploading video but only up to about 1.5megs. I had problems with files larger than that. I believe its a limitation that my hosting company has on the Temp folder that the file is put in during the upload process.
I dont put my files in the database. I upload the picture or video into folders and store the URL of where the file is located in the database. I am sure there is more than one way but this is what I did and works fine.