PHP代写 | 31748 Programming on the Internet Assignment

本次澳洲IT代写主要是PHP网站开发

31748 Programming on the Internet

Assignment 1:
“An On-line Grocery Store with Graphic User Interface”

Due on: Friday 23 April 2021, at 11:59 pm

Introduction

In this assignment, you are required to develop a web site for a Grocery Store to run a grocery business on-line. This Grocery Store system is a simulated online grocery shopping experience. It is applicable to any e-commerce shopping application.

The products in the store for sale can be divided into five categories: Frozen-Food, Fresh- Food, Beverages, Home-Health and Pet-Food. The data pre-defined in a MySQL database is shown as below:

Attributes associated with each product:
(Table; products)
+---------------+------------------+------+-----+---------+-------+
| Field         | Type             | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+-------+

| product_id    | int(10) unsigned |

| PRI | 0       |       |
|     |         |       |
|     | 0.00    |       |
|     |         |       |
|     | 0       |       |

| product_name  | varchar(20)
| unit_price    | float(8,2)
| unit_quantity | varchar(15)
| in_stock      | int(10) unsigned |
+---------------+------------------+------+-----+---------+-------+

| | |

Products available for sale: +————+——————–+————+—————-+———- +
| product_id | product_name | unit_price | unit_quantity | in_stock | +————+——————–+————+—————-+———- +

  • |        1000 | Fish Fingers       |
    |
    
  • |        1001 | Fish Fingers       |
    |
    
  • |        1002 | Hamburger Patties  |
    |
    
  • |        1003 | Shelled Prawns     |
    |
    
  • |        1004 | Tub Ice Cream      |
    |
    
  • |        1005 | Tub Ice Cream      |
    |
    
  • |        2000 | Panadol            |
    |
    
  • |        2001 | Panadol            |
    |
    

2.55 | 500 gram
5.00 | 1000 gram
2.35 | Pack 10
6.90 | 250 gram
1.80 | I Litre
3.40 | 2 Litre
3.00 | Pack 24
5.50 | Bottle 50

|     1500
|      750
|     1200
|      300
|      800
|     1200
|     2000
|     1000

  • |        2002 | Bath Soap          |
    |
    
  • |        2003 | Garbage Bags Small |
    |
    
  • |        2004 | Garbage Bags Large |
    |
    
  • |        2005 | Washing Powder     |
    |
    
  • |        2006 | Laundry Bleach     |
    |
    
  • |        3000 | Cheddar Cheese     |
    |
    
  • |        3001 | Cheddar Cheese     |
    |
    
  • |        3002 | T'Bone Steak       |
    |
    
  • |        3003 | Navel Oranges      |
    |
    
  • |        3004 | Bananas            |
    |
    
  • |        3005 | Peaches            |
    |
    
  • |        3006 | Grapes             |
    |
    
  • |        3007 | Apples             |
    |
    
  • |        4000 | Earl Grey Tea Bags |
    |
    
  • |        4001 | Earl Grey Tea Bags |
    |
    
  • |        4002 | Earl Grey Tea Bags |
    |
    
  • |        4003 | Instant Coffee     |
    |
    
  • |        4004 | Instant Coffee     |
    |
    
  • |        4005 | Chocolate Bar      |
    |
    
  • |        5000 | Dry Dog Food       |
    |
    
  • |        5001 | Dry Dog Food       |
    |
    
  • |        5002 | Bird Food          |
    |
    
2.60 | Pack 6         |      500
1.50 | Pack 10        |      500
5.00 | Pack 50        |      300
4.00 | 1000 gram      |      800
3.55 | 2 Litre bottle |      250

                                          8.00 | 500 gram
                                         15.00 | 1000 gram
                                          7.00 | 1000 gram
                                          3.99 | Bag 20
                                          1.49 | Kilo
                                          2.99 | Kilo
                                          3.50 | Kilo
                                          1.99 | Kilo
                                          2.49 | Pack 25
                                          7.25 | Pack 100

13.00 | Pack 200 2.89 | 200 gram 5.10 | 500 gram 2.50 | 500 gram 5.95|5kg Pack 1.95|1kg Pack 3.99 | 500g packet 2.00 | 500g

This assignment consists of four components. You are required to work individually to complete all functionalities of this project. This assignment counts as 45% towards your final assessment.

  • |        5003 | Cat Food           |
    |
    
  • |  5004 | Fish Food |
    | +————+——————–+————+—————-+———- +

