23 Jan 2014

Our robotics team has a 60-hour work requirement in order to attend competitions as an official member of the team. What better way to track the requirement than with a program? How about a program that features my first full fledged use of PHP and Mysql? Because here’s that.
The website has a simple enough functionality. A high-ranking team member logs in at the start of a build session and then everyone enters their name and “punches in” to start working. When they leave, they hit “sign out” next to their name, they’re given a sign-out time to match their sign-in time and then, when everyone’s done, someone can hit submit to end the day of work and tally up all the hours collected that day. The hours and times (for future reference) are sent on over to a Mysql database and saved to be accessed later when viewing and/or manipulating the totals.
The actual code isn’t particularly novel to an outsider, but for me it was a rather challenging experience. I was familiar with PHP, having touched it often while working on WordPress templates, but I’d never made anything from scratch that required such server-side coding. The same can be said for Mysql. As such, this project meant learning both. In the end, I figured out the languages, organized my database, and even went the extra step to close all possibility of sql injection. It was a useful experience, and the result was a successful, streamlined way of tracking our team members’ hours through the season. Overall, definitely a success.
The Basics:
Language: HTML, CSS, Javascript, PHP, Mysql
Tools: Cloud9 IDE, jQuery (AJAX), bunches of Stack Overflow
The Link:
… Is right here: