Lecture Notes

Week 14

Jump to Top of Page.

• Review: Term Review Notes

Week 13

Jump to Top of Page.

• Lecture Notes: Transactions

Week 12

Jump to Top of Page.

• Lecture Notes: Web Security

Week 11

Jump to Top of Page.

• Readings: CERT Advisory CA-2000-02 Malicious HTML Tags Embedded in Client Web Requests <www.cert.org/advisories/CA-2000-02.html>;
  The Cross Site Scripting FAQ <www.cgisecurity.com/articles/xss-faq.shtml>

Week 10

Jump to Top of Page.

• Lecture Notes: Validation
• Design Pattern: Reporting Tables

Week 9

Jump to Top of Page.

• Handout: SQL92 Join Syntax

Week 7

Jump to Top of Page.

• Lecture Notes: Multi-Tier and Model-View-Controller Web Ap.htm

Week 6

Jump to Top of Page.

• Lecture Notes: Session Management
• Design Pattern: Personal Information

Week 5

Jump to Top of Page.

• Design Pattern: Active Bits and Effective Dates

Week 4

Jump to Top of Page.

• Lecture Notes: Web Application Fundamentals
• Design Pattern: Role-Based Security

Week 3

Jump to Top of Page.

• Lecture Notes: Introduction to MySQL
• Lab Notes: Connecting to MySQL from PHP
• Readings: PHP/MySQL Tutorial <hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html> (you can safely skip the installation instructions in Lesson 1).

Week 2

Jump to Top of Page.

• Lecture Notes: Introduction to PHP
• Exercises: Handling Forms in PHP
• Readings: Text Chapter 12 (Introduction to PHP). You may also want to look at Chapter 2 of the PHP documentation, A Simple PHP tutorial <www.php.net/manual/en/print/tutorial.php>.

Week 1

Jump to Top of Page.

• Lecture Notes: Common Gateway Interface
• Lab Notes: Dealing with the Project Webserver
• Handout: Linux Survival Guide
• Readings: Text Chapter 9 (CGI Scripting); Text Chapter 10 (Some CGI Examples); Text Section 17.4 (Common Gateway Interface). In the first two cases, don't worry about the Perl scripts, instead focus on how CGI works to create web pages on the fly. If you're new to CGI, you may also want to look at How CGI Scripting Works <www.howstuffworks.com/cgi.htm/printable> and An Instantaneous Introduction to CGI Scripts and HTML Forms <www.cc.ukans.edu/~acs/docs/other/forms-intro.shtml>