• review and guidelines for Homework Two
• review and guidelines for Homework Five
• review and guidelines for Homework Seven (code 11/20: One.java, web.xml, one.jsp)

Also to be posted:

• review and guidelines for Homework Three (older notes, starting point)
• review and guidelines for a Semester Project (starting point, older guidelines)

• part I (Homework Four)
• part II (Homework Six)

Useful links:

• http://www.cs.indiana.edu/classes/a348/spr2008/0327.txt
• http://www.cs.indiana.edu/classes/a348/spr2008/Two.java
• http://www.cs.indiana.edu/classes/a348/spr2008/One.java

More useful links:

• go to http://www.libraries.iub.edu/scripts/countResources.php?resourceId=59555
• then go to http://bert.lib.indiana.edu:3847/toc.asp?bookid=20437

A sample Java project (code).

Older guidelines and sample project blog.

1. PHP with server-side state
2. PHP with client-side state
3. CGI/Perl with client-side state
4. CGI/Perl with server-side state

Notes for today.

Recipe for server-side state CGI/perl implementations.

Notes for this week and the previous: part one, part two.

Three things on the horizon:

1. Reorganize your websites to better reflect your accomplishments this semester.
   Here's a sample portfolio for just this part of the course.

2. Prepare a project proposal and post it on your website.
   Here's how you might started: sample project.

3. Prepare for the exam next week and take it.
   Here's a problem to work on, to prepare for the midterm.

In class we will probably rewrite them again. If we do, you will find them posted here.

Either way, reference file for today: collection of given procedures

Your servers must look like this:

+------------------------------+--------------------------+
|  Apache (Homework One)       |    Lab One (Unix)        |
+------------------------------+--------------------------+
|  CGI/Perl (or CGI/Python)    |    Lab Two (Basic CGI)   |
|  The Flag Quiz Program       +--------------------------+
|  (Homework Two)              |    Lab Three (htpasswd)  | 
+------------------------------+--------------------------+
|  Introduction to Databases   |    Lab Four (HTTP)       |
|  RDBMS Design, SQL Queries   +--------------------------+
|  (Homework Three)            |    Lab Five (PHP)        |
+-----------------------------+--------------------------+
|  PHP server-side state       |    Lab Six (MySQL)       |
|  Intro to PHP, Sessions      +--------------------------+
|  (Homework Four)             |    Lab Seven (DBI.pm)    |
+------------------------------+--------------------------+
|  Server-side state in CGI    |    Lab Eight (Practical) |
|  Perl/Python implementations +--------------------------+
|  (Homework Five)             |    Lab Nine (DHTML)      |
+------------------------------+--------------------------+

We ended up with a collection of tables, with data in them, and wrote an SQL query (a complex one, as an example).

We then discussed three scripts that were able to extract data from the database.

Here they are: Perl, Python, PHP.

Let's work out a simple exercise: here's the basic database setup for this exercise.

Two PHP scripts: part one, and part two

But before that we will discuss Chapter 12 in the text.

It will help us understand (and unify) the client-side with the server-side state maintenance techniques.

Introduction to databases (Adamski and Pratt) slides for chapters 5 and 6:

• Normalization (in general)
• Design Methodology for databases

Here's the database for The Chess Tournament.

Notes prepared for today's class and the lab.

(A little bit more will be developed in lab (reference), though, and posted over here.)

The lab is based on this data:

                          Larry Bird (lbird) | Michael Jordan (mjordan) | Toni Kukoc (tkukoc)
---------------------------------------------+--------------------------+---------------------
Eric Gordon     egordon          9           |          10              |
---------------------------------------------+--------------------------+---------------------
D.J. White      djwhite         10           |                          |
---------------------------------------------+--------------------------+---------------------
Deandre Thomas  dthomas          7           |                          |
---------------------------------------------+--------------------------+---------------------
A.J. Ratliff    ajratlif         8           |                          |
---------------------------------------------+--------------------------+---------------------
Mike White      mwhite                       |           8              |       
---------------------------------------------+--------------------------+---------------------
Armon Bassett   abassett                     |           7              |       
---------------------------------------------+--------------------------+---------------------
Jamarcus Ellis  jmellis                      |                          |     10
---------------------------------------------+--------------------------+---------------------
Lance Stemler   lstemler                     |                          |      5             

• Cover chapters 9, 10, 3 in this text
• We will refer to some of these notes or these notes.

Some other URLs for this week:

• http://www.cs.indiana.edu/classes/a202-dger/fall2006/a201-text/thinkCSpy.pdf
• http://www.cs.indiana.edu/classes/a201-dger/problems.txt

• Introduction to Python
• Introduction to Perl and CGI

Local copies of the Univ. of Virginia tutorial: one, two, three, four, five, six, seven, eight.

Some of the links distributed last week:

• Installing Apache
• Unix commands
• List of ports assigned
• This is the complete .pdf of the textbook used last semester.