[zoliky]

I have a PHP script to upload files.
Each uploaded file name, size and type are stored in mysql table. I have a table called files_temp (temporary table for uploaded files).

The mySQL table:

Code:

id    name               size       type
1     File.exe          79360     application/x-sdlc
2     File2.exe        12323     application/x-sdlc

I don't store the files as BLOB, i store only the details in mySQL table. I have a separate directory on Web server to store each uploaded file.
I want to check the total size for each uploaded file. PHP need to tell the web browser, hey your files are bigger than 10MB.

Code:

79360 +
12323
-------
91683

I know exist a way to do this using SUM in mySQL but I don't know what I need to do to get the last files uploaded from user.
mysql_insert_id not return more than last row. If more files uploaded more rows created.

Exist a way to check the files size after upload? I don't want to do this only with mySQL, I wait any idea or better suggestions.

Thanks!

[Nico]

Hm, do you want to check the size when uploading? If so, you don't need MySQL. You can simply do.

PHP Code:

if ($_FILES['file']['size'] > 10485760)

{

    echo 'hey your files are bigger than 10MB.';

    exit();

}

else

{

   // Insert into database

} 

[zoliky]

Thanks nico_swd !

Which formula help me to calculate the allowed size?
For example I want 1MB not 10MB.

[Nico]

This might help.

http://www.sengpielaudio.com/calculatorBits.htm

[zoliky]

cool, thanks

[Marcelino]

I don't know how, but I would recommend you to make this kind of script in Java. In this way you could avoid uploading large file to your server before making any validating step.