PHP Camp -- Day 3

Today was MySQL day. The goals for today were to learn how to use a database, and to convert the site to read its information from the database. We actually accomplished more than I thought we would.

Here's today's agenda:

• First we reviewed some of the PHP we learned yesterday.
• Then I explained how databases store their information in tables, containing rows and columns of information.
• I told them about the language SQL, which is a language that lets you query the database. We talked about the three basic queries: SELECT, INSERT, and UPDATE.
• Next we went to the computers and they used the phpMyAdmin tool to create tables to hold game and review information.
• Then they used phpMyAdmin to add some games to the tables they had created.
• We modified the functions that we created yesterday to return game information from the database instead of hard-wired information.
• Then they added review information to the database, and we modified the functions that return review information.
• Flaming Hot Cheetos and Strawberry Marguerita snow cones were enjoyed by all.

Tomorrow we'll start working on pages to let us add games and reviews to the database.

Check it out!