I am making a website where people can register/login and upload files (text only) and other people can view them. I have the file upload feature which upload the file to a folder and it automatically saves file information(title, size, uploader etc.) to the database.

Is this the right way to save files using a database? And how would I add keywords to the file type, so I can use it to search by keyword.

  • 1
    You might be well advised to look at what others have done in this area - open source message board software for example? Or file sharing? – Vérace Jun 6 '14 at 1:46
  • You could create a keywords table with ids. Link the keyword to each file in another table. – SQLChao Jun 6 '14 at 1:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.