Earn Higher Grades With Instant Assignment Help.Ask Question!

Database
(5/5)

You will allow visitors to register on your shopping website. The visitor will also be able to log in (and stay logged in).

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Assignments must be completed on your own. Any evidence that students have collaborated on assignments will be considered a violation of the academic honesty code.

 

You will allow visitors to register on your shopping website. The visitor will also be able to log in (and stay logged in). You will update the Description page to make it dynamically show the different items you have listed in your database (depending on which item was clicked on from the Items page). Users will be allowed to update their profile information & image. Users will also be able to post a review for the items available on your website.                                                                                       

                                                                                                                 

Review the submission instructions before starting. View my current Assign4 for more information: http://3.83.90.210/hawkins_assign4/

 

  1. On the php, allow a visitor to register with the website. Check if the username is already in the database BEFORE allowing the user to register. Reminder: a customers record needs the date of when the user account was created.

 

  1. On the php, when the user has entered in valid information, create a session. If the customer did not enter a valid user_name & password, make sure to destroy the session.

 

  1. On the php, update the random variable to find out if the user is logged in. If the user is logged in, make sure to output the name of that user that is logged in.

 

  1. Update all website pages to start a session. Update the logged-in pages to see if the user is logged in & if the user is not logged in, send the user to the php page.

 

  1. Create a php file. Redirect the user to the home page.

 

  1. Update the php to show the link to let a user log out.

                                                                           

  1. On the php, add in each item’s Item_Id to the link to the Description page in order for this information to be retrieved from the URL.

 

  1. On the php, use the columns from the items table that outputs the information to the page appropriately (ie: the Item_Name would go in the H3 for the “Generic Name”, Item_Price would be output to the Price location on the page) – make sure that you GET the Item_Id from the URL in order to show just the item you clicked on. Use the Item_Id to dynamically change the contents of your description page, pulling in information that you have stored in the database about each item. Remember the user reviews.
  • You will need an image for each of the items listed in your database. Resize each image to be appropriate in size.
  • Suggestion: store your item images in an itemImages folder to keep your main folder organized.
  • You will need a different query to SELECT the user reviews for that item and display them on the page. If there are no reviews for that item, ask the user if they’d like to leave one.
  • If the user does provide a review, update the reviews table with the review, the item, the user, and the time the review was posted.
  • Reminder: sanitize any information you receive from a user.

 

 

  1. On the php, get any information stored in the customers table for the user who is logged in.
  • Use this information to dynamically change the contents of the profile page, pulling the information stored in the database and modifying it to be appropriate for the web page.
  • Users should be able to update & change their profile image. Allow images formats of GIF, JPEG, or PNG. Rename the filename of the image to be the user’s name & the appropriate extension. For easier maintenance, store these images in a custImages
    $location = "custImages/" . $UserName . $ext;
    move_uploaded_file($_FILES["image"]["tmp_name"], $location);
  • Users should be able to update only the parts of their profile they want. If one of the form fields is filled in, UPDATE the customers table for that user with the information they have submitted. Remember to sanitize each field and provide a date of when the user has last updated their information.

                                                      

Submission Instructions (-100 points):  

  • Upload all files in a folder (LastName_Assign4) on your Development Server.
  • (-100 [-25 * 4 files]) All files must validate to green status using the W3C Validators.
    Validate by URI – copy the URL address for each page and paste it into the Address location.
  • Do NOT ZIP your folder on your Development Server.
  • In the dropbox on Folio:
    • Upload your LastName_Assign4 folder that has been ZIPPED.
    • Paste the URL to your Assignment 4 folder on your Web Server in the comments section.

Assignment 4 will NOT be graded if it has not been uploaded to your Development Server AND to Folio

Attachments:
(5/5)

Related Questions

CSI 1420 Introduction to C Programming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two majorconstructs of the C programming language – Fu

The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

Ask This Assignment To Be Done By Our ExpertsGet A+ Grade Solution Guaranteed

expert
joyComputer science
(4/5)
12 Answers Hire Me
expert
Robert DLaw
(4.8/5)
519 Answers Hire Me
expert
Dr Samuel BarberaStatistics
(5/5)
798 Answers Hire Me
expert
Tutor For YouEconomics
(5/5)
952 Answers Hire Me