Courtney Sell


Publish a straightforward E-retail store application employing PHP and MySQL*. This may be a bookshop, tunes retail outlet, clothing retail outlet, or anything you want. There must be a “particular person” interface to permit potential clients to pick and purchase things (Really don’t be concerned regarding the payment facet of details). Preferably there also ought to absolutely become a password-protected “operator” interface, to enable the E-shop operator to point of view/edit stock and pending orders.

The workout is deliberately “hard” delivered the fast deadline, Which i under no circumstances anticipate Every person effectively to complete it to perfection. This could most likely be taken into consideration within the marking.


[A 5%] Capability to compose Doing the job HTML code (i.e. code that makes prosperous markup on a browser window).**

[B five%] Capacity to submit an HTML Net-website over a server these types of that It is really recognizable about the net. ***

[C 10%] Ability to make an HTML kind communicate with a PHP script.**

[D 10%] Electrical power to come up with a PHP script talk to a MySQL database.**

[E forty%] Procedure (the extent to which the software method’s Technique complies with – or exceeds- the primary specification).

[File 10%] Person friendliness (the extent to which the browser shows are clear and self-explanatory).

[G ten%] Presentation. (This may encompass suitable utilization of photos, colour, textual content material fonts, design and style-sheets and dynamic HTML capabilities.)

[H ten%] Clarity and readability of coding and similar documentation (e.g. utilization of opinions, appropriate indentation etc.)


*If you wish to use exclusive World-wide-web-principally based systems (e.g. ASP, JSP, Pearl) make sure to do this. Possessing stated that, make sure you Do not use substantial-stage Personal computer application packages which need to have no programming abilities (e.g. “wysiwyg” HTML editors), as these rather defeat the objective of acquiring this module.

** In groups A to D, the marks are awarded inside of a “binary” way (i.e. the scholar receives maybe The full weighting mark or else zero). As a result thirty% is often attained just by demonstrating a basic idea of HTML, PHP and MySQL. The remaining classes are marked in an exceedingly “constant” vogue (i.e. any variety of marks relating to zero combined with the weighting well worth is usually awarded).

*** Whilst within the social gathering of server failure (or other irresolvable technical troubles) Category B will most likely be taken off and also the weightings of the opposite types scaled appropriately.


My electronic store software is to your sale of textbooks in addition to other assorted merchandise sold from the Wandle Industrial Museum.

This development is admittedly a reasonable extension to an recent static Web-web site. The info and primary format of my software are derived from this pre-existing do The task.

The primary INTERFACE:

the initial Display screen, not including the First frames Used in the Museum World wide web-website. The vast majority of the content material in the most beneficial and base frames is non useful and is usually incorporated for completeness, this can also assist show the dynamic HTML that delivered secondary navigation constructions.

This Show shown The real key physique of your respective shop particulars along with the “procuring basket” capabilities while in the button. This web page provides entry to:

just one) An entire list of the online “catalogue”;

two) A subset in the catalogue outlined by products or services group;

three) A subset in the catalogue dependant on person outlined lookup conditions;

4) A lot more specific details of the merchandise;

five) Capacity to include goods for your session based mostly “browsing basket”;

6) Ability you registered buyers to put in writing tutorial testimonials;

If a person is new into the equipment, he/she’s tested the message “Welcome. At present a shopper? Click the link to register”, or else they see their individual name and also a button to the top named “My account” which allows them to edit their data and details . This facts is saved in just a client facet cookie Which might be retained for 30 minutes.

Concerning the SUMMARY Show:

The summary of points displays the merchandise code, title, value, description and stock diploma of all objects. The Display screen also includes two supplemental other alternatives, a single items which might be from inventory are show in pink textual material. 2 merchandise that aren’t bought from the online retail outlet are “grayed-out” in Similarly these cases the “get” button is removed from all shows for the provided products.


The Basket To begin with There’s undoubtedly not procuring basket till lastly the person presents an item, right until finally this kind of time clicking around the “viewpoint basket button reveals a default observe.

When an product or service is additional, its volume is going to just one by default, This will the two be Increased by introducing the same merchandise in the direction of the basket once more or by clicking inside the increment button for the basket monitor revealed right here. Once a basket is produced and the person enters the course of action the following remedies may be received beneath the answer description:

1) Unique cart;

2) Carry on on getting;

3) Checkout;

In the event that the item is de-incremented to zero then it truly is faraway from the basket.

The basket is predicated on PHP classes and in contrast to the top end users identification, that may be reined for thirty minutes, will likely not persist subsequent the situation inside the browser is shut.

