Schools Virtual Drive Project

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cbuk2k
Forum Newbie
Posts: 1
Joined: Tue Jan 13, 2004 8:53 am
Location: Sheffield, UK

Schools Virtual Drive Project

Post 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
krash_control
Forum Newbie
Posts: 14
Joined: Mon Jan 12, 2004 10:02 am
Location: United Kingdom
Contact:

Post 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.
Post Reply