This project utilizes two of the most popular open-source technologies on the web, PHP and MySQL. I was contracted by Graham at Global Audience Comminications to provide a PHP/MySQL database for the people at the House of Friendship.
They required the following:
- Password protected Employee pages
- The ability to post jobs/volunteer positions/employee information
- Event Calendar
- Attach files for download to all of the above
- Make posted information public to be viewed by everyone or private to be viewed only when accessing the employee pages.
- Categorize Employee information posts
- Administration forms to handle users and all posts
I used PHP to update and retrieve the dynamic information from the mysql database. All of the administration forms used client-side javascript to validate the form fields before being submitted to the database, reducing the number of page loads when information was incorrect.
I used SESSION variables to handle user authentication and to determine if the dynamic pages should display the data that was marked private.