Thursday, December 27, 2007

Simulation Remake - UPDATE

Just a quick update on my progress so far:

  • Schema for database backend has been created using MySQL
    • Currently using three tables
  • Installed MySQL ODBC driver so connection to database can be established in executable (connection yet to be established)
  • All conference and team information has been entered into the database
    • 32 conferences
    • 341 teams
  • Started a PHP script to scrape player statistics from popular sports website
    • Statistics scraping currently done by team, one team at a time
    • Team selected using drop-down list -- all 341 teams are available
    • Statistics scraping code completed successfully, but still need to add code to insert stats into database
That's pretty much it. All-in-all, it's been a pretty productive few days of work. I plan on adding the database insertion code to the PHP script tomorrow. Should be fairly straightforward -- just need to take care not to duplicate player stats when inserting. After that, I'll begin to tackle the database connection inside the executable.

EDIT - Here's a quick little video of the PHP stats script. My script is in the left pane, and the website the stats are being extracted from is in the right pane. If the video quality weren't so poor, you'd see it successfully retrieve the stats. Since the making of this video, I've enhanced the on-screen output of the retrieved stats by putting them in tabular format -- looks much cleaner. ;)

Note: If you're using FireFox, the video may not play completely. Not sure why. Seems to work OK with IE though. Make that semi-OK. Or maybe it's just my computer...hmmm...

No comments: