The MegaGamez Web Site With Shopping Trolley

1
The MegaGamez Web Site With Shopping Trolley

• Dave Elliman

2
Specification

• To produce am e-commerce web site
• The site is a company MegaGamez
• It sells 4 X-Box Games
• Crimson Skies XBCrims
• Ghoulies XBGhoul
• NFL Fever XBFever
• Midtown Madness XBMidto

3
Pictures of These Games
4
Specification

• The customer can add a game to a shopping cart.
  The same game can be added any number of times
• The customer can view the cart
• The customer can delete a game from the cart
• The customer can purchase the games

5
The Events That Affect the Shopping Cart
Main Page
View Cart Page
6
Purchase Page

• Collects following information about a customer
• email address (primary key)
• password
• You can then look up the customer details and
  check validity
• A button to purchase. This stores the order in a
  table

7
A Refinement in PHP

• pwdcoded crypt (passwd, passwd)
• This is a ONE WAY function

Simple to use, just crypt it whenever it is input
and store it in that form
8
In Summary

• We need some web pages
• Home select games
• View trolley View order and delete items
• Buy Identify customer and purchase
• Later we need to write the customer details
  handling or credit card processing

9
Database Handling

• The application will use a MySQL database.
  Details could be
• Host saruman.cs.nott.ac.uk
• Database elc
• Port 3306
• Username ltmegt
• Password ltmysecretgt

10
Database Tables

• You need SELECT permission on
• TABLE customers
• TABLE games
• You have SELECT, UPDATE permission on TABLE
  ltyourlogingt
• and ltyourlogingt_lines
• This last table should contain Cart contents and
  Orders placed

11
The games table
code char(7) title varchar(144) price int
(pence)
There are four games in the table as on slide 2
What other fields might be needed in practice?
12
The customer table
emailpasswordtitlesurnamefirstnameaddr_line1
addr_line2townpostcode all varchar()
13
The orders table

• email // for customer
• stamp // date and time
• real // yes/no - if ordered
• cost // int in pence
• // note cots is at time of purchase

14
The orderlines table

• email // for customer
• stamp // date and time
• code // for game
• no_off // int no of this game