Term project released

Information on the term project (Pittsburgh Interactive Research Accounting System) has been posted on the web page, along with the supplementary files. It is due on Saturday, April 27th.

Third assignment released

The third assignment, on javascript, has been released. It is due on April 19th.

AJAX by example

AJAX stands for Asynchronous JAvascript and Xml. The main idea is that a web page can use AJAX to send requests (using Javascript) to a web server and then update parts of the page (which are specified using Javascript) according to the web server's response (which could run any type of script, e.g., PHP).

Here's the detailed sequence of steps typically found in an AJAX-enabled web page:

1. [@web browser] Some event occurs (e.g., onload or after clicking something)
2. [@web browser] A Javascript function is called 
3. [@web browser] An XMLHttpRequest Object is created
4. [@web browser] HttpRequest sent to web server
5. [@web SERVER] HttpRequest processed, typically by a PHP script
6. [@web SERVER] A response is generated (e.g., by looking up a database entry)
7. [@web SERVER] Response is sent back to browser
8. [@web browser] Process the returned data using Javascript (data could be text, html, or xml)
9. [@web browser] Update parts of web page, specified by Javascript (e.g., using elementID)

Examples:

• hello1.html -- "Hello World" example, where after clicking the "Change Content" button, a request is sent to the web server for file hello_ajax.txt which is retrieved by the browser and used to change the content of the page.
• hello2.html --  same with the previous example, but with the addition of a timestamp, computed locally by Javascript at the browser.
• hello3.html --  same with the previous example, but now instead of a static file read from the web server, the content is generated by calling hello_ajax.php (source -- run) which computes the date and picks a random pair of words to show.
• hello4.html --  same with the previous example, but now the PHP script at the web server hello_ajax_d.php (source -- run) includes a time delay of 2 seconds. This is used to demonstrate the asynchronous nature of AJAX. Notice the difference of the two timestamps displayed.
• suggest.html -- generate suggestions for first names (that have the same prefix as what has been typed), after one or more letters are typed. Relies on gethint.php 
• suggest2.html -- generate suggestions for first names (that contain these letters), after one or more letters are typed. Relies on gethint2.php

More information:

• AJAX Tutorial: www.w3schools.com/ajax/default.asp

Second midterm exam on Wednesday

The second midterm exam (and last exam for the course) is this Wednesday, March 27th during class time. It will be open-internet and will be exclusively on PHP.

Assignment #2 posted

Assignment #2 has been posted. It is due on April 1st.

Only one recitation session this week (Friday @ 3pm)

We will utilize the recitation time this week to make up for the lost lecture on Monday. We will meet in a bigger room (room 6110 on the sixth floor) at 3pm on Friday. There will not be a 4pm recitation.

Sample answers for assignment #1 released

Sample answers for assignment #1 have been released at http://db.cs.pitt.edu/courses/cs1520/spring2013/recitations.html#05

Assignment #1 deadline pushed to February 18th

The deadline for the first assignment has been pushed to February 18th at midnight.

Recitation material posted online

All past recitation material has been posted online and will be updated regularly from now on.

Clarifications to assignment #1

Please see the comments of this post for important clarifications to assignment #1.

First Assignment has been posted (due on Feb 15th)

The first assignment has been posted -- it is due on Friday February 15th. There is also a test assignment, due on Tuesday, February 6th.

Midterm exam rescheduled for Wednesday, February 13th

The midterm exam that was originally scheduled for Wednesday, February 6th, during class time, has been rescheduled to Wednesday, February 13th, during class time. We will have a short quiz on Feb 6th, to make everybody a bit more familiar with the online testing process, before the midterm.

Class web site is up

The Spring 2013 incarnation of the class web site is finally up, at http://db.cs.pitt.edu/courses/cs1520/spring2013