Database Systems for Website Applications Part 3, 4, & 5 for "The grAde"

Project Part 3

Creating the User Interface

The focus of this week is PHP design and implementation. You will design a client-side application with the specified requirements. Review PHP code structures and provide basic instructions on object-oriented techniques. Work on your Dropboxassignment and submit the following by the end of the week:

·         Create the HTML web pages that you plan to use in your Dropbox assignment. Submit a screenshot for each web page.

·         Add the proper PHP code to retrieve information from the database (items) and display them on the page. Submit a screenshot of the items displayed on the screen.

·         Create a Login screen allowing users to log in to determine whether user is an admin or just a regular      user (a return customer). Submit a screenshot of the admin or login page.

·         If user is administrator, and after logging in, display a new link on the main page for administrative users to click on which will direct them to a page allowing them to insert or delete new items from the table in the database. Submit a screenshot of the main page before and after admin logs in.

Submit all screenshots, with PHP code in one zipped file to the Dropbox.

Support your responses with examples.

Cite any sources in APA format.

Project Part 4

Adding Administrative Rights

This week, you are going to work on the administrator page.

You are going to create a page (or more) to allow administrators to modify the database content built in the previous weeks using Hypertext Markup Language (HTML)/PHP interface. Build the following page or pages using PHP script:

·         Create an admin page that provides the following functionalities:

o    Add a new book to the appropriate table that you created in the W3 Assignment 2. Item should have data for each of the fields in your table.

o    Delete an existing book from the appropriate table.

o    Modify the name of an item in the appropriate table.

o    If there is a field for price, modify the price of an item in the appropriate table.

Submit screenshots for each operation together with your HTML and PHP code in the appropriate Dropbox.

Support your responses with examples.

Cite any sources in APA format.

Project Part 5

Putting it All Together

Based on your designs in previous weeks' Dropbox assignments, this week, you are going to link the interface to the database.

In this assignment, you are going to work on getting the website to interact with both the user as well as the database to display the data on the screen. Work on the following points and submit a screen shot for every element together with your HTML/PHP code:

• Link the first page to display contents (items) from the database. Make sure every item has an "add item" button or link to add the item to the shopping cart.