Weekly+Topics

=Weekly Topics and Activities=

**Topical Outline of the Course:**

=LAB EXERCISES=

Lab 1. Introduction to PHP

 * Chapter 1**

Use basic PHP syntax and structure output information to an HTML page. Create a configuration file to control how PHP behaves. Use a PHP function to include content from another page into your PHP page. Use the phpinfo function to investigate the configuration ofyour server and its modules.

Lab 2. Template System

 * Chapter 3**

Create a PHP template system complete with a dynamic status indication and page heading system. Output the current date and time in your time zone on your template pages. Use an external style sheet to format your pages. Using your new template system, create a small 4 page web site.

Lab 3. Form Processing

 * Chapter 2**

Create a PHP class to filter user input through HTML forms.

Lab 4. Working With MySQL Databases

 * Chapters 4 and 5**

Connect to a database, query a table and retrieve content, looping through it to display it on an HTML page. Use phpMyAdmin to create a database table with a primary key and unique id.

Lab 5. Add & Edit Records

 * Chapters 4 and 5**

Create a page with an HTML form that will allow you to add a record to a database, and another page for editing database records.

Lab 6. Delete Records, Administrative Home Page

 * Chapters 4 and 5**

Create a page that will allow you to delete database records. You page should first ask for confirmation before deleting the record. Create an administrative home page that will connect to a database and loop through all records, displaying them in a logical order, and dynamically building buttons or links to edit or delete the record (these buttons/links connect to week 5 lab exercise pages). Include an “Add Record” link at the top of your administrative home page.

Lab 7 User Authentication

 * Chapter 6**

Using classes, create a user authentication system to protect your CMS from unauthorized users. Compare your class based user authentication system to a procedural approach and list the benefits or pitfalls of each approach.

Lab 8. Upload Files

 * Chapter 10**

Modify your add and edit record pages from last week to include a file upload feature. In the case of editing a record with a file associated, delete the existing file before replacing it with a new one.