ICS415 - Programming for the Web

Fall 2008

Assignment Problem Page Problem Link
1 1 N/A N/A N/A
2 N/A N/A N/A
3a 158 4.18 N/A
3b 196 5.8 N/A
3c 196 5.9 N/A
2 1 357 9.7 area-circle.html
2 359 9.19 temp-convert.html
3 360 9.27-28 teach-multi.html
4 360 9.30-31 guess-num.html
5 361 9.35 visual-rec.html
3 1 486 12.3 links.html
2 486 12.5 button-increment.html
3 486 12.6 print-collections.html
4 486 12.7 N/A
5 486 12.10 spolarium.html
4 1 514 13.3 1.html
2 514 13.6 2.html
3 587 14.7 cookies.xml
4 587 14.8 nutrition.xsd
5 1 903 22.4

A) SELECT lastName, firstName, authorID
FROM authors

B) SELECT titles.title, titles.copyright, titles.isbn
FROM titles INNER JOIN (authors INNER JOIN authorISBN ON authors.authorID = authorISBN.authorID) ON titles.isbn = authorISBN.isbn
ORDER BY titles.title

C) INSERT INTO authors
VALUES (5, 'James', 'Patterson')

D) INSERT INTO titles
VALUE(0132404168, 'C# How to Program', 2, 2006)
SELECT titles.isbn, titles.title, titles.editionNumber, titles.copyright
FROM titles INNER JOIN (authors INNER JOIN authorISBN ON authors.authorID = authorISBN.authorID) ON titles.isbn = authorISBN.isbn
2 955 23.4 A{1}[[:alpha:]]{3,}B+[[:digit:]]{2}
3 955 23.5 Input from an XHTML form is retrieved using the superglobal arrays $_POST or $_GET that are sent to the web server and the data is processed and sent back to the client as XHTML.
4 955 23.8

email-form.php

register.php