In the celebration the person is unidentified for the making use of when he/she makes an attempt to finish the transaction, they will be questioned to sign-up, Inside the party The patron has an account he/she will be able to login and continue With all the transaction.

If the consumer has not received an account he/she have to register just right before with a chance to total shopping for almost nearly anything.

Including Products To the Getting BASKET:

Goods might be further to searching basket both from any summary listing, or an solution description web page.

A summary web site shows standard solution facts and facts in an exceedingly tabular construction whithout illustrations or photos, much like the one shown great by clicking concerning the “receive” button around the remaining around the products line.

This may be completed inside the item depth page, that’s shown by clicking the products and solutions code revealed on the still left with the summary Exhibit.

Every person product depth webpage also contains a “acquire” button As well as another hunting basket products” These are generally more than the summary web-site but at The underside so desire scrolling

The databases supports two styles of things, “textbooks”, as established above, which encompass data precise to researching elements, and “goods” which only encompass easy products facts, products code, title and value.

Wherever by visuals ae not obtainable a substitution is straight away instituted till the administrator specifies an actual graphic.

In regards to the USER:

Must the user is unknown towards the applying when he/she tries to accomplish the transaction, They are going to be asked for to sign up, Must the individual has an account he/she should be able to login and continue Though utilizing the transaction

In case the person hasn’t gained an account he/she need to indicator-up upfront of getting the ability to end getting anything. Here we start to see the affect of the invalid try and register a completely new account. The consumer is presented a textual information description within your slip-up as well as the suspect entities are emphasize in sequence proper up until all anomalies are by now fixed.

Following the individual has registered he/she is questioned to print the shape for his/her reference. Then is logged in and may bypass authentication when purchasing.

The making use of continues to become complicated coded with a single administrative account, the username is “technique” together with the password is “god” Note There exists at this time no technique to change this.

The administration Display screen permits the prospective buyers to:

one) outline new product sorts;

2) Edit and delete persons;

3) Include, edit and delete groups;

This monitor enables The buyer to maybe edit an present info product while in the provided classification recognized by its solution code or create a new products or services day item. The applying contains a certain list of validation specifications as demonstrated in the next perception. Solutions are shown alpha numerically, continue to remaining to ideal.

Listed here we see the result of a unsuccessful facts entry operation denoted by crosses to denote invalid or missing entries for presented fields, Also a tick signifies the field is legitimate. It can be achievable to have a blank appropriate entry – eg, if There is no illustrations or images these boxes needs to be even now left apparent.

The query mark is usually to double Verify the intention to depart blank in guaranteed cases

This monitor reveals that theadministrator has picked to delete a consumer’s account in the databases – the edit and delete capabilities utilize the identical Show besides the edit complete wouldn’t display the delete warning

The interface The impression shows the Preliminary (welcome) display screen, not such as the frames Utilized in the Museum Web site.

This Show established the basic principle Over-all human body on the store knowledge together with the “shopping for basket” abilities at primary along with the button. This web site provides use of:

just one) A whole list of the world wide web “catalogue”;

two) A subset during the catalogue demonstrated by product classification;

3) Potential to have the catalogue demonstrated by product or service code, amount or title, in acceding purchase;

four) A subset with the catalogue based upon buyer defined lookup phrases;

5) Further detailed information about an merchandise;

six) Capability to include goods right into a session based mostly “browsing basket”;

If a person is new to the equipment, he/she’s demonstrated the knowledge “Welcome. Previously a buyer? Simply Simply click here to examine in”, Typically they see their human being identify As well as a button to the correct named “My account” which permits them to edit their data. This info is saved in a really shopper aspect cookie that is without a doubt retained for thirty minutes.

The administration Video display allows the customers to:

a single) Define new goods types;

two) Edit and delete buyers;

three) Insert, edit and delete forms;

four) Include things like, edit, transfer and delete things;

five) Edit and incorporate guidance facts;

six) Create and restore dumps of tables;


A data dictionary defines the prevalent problems, codes, and conventions produced use of. Shown below are usually the databases lookup tables required with the store databases software.

Desk: bookinfo: Feed-back: E-book specified metadata. Business Type Null Default code varchar(five) No No creator varchar(fifty) No Unidentified publisher varchar(100) No Unknown isbn varchar(fifteen) No None illustrations varchar(fifteen) Sure Sure - gray date day Absolutely sure NULL Proportions varchar(100) No Mysterious summary textual content No design and style varchar(sixteen) No

Desk: courses: Thoughts: Products metadata Self-discipline Style Null Default id int(three) No detect varchar(fifty) No etype int(a person) No 2 Lookup phrases varchar(100) No

