Informatics I494: Designing and Developing an Information System

Objectives: 

The objective of this assignment is for the student to demonstrate a reasonable level of comfort with constructing simple PHP that allow interaction with a database, and thereby complete the I494 PHP 2 technology seminar requirements.

Assignment 

1. Create a table on your MYSQL account (use database yourusernamedb ) on spock.informatics.indiana.edu. The table will represent the list of registered accounts for our book exchange, so you can pick an appropriate name for the table (i.e. user) The attributes for the table should include account number, first name, last name, email address, creation date, password, and username. You should create the table by writing a php script that takes a table creation query and runs it on the MYSQL server.

2. Create php script(s) that allow you to view the data in your table and either add to or delete entries from your table.

Turn in the links to your PHP scripts in a text file. Include complete copies of your PHP source for each page in the file! In other words, copy and paste your code for each page into the text file. Name the file php2.doc and submit it in the Technology Seminar dropbox on Oncourse. If you don't know where to start, look at the "source" examples here. They are essentially doing everything you need in this assignment.

Due Date: