CSE 190 M, Spring 2007
Final Exam

• You have 120 minutes to complete this exam.
  You may receive a deduction if you keep working after the instructor calls for papers.
• This test is open-book/notes.
• You may not use any computing devices of any kind including calculators.
• Please do not abbreviate any code on your exam.
• If you enter the room, you must turn in an exam before you leave.
• You must show your Student ID to a TA or instructor for your exam to be accepted.

Good luck!

1. HTML/CSS Interpreting (20 points)

Draw a picture of how the following HTML and CSS code will look when the browser renders it onscreen. Indicate a background coloring by shading lightly or by drawing repeated diagonal lines like . Assume that stickman.png is a generic picture of a stick man.

2. Javascript/DOM (20 points)

Write the Javascript code to accompany the following HTML code, so that when the Delete button is clicked, any button whose text value is divisible by the number written in the text field is removed from the page. You may assume that a valid number has been typed in the text field. The HTML code is the following:

For example, after typing the number 2 into the text field and pressing Delete, the following should be the page appearance:

3. Ajax/XML (20 points)

Write the Ajax Javascript code to fetch and display XML data from the file named movie.xml (in the same directory as your code). This file contains lines spoken by a character in a movie. Your code should process the XML and display the character's lines, each in its own paragraph, in the format shown below. Assume that the code will execute on an HTML page containing a div with the CSS ID of q3html, and insert the paragraphs into this div.

The XML data will be in a format that matches the following abbreviated example:

<character name="Captain Jack Sparrow" actor="Johnny Depp" />
     <line time="02:55">Captain Jack Sparrow, if you please, sir.</line>
     <line time="3:21">I'm in the market as it were.</line>
     ...
     <line time="2:41:38">On deck, you scabrous dogs! Man the braces!
     Let down and haul to run free. Now... bring me that horizon.  And
     really bad eggs?  Drink up, me 'earties, yo ho.</line>
</character>

For the XML data above, your code would produce the following content on the HTML page:

You may assume that your page already contains the following code from lecture and the slides:

function ajaxHelper(url, fn)

4. PHP (20 points)

Write PHP code that processes the following form:

<form action="solution/q4.php" method="post">
  <fieldset>
  <input type="text" name="name" /> Name<br />
  <input type="text" name="pw" /> Password<br />
  <input type="text" name="cc" /> Credit Card Number<br />
  <input type="submit" />
  </fieldset>
</form>

(Onscreen, the form looks like this:)

Your code should examine the name, password, and credit card number submitted, and verify that they are valid. A valid name is any non-empty string. A valid password is any string that is at least 6 characters long. A valid credit card number contains exactly 16 digits. Optionally, the credit card number can contain dashes between some or all groups of four digits. No other characters may be part of a credit card number. For example, the following are some examples of valid and invalid credit card numbers:

Use regular expressions for pattern matching and replacement. Assume that the page begins with some introductory HTML content stored in the file q4top.html and some ending content stored in the file q4bottom.html, both of which you must place into your page.

5. SQL (20 points)

Write an SQL query that will return the names of all characters that appeared in two or more of the Pirates of the Caribbean movies; that is, movies whose name contains the substring "Pirates of the Caribbean". Ensure that the results are returned in alphabetical order. If it helps you, you may assume that the character is played by the same actor in both movies. The following is a subset of the results returned:

+----------------------------+
| Anamaria                   | 
| Bad Pirate                 | 
| Barbossa                   | 
| Bo'sun                     | 
| Butler                     | 
| Captain Jack Sparrow       | 
...
| Young Elizabeth            | 
| Young Will                 | 
+----------------------------+
73 rows in set (53.41 sec)

Recall that the imdb database contains the following tables:

X. Extra Credit (+1 point)

Write a haiku related to CSE 190M. A haiku is a Japanese poem made of three lines with 5, 7, and 5 syllables respectively. For example, the following is a haiku about Java:

public class Marty
public static void Booyah
System out println

(Any reasonable attempt at a haiku will get the +1 point.)