I’ve done as much as I’m going to do on the web design coursework. The site is here. If you want the database stuff to work, you’ll need to feed this script into PHPmyadmin.
For those of you who aspire to be administrators, go here.
The write-up has taken a working day. Writing it helped me find several errors (now fixed, I think) and plenty of scope for improvement if this site was ever to go live. Enjoy!