Need PHP code to interact with existing MYSQL database and create reports. The database consists of play-by-play accounts of (american) football games. The reports would be box scores, weekly and seasonal stat summaries, text versions of the PBP, to be stored as HTML pages.
For more information, see <a href="[login to view URL]>[login to view URL]</a>.
## Deliverables
I have a large database of historical football play-by-play data, and I would like to create an online encylopedia which uses this database to build content. A description of the database schema and a sample of the data is available at: [login to view URL]
I need a set of backend tools that will create HTML pages from this database. For each game in the database, the tools should create:
1) linescore/summary page
2) boxscore page
3) play-by-play page
See [login to view URL] for more details on how this will look.
In addition, when processing each game, the tools will write linescore and boxscore data to a table in the database.
The programmer should have enough knowledge of the game to understand how to create a boxscore and linescore from the play-by-play data.
Each page that is created will need to observe the defined filename / directory structure, and include appropriate header and breadcrumb information (as shown at [login to view URL])
The tools should include an interface that lets the user perform these tasks (create pages and write to databases) for every game in the database at once, or to choose individual games, seasons, team/seasons from a list for batch processing.
Please contact me with additional questions.