Table: buyers: Responses: Shopper billing aspects. Subject matter Style Null Default uname varchar(fifteen) No first_name varchar(25) No last_name varchar(20 five) No telephone varchar(20) No e-mail varchar(fifty) No zip varchar(ten) No city varchar(fifty) No country_code int(two) No 0 bill_address varchar(90) No modified timestamp(fourteen) Certainly NULL

Desk: orderdata: Reviews: Client purchase facts Area Kind Null Default ordernumber int(5) No 0 itemcode varchar(5) title varchar(one hundred) No amount int(three) No 0 Total float No 0 posture int(11) No 0 stamp timestamp(fourteen) Not surprisingly NULL

Table: orders: Suggestions: customer get refferance facts. Willpower Form Null Default uname varchar(fifteen) No 0 ordernumber int(five) No standing int(1) No 0 day day Indeed NULL

Table: evaluations: Remarks: client book evaluations and rations. Matter Kind Null Default uname varchar(fifteen) No 0 variety int(just one) No rating int(one) No 0 stamp timestamp(fourteen) Certainly NULL critique textual articles No

Desk: goods: Desk reviews: Major products data. Spot Type Null Default code varchar(five) No category_id int(a few) Not one person title varchar(one particular hundred) No keywords and phrases and phrases varchar(255) No small_image varchar(fifteen) No nopic.jpg large_image varchar(fifteen) No nopic.jpg description text No selling value decimal(five,two) No 00.00 date_modified day No 0000-00-00 standing int(one particular) No one Desk: get: Remarks: Principal merchandise expertise. Discipline Variety Null Default code varchar(5) No day timestamp(fourteen) Without a doubt NULL inventory int(a few) No> fifteen Price tag decimal(five,2) No 00.00

Desk: pwl: Critiques: Consumer password/get hold of facts. Field Design and style Null Default uname varchar(fifteen) No upass varchar(one particular hundred) No 5d2e19393cc5ef67 developed timestamp(fourteen) Sure NULL

Table: syshelpindex: Responses: Technique guide difficulty index.Discipline Design and style Null Default cat int(2) No 0 material varchar(30) No

Desk: syshelpinfo: Remarks: software help specifics.Self-control Design and style Null Default cat int(3) No 0 title varchar(30) No specifics textual articles No photo varchar(20) No type int(just one) No 0

FILE Development: The Electronic shop application is on the sale of publications and likewise other assorted product or service acquired via the Wandle Industrial Museum. This improvement generally is a sensible extension to an existing static World wide web web page.

The equipment’s info are saved in nine subdirectories. These are definitely generally as follows: ../htdocs/order.htg/ Here is the foundation Listing of the online world software package, it is actually built up of all suggests connected with the Internet site. All generic info information and ancillary factors are saved at this amount of money. (3.74mb 263 data files)

  • continfo.php – Make contact with and ordering information (PHP 4.01kb).
  • create_db.sql – Databases development (SQL dump five.82kb).
  • credit rating-cards.gif – Usable financial institution playing cards types (image two.02kb).
  • cvc.jpg – Clarifying where by to find a CVC price tag (graphic six.0kb).
  • dictionary.txt – MYSQL Specifics Dictionary (textual content two.85kb).
  • price reduction.gif – Animalised ten% price cut for associates realize (photo 111.kb).
  • discount1.gif – Marketing a 10% price tag reduction for users (impression fifty 3.6kb).
  • avicon.ico – Depiction of an easy waterwheel (icon 318b).
  • index.htm – Custom Website 404 mistake Site (HTML one particular.76kb).
  • new_ani.gif – An animation Using the phrase ‘new’ (photo one.66kb).
  • delivers.gif – Graphic of your textual content ‘Look into these Precise provides’ (impression one particular.77).
  • pleasenote.gif – A burning animation of the text ‘make sure to Detect’ (effect fourteen.7kb).
  • reset.gif – Graphical enter sort reset button (graphic one.28kb).
  • store.gif – Modest photograph of the true museum store (image7.31kb).
  • put up.gif – Graphical enter sort submit button (picture 1.18kb).

