| Week |
Monday |
Wednesday |
Assignments |
| Aug 24 |
No Class |
Fundamentals of the web |
- |
| Aug 31 |
HTTP |
Web site layout control |
1: Create a simple web site |
| Sep 07 |
XHTML forms |
PHP basics (Ch 1) |
- |
| Sep 14 |
PHP basics (Ch 1) |
Reusing code and functions (Ch 5) |
2: Use PHP in web site. |
| Sep 21 |
PHP arrays (Ch 3) |
PHP strings (Ch 4) |
- |
| Sep 28 |
Test 1 |
Database and MySQL (Chs 8, 9) |
3: Create web database |
| Oct 05 |
Database and MySQL (Chs 8, 9) |
Case study: online bookstore |
Start Term Project |
| Oct 12 |
Working with MySQL (Ch 10) |
Querying MySQL in PHP (Ch 11) |
4. Query web database 1 |
| Oct 19 |
Fall Break, No Class |
Writing to MySQL in PHP |
- |
| Oct 26 |
Writing to MySQL in PHP |
Test 2 |
5. Query web database 2 |
| Nov 02 |
Handling errors (Ch 26) |
Validating user input (Chs 4) |
- |
| Nov 09 |
Validating user input (Chs 4) |
Sessions (Ch 23) |
6. Modify web database |
| Nov 16 |
Security (Chs 15, 16, 17, 18) |
Security (Chs 15, 16, 17, 18) |
- |
| Nov 23 |
Building an online system (Chs 14, 25) |
Thanksgiving, No class |
7. Sessions and Security |
| Nov 30 |
Shopping cart (28) |
Sending emails (20) |
- |
| Dec 07 |
Review |
No Class |
Submit Term Project |
| Dec 09 |
Final Exam, 11:30am, Wednesday |