32 rows in set (0.01 sec)

3.00 | 500g

|     1000
|     1000
|      200
|      200
|      400
|      500
|      200
|      500
|     1200
|     1200
|      800
|      500
|      500
|      300
|      400
|      400
|      200
|      200
|      200

Objectives

  1. Learn
  2. Learn
  3. Learn
  4. Learn
  5. Learn

Window Layout

The browser window is divided into three frames, the Left Hand Frame, the Top Right Hand Frame and the Bottom Right Hand Frame, as shown below:

Contents

The main focus of our on-line shopping project is to allow customers to visually search/browse for products available in the shop and then display the details of chosen products. Customers can add chosen products to a virtual shopping cart and when they wish to complete the shopping, they can checkout by filling an on-line Purchase Form that asks for the delivery of details and email address. Once the Form is filled out, the customer can complete the order by clicking on the “Purchase” button. The details of the order are then sent via email to the email address given on the form as a confirmation of the order.

There are four components in this project. These component will display in one of the three frames of browser’s window. The four components are :-

1. The left hand frame displays a Visual (e.g. an Image Map) Browser. The Visual Browser shows the category hierarchy of products available in the shop. The default image only shows two levels of the products hierarchy.

about the design of professional (advanced) Web pages
about real-life Website design, including hierarchal structures for navigation. how to use graphic tools for creating clickable rollover image maps
how to design customised presentation (layout) of Web pages
how to use server/client side scripting languages for creating dynamic Web

how to use PHP & MySQL for reading, writing and verifying data

how to create an e-commerce application using a combination of scripting languages, descriptive languages, development tools and backend databases.

pages

  1. Learn
  2. Learn

When the mouse pointer moves over a particular category node then the image displayed changes to a more detailed graph, showing the substructure of this particular category. At the lowest level of the hierarchy individual nodes are “live” i.e. they represent particular products and they are live links to a php file.

When a user clicks on a particular “product node” it will bring up a php file showing the details of the product in the right top frame.

  1. The top right frame is a web page generated on the server side by a php script. It retrieves the appropriate product entry from the MySQL products table and then displays selected attributes of the product in a web page generated by the script. Each product displayed has an “Add” button which adds the selected product to the user’s shopping cart, which is displayed in the bottom right hand frame.
  2. The bottom right hand frame displays a Virtual Shopping Cart, showing the user how many products that are already chosen and the total value of their selections so far. Users can empty the shopping cart (i.e. clear all selections made so far) by clicking on a “Clear” button. Users can also complete their shopping session by clicking on a button labelled “Checkout”. When the Checkout button is clicked, the system checks that the

user actually has products in the shopping cart, and if so it executes a php script whose results are shown in the top right hand frame. (If there are no products in the shopping cart a simple message is displayed in the shopping cart frame).

4. The checkout component displays a purchase form asking the user to fill in their delivery details (name, address, suburb, state, country and email address). All these fields must be completed for the order to go ahead. The user completes the transaction by clicking on a button labelled “Purchase”. The details of the order are sent via email to the email address given on the form.

Process

  •   Use Cloud9 or your local IDE for development. Deploy your website using BeanStalk.
  •   Use a graphic tool of your choice to cre image maps.
  •   Use clickable image maps and JavaScript to create your rollover image maps.
  •   Use PHP code to retrive products’ information from MySQL database
  •   Test each component of your system, and then integrate all components into a

    complete system.

    Submission

    You submit the assignment details (your name, Student ID, URL of the assignment, partner’s details (if done with someone else) through a form which will appear as a menu option on the subject website. If you want to you can submit your assignment details after the form appears, but prior to the due date you may do so. There will be a link to the submission form at the subject homepage for making your submission. You will be asked to submit the URL of your page.

  •   Before you submit your assignment, please check whether your web site is accessible.
  •   Do not send the URL of your assignment to the lecturer or tutors by email!

    After the indicated deadline submissions will not be accepted!

Collaboration/plagiarism

Students are reminded of the principles laid down in the “Statement of Good Practice and Ethics in Informal Assessment” in the Faculty Handbook. Assignments in this subject should be your own original work. Any collaboration with another participant should be limited to those matters described in the “Acceptable Behaviour” section. Similarly, any group work should be the result of collaboration only within the group. Any infringement by a participant will be considered a breach of discipline and will be dealt with in accordance with the Rules and By-Laws the University. The Faculty penalty for proven misconduct of this nature is zero marks for the subject. For more information, see: