A database-driven directory site with secure administration section written in PHP.
What they had...
Dorset Agenda 21 (DA21) had an existing directory of sustainable organisations Dorset, but it was becoming unmanageable because it was a collection of static web pages. As it stood, each entry in the directory and all listings pages were hand-crafted by DA21's staff so that each new addition to the directory caused the editing of dozens of pages. They wanted the directory to be upgraded to a database-driven system so that they could just enter each organisation's details and all the relevant pages and indexes would be created automatically.
What I did...
I created a MySQL database representing DA21's Sustainable Organisations directory, ensuring it was fully normalised so it could be extended along whatever future lines they saw fit. They needed a secure administration section to allow their staff to edit and add entries, so one was built that allows anyone with basic web skills to update and manage the directory. Finally, I re-created the existing directory pages and indexes using PHP and database queries.
