| # |
Day |
Date |
Topic(s) |
Lecture Notes |
Readings* |
Assignments (week assigned) |
| 1 |
Tue |
Jan 15 |
Introduction, course overview.
Review HTTP, HTML, CGI |
lect1 |
Read WS 1, 2, & 9.
Ref: WS 3-8, 14-19.
Read Demystifying the Browser
Read Learning HTTP up to "Server Response Codes" |
p0 - Programming
p0-data.txt |
| 2 |
Tue |
Jan 22 |
Unix and PHP |
Unix
lect2
ex1 |
Read 1, 2. Skim 3 & 4. Read 5. |
p1 - HTML and CSS
home.html
contact.html
browse.html |
| 3 |
Tue |
Jan 29 |
MySQL refresher
PHP and MySQL |
lect3
ex2 |
Skim 8. Skim/read 9 & 10. Read 11, 12, & 13. |
p2 - Flat file databases
records.txt |
| 4 |
Tue |
Feb 5 |
PHP & User Input
Security, Ecommerce |
lect4 |
Read 14 & 15 |
p3 - DL: Retrieve metadata from a DB
smallrecords.txt
bigrecords.txt |
| 5 |
Tue |
Feb 12 |
Session control
User Authentication |
lect5 |
Read 16
Read 22 |
p4 - DL: Account types and logins
p4bigrecords.txt |
| 6 |
Tue |
Feb 19 |
In-class Mid-Term Exam
Lecture: DB permissions |
ex3 |
|
|
| 7 |
Tue |
Feb 26 |
File upload
Time and dates
Secure transactions |
lect6
ex4 |
Read 18
Skim 19 & 20
Read 17 |
p5 - DL: File upload |
| 8 |
Tue |
March 4 |
Database search |
lect7
ex5 |
|
p6 - DL: Metadata and full-text search |
| |
|
March 11 |
Spring Break |
|
|
|
| 9 |
Tue |
March 18 |
Javascript and DOM |
lect8
ex6 |
Read WS 20, 21, 22, & 23 |
p7 - Javascript and DOM |
| 10 |
Tue |
March 25 |
Ajax |
lect9
ex7 |
|
|
| 11 |
Tue |
April 1 |
XML, XPath, and XSLT |
lect10
lect10-more
ex8 |
|
p8 - XML, XPath, and XSLT |
| 12 |
Tue |
April 8 |
NO CLASS |
|
|
|
| 13 |
Tue |
April 15 |
ASP |
lect11
ex9 |
|
p9 - ASP |
| 14 |
Tue |
April 22 |
Course Summary/Review |
TBA |
|
|
| |
Tue |
April 29 |
Final Exam |
|
6:00pm - 8:30pm |
Manning 307 |