../htdocs/get.htg/common.htg/ This Listing has all popular utility scripts as well as other assets the World wide web software relies upon upon.(185kb fifty data files)

  • about0.gif – Graphic through the textual content material ‘dwelling Web-site site’ (impression 0.98kb).
  • alart.gif – Animalised rotating red warning bulb (graphic 2.04kb).
  • notify.gif – A human cranium Together with the phrase ‘warning’ (three.39kb).
  • archive0.gif – Graphic with the textual material ‘archive’ (picture 970b).
  • backg.jpg – Wallpaper drawing depicting a watermill for your watermark (picture thirteen.6kb).
  • track record.jpg – Wallpaper showcasing a marble stone sort influence (image 4.59kb).
  • typical.css – Web site formatting and formatting descriptions (style and style sheet 7.53kb).
  • brics.gif – Animalised uncovered circuits in a really wall driving the wallpaper (image seven.46kb).
  • caurtion.gif – Animalised rotating warning street sign (graphic six.53kb).
  • cnote.htm – Website-web-site copyright and attribution information and specifics (HTML one.95kb).
  • – Software international information values (PHP involve 161b).
  • contact0.gif – Graphic in the textual content ‘contacts’ (photograph 976b).
  • db_lib.php – Widespread databases accessibility features and utilities (PHP twenty five.2kb .
  • disclaimer.gif – Animalised flashing graphic in the text ‘disclaimer’ (image four.57kb).
  • email2.gif – Drawing of your mail out box a couple of earth (picture 1.12kb).
  • fax.gif – Drawing of an easy fax machine (picture 231b).
  • feed0.gif – Graphic through the textual content ‘feed-back’ (picture 990b).
  • concentrate.js – Script to put give consideration to the hid popup window (javascript 165b).
  • home0.gif – Graphic from the textual written content ‘simple’ (picture 967b).
  • iiv.gif – Crystal clear graphic while in the Obtaining Volunteers emblem (graphic two.63kb).
  • iiv.fpg – Opaque graphic from the Investing in Volunteers emblem (photo 4.49kb).
  • index.htm – Individualized Internet-internet site 404 error web page (HTML 1.76kb).
  • data.gif – Transparent museum emblem with Get in touch with data (picture 2.31).
  • jfooter.js – Code to dynamically make webpage footer info (javascript two.41kb)
  • letter.gif – Drawing of two standard letters (image 698b).
  • linksb.jpg – A spider in an internet based on somewhat depiction with the browser (picture one.eighteen.kb).
  • linkware.gif – Transparent graphic of your respective textual content ‘all components on this Internet site are backlink ware’ (graphic a person.fifty six).
  • map0.gif – Graphic within the text ‘sitemap’ (graphic 989b).
  • members0.gif – Graphic on the textual articles ‘associates’ (graphic 984b).
  • – Freeola SQL support entry authentication details (PHP integrate 144b).
  • news0.gif – Graphic on the textual articles ‘news letter’ (photograph 947b).
  • – SQL authentication information for my server (PHP include things such as 144b).
  • nopic.jpg – See of there obtaining no obtainable Photograph (photograph 5.forty).
  • order0.gif – Graphic to the text ‘Mail Order’ (graphic 0.96kb).
  • cell phone.gif – Crystal clear graphic with the purple cellphone (image 281kb).
  • print.css – Monitor formatting descriptions (model sheet three.65kb).
  • registered.gif – Opaque graphic While using the registered museums emblem (image 428b).
  • registered3.gif – Transparent graphic inside the registered museums logo (image 2.80b).
  • resize.js – Code to dynamically modify a window into the picture dimension (javascript 1.05kb).
  • lookup.gif – Graphic of your respective textual content lookup’ (perception 108b).
  • – Code to dynamically make an SQL dump file (PHP integrate
  • cease.gif – Transparent graphic of the pink hand (impression two.64kb).
  • time.js – Code to dynamically Show a countdown timer (javascript 591b).
  • toc.js – Code to dynamically Monitor a navigation construction (javascript three.34kb)
  • wandlemuseu.gif – Very clear animated graphic while in the textual articles ‘The Wandle Industrial Museum’ (photograph forty two.3kb).
  • webbo.gif – Distinct graphic of webbo’s head (picture just one.16kb).
  • webo1.gif – Very clear graphic of webbo (graphic a few.81kb).
  • wimlogo.gif – Opaque graphic of your museum’s waterwheel model (graphic 417b)

../htdocs/order.htg/data_backup/ This Listing is used to maintain SQL dump files..(242kb 3 files) ../htdocs/get.htg/empower/ This directory is accustomed to maintain graphics for empower desk database. (336kb 26 data data files) ../htdocs/get.htg/photos.htg/ This Listing is used to preserve graphics with the store database. (two.41mb 91 info information)

../htdocs/obtain.htg/mysqlsnips This directory has a list of textual content information files suitable to illustration SQL Guidelines.

../htdocs/purchase.htg/shop.htg/ This Listing has Every single of the availability info data files applicable to the general public parts of the store databases utility scripts and in addition other template resources that the World wide web application is depending on. (eighty 5.1kb 20 details)

  • basket.php – Deliver and maintains a session dependent browsing basked (PHP 9.29bk).
  • book_detail.php – Code block for exhibiting in-depth info for a particular manual (PHP 2.41kb).
  • – Code block for exhibiting motion bottoms associated with products details (require two.43kb).
  • catalog.php – Generates conclude consumers viewpoint of the main catalogue interface (PHP six.63kb).
  • checkout.php – Script for updating the merchandise and buy databases (PHP five.02kb).
  • help.php – Show people point of view inside the program support desk interface (PHP six.71kb).
  • login.php – Script for consumer and databases administration login functions (PHP 7.91).
  • out-of-date login.php – Out of date login script (PHP8.99kb).
  • orderend.php – Code block for displaying browsing basket buttons (PHP one.36kb).
  • ordertop.php – Code block for exhibiting shot info and points and first controls (PHP5.73kb).
  • – Code block to create the ending HTML webpage structure (Entail 801b).
  • – Code block to produce the beginning HTML Internet site web page composition (Include 854b).
  • product_detail.php – Code block for exhibiting comprehensive Resolution info (PHP 1.15kb).
  • product_list.php – Code block for exhibiting summary merchandise data (PHP 3.07kb).
  • product_show.php – Code block that displays substitute summary points (PHP3.sixteen).
  • – Code block for exhibiting a information and facts for your buyer (incorporate 897b).
  • signin.php – Computer screen logon basic login visual display unit.(PHP three.08kb).
  • ailments.php – Show stipulations (PHP five.83kb).
  • terms2.php – Exhibit stipulations far a little one window (PHP 5.75kb).
  • thankyou.php – Exhibit closing affirmation monitor (PHP three.28kb).

../htdocs/buy.htg/update.htg/ This directory is produced up of all of the offer knowledge data files connected to the administration areas of The shop database and also other utility scripts. (240kb 34 data files)

  • addcat.php – Insert more product groups for the database (PHP two.18kb).
  • addproduct.php – Consist of supplemental merchandise to your databases (PHP 6.30kb).
  • admin.php – Web-website materials administration interface (PHP sixty 5.9kb).
  • backup.php – Generates databases dump info (PHP five.21kb).
  • – Existing faults For brand new e-e-book database goods (Require PHP 3.0kb).
  • – Code block for e ebook points entry (Include six.64kb).
  • – Screen editable reserve information (Involve ten.2kb).
  • – Code block to crank out editing command buttons (Incorporate things like four.41kb).
  • transform.php – Resource code for update affirmation messages (PHP14.4kb).
  • edithelp.php – Enables modifying and era of guidance desk info (PHP14.0kb).
  • – Code block for information entry kinds command buttons (Include just one.21kb).
  • error.gif – Clear graphic of a cartoon cross (Graphic 118b).
  • superb.gif – Crystal clear graphic fo a cartoon tick (Photo 126b).
  • assist.php – Display administrators evaluate While using the program empower desk interface (PHP six.22kb).
  • index.php – Administrative access to databases modification general performance (PHP twelve.5kb)
  • Bill.php – Make Present customer invoices for printing (PHP 5.33kb).
  • mysqlsend.php – Enable human being to execute tailor made made SQL Steerage (PHP 4.59)
  • – .Display new The category name error correction (Include things such as 773b).
  • – Computer screen new merchandise entry variety (Include 438b).
  • newproduct.php – Update/delete specifics from a inventory database (PHP 781kb).
  • – Exhibit new group entry style (Incorporate 563kb).
  • – Show approach facts messages (Consist of 524b).
  • oldorders.php – Display screen summary information for shut orders (PHP three.22kb).
  • orders.php – Clearly show picked out open buy facts and info (PHP 7.77kb).
  • – Show merchandise info and details Challenges (Contain such things as one.ninety nine).
  • – Demonstrate products enter form (Include 3.sixty eight).
  • – Display editable item details (Require 7.02kb).
  • quest.gif – Clear graphic fo a question mark (Impact 114b).
  • inventory.php – Administrative stock data summary (PHP nine.07).
  • upload.jpg – Graphical add button (graphic a single.84kb).
  • upload.php – Duplicate pics to the images.htg directory throughout the server (PHP 5.40kb).
  • userorders.php – Exhibit particular person get heritage (PHP 2.36kb).
  • customers.php – Clearly show editable purchaser login details (PHP10.04kb).