I had a great programming run last night and didn’t finish until after 1am! The static database class is taking shape and has returned meaningful data… which is nice.
Tonight, Kaz helped me to get the results from one division in 1996 into the new database. This will allow me to write and test the league table query. With several years of flat HTML pages to work through, it’ll be a while before all the old data is processed.
In recent times it’s become apparent to me that my Snooker League site needs updating and consolidating into a full blown Object Oriented PHP application. The database design was limited by my knowledge many years ago, resulting in some horrible queries. It does the job, but is hardly a good advert for my PHP and SQL skills these days.
So today it all kicked off, a couple of draft classes were written to retrieve some results from week one of the 1996 season (the year I began making the results and league standings available on the web).
The database has 14 17 tables to date and is being updated regularly. I’m using the excellent MySQL Workbench to design and layout the tables. The database design has been work in progress for months, finally I’ve made the time to get things rolling.
Oh and it’s my birthday today too. 