MySQL Exercise

Prerequisites
This exercise assumes you have installed the following software on your PC:
 * PHP
 * MySQL
 * phpmyadmin

Problem Statement
Use phpmyadmin to create a MySQL database named cpsc225 that contains three tables. The members table stores the members of this course. For each member, the table stores the email address (primary key), full name, school, role (student, faculty, volunteer), and team number. The schools table should store the name of the school, its city, and state (CT). The teams table will store the team number (primary key) and the team name (string).

Once you have created a database with this structure, use phpmyadmin to populate the tables with data derived from the CPSC225/Classlist. For now, make up names of fictitious teams and assign members to teams.

Write a PHP program that will display a titled web page containing an HTML table that shows the following data for each member in the database. Model your program after example 6.3 from our text. Don't forget the PhpDocumentor comments.

Hand In
For this exercise, you must post three results: Follow the example provided below. NOTE: Don't post your source code solution until two hours before Monday's class.
 * Your well-documented PHP Source code.
 * A link to your PhpDocumentor generated documentation for your program.
 * A copy of (or a link to) the web page that your program generated.

Solutions

 * Morelli: Web page, PhpDocumentation, Source Code
 * Student A: Web page,PhpDocumentation, Student A MySQL Source Code
 * Student B: WebPage,PhpDocumentation, Student B MySQL Source Code
 * Student C: Web Page,PHP Documentation,Source Code
 * Student D: Web Page,PHP Documentation,Source Code
 * Student E Web Page,PHPDocumentation,Student E MySQL Source Code
 * Student F Web page, PhpDocumentation, Source Code
 * Student G: Web Page,PHP Documentation,Source Code
 * Student H: Web Page,PHP Documentation,Source Code
 * Student I: [Web page], PHP documentation, Source Code
 * Student J: Web Page,Student J MySQL Source Code
 * Student K MySQL Source Code
 * Student L: Web page, PHP documentation, Source Code
 * Student M: Web page, PHP documentation, Student M MySQL Source Code
 * Student N and Student O Web Page], PHP Doc Students N, O MySQL Source Code, PHP Doc with regular skin
 * Student P: Student P MySQL Source Code
 * Student Q doc, live page,source
 * Student R: Web Site DocumentationStudent R MySQL Source Code
 * Student S: Web SiteDocumentationFiles