Task 01:	Apache
Task 02:	Unix/HTML
Task 03:	Perl/Python
Task 04:	CGI with Perl and Python
Task 05:	Keeping state (CGI/hidden fields)
Task 06:	SQL and MySQL
Task 07:	PHP
Task 08:	PHP sessions
Task 09:	Database access from PHP, Perl and Python
Task 10:	Implementing CGI sessions with Perl DBI

All links in the material for last week work now.

Materials we might want to briefly visit this week (three links at the top).

The fix we need to apply to two to eliminate accidental reloads: three.

Sequence of tasks for the semester portfolio now complete.

• problem one
• problem two
• problem three
• problem four

The test will be 5-7 minutes long. After that you will take turns converting them to PHP.

We spent 25-30 minutes to develop the first, and only 3-4 minutes to get the second from the first.

Or, maybe we should start with the program discussed in the text (pp. 51-66).

Specifics for database connection for this semester (please use your port and password):

#!/usr/bin/perl

use DBI; 
use CGI; 

$q = new CGI; 

print "Content-type: text/html\n\n"; 

$DB        = 
"dbi:mysql:demoOne:silo.cs.indiana.edu:port=14518"; 
$username  = "dgerman";             
$password  = "sp00n"; # put 
your own password, you can see mine if you highlight it

$dbh = DBI->connect($DB, $username, $password, {PrintError => 0})
  || die "Couldn't open database: ", $DBI::errstr; 

$query = "select * from players"; 

$sth = $dbh->prepare($query) || die $dbh->errstr;

$sth->execute() || die $sth->errstr;

Programs that you might want to test your PHP with:

<? session_start();
   if ($message) {
     $balance += $amount; 

     $message = "Balance is currently: " . $balance;

   } else { // initialize state 
     $message = "Balance is: "; 
     session_register("message"); 

     $balance = 0; 
     $message .= $balance; 
     session_register("balance"); 
   } 
 ?>

<form> 
  <?=$message?> <p> 

  Amount to add: <input type="text" name="amount" size=4> <p>

  Press <input type="submit" value="Proceed"> when ready. 
</form> 

<?
   if ($message) {
     $balance += $amount;
     
     $message = "Balance is currently: " . $balance;
     
   } else { // initialize state
     $message = "Balance is: ";
     $balance = 0;
     $message .= $balance;
   }
 ?>
    
<form>

  <?=$message?> <p>

  
  Amount to add: <input type="text" name="amount" size=4> <p>
  
  Press <input type="submit" value="Proceed"> when ready.
  

  <input type="hidden" name="message" value="$message">
  <input type="hidden" name="balance" value="$balance">

     
</form>

• page 51
• page 52-53
• page 54-55
• page 56-57
• page 58-59
• page 60-61

Here's some code you could use directly:

./configure \
  --with-mysql=/nobackup/dgerman/mysql \
  --with-apxs2=/u/dgerman/apache/bin/apxs \
  --with-config-file-path=/u/dgerman/apache/conf \
  --with-xml --enable-track-vars \
  --prefix=/u/dgerman/apache

    AddType application/x-httpd-php .php .phtml
    AddType application/x-httpd-php-source .phps

The notes on the class notes page will not add much more to what's posted here.

--log-error=/nobackup/dgerman/mysqld-error.log \

Steps for installing MySQL: one, two, three, four.

Another set of notes with a shorter sequence of steps.

• basic outline, directions.

Steps for installing a protected folder: one, two.

Program to study: shuffle (see it running here). What's it doing?

• silly card game
• simple addition quiz
• paper, rock, scissors

• a simple flag quiz (program almost complete)