HW02: Database Read and Write due Tue 30 Jan 13:20

\begin{purpose}
In completing this assignment you will:
\begin{itemize}
\ite...
...ormation obtained from a
form into the database.
\end{itemize}
\end{purpose}

Allowed and Disallowed Resources

In completing this assignment you MAY use/access the following resources:

You may NOT use/access:

Failure to abide by these guidelines will result in a zero for the assignment and the incident will be reported to the university provost as a violation of the university academic integrity policy. A second incident of academic dishonesty (whether from this course or another computer science course) will result in an F in the course.

Overview

Do all work for this assignment in the web2/hw02 directory.

This assignment is the first in a series that will continue for the rest of the semester. You will be building a simple community book-selling website in which users can list books for sale (title, condition, and price) and interested shoppers can contact the seller to arrange for the sale.

At the end of this assignment you will have a reasonably good looking site with the following features:

Example queries you'll need:

SELECT title, price FROM your_schema_name.books  -- list title/price of all books

INSERT INTO your_schema_name.books (book_id, title, condition, price)
    VALUES (default, 'Cool!', 3, 12.95) -- insert book into database

It would make sense for you to use the basic styling and page arrangement you used for your final web page from last semester, but you are welcome to branch out and do something different.

IMPORTANT: Although it can be tempting to tweak code in place after an assignment is due you should not do so. Since I am grading the files in-place on the server all I have to go on are the time stamps on the files. If you open a file and then save it (even without making changes) the time stamp is changed. If there is a tweak you feel has to be made then let me know what file and what change you want to make.