Here are three generic programs:

• a Python program
• a Perl program
• a PHP program

Copy the PHP code and change:

• the port, username and password
• the database
• the query

Adjust the printing to match the query.

Here are two versions of a tutorial written by former A348 student Jimmy Denton.

Django installation steps (collection of slides)

Here's a Fall 2009 version of the same tutorial.

 1008  cd
 1011  mkdir struts
 1012  cd struts
 1013  ls
 1014  cp /l/www/classes/a348/sum2006/software/struts-2.0.14-all.zip .
 1015  unzip struts-2.0.14-all.zip
 1016  ls
 1017  quota -v
 1018  ls
 1019  cd struts-2.0.14/
 1020  ls

Basic Java help in lab today.

Here's an example that you may find useful with the exam problem.

Another example (was given to you as reference yesterday).

Finally, check here under Tue Aug 10: a servlet. What does it do?

Here are the steps for the first CakePHP project (more to come).

You will need to write a JSP or a servlet from scratch.

It will be of choice what you develop (either JSP or servlet).

You will also have to put together (puzzle) a JSP or a servlet (the Flag Quiz).

We can discuss/adjust things in lab on Fri (if necessary).

Example developed last time:

• created a context in webapps: cucumber
• created a file in cucumber/WEB-INF/classes/Rutabaga.java
• compiled the file with $JAVA_HOME/bin/javac
• we then accessed Tomcat Manager and reloaded the cucumber context
• we wrote a web.xml for deployment and according to it
• we then accessed the servlet from the corresponding URL
• ... and that was it.

• Correct script.
• Incorrect script.

See the difference (it's all a rearrangement of if statements).

I am rewriting them now in a better format.

Today in lab:

• check on Tomcat servers
• check on the program we wrote yesterday
• implement Chapter 3 project in the CakePHP 1.2 book
• potentially use this document to draw some early conclusions
• look at what comes after that (updated version)
• here's the document that presents the first two assignments (exams) side by side

Some questions forthcoming regarding these programs.

How would you implement something else in the same framework?

The basic information about the exam on Thu is captured in this document.

Here's information on how you can write Hangman with server side state in CGI/Python.

Grades for the exam taken today will be posted tomorrow.

Side by side comparison of a development in CGI/Python and PHP.

It covers the entire semester so use it selectively to prepare for next week.

Don't forget we have Exams One and Two next week.

• one
• two
• three
• four
• five

Older set of goals for where we are now.

Some notes that might be useful this week.

(Add 219 to your Apache port number to obtain your MySQL port number.)

#!/usr/bin/python

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

d = { "jacohend" : "Jacob", \
      "dgerman"  : "Adrian", \
      "agmyers"  : "Andrew",  \
      "mkdavids" : "Mike",     \
      "dnate"    : "Dan",       \
      "cwheikki" : "Chris",      \
      "linji"    : "Jason",       \
      "jfarny"   : "Jake"          }

import random

users = ( "jacohend", "dgerman", "agmyers", \
          "linji", "mkdavids", "dnate",      \
          "cwheikki", "jfarny") 

picture = random.choice(users)
username = picture

name = d[username]

print """
  <img src="http://www.cs.indiana.edu/classes/c212/fall2010/images/%s.jpg"> <p>
  %s (%s) <p>
""" % (picture,name,username)

#!/usr/bin/python

import cgitb
cgitb.enable()

import cgi
data = cgi.FieldStorage()

if data.has_key("index"):
  index = data["index"].value
  index = index + 1
else: index = 0

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

d = { "jacohend" : "Jacob", "dgerman" : "Adrian", "agmyers" : "Andrew", "mkdavids" : "Mike", "dnate" : "Dan", "cwheikki" : "Chris", "linji" : "Jason", "jfarny" : "Jake" }

import random

users = ( "jacohend", "dgerman", "agmyers", "linji", "mkdavids", "dnate", "cwheikki", "jfarny" ) 

picture = users[index]
username = picture
name = d[username]

print """
  <img src="http://www.cs.indiana.edu/classes/c212/fall2010/images/%s.jpg">

  <form>
    <input type="submit" name="action" value="previous" />
    <input type="submit" name="next" value="next" />
    <input type="hidden" name="index" value="%s" />
  </form>

  %s %s
""" % (picture, index, name, username)

We need to fix it and move on, like this.

1. one that pulls out a random picture and shows it
2. another one that displays one picture at a time, exhausting them in random order
3. the other one that enhances the second by asking for the name and grading your answer

In the process let's remember:

• because we know Unix commands we can work on silo
• because we have installed and maintain Apache we can post HTML
• because we know CGI and Python we can write programmatic resources in Apache
• because we know the template below we can succeed no matter the problem

Template:

Notes from Tue to be posted soon.

Here's how your development might proceed.

In lab today:

12001 12002 Davidsen , Michael Kennedy    , mkdavids, 9643
12003 12004 Farny    , Jacob C            , jfarny  , 9721
 8546  8646 German   , Dan-Adrian         , dgerman , 8346 
12007 12008 Heikkinen, Christopher William, cwheikki, 9648
12009 12010 Henderson, Jacob Michael      , jacohend, 9700  9919
12011 12012 Myers    , Andrew Glen        , agmyers, 9634  9853
12013 12014 Nate     , Dan Patrick        , dnate, 9694
12015 12016 Lin      , Jia-Sheng          , linji , 9991  10282

Two things we will go over in class today:

• Installation of Apache
• Basic Unix commands

Here's the text from which I gave you pages last time.

Here's our class description in the Registrar's pages.