| Week |
Period |
Topics |
Reading Assignment |
Lab |
| #1 |
Lecture 1 |
Course introduction |
|
Introduction to Apache, MySQL and
the PHP programming language (AMP) |
| Lecture 2 |
How the pieces of the AMP model work together |
Chapter 1 |
| Lecture 3 |
Configuring the Apache installation |
|
| #2 |
Lecture 1 |
Configuring the PHP installation |
Chapter 2 |
Lab 1: To be
determined |
| Lecture 2 |
Configuring the MySQL installation |
|
| Lecture 3 |
Overview of JavaScript structure and syntax |
|
| #3 |
Lecture 1 |
JavaScript constants, variables and expressions |
Chapter 3 |
Lab 2: To be determined |
| Lecture 2 |
JavaScript flow of control statements |
|
| Lecture 3 |
JavaScript functions and passing/returning
parameters |
|
| #4 |
Lecture 1 |
Using PHP with MySQL |
Chapter 4 |
Lab 2:
continued |
| Lecture 2 |
MySQL server and database connections |
|
| Lecture 3 |
Querying the MySQL database (result sets) |
|
| #5 |
Lecture 1 |
Using HTML tables to display results (from
database tables) |
Chapter 5 |
Lab 3: To be
determined |
| Lecture 2 |
HTML forms and form processing |
|
| Lecture 3 |
HTML form validation |
|
| #6 |
Lecture 1 |
User-modifiable databases |
Chapter 6 |
Lab 3: continued |
| Lecture 2 |
Record management in database systems |
|
| Lecture 3 |
phpMyAdmin web administration package |
|
| #7 |
Lecture 1 |
Creating and managing images with PHP |
Chapter 7 |
Lab 4: To be
determined |
| Lecture 2 |
Overview of PHP structure and syntax |
|
| Lecture 3 |
PHP constants, variables and expressions |
|
| #8 |
Lecture 1 |
PHP control structures and functions |
Chapter 8 |
Lab 4: continued |
| Lecture 2 |
PHP libraries and extensions |
|
| Lecture 3 |
Error processing (avoiding and handling) |
|
| #9 |
Lecture 1 |
Exception processing in PHP |
Chapter 9 |
Lab 5: To be
determined |
| Lecture 2 |
Database design principles |
|
| Lecture 3 |
Processing email with Apache |
|
| #10 |
Lecture 1 |
User logins, profiles and personalization |
Chapter 10 |
Lab 5: continued |
| Lecture 2 |
Online Stores, authentication, authorization |
|
| Lecture 3 |
Online Stores, shopping carts and credit card
purchasing |
|
| #11 |
Exam week |
Final exam |
|
|
![[MSOE Logo]](../msoelogo.gif)