CS-090.3 Assignment 7

For this assignment, you are to look up the user’s email address and password in the database.

Each student has his or her own database on maple: the database name and the user name for accessing it are both your own last name (uncapitalized). The password is the word “secret.” If the user supplies a valid QC email address, connect to your database using the pg_connect() function. If your last name is Jones, your connection string would be host=maple.cs.qc.edu dbname=jones user=jones password=secret. Remember, you can access your database only from computers on campus (IP address of 149.4.xxx.xxx).

If the email address supplied by the user matches any email addresses in the people table of the database, list the first_name and last_name fields for all matching addresses. If the email address is not in the people table, print a message saying so.

When you have tested your web pages, send me an email message to me saying your assignment is ready; I will get a copy from your account on the server and check it out. Send your email to:

Christopher.VickeryATqc.cuny.edu

Be sure the Subject Line of your email says CS-90.3 Assignment 7, just like that, to be sure your message does not get trapped by my spam filters.

Be sure to sign your email so I can tell who sent it!