My mother is the head teacher of a local primary school and they are looking to implement a file server (which I have been telling her she needs for years). I am an undergraduate student and have been impressed with an idea which is used at my university in which work can be submitted online and notes can also be collected in a much more orderly fashion than via ftp equivalent (if not the implementation of it), I would like to create a similar system for the school, I have been playing with PHP / MySQL for a while and think this would be a good opportunity to try a full application. The one thing that has me stuck is how to control access to files, 1 simple solution I have considered is storing the document s in a MySQL DB as I know it supports binary data, are there any problems in doing this? I have seen a few posts that say this is not a good idea but fail to say why. Security isn't paramount and the documents involved will be fairly small.
thanks for your time Chris
Schools Virtual Drive Project
Moderator: General Moderators
-
krash_control
- Forum Newbie
- Posts: 14
- Joined: Mon Jan 12, 2004 10:02 am
- Location: United Kingdom
- Contact:
If security isn't of the highest importance then why not use password protected directories (I believe this can be done with a simple .htaccess file on linux) and use PHP file uploading and moving functions to store/retrieve the files and keep a record of where the files are, when they were submitted etc in you MySQL DB.