Good Example of upload files in PHP

As a good practice, in general Do NOT upload file into a SQL DB

Why?
1 - it has usually a variable lenght and will therefor impact optimization and performance
2 - you always run the risk that some programmer will not use the recommended good paractice to read a list of fields, but instead to read the complete row / record.... which will severely impact the program performance in unexpected (by the programmer) ways

Recommended practice is to have a donwload area, and to place inti the db a link to the file

Hi,

Here is my method that save a lot of ressource.

I saved file per client or project
I never put all files in one directory
I would create a directory per project or per contact
I always rename the file using timestamp this prevent a lot of problem and each file have unique name.

I saved all file information into the DB:
file size,
file mime,
original name, (so user will see the original file name)
new name (this will be use to find the phisical file let say for unlink the file)
contact or project id,
uploder id,
upload date and time (timestamp)

I'm saving file size and mime to save ressources, getting info everytime using PHP this can slow down the system.