Want to do a file download management system solution

Want to do a file download management system
Want to ask the specific ideas, is not able to manage each upload to add a file name to the table to do statistics, this is my little idea, I novice, I hope you give some rookie ideas, do not frame, thank you

------Solution--------------------
You can create a new file table to manage files
It's inside.
ID: auto-numbering
File number, file name, upload time, upload user, etc...
When uploading, I typically name each uploaded file as an ID, and add the "File extension" field to the Files table
This will ensure that the file is not duplicated when it is uploaded.
And there is a specific directory to store files, such as the WWW root directory to create a file folder to hold all uploaded files
If you want to list all the files,
SELECT * from File
ID number name Download
1 001 This is the upload file download file
When you click Download, you only need to get the ID and extension of this record to get the file.
Assuming that the file has a. jpg extension, the file's location is/file/1.jpg.
------Solution--------------------
Explore
Hello, my specific ideas are like this, thank you very much, then I want to do is, click the Download pop-up a password box, verify that the successful party can download. What to do, you know? I hope you can answer thank you.

