Wednesday, 15 February 2012

Project Progress Report

Since my last post on Monday 30th January, work to develop the solution has commenced. A foundation for the structural layout for each webpage has now been created, and most web pages contain content. Furthermore, some of the system's functionality has now been estbalished:
  • Admin members can now enter the latest external club result into a form, which is stored in the MySQL Server Database. A PHP function on the index page then retrieves the latest external club result data from the database and displays the information on the home page for all website users to view.
  • Admin members can now update the MySQL database with the latest 'Social Evening' results (e.g. Bingo, Find the Joker and Tote Draw Results), using a pre-programmed PHP commands. These details are stored in the MySQL database, and retrieved by a separate PHP command which displays the latest set of results on a separate page for all users to view. When an admin member enters a new set of Social Results into the database, the PHP command on the 'Social Results' page will display the latest set of results, hence, the latest set of results will be displayed, and any previous results will be replaced.
  • Furthermore, two log-in functions have now been created, one log-in function verifies if a member is a genuine bowling member, and the other log-in function verifies if a member is a genuine staff (admin) member. If a member is genuine, they will be taken to their respective home page. The 'Bowling Member Home Page' and 'Admin Member Home Page' are still under development, I aim for these pages to be completed by the end of the week.
Alongside the functional aspects of the solution, I have started to develop graphics and images using a combination of Adobe Photoshop CS5 and Adobe Premiere Elements 2.0. Additionally, I am continuing to work on the project report - I am currently working on the Implementation section of the report, stating how I am developing certain parts of the solution. CSS3 has played a major role on the development of my solution - the '-moz-border-radius:' and 'border-radius:' functions have allowed me to curve the edges of boxes, and helped increase the professionalism of webpages.

In term's of my project's progress, thus far I would say I am on target with development. I aim to create further functional PHP and MySQL commands by the end of next week, which will allow admin members to start maintaining internal league results. To structure these PHP commands I intend to continue Paul Hudson’s “Practical PHP” e-book, which thoroughly explains how to establish complex PHP functions.