[SOLVED] C html database Instructions

$25

File Name: C_html_database_Instructions.zip
File Size: 263.76 KB

5/5 - (1 vote)

Instructions
Modify each page to include the sessionstart function.
The index page needs to clear the session variable for selected category.
The header should be changed so that only for the index page, the categories are retrieved from the database and an array created.That array should be stored as a session variable.
The dropdown box on the header should be driven from the category array that is stored as the session variable in step 3 above.
The header needs to check if the number of items in the cart is stored as a session variable.If so, that should be displayed.If not, the number of items in the cart should be 0.
The category page needs to store the number of items in the cart as a session variable.
The category page needs to store the selected category as a session variable there must always be a selected category if the category page is loaded.
Modify the left section of the category page that shows the list of categories so that it is driven from the category array stored as a session variable in step 3 above.
Modify the right section of the category page that shows the books, so that based upon the selected category, the right books will be retrieved from the database, instead of the array.Once done, you should be able to remove the array of books completely.
If the user goes to the cart page from the category page by clicking on an Add to Cart button or clicking on the cart on the header, there should be a session variable set for the selected category.
1sessionstart
2
3
43
50
6
7
83
9
10

When the cart page is loaded because the Add to Cart button was clicked on the category page, you need to:
Create an array of cart items, if it doesnt already exist.
Retrieve the bookId from the URL.
Increment the number of books in the cart
If the book is already in the cart, increment its count.
If the book is not already in the cart, retrieve relevant information from the database, based upon the bookId and store it in the cart items array.
Store the updated cart items array as a session variable.
The Clear Cart button should refresh the cart page with an action specified on the URL.When the cart page loads, it should check to see if the action is on the URL and, if so, reset the number of items session variable and the items array session variable.
If the selected category session variable is set, the Continue Shopping button should link to the category page, with the selected category still selected.If the selected category session variable is not set, the Continue Shopping button should link to the Index page.
The Update Quantity code needs to be updated to store the updated quantity of the right book in the array of cart items.
The table that shows the contents of the cart including the headings should only be displayed if the cart is not empty.If it is empty then a message saying Your cart is empty should be displayed instead.
The rows of the table should be populated using the cart items array that is stored as a session variable.
The totals at the bottom of the cart item table need to be implemented.When the total dollars in the cart is calculated, it should be stored as a session variable.
If the cart is empty, when the checkout page is loaded, there should be a redirect to the confirmation page.
The Checkout Summary on the right of the checkout page should be implemented using the cart total that was stored as a session variable.
The confirmation page should display one of two messages depending upon whether the cart was empty or not.It will either display There is nothing to check out or it will display Thank you for the order.Have a great day!.
11

bURLbookId
C
d
ebookId
F
12URLURL
13
14
15
16
17
18
19
20

On the confirmation page, the session variables should be initialized and the session id destroyed.
Below the message on the confirmation page, should be a Return to Home button, which links to the index page.
21ID 22

Specific Requirements
Make sure you upload two separate files to NYUClasses as stated in the Deliverables section above.
The number of items in the cart on the header needs to be fully functional.
The database should include two tables for books and categories
The database must have at least 16 records in the book table and 4 records in the category table.
The category page should display books that are retrieved from the database based upon the selected category.
The Clear Cart button on the cart page should be fully operational
The Continue Shopping button on the cart page should be fully operational taking the user back to the category page with the same category selected or the index page if no category was selected.
The Update Quantity function should be fully operational including removing a book from the cart if the quantity is zero
The Add to Cart button should be fully functional, taking the user to the cart and updating the display appropriately.
The table on the cart page and the various totals should all reflect the user actions.
1NYUClasses 2 3 4164 5 6 7 8 9 10

The checkout page should be fully functional, i.e. the totals should all be accurate.
The checkout page should not be displayed if the cart is empty.
The confirmation page should have a different appropriate message depending upon whether the cart is empty or not.
The two database tables should have primary keys specified and there should be a foreign key relationship between the two tables.
The datatypes for the attributes should be appropriate.For example, the price attribute in the book table should be numeric.
The session and session variables should all be initialized and destroyedunset at the appropriate times.
Your class and element names should be simple, contentrelevant, and readable.
All names should be camel caseexcept for files which should be lower case with words separated by an underscore.
Your HTML code should be properly formatted with indentations showing nested elements.
Your CSS code should be properly formatted with each rule on a separate line, with rule sets clearly grouped.
There should be no unused code i.e. no commented out code or CSS rules that do not refer to anything.
There should be no CSS in the HTML pages, either as part of the head section or as attributes for specific elements.
There should be no code errors signified by red crinkly underlines or yellow highlights.
If you use any techniques that you find through online research, you must be prepared to explain why they are better than what is described in the book or what was taught in class.Failure to do so will result in no credit for the code.

11
12
13
14
15bookprice
16
17
18
19HTML
20CSS
21CSS
22HTMLCSS
23
24

Grading Rubric
Category
Item
Penalty
Overall
Incorrectly named deliverables
0.5

Missing elements or badly packaged deliverables
0.5

Functionality
The cart count on the header is not working correctly
0.5

Cart page not fully functional
1

Checkout page not fully functional
1

Confirmation page not fully functional
1

Each cart page action button not working as specified
0.5

The category page does not correctly retrieve books from the database
1

Category dropdown not driven by the database
0.5

Category list on category page not driven by the database
0.5

The Update Quantity function does not work as expected
0.5

The Add to Cart button does not work as expected
0.5

The cart page does not display books correctly
0.5

The cart page totals are not correct
0.5

The cart page money fields do not show dollar signs
0.5

The information on the checkout page is not correct
0.5

The checkout page money fields do not show dollar signs
0.5

The checkout page is displayed if the cart is empty
0.5

The confirmation page does not display the appropriate message
0.5

The Read Now functionality is not implemented for some books
0.5

Coding
The database does not have a book and category table
1

The database does not have 4 categories and 16 books
1

The database tables do not have primary keys and a foreign key
0.5

Unnecessary database fields are created
0.25

Unclear database naming
0.25

Inappropriate database data types
0.25

Web page code naming not clear and relevant
0.25

Camel case not used for variableselements namesclasses
0.25

HTMLCSS not properly formattedorganized
0.25

CSS in HTML pages
0.25

PHP code unnecessarily complicated
0.5

Code errors present
0.25

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shopping Cart
[SOLVED] C html database Instructions
$25