University of Washington, CSE 190 M

Lab 9: Practice Final Exam Problems

created by Brian Le and Marty Stepp

Basic lab instructions

This lab's purpose is to practice problems that are similar to those on the final exam.

You may want to bring your textbook to labs to look up syntax and examples.
We encourage you to talk to your classmates; it's okay to share code and ideas during lab.
You don't need to finish all of the exercises. Do as much as you can in the allotted time.
Before you leave, check in with a TA to get credit.
Resources: lecture slides

Exercise : JavaScript/DOM/Prototype

Write JavaScript code so that when the page loads, every table in the page will become "zebra striped."

Every odd row should be changed to have a black background and white text. (The page's CSS file has a class named zebrastripe that you can attach to the odd rows.)
Note that the number of rows in one table should not affect the striping for another table.

before

after

Name	Bounces
Snuggles	7
Horseface	13
Cornelius	3
Tigger	1000

Name	Favorite Pasta
Snuggles	Fettucini Alfredo
Horseface	Spaghetti Pomodoro
Cornelius	Chicken Penne

Name	Bounces
Snuggles	7
Horseface	13
Cornelius	3
Tigger	1000

Name	Favorite Pasta
Snuggles	Fettucini Alfredo
Horseface	Spaghetti Pomodoro
Cornelius	Chicken Penne

Exercise : Ajax/XML

Write the complete JavaScript code to fetch XML data about rectangles and display it on the current page.

The data comes from a page rect.php in the same directory as your code. When contacted with no parameters, it outputs a group of rectangles to draw on the page, such as:

<?xml version="1.0" encoding="UTF-8"?>
<shapes>
  <rectangle x="10"  y="40"  width="100" height="30" color="FFFF00" />
  <rectangle x="190" y="10"  width="20"  height="60" color="9000DD" />
  <rectangle x="30"  y="120" width="90"  height="55" color="00BB88" />
</shapes>

Process the XML and display each rectangle as an absolutely-positioned div of the right position/ size/ color. Add it to the div with id of rectanglearea:
```
<body> ... <div id="rectanglearea"></div> ... </body>
```

Exercise : PHP

Write a PHP file lookup.php that looks up a name in a file and outputs a URL about the person.

You will be given a full name as a GET parameter name. Assume that the parameter is always passed.

Read data from a file employees.txt. Full name, username, and position are separated by tabs:

Morgan Doocy        mdoocy    Devourer of Souls!!!!
Conner Q. Reilly    con74     Director of Archives
Marla Jeffries      mjeff     Lamination Tzar

If the name is matched, output a URL with the employee's name/title, in the following format:
```
http://www.awesomeco.com/PositionNameWithoutSpaces/userName
```
- For example, lookup.php?name=Conner+Q.+Reilly produces the following output:
```
http://www.awesomeco.com/DirectorofArchives/con74
```
If the name is not matched, output the URL: http://www.awesomeco.com/

Exercise : SQL

Write an SQL query to show all actors who share the same last name and were in a movie together. Display the first names, last name, and movie name. Do not match up an actor with him/herself. Order by last name.

+-----------------+------------+-----------+---------------------+
| first_name      | first_name | last_name | name                |
+-----------------+------------+-----------+---------------------+
| Bill (I)        | Frankie J. | Allison   | Ocean's Eleven      | 
| Anthony         | Frankie J. | Allison   | Ocean's Eleven      | 
| Anthony         | Bill (I)   | Allison   | Ocean's Eleven      | 
| J. Todd         | Sharon     | Anderson  | Fargo               | 
| ...             | ...        | ...       | ...                 |
| Elenor          | Rowan      | Witt      | Matrix, The         | 
| Ben (I)         | Samuel E.  | Wright    | Little Mermaid, The | 
+-----------------+------------+-----------+---------------------+   134 rows in set

Recall that the imdb database contains the following tables:

actors
id	first_name	last_name	gender
433259	William	Shatner	M
797926	Britney	Spears	F
...

movies
id	name	year
112290	Fight Club	1999
209658	Meet the Parents	2000
...

roles
actor_id	movie_id	role
433259	313398	Capt. James T. Kirk
797926	342189	Herself
...

Exercise : PHP, HTML, SQL

(The next 2 slides describe this exercise. Please read them both, then start.)

Write the PHP code to display all the results from the preceding SQL query in two ordered lists.

The first list should show last names that start with A-J inclusive, and the second shows K-Z names.
Write a function display_last_names that displays these two lists, as shown below:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
    ...
    <body>
        <?php
        display_last_names();
        ?>
    </body>
</html>

Exercise , continued

Your code should produce the following output (abbreviated):

<ol>
    <li>Allison, Anthony / Bill (I): Ocean's Eleven</li>
    <li>Allison, Anthony / Frankie J.: Ocean's Eleven</li>
    <li>Allison, Bill (I) / Frankie J.: Ocean's Eleven</li>
    <li>Anderson, George (IV) / Jo (I): JFK</li>
    ...
    <li>Jones, Annette / James Earl: Star Wars</li>
    <li>Jones, Annette / Linda (I): Star Wars</li>
    <li>Jones, James Earl / Linda (I): Star Wars</li>
</ol>
<ol>
    <li>Kennedy, Caroline / Ethel (II): JFK</li>
    <li>Kennedy, Caroline / Jacqueline (I): JFK</li>
    ...
    <li>Witt, Elenor / Rowan: Matrix, The</li>
    <li>Wright, Ben (I) / Samuel E.: Little Mermaid, The</li>
</ol>

You may have to give unique names to columns in your query, so you can access the columns in your PHP code. Do not use print/echo statements. You do not need to check for MySQL errors.

If you finish them all...

If you finish all the exercises, you're done! You could go look at the recent section practice final exam problems, or if the lab is over or almost over, check with a TA and you may be able to be dismissed.

Great work! Good luck on the final exam!