CPSC 371, Fall 2001                         Information for the Second Test
---------------------------------------------------------------------------

   The second test in this course will be given in class on Wednesday,
October 24.  I will hold extra office hours on Tuesday, October 23,
from 1:00 until 4:00.

   The test covers everything that we've done in class and in lab since
the previous test.  Because that material builds on what we did earlier,
you should also know the basic material on PHP and SQL that we covered
earlier in the term.  Here are some of the important terms and ideas
that you should know for this test:

      SQL commands:
         INSERT, 
         SELECT, 
         UPDATE 
      PHP interface to MySQL:
         mysql_connect($host,$user,$password), 
         mysql_select_db($database),
         mysql_query($query), 
         mysql_insert_id(), 
         mysql_num_rows($result),
         mysql_fetch_row($result), 
         mysql_fetch_array($result),
         mysql_error()
      HTTP is a "stateless" protocol
      HTTP headers
      authorization
      authentication
      .htaccess file for access control
      sessions
      applications of sessions, such as logins and shopping carts
      cookies
      problems with using cookies
      managing sessions with cookies
      managing sessions with "hidden" fields in forms
      managing sessions with extra data in URL's
      session identifiers
      storing session data in a database
      setCookie() function in PHP
      expiration time of a cookie
      sessions in PHP:  session_start() and session_register("varname")
      Zope
      DTML
      DTML compared to PHP
      hierarchical structure of a Zope Web site
      basic DTML tags:
         <DTML-var>, <DTML-if>, <DTML-in>, <DTML-let>
      special variables in <DTML-in>:  
         sequence-item, sequence-number, sequence-even
      users and user authentication in Zope
      adding objects to a Zope Web site