reflections

Work Completed

• Database design
• Showcase rehearsal
• Administrative interface

Summary

I've completed the database design and figured out how to use a MySQL database as a data source for a Flash movie, using PHP. I'm going to pass data into the Flash file, using ampersand (&) separated values that Flash can read.

What this will allow me to do is pass results of a MySQL query into a Flash file, using PHP. The database will contain all the questions, answers, categories, etc. The upshot of it all is that each version of the game will be completely different, depending on what database it is using.

I've also completed the Administrative Interface. I need to write directions for the users, but I believe it is fairly self-explanatory as far as how to add categories and questions.

One point, which I may have not made prior to this, is that the game needs at least 5 categories with 5 questions in each to be playable - otherwise, the game board cannot be filled. Inside the administrative interface, categories are described as being Complete or Incomplete, which indicates whether they have 5 or more questions. There can always be more that 5 categories, and more than 5 questions in each category. In fact, the more categories and questions there are, the more the game will vary each time it is played.

Links

• Database Diagram
• SQL Statements

Work On Tap

• PHP integration
• Look and feel finalization
• Database driven extra features