Page 1 of 1

Schools Virtual Drive Project

Posted: Tue Jan 13, 2004 8:53 am
by cbuk2k
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

Posted: Tue Jan 13, 2004 9:02 am
by krash_control
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.