For this test, you may bring one sheet (8.5" x 11") of handwritten notes. This is the rough outline of the topics that you will be tested on. Study chapters 7, 9, 10 and 13 from your book, the notes handed out in class and the notes on AJAX on the web.

PHP

• Prompt someone coming to your site for the first time for their name and then subsequently greet them by name. Use cookies.
• Automatically log out a person after 15 minutes of use. Use session files.

SQL and MySQL

• Using SQL write code to create and delete tables
• Using SQL write code to insert or update data in a table
• Using SQL write code to query for data from table(s)
• Write PHP code to access to a MySQL database to insert, update, delete or query for data and display results in tabular form

XML

• Determine if a piece of XML code is well formed
• Write an XML DTD from a given specification
• Write an XML data set that conforms to a given DTD
• Write an CSS stylesheet that displays the data in a XML file

AJAX

• Create a simple AJAX application for a given specification. The application will involve making a call to the server, obtaining information from the server, and then updating the HTML page.