Portfolio 4 Submission
- Details
- Category: Level 1, Portfolio 4 (Advanced HTML, PHP, CSS)
- Published: Sunday, 26 August 2018 10:01
- Hits: 7016
Natty Notebooks Inc.
Portfolio 4
Istvan Franko
Level 1 BSc
Lecturers:
Dr. Siobhan Devlin and Mr. Andrew Smith
Entity Relationship Modelling of the system
The following nouns or compound nouns are present in the description
Normalisation to 3rd Normal Form
Scenario
Natty Notebooks Inc (see portfolio 3) is a growing IT company that specialises in selling laptop computers to the trade and public. The company first started trading in 1999via mail order, selling laptops and computer peripherals, before moving to a retail unit in 2005. The business has grown significantly over the last few years and has diversified to sell a range of laptops, netbooks, tablets and e-readers.
To help attract new customers, the company would like to develop a ‘laptop’ website allowing prospective buyers to view details about each laptop and stock availability, and to make an online reservation for pick up in store the next day. The company intends to market the online catalogue by email and via carefully placed adverts online.
Access to pages
You need access to use all the functions of the website.
Back-end:
http://www.frankofamily.info/UniOfSunderland/Level1/Portfolio4/administrator/
user: "Andrew"
password: "Andrew"
or
user: " Siobhan"
password: " Siobhan"
Front-end:
http://www.frankofamily.info/UniOfSunderland/Level1/Portfolio4/
user: " Archie"
password: " Archie"
or
user: " Lucas"
password: " Lucas"
A well-made PACT (People, Activities, context and technologies) analysis can help to achieve our target goals as accurately and as quickly as possible. During the analysis we can asses our needs, to the given situation, our environment and we can understand what we want to achieve to ensure the operation of our system. It is also an excellent starting point to plan for our tasks.
People
Front-end:
A portable computer system manufacturer company’s interest could move on a large scale. These group members could be different age groups, different social position and can have different IT based knowledge. To satisfy the different customers, it is necessary to make the system should work swiftly with simplicity, with good transparency and ease of use. The users of such a page use different ways to get onto the web pages. Each of them looking to use the website for different reasons.
As we also sell electronic book readers, another circle of interest is people who wish to read and may not be doing the searching alone, but with the help a friend who has knowledge of IT or a family member.
The users could have basic knowledge of the internet or even have a excellent knowledge of it, so our system needs to be clear for everyone, while supplying important information.
A well made system is remembered by more people, due to the ease of use, clear labelling on the different buttons, and could make people return to the link on a regular basis.
People like to see more and more sides of a product, so an accurate and detailed information could grab the attention of many people.
.
Since our company’s current state is only limited to local sales, most of the potential guests will be limited to people who live around the nearby area. With accurate and detailed information being shown, they could be useful around the world, the popularity gained this way could help the company to go to the next level, and have their sales made just from online.
Our sites guest could have different limitations who we can aid by, making the font size adjustable, with different, distinct hues or with even adjustable colour pallets.
Back-end:
The company’s system is run by the people specifically hired to maintain the site. These people can login with the personal username and password and are allowed to change any information that is available to every costumer.
To keep the stock accurate, it is unavoidable for the sellers to modify the stock as soon as they have received it, because the items that were not received will automatically release for the specific products in 24 hours.
Our company also hires mobile salespeople, who during their work can show the product in the public site, can check for the available stock. On the administrator site they can watch and handle their orders.
Activities
Our current webpage needs to be capable of performing the following.
Front-end:
1, To be able to browse through the items by using the different categories and filters.
2, To have detailed information which shows more specific information on the product.
3, Purchase wanted items, have them booked from a specific store until the available stock runs out.
4, Be able to ask questions about specific products.
5, Frequently asked questions and comments have to be sent through with the help of the specifically designed form.
6, To check for basic item information.
Back-end:
1, Log-in, out.
2, Listing new products
3, Modify current products
4, Deleting current products
5, Handling of featured products
6, List of orders
7, More information on specific order’s
8, Modify the order status
9, List of customer questions
10, Answer the customer questions
Context
Front-end
Our guests must have internet access to check our online catalogue.
These internet connection points could be:
- Home computers
- Devices used at Work
- Portable computers, with its own or access to public internet connection.
- Mobile internet ready devices, such as Smartphones, Tablets almost usable anywhere
- The terminals set up specifically for customers
- Through our mobile salesman’s clients premises.
Back-end
- Our workers connected to our internal network at their workplace
- For the managers to access order information 24 hours a day, from work or from home
- Mobile sales managers with their work activities linked with their performance.
Technology
Our site could be reached from many different operating systems. (many versions of Microsoft Windows, Mac OS, Android etc.)
Many web browsers within these operating systems. (eg. Internet Explorer, Google Chrome, Netscape, Mozilla Firefox, Opera, Safari)
While optimising our system it is advisable to check through all available operation system and web browsers, since problems may occur, which need to be identified and repaired.
The given task required to only use HTML, CSS and PHP codes. This has defined and has also restricted our options, Which will affect the customer friendliness and the ease of use of the website.
Our systems operation is also restricted by the university's servers parameters. We are restricted to only use technologies that were available.
Entity Relationship Modelling of the system
The following nouns or compound nouns are present in the description:
Company, laptop, Computers, public, peripherals, unit, netbooks, tablets, e-readers, customers, website, buyers, stock availability, market, catalogue, email, adverts.
Entity table
|
Entity |
Key attribute |
Non-key attribute |
|
Customer
|
- customer number |
- customer name - customer user name - customer password - customer email - customer phone number |
|
Item for sale
|
- item number |
- item name - item price - item category - item brand - item model number - item availability - item special offer - item in stock - item operation system - item CPU - item memory - item HDD - item screen size - item short description - item description - item pictures - item official URL |
|
Order
|
- order number |
- order name - order email - order phone number - items in order - item id - ordered quantity - ordered from - order time - order state |
|
Feedback/Question
|
- feedback number |
- feedback item - feedback name - feedback subject - feedback comment or question - feedback email - feedback respond - feedback state |
|
Administrators
|
- admin number |
- admin name - admin username - admin password - admin email - admin phone number |
Entity modelling
Normalisation to 3rd Normal Form
|
UNF |
UNF LEVEL |
1NF |
2NF |
3NF |
|
order number order name order email order phone numb. order time item id item name item price item category item brand item model numb. item availability item special offer item in stock item op. system item CPU item memory item HDD item screen size item short desc. item description item pictures item official URL ordered quantity ordered from order state items in order |
1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 |
order number order name order email order phone numb. order time
order number item id item name item price item category item brand item model numb. item availability item special offer item in stock item op. system item CPU item memory item HDD item screen size item short desc. item description item pictures item official URL ordered quantity ordered from order state items in order |
order number order name order email order phone numb. order time
order number item id ordered quantity ordered from order state items in order
item id item name item price item category item brand item model numb. item availability item special offer item in stock item op. system item CPU item memory item HDD item screen size item short desc. item description item pictures item official URL |
order number order time *order email order email order name order phone numb. order number item id ordered quantity ordered from order state items in order
item id item name item price item category item brand item model numb. item availability item special offer item in stock item op. system item CPU item memory item HDD item screen size item short desc. item description item pictures item official URL |
Front-end
- display information's about company and contact details
- add an item to shopping cart
- ask from an item
- insert data to "feedbacks" sql table
- display cart summary
- insert order details to "natty_orders" sql table
- set order state to "Uncompleted"
- display order recorded
- send a confirmation email to customer
- display items in cart
- form to required quantity
- if user not logged in, show a user details form
- if user is log in, show his/her personal details
- links to remove an item from cart
- emptying whole cart
- remove an item from cart
- display four main categories
- list items from a selected category
- display item details
- links to "Add to cart" and "Ask about this"
- links to full size item pictures
- form to send feedbacks or questions
- if user input validated insert data to "feedbacks" sql table
- filter module for product-list.php what list all available items
- form fields built from "natty" sql table
- this filter including category fields too
- filter module for category-list.php what list items from a selected category
- form fields built from "natty" sql table
- pages head, all other page code include except modules
- starting page
- list all "Special Offer"-s
- user log-in form
- links to "Password reminder" and "Sign-up" pages
- user log-out function
- unset browser session
- redirect to index.php
- navigation-bar.php
- navigation menu for main functions
- if the cart doesn't empty, show "Go to cart" link
- if user doesn't log-in show "Log-in" link
- if user logged in, show "My account" link
- show order details to registered users who is logged in
- list orders for registered user who is logged in
- "Details" link for order details
- password-change.php
- form to change password to registered users
- send an email to user with registered password
- list all items
- pagination function to scroll pages
- or filter module to search in properties
- searches through the given word from the name, category, type, operating system, the processor, hard disc drive, memory, and screen size of the products property
- display results
- form for users who wants to register
- insert details to "users" sql table
- display user details
- link to "Change your password" and "Your order history"
Back-end
- list all items
- pagination function to scroll pages
- or filter module to search in properties
- link for item details under the item name
- link for full size picture under the thumbnail picture
- "Update" link to update item properties
- "Delete" link to remove an item
- navigation menu for main functions
- it show "Logout" link only if the admin logged in
- confirmation form to delete an item
- delete the confirmed item from "natty" sql table
- show all item properties
- list all feedback
- pagination function to scroll pages
- or filter bar to search in properties
- "Respond" link to answer to customer
- filter module for admin.php what list all available items
- form fields built from "natty" sql table
- log-in form for administrators
- get variables from insert-form.php
- insert a new item to "natty" sql table
- a form to insert an item
- post properties to insert.php
- admin logout function
- unset browser session
- redirect to index.php
- display an order details in a form
- access to edit order properties
- list all orders
- pagination function to scroll pages
- or filter bar to search in properties
- "Details" link to order-details-orm.php
- if an admin open the orders-list.php this code check all 'Live' state order's time and if that older than 1 day change the status to "Expired" and take back the booked quantity to stocks quantity
- get variables from order-details-form.php and update "natty_orders" sql table
- show a feedback or ask from item question
- a form to respond to feedback
- send a email to customer with respond
- searches through the given word from the name, category, type, operating system, the processor, hard disc drive, memory, and screen size of the products property
- get variables from update-form.php and update item details in "natty" sql table
- a form to update item details
- post inputs to update.php
Export of SQL tables
Item details
-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Host: bel.sunderland.ac.uk
-- Generation Time: Feb 02, 2014 at 06:49 PM
-- Server version: 5.0.24-max
-- PHP Version: 5.3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `bg47bp`
--
-- --------------------------------------------------------
--
-- Table structure for table `natty`
--
CREATE TABLE `natty` (
`ItemID` int(11) NOT NULL auto_increment,
`ItemInMbro` int(11) NOT NULL,
`ItemInStockton` int(11) NOT NULL,
`ItemAvailable` int(11) NOT NULL,
`ItemSpecialOffer` int(2) NOT NULL,
`ItemName` char(100) NOT NULL,
`ItemPrice` double NOT NULL,
`ItemCategory` char(50) NOT NULL,
`ItemBrand` char(50) NOT NULL,
`ItemModelNum` char(50) NOT NULL,
`ItemOpSys` char(50) NOT NULL,
`ItemCpu` char(50) NOT NULL,
`ItemMem` char(20) NOT NULL,
`ItemHdd` char(50) NOT NULL,
`ItemScreenSize` char(50) NOT NULL,
`ItemShortDesc` char(250) NOT NULL,
`ItemDesc` text NOT NULL,
`ItemPicture1` char(100) NOT NULL,
`ItemPicture2` char(100) NOT NULL,
`ItemPicture3` char(100) NOT NULL,
`ItemPicture4` char(100) NOT NULL,
`ItemPicture5` char(100) NOT NULL,
`ItemOfficialUrl` char(250) NOT NULL,
PRIMARY KEY (`ItemID`),
UNIQUE KEY `itemid` (`ItemID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Dumping data for table `natty`
--
INSERT INTO `natty` (`ItemID`, `ItemInMbro`, `ItemInStockton`, `ItemAvailable`, `ItemSpecialOffer`, `ItemName`, `ItemPrice`, `ItemCategory`, `ItemBrand`, `ItemModelNum`, `ItemOpSys`, `ItemCpu`, `ItemMem`, `ItemHdd`, `ItemScreenSize`, `ItemShortDesc`, `ItemDesc`, `ItemPicture1`, `ItemPicture2`, `ItemPicture3`, `ItemPicture4`, `ItemPicture5`, `ItemOfficialUrl`) VALUES
(1, 18, 14, 1, 0, 'Toshiba C50', 349.99, 'Laptop', 'Toshiba', 'C50', 'Windows 8', 'Intel Core i3 dual core', '4GB', '1TB', '15.6 inch', 'With a slim, stylish black design the Toshiba C50 laptop is perfect for watching all your films and multimedia with an impressive 15.6" HD display screen, enhanced by impressive HD graphics 4000. Complete with an impressive 1TB hard drive and 4G', 'Product description / spec\r\n\r\nWith a slim, stylish black design the Toshiba C50 laptop is perfect for watching all your films and multimedia with an impressive 15.6" HD display screen, enhanced by impressive HD graphics 4000. Complete with an impressive 1TB hard drive and 4GB RAM you can effortlessly run all your programmes without affecting performance.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Core i3 dual core .\r\n 3110M processor.\r\n 2.4GHz processor speed.\r\n 4GB RAM.\r\n 1000GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n High definition display.\r\n DVD+RW/DVD-RW (read/write).\r\n\r\nGraphics:\r\n\r\n Shared graphics card.\r\n Intel HD Graphics 4000.\r\n\r\nInterfaces and connectivity:\r\n\r\n Secure Digital (SD), Memory Stick (MS), Multi-Media Card (MMC) compatible.\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n 1 Ethernet port.\r\n 0 FireWire port.\r\n 1 HDMI port.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n Built-in mic.\r\n\r\nGeneral features:\r\n\r\n Up to 3.5 hours battery life.\r\n Size H3.5, W38, D24.2cm.\r\n Weight 2.4kg.\r\n EAN: 4051528078343.', 'Toshiba-C50.png', 'Toshiba-C50-2.jpg', 'Toshiba-C50-3.jpg', 'Toshiba-C50-4.jpg', 'Toshiba-C50-5.jpg', 'http://www.toshiba.com/us/computers/laptops/satellite/C50'),
(3, 20, 8, 1, 0, 'HP Pavilion AMD A6', 329.99, 'Laptop', 'HP', 'AMD A6', 'Windows 8', 'AMD dual core A6 processor', '4GB', '750GB', '15.6 inch', 'Bring peace of mind and style to everyday tasks. Whether you re sending an email, sharing photos, online banking, or listening to music, the HP Pavilion', 'Product description / spec\r\n\r\nBring peace of mind and style to everyday tasks. Whether you re sending an email, sharing photos, online banking, or listening to music, the HP Pavilion - now with a thinner, lighter design - delivers, day after day. Never worry about running out of space - this dependable notebook has a 750GB hard disk drive for storing files, music, photos, videos and more.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n AMD dual core .\r\n A6 processor.\r\n 2.9GHz processor speed.\r\n 4GB RAM.\r\n 750GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nDVD optical drives:\r\n\r\n DVD+RW/DVD-RW (read/write).\r\n\r\nGraphics:\r\n\r\n 8450G graphics card.\r\n AMD Radeon HD.\r\n\r\nInterfaces and connectivity:\r\n\r\n 1 USB 2.0 port.\r\n 2 USB 3.0 ports.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n\r\nMultimedia features:\r\n\r\n Built-in webcam.\r\n Built-in mic.\r\n DTS sound system.\r\n\r\nGeneral features:\r\n\r\n Size H37.9, W24.6, D3.18cm.\r\n Weight 2.35kg.\r\n EAN: 888182076729.\r\n\r\n', 'HP-Pavilion-AMD-A6.png', '', '', '', '', 'http://shopping.hp.com/en_US/home-office/-/thematic/hp-pavilion-amd-pc.html'),
(5, 19, 27, 1, 0, 'HP Pavilion 15 Ci3', 349.99, 'Laptop', 'HP', 'Pavilion 15 Ci3', 'Windows 8', 'Intel Core i3 dual core 3217M processor', '8GB', '1TB', '15.6 inch', 'With a cool, stylish white design the HP Pavilion 15 Laptop with a 1TB hard drive will give you fantastic performance on a wide 15.6 inch screen', 'Product description / spec\r\n\r\nWith a cool, stylish white design the HP Pavilion 15 Laptop with a 1TB hard drive will give you fantastic performance on a wide 15.6 inch screen. Watch films and all your multimedia content in fantastic clarity with Intel HD graphics and brilliant sound from the Altec Lansing Speakers sound system\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Core i3 dual core .\r\n 3217M processor.\r\n 1.8GHz processor speed.\r\n 8GB RAM.\r\n 1024GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nGraphics:\r\n\r\n Intel HD Graphics 4000.\r\n\r\nInterfaces and connectivity:\r\n\r\n 1 USB 2.0 port.\r\n 2 USB 3.0 ports.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n Altec Lansing Speakers sound system.\r\n\r\nGeneral features:\r\n\r\n Size H34.5, W52, D8cm.\r\n Weight 3.34kg.\r\n EAN: 887758684078.\r\n\r\n', 'HP-Pavilion-15-Ci3.png', '', '', '', '', 'http://h20386.www2.hp.com/UKStore/'),
(6, 30, 15, 1, 0, 'Lenovo G505', 349.99, 'Laptop', 'Lenovo', 'G505', 'Windows 8', 'AMD A Series quad core 5000 processor', '4GB', '1TB', '15.6 inch', 'Battery Life\r\n **Up to 6 hours with standard 6-cell battery\r\nWeight\r\n Starting at 5.7 lbs (2.6 kg) / 1.34" (34mm)', '\r\n15.6" HD Widescreen Display\r\n\r\nThis display delivers bright, crisp visuals in 16:9 widescreen format and 1366 x 768 resolution.\r\n\r\nMultimedia Extravaganza\r\n\r\nThanks to its stereo speakers with Dolby® Advanced Audio™ v2, graphics card options up to the speedy AMD Radeon 8570M with 2GB DDR3 VRAM, and optical disk drive options up to a Blu-ray Disc™ combo, the G505 offers stunning, stutter-free visuals and immersive sound for a fuller, more satisfying home entertainment experience.\r\n\r\nFast Data Transfer\r\n\r\nMove data between the G505 and other devices quickly with USB 3.0 SuperSpeed; it''s up to ten times faster than previous USB technologies.\r\n\r\nAccuType Keyboard\r\n\r\nThis spill-resistant, island-style keyboard is ergonomically designed to make typing more comfortable and to reduce errors.\r\n\r\nBattery-Saving Technology\r\n\r\nLenovo Energy Management protects the long-term durability of the battery and uses advanced energy-saving technology to increase time spent between charges.\r\nSimple Maintenance\r\nWith OneKey Recovery, recovering from viruses or other technical difficulties is a snap.\r\n\r\nConnectivity Options\r\n\r\nWith 802.11 b/g/n WiFi connectivity, 10/100 LAN, and Bluetooth®, you''ll be able to connect to the internet wherever you go.\r\nIntegrated Webcam\r\nThe 720p HD High-Sense webcam will help you enjoy web conferences or online video chats like you''re really there.\r\n\r\nHDMI Output\r\n\r\nFor easy connection to a television or other display.\r\n\r\nLenovo Cloud Storage\r\n\r\nProtect your important files and data, while also making access to information and file-sharing quick and convenient. Automatically back-up and synchronize data across your home, while enabling access from multiple devices. Data is encrypted on transfer for an extra level of security. ', 'Lenovo-G505.png', '', '', '', '', 'http://shop.lenovo.com/gb/en/laptops/essential/g-series/g505/'),
(7, 16, 13, 1, 1, 'Asus X102BA Touch', 299.99, 'Netbook', 'Asus', 'X102BA Touch', 'Windows 8', 'AMD Quad Core quad core A4 processor', '4GB', '500GB', '10.1 inch', 'Ultraportable 10.1-inch notebook with a responsive multi-touch display', 'Product description / spec\r\n\r\nCPU, Memory and Operating System:\r\n\r\n AMD Quad Core quad core .\r\n A4 processor.\r\n 1GHz processor speed.\r\n 4GB RAM.\r\n 500GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 10.1 inch screen.\r\n\r\nGraphics:\r\n\r\nInterfaces and connectivity:\r\n\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n Bluetooth.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\nGeneral features:\r\n\r\n Up to 5 hours battery life.\r\n Size H23.3, W266, D185.1cm.\r\n Weight 1.1kg.', 'Asus-X102BA-Touch.png', '', '', '', '', 'https://www.asus.com/Notebooks_Ultrabooks/X102BA/#overview'),
(8, 18, 25, 1, 1, 'Asus X502', 299.99, 'Laptop', 'Asus', 'X502', 'Windows 8', 'Intel Celeron dual core 1.5GHz processor', '4GB', '500GB', '15.6 inch', 'With a sleek, stylish design the white Asus X502 laptop comes with an impressive 500GB hard drive and 4GB of ram for smooth effortless performance.', 'Product description / spec\r\n\r\nWith a sleek, stylish design the white Asus X502 laptop comes with an impressive 500GB hard drive and 4GB of ram for smooth effortless performance, so you can browse your favourite websites or keep in touch with friends on social network sites without any interruptions on a stunning 15.6" screen.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Celeron dual core .\r\n 1.5GHz processor speed.\r\n 4GB RAM.\r\n 500GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n\r\nGraphics:\r\n\r\n Intel UMA.\r\n\r\nInterfaces and connectivity:\r\n\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n\r\nMultimedia features:\r\n\r\nGeneral features:\r\n\r\n Up to 5 hours battery life.\r\n Size H38, W25, D2.2cm.\r\n Weight 2kg.\r\n EAN: 4716659510833.\r\n\r\n', 'Asus-X502.png', '', '', '', '', 'http://www.asus.com/Notebooks_Ultrabooks/X502CA/'),
(9, 15, 11, 1, 0, 'Acer V5', 249.99, 'Netbook', 'Acer', 'V5', 'Windows 8', 'AMD C Series dual core C70 processor', '2GB', '320GB', '11.6 inch', 'The Aspire V5 is thinner and more elegant than ever. It comes in three practical screen sizes (11.6", 14" and 15.6") and a selection of chic colors.', 'Product description / spec\r\n\r\nCPU, Memory and Operating System:\r\n\r\n AMD C Series dual core .\r\n C70 processor.\r\n 1GHz processor speed.\r\n 2GB RAM.\r\n 320GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 11.6 inch screen.\r\n High definition display.\r\n\r\nGraphics:\r\n\r\n Shared graphics card.\r\n 6290 graphics card.\r\n AMD Radeon HD.\r\n\r\nInterfaces and connectivity:\r\n\r\n Secure Digital (SD), Memory Stick (MS), Memory Stick Pro (MS-Pro), Multi-Media Card (MMC) compatible.\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n Bluetooth.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n Built-in mic.\r\n\r\nGeneral features:\r\n\r\n Up to 5.5 hours battery life.\r\n Size H2.75, W28.5, D20.2cm.\r\n Weight 1.2kg.\r\n EAN: 4712196694463.', 'Aspire-V5.png', '', '', '', '', 'http://us.acer.com/ac/en/US/content/series/aspirev5'),
(10, 21, 30, 1, 0, 'Sony Vaio SVF1521A2EW', 449.99, 'Laptop', 'Sony Vaio', 'SVF1521A2EW', 'Windows 8', 'Intel Pentium 1.5GHz processor', '4GB', '500GB', '15.5 inch', 'This sleek Sony Vaio touchscreen laptop has a responsive 15.5 inch screen and has a massive 500GB hard drive for huge storage and 4GB RAM to keep it from slowing down.', 'Product description / spec\r\n\r\nThis sleek Sony Vaio touchscreen laptop has a responsive 15.5 inch screen and has a massive 500GB hard drive for huge storage and 4GB RAM to keep it from slowing down. Listen to songs and soundtracks in absolute clarity on the sleek VAIO® Fit 15E. A notebook that packs a punch with large speakers, built-in subwoofer and ClearAudio+. Connect instantly to your NFC enabled headphones or speakers with one touch. Optional touchscreen gives intuitive access to all the things you love.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Pentium .\r\n 1.5GHz processor speed.\r\n 4GB RAM.\r\n 500GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.5 inch screen.\r\n\r\nGraphics:\r\n\r\nInterfaces and connectivity:\r\n\r\n 1 Ethernet port.\r\n\r\nMultimedia features:\r\n\r\nGeneral features:\r\n\r\n Up to 5 hours battery life.\r\n Size H26.1, W380.3, D260.8cm.\r\n Weight 2.6kg.\r\n EAN: 4548736711075.\r\n\r\n', 'Sony-Vaio-SVF1521A2EW.png', '', '', '', '', 'http://www.sony.co.uk/customise/vn-fit-e?cid=14200000&medium=ppc&s_kwcid=sony%20vaio'),
(13, 10, 10, 1, 0, 'Samsung Galaxy Tab 3 - White', 159.99, 'Tablet', 'Samsung', 'Galaxy Tab 3', 'Android', '1.2GHz processor', '1GB', '8GB', '7 inch', 'The Samsung Galaxy Tab 7.0 has a powerful Dual Core Processor and maximises experience with its brilliant display, offering high resolution for eye-popping colour and crystal clear clarity.', 'Product description / spec\r\n\r\nThe Samsung Galaxy Tab 7.0 has a powerful Dual Core Processor and maximises experience with its brilliant display, offering high resolution for eye-popping colour and crystal clear clarity. The slim design makes this visually appealing and portable.\r\n\r\n 1.3MP front facing and 3MP rear facing cameras.\r\n\r\nDisplay:\r\n\r\n 7 inch screen.\r\n Resolution 1024 x 600 pixels.\r\n 1.2GHz processor.\r\n 1GB RAM.\r\n 8 GB internal storage.\r\n Android 4.1 Jelly Bean operating system.\r\n Webcam.\r\n Wi-Fi enabled.\r\n microSD memory card slot.\r\n 1 x USB 2.0.\r\n Micro USB.\r\n\r\nAdditional information:\r\n\r\n Up to 8 hours battery life (depending on usage).\r\n EAN/MPN/UPC/ISBN: 8806085655768 .\r\n\r\n', 'Samsung-galaxy-tab-3.png', 'Samsung-Galaxy-Tab-3-1.jpg', 'Samsung-Galaxy-Tab-3-2.jpg', 'Samsung-Galaxy-Tab-3-3.jpg', '', 'http://www.samsung.com/us/mobile/galaxy-tab/SM-T3100ZWYXAR'),
(14, 20, 20, 1, 1, 'Microsoft Surface 2', 359, 'Tablet', 'Microsoft', 'Surface 2', 'Windows 8 RT', '1.7GHz NVIDIA - Tegra 4 Quad-cor', '2GB', '32GB', '10.6 inch', 'Thinner, faster and lighter than before, the Surface 2 is a petite but powerful tablet that can do more.', 'Product description / spec\r\n\r\nThinner, faster and lighter than before, the Surface 2 is a petite but powerful tablet that can do more. Coming complete with Office 2013 RT (including Outlook), a micro SD card reader for up to 64GB extra storage and a crystal clear 1080p Full HD widescreen display, the Surface 2 has all you need.\r\n\r\n Includes free Skype for a year enabling you to stay in touch with friends and family all over the world. For more information and availability please see www.skype.com/surface.\r\n Also features an extra 200GBs of SkyDrive Storage free for two years. For further information and availability, please see www.skydrive.com/surface.\r\n Keyboard purchased separately.\r\n\r\nDisplay:\r\n\r\n 10.6 inch screen.\r\n Resolution 1920 x 1080 pixels.\r\n Multi-touch screen.\r\n\r\nSpecifications:\r\n\r\n 1.7GHz NVIDIA - Tegra 4 Quad-core processor.\r\n 2GB RAM.\r\n 32 GB internal storage.\r\n Windows 8 RT operating system.\r\n\r\nGeneral features:\r\n\r\n Built-in speaker.\r\n Webcam.\r\n Wi-Fi enabled.\r\n Bluetooth - enabling you to easily and wirelessly connect with other bluetooth enabled devices.\r\n 3.5mm stereo headphone jack.\r\n Microphone.\r\n microSD memory card slot.\r\n 1 x USB 3.0.\r\n HDMI.\r\n\r\nAdditional information:\r\n\r\n Up to 10 hours battery life (depending on usage).\r\n 8mm thin.\r\n Size H17.3, W27.5cm.\r\n Weight 675g.\r\n EAN/MPN/UPC/ISBN: 885370620498.\r\n\r\n', 'Surface-2.png', 'Surface-2-1.jpg', 'Surface-2-2.jpg', '', '', 'http://www.microsoft.com/surface/en-gb/products/surface-2'),
(15, 24, 15, 1, 0, 'Samsung Galaxy Tab 3 - Black', 159.99, 'Tablet', 'Samsung', 'Galaxy Tab 3', 'Android', '1.2GHz processor', '1GB', '8GB', '7 inch', 'With the Samsung Galaxy Tab 3 at your fingertips, it''s a whole new world. Slimmer, narrower and with a thinner bezel, it offers a comfortable grip that makes it easy to use on the go.', 'Product description / spec\r\n\r\nWith the Samsung Galaxy Tab 3 at your fingertips, it''s a whole new world. Slimmer, narrower and with a thinner bezel, it offers a comfortable grip that makes it easy to use on the go. It''s also lighter than previous tablets, but still packs powerful performance thanks to a Dual Core processor and dual cameras. You''ll also enjoy more apps from Samsung and Google as well as free 50GB Dropbox storage.\r\n\r\n Model number: SM-T210.\r\n Carry a lightweight and portable design that''s just 9.9mm thin.\r\n Enjoy fast performance with a powerful dual core processor.\r\n Access a range of entertainment content with Samsung Hubs.\r\n\r\nDisplay:\r\n\r\n 7 inch screen.\r\n Resolution 1024 x 600 pixels.\r\n Multi-touch screen.\r\n\r\nSpecifications:\r\n\r\n 1.2GHz processor.\r\n 1GB RAM.\r\n 8 GB internal storage.\r\n Android 4.1.2 Jelly Bean operating system.\r\n\r\nGeneral features:\r\n\r\n Built-in speaker.\r\n Webcam.\r\n Wi-Fi enabled.\r\n Bluetooth - enabling you to easily and wirelessly connect with other bluetooth enabled devices.\r\n 3.5mm stereo headphone jack.\r\n microSD memory card slot.\r\n Micro USB.\r\n Store files thanks to 50GB of free Dropbox storage for 2 years.\r\n Slimmer for a comfortable fit in the hand.\r\n Useful device with the latest technology.\r\n\r\nAdditional information:\r\n\r\n Up to 8 hours battery life (depending on usage).\r\n 0.9mm thin.\r\n Size H11.1, W18.8cm.\r\n Weight 300g.\r\n\r\n', 'Samsung-galaxy-tab-3-black.png', 'Samsung-Galaxy-Tab-3-black-1.jpg', 'Samsung-galaxy-tab-3-black-2.png', '', '', 'http://www.samsung.com/us/mobile/galaxy-tab/SM-T3100ZWYXAR'),
(16, 20, 24, 1, 0, 'Kindle Wi-Fi', 69, 'E-reader', 'Kindle', 'Wi-Fi', 'NA', 'Silicon Supplier Freescale i.MX35', '2GB', '2GB', '6 inch', 'The Amazon Kindle now has Wi-Fi, download and enjoy your favourite titles in just 60 seconds', 'Product description / spec\r\n\r\nThe Amazon Kindle now has Wi-Fi, download and enjoy your favourite titles in just 60 seconds. This pocket-sized library is smaller and lighter than the previous model but maintains the same 6 inch screen. Enjoy a seamless reading experience with faster page turns and superior E-ink for perfect viewing even in the sunshine.\r\n\r\nE-reader features:\r\n\r\n 6 inch e-ink screen.\r\n Wi-Fi connectivity.\r\n Stores 1400 books.\r\n Display looks and reads like real paper with no glare, even in bright sunlight. New higher contrast, high resolution display.\r\n Read with one hand - lighter than most tablets.\r\n Battery lasts up to 1 month with over 400,000 Kindle exclusive titles.\r\n Kindle Owners'' Lending Library - with an Amazon Prime membership, Kindle owners can choose from more than 400,000 books to borrow for free - as frequently as 1 book per month with no due dates.\r\n USB 2.0 cable included.\r\n Choose from 8 adjustable font sizes to improve readability.\r\n Compatible with Kindle Format 8 (AZW3), Kindle (AZW), TXT, PDF, unprotected MOBI, PRC natively, HTML, DOC, DOCX, JPEG, GIF, PNG, BMP through conversion.\r\n\r\nGeneral information:\r\n\r\n Size H16.6, W11.4, D0.87cm.\r\n Weight 170g.\r\n EAN: 814916017805.\r\n\r\n', 'Kindle-Wi-Fi.png', 'Kindle-Wi-Fi-1.jpg', '', '', '', 'http://www.amazon.com/Kindle-Ereader-ebook-reader/dp/B007HCCNJU'),
(2, 11, 15, 1, 1, 'iPad mini Wi-Fi 16GB - White', 249, 'Tablet', 'Apple', 'iPad mini', 'Apple iOS 6', 'Apple A5 1000 MHz', '500MB', '16GB', '7.9 inch', 'iPad mini features a beautiful 7.9 inch display, FaceTime HD and iSight cameras, the A5 chip, ultra-fast wireless and up to 10 hours of battery life.', 'Product description / spec\r\n\r\niPad mini features a beautiful 7.9 inch display, FaceTime HD and iSight cameras, the A5 chip, ultra-fast wireless and up to 10 hours of battery life. With over 275,000 apps on the App Store made for iPad these will also work with iPad mini. So it''s an iPad in every way, shape and slightly smaller form.\r\n\r\nDisplay:\r\n\r\n 7.9in multi-touch screen.\r\n LED backlit display.\r\n\r\nFeatures:\r\n\r\n 16GB memory capacity.\r\n Uses the latest iOS operating system.\r\n iCloud - allowing you to access your music, photos and any other data from whatever device you are on.\r\n Speaker and microphone built-in.\r\n 5MP iSight camera with 1080p HD video recording.\r\n Mobile data service on Wi-Fi and Cellular models (data plan sold separately) with nano SIM .\r\n\r\nConnectivity:\r\n\r\n Bluetooth.\r\n B/g/n wireless/WiFi enabled.\r\n 3.5mm stereo headphone jack.\r\n Up to 10 hours battery life (depending on usage).\r\n 7.2mm thin.\r\n EAN/MPN/UPC/ISBN: 885909667666.\r\n\r\n', 'ipad-mini.png', 'ipad-mini.jpg', 'ipad-mini-2.jpg', '', '', 'http://store.apple.com/uk/ipad?afid=p219|GOUK&cid=AOS-UK-KWG-UK_iPad_mini'),
(4, 10, 10, 1, 1, 'Kobo Aura E-Reader - Black', 119.99, 'E-reader', 'Kobo', 'Aura', 'NA', '1GHZ', '4GB', '4GB', '6 inch', 'With a beautiful 6 Inch high resolution screen, the stunning Kobo Aura provides a unique reading experience, even in direct sunlight.', 'Product description / spec\r\n\r\nWith a beautiful 6 Inch high resolution screen, the stunning Kobo Aura provides a unique reading experience, even in direct sunlight. With the latest E Ink screen, flick smoothly between pages and pinch to zoom in on every detail. The Kobo Aura''s built-in comfort light allows for a perfect reading brightness level at both day and night.\r\n\r\n Model number: N514-KU-BK-K-EP.\r\n\r\nE-reader features:\r\n\r\n 6 inch e-ink touch screen.\r\n Wi-Fi connectivity.\r\n Internal memory 4GB - stores 3000 books.\r\n Features a microSD memory card slot for 32GB expandable memory.\r\n 11 fonts, 24 sizes, exclusive weight and sharpness setting.\r\n English, French, German, Spanish, Dutch, Italian, Brazillian Portuguese, Portuguese and Japanese.\r\n Kobo picks - Personal reccomendations based on your feedback and interests.\r\n Beyond the book - Dive deeper into what you''re reading by tapping on the highlighted words to discover related books, authors, articles and more.\r\n Easy to set up in just a few simple steps from your computer or directly from your Kobo Aura using Wi Fi.\r\n Charge time of 1.5 hours.\r\n Battery life of 1440 hours.\r\n Choose from 24 adjustable font sizes to improve readability.\r\n 16 levels of grey scale give ultra fine text detail.\r\n Virtual keyboard.\r\n Supported formats: EPUB, PDF & MOBI.\r\n\r\nGeneral information:\r\n\r\n Size H15, W2, D8.9cm.\r\n Weight 174g.\r\n EAN: 681495005864.', 'Kobo-Aura-E-Reader-Black.png', 'Kobo-Aura-E-Reader-Black.jpg', '', '', '', 'http://www.kobo.com/koboaura#overview'),
(11, 15, 15, 1, 1, 'New Kindle Fire HD Tablet - 8GB', 119.99, 'Tablet', 'Kindle', 'Fire HD', 'Fire OS 3.0', '1.5 GHz dual-core ARM Cortex-A9', '8GB', '8GB', '7 inch', 'The new Kindle Fire HD is a feature-packed HD tablet at a breakthrough price. There''s more to enjoy than ever before with a stunning HD display', 'Product description / spec\r\n\r\nThe new Kindle Fire HD is a feature-packed HD tablet at a breakthrough price. There''s more to enjoy than ever before with a stunning HD display, faster performance, lighter design and longer battery life than the previous Kindle Fire.\r\n\r\nE-reader features:\r\n\r\n 7 inch LCD touch screen.\r\n Wi-Fi connectivity.\r\n Screen resolution: 1280 x 800.\r\n Internal memory 8GB - stores 6000 books.\r\n The most affordable Kindle Fire - now with a stunning HD display and faster processor.\r\n Vivid HD display with over 1 million pixels.\r\n Over 27 million songs, games, apps, movies and more with free unlimited storage for Amazon content.\r\n Kindle FreeTime for individual profiles and time limits for kids.\r\n USB 2.0 cable and mains adaptor included.\r\n Charge time of 4 hours.\r\n Battery life of 10 hours.\r\n Choose from 11 adjustable font sizes to improve readability.\r\n Built-in speakers, MP3 player and virtual keyboard.\r\n Supported formats: Kindle (AZW), KF8, TXT, PDF, unprotected MOBI, PRC natively, Audible Enhanced format (AAX), DOC, DOCX, JPEG, GIF, PNG, BMP, Dolby Digital (AC-3), Dolby Digital Plus (E-AC-3), non-DRM AAC, MP3, MIDI, PCM/WAVE, OGG, WAV, M4V, MP4, AAC LC/LTP, HE-AACv1.\r\n\r\nGeneral information:\r\n\r\n Size H19.1, W12.8, D1.06cm.\r\n Weight 345g.\r\n EAN: 0848719021028', 'New-Kindle-Fire-HD-Tablet- 8GB.png', 'New-Kindle-Fire-HD-Tablet- 8GB.jpg', 'New-Kindle-Fire-HD-Tablet- 8GB-2.jpg', '', '', 'https://kindle.amazon.com/'),
(12, 21, 20, 1, 0, 'Google Nexus 7 2013 - 16GB.', 199.99, 'Tablet', 'Google', 'Nexus 7', 'Android', '1.5GHz Qualcomm', '2GB', '16GB', '7 inch', 'Display:\r\n\r\n 7 inch screen.\r\n Resolution 1920 x 1200 pixels.', 'Product description / spec\r\n\r\nDisplay:\r\n\r\n 7 inch screen.\r\n Resolution 1920 x 1200 pixels.\r\n IPS technology.\r\n Multi-touch screen.\r\n LED backlit display.\r\n\r\nSpecifications:\r\n\r\n 1.5GHz Qualcomm Snapdragon processor.\r\n 2GB RAM.\r\n 16 GB internal storage.\r\n Android 4.3 Jelly Bean operating system.\r\n\r\nGeneral features:\r\n\r\n Built-in speaker.\r\n Webcam.\r\n Wi-Fi enabled.\r\n Bluetooth - enabling you to easily and wirelessly connect with other bluetooth enabled devices.\r\n 3.5mm stereo headphone jack.\r\n Microphone.\r\n Micro USB.\r\n\r\nAdditional information:\r\n\r\n Up to 10 hours battery life (depending on usage).\r\n 8.6mm thin.\r\n Size H20, W11.4cm.\r\n Weight 300g.\r\n EAN/MPN/UPC/ISBN: 4716659289913.\r\n\r\n', 'Google-Nexus-7-2013-16GB.png', 'Google-Nexus-7-2013-16GB.jpg', '', '', '', 'http://www.google.com/nexus/7/'),
(17, 15, 15, 1, 0, 'Toshiba NB10T Touch', 329.99, 'Netbook', 'Toshiba', 'NB10T', 'Windows 8', 'Intel Celeron N2810 2.1GHz', '4GB', '500GB', '11.6 inch', 'Fully-featured, lightweight and compact by design, the user-friendly Toshiba Satellite NB10t features a 29.5 cm (11.6") HD touchscreen.', 'Product description / spec\r\n\r\nFully-featured, lightweight and compact by design, the user-friendly Toshiba Satellite NB10t features a 29.5 cm (11.6") HD touchscreen. The Satellite NB10t has stereo speakers combined with a full size keyboard for ease of use. With full Windows 8 functionality with multi-touch support users have everything at their disposal.\r\n\r\n Full size connections. The NB10t-A has a range of full-size ports to keep you connected with USB ports, HDMI and an RGB.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Celeron dual core .\r\n N2810 processor.\r\n 2.1GHz processor speed.\r\n 4GB RAM.\r\n 500GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 11.6 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nGraphics:\r\n\r\n Shared graphics card.\r\n Intel HD Graphics.\r\n\r\nInterfaces and connectivity:\r\n\r\n Secure Digital (SD) compatible.\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n Bluetooth.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n Built-in mic.\r\n DTS sound system.\r\n\r\nGeneral features:\r\n\r\n Up to 3.5 hours battery life.\r\n Size H1.38, W28.4, D20.86cm.\r\n Weight 1.5kg.\r\n EAN: 4051528103021', 'Toshiba-NB10T.png', 'Toshiba-NB10T.jpg', '', '', '', 'http://www.toshiba.co.uk/laptops/satellite-pro/nb10/satellite-pro-nb10t-a-106/'),
(18, 20, 30, 1, 0, 'Lenovo Flex 10 Touch Multimode', 319.99, 'Netbook', 'Lenovo', 'Flex 10 Touch', 'Windows 8', 'Intel Celeron dual core N2805', '2GB', '500GB', '10.1 inch', 'For affordable, flexible computing look no further than the Lenovo Flex 10 Touch Multimode Laptop', 'Product description / spec\r\n\r\nFor affordable, flexible computing look no further than the Lenovo Flex 10 Touch Multimode Laptop. The lightweight Lenovo Flex 10 has a functional keyboard for typing but maintains the tablet functionality with an intuitive multi touchscreen, HD webcam and impressive speakers. For an invovative laptop experience try the Lenovo Flex 10.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Celeron dual core .\r\n N2805 processor.\r\n 1.46GHz processor speed.\r\n 2GB RAM.\r\n 500GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 10.1 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nGraphics:\r\n\r\n Shared graphics card.\r\n Intel HD Graphics.\r\n\r\nInterfaces and connectivity:\r\n\r\n Memory Stick (MS), Memory Stick Pro (MS-Pro), Multi-Media Card (MMC) compatible.\r\n 1 USB 2.0 port.\r\n 1 USB 3.0 port.\r\n 1 HDMI port.\r\n Bluetooth.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n Built-in mic.\r\n\r\nSoftware included: Microsoft Office 2013 Home & Student\r\n\r\nGeneral features:\r\n\r\n Up to 4 hours battery life.\r\n Size H18.85, W27.3, D2.1cm.\r\n Weight 1.2kg.\r\n EAN: 0888440328751.', 'Lenovo-Flex-10-Touch.png', 'Lenovo-Flex-10-Touch.jpg', 'Lenovo-Flex-10-Touch-2.jpg', '', '', 'http://shop.lenovo.com/ae/en/laptops/ideapad/flex/flex-10/'),
(19, 25, 50, 1, 1, 'Asus VIVOBOOK Touch - White', 299.99, 'Netbook', 'Asus', 'VIVOBOOK Touch', 'Windows 8', 'AMD A Series A4-1200', '4GB', '500GB', '10.1 inch', 'The white Asus VIVOBOOK X102BA 4GB 500GB Touch Laptop offers a great all-round package.', 'Product description / spec\r\n\r\nThe white Asus VIVOBOOK X102BA 4GB 500GB Touch Laptop offers a great all-round package. Small in stature but not in power, this Asus VIVOBOOK has 4GB of RAM and a 500GB hard drive, offering plenty of power and storage. The touchscreen provides a whole new immersive experience too. For effective, portable computing try the Asus VIVOBOOK.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n AMD A Series .\r\n A4-1200 processor.\r\n 4GB RAM.\r\n 500GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 10.1 inch screen.\r\n\r\nGraphics:\r\n\r\n Dedicated graphics card.\r\n 8180 graphics card.\r\n AMD Radeon HD.\r\n\r\nInterfaces and connectivity:\r\n\r\nMultimedia features:\r\n\r\n Built-in webcam.', 'Asus-VIVOBOOK-Touch.png', 'Asus-VIVOBOOK-Touch.jpg', 'Asus-VIVOBOOK-Touch-2.jpg', 'Asus-VIVOBOOK-Touch-3.jpg', '', 'https://www.asus.com/Notebooks_Ultrabooks/X102BA/'),
(20, 20, 20, 0, 0, 'HP Pavilion 15-n221sa - Purple.', 399.99, 'Laptop', 'HP', 'Pavilion 15-n221sa', 'Windows 8', 'Intel Core i3 dual core 1.8GHz', '8GB', '1TB', '15.6 inch', 'Attractive, easy to use and full of features, the purple HP Pavilion 15-n221sa 15.6 Inch 8GB 1TB Laptop has much to offer.', 'Product description / spec\r\n\r\nAttractive, easy to use and full of features, the purple HP Pavilion 15-n221sa 15.6 Inch 8GB 1TB Laptop has much to offer. A clear HD screen powered by Intel HD 4000 graphics, ensures high quality visuals. Chat via the HD webcam and connect to the multiple USB ports for your data and peripheral connectivity with the HP Pavilion.\r\n\r\n Never worry about running out of space - this dependable laptop is packed with storage. Get up to 1TB hard disk drive space for storing files, music, photos, videos and more of what you love and everything you need.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Core i3 dual core .\r\n 1.8GHz processor speed.\r\n 8GB RAM.\r\n 1024GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nGraphics:\r\n\r\n Dedicated graphics card.\r\n Intel HD Graphics 4000.\r\n\r\nInterfaces and connectivity:\r\n\r\n 1 USB 2.0 port.\r\n 2 USB 3.0 ports.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n Built-in mic.\r\n DTS sound system.\r\n\r\nGeneral features:\r\n\r\n Size H2.26, W38.56, D25.8cm.\r\n Weight 2.3kg.\r\n EAN: 888182353349.', 'HP-Pavilion-15-n221sa-Purple.png', 'HP-Pavilion-15-n221sa-Purple.jpg', '', '', '', 'http://www8.hp.com/uk/en/products/laptops/product-detail.html?oid=6705877#!tab=features'),
(21, 20, 20, 1, 0, 'HP Pavilion 15-n221sa - Red.', 399.99, 'Laptop', 'HP', 'Pavilion 15-n221sa', 'Windows 8', 'Intel Core i3 dual core 1.8GHz', '8GB', '1TB', '15.6 inch', 'Attractive, easy to use and full of features, the red HP Pavilion 15-n221sa 15.6 Inch 8GB 1TB Laptop has much to offer.', 'Product description / spec\r\n\r\nAttractive, easy to use and full of features, the red HP Pavilion 15-n221sa 15.6 Inch 8GB 1TB Laptop has much to offer. With a clear HD screen powered by Intel HD 4000 graphics, you can enjoy high quality visuals. Chat via the HD webcam and connect to the multiple USB ports for your data and peripheral connectivity with the HP Pavilion.\r\n\r\n Never worry about running out of space - this dependable laptop is packed with storage. Get up to 1TB hard disk drive space for storing files, music, photos, videos and more of what you love and everything you need.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Core i3 dual core .\r\n 1.8GHz processor speed.\r\n 8GB RAM.\r\n 1024GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nGraphics:\r\n\r\n Dedicated graphics card.\r\n Intel HD Graphics 4000.\r\n\r\nInterfaces and connectivity:\r\n\r\n Multi-Media Card (MMC) compatible.\r\n 1 USB 2.0 port.\r\n 2 USB 3.0 ports.\r\n 1 Ethernet port.\r\n 1 HDMI port.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n Built-in mic.\r\n DTS sound system.\r\n\r\nGeneral features:\r\n\r\n Size H2.26, W38.56, D25.8cm.\r\n Weight 2.3kg.\r\n EAN: 888182353349.\r\n\r\n', 'HP-Pavilion-15-n221sa-Red.png', 'HP-Pavilion-15-n221sa-Red.jpg', '', '', '', 'http://www8.hp.com/uk/en/products/laptops/product-detail.html?oid=6705877#!tab=features'),
(22, 15, 15, 1, 0, 'Acer E1-522', 379.99, 'Laptop', 'Acer', 'E1-522', 'Windows 8', 'AMD quad core A4-5000 1.5GHz', '6GB', '1TB', '15.6 inch', 'CPU, Memory and Operating System:\r\n\r\n AMD quad core .\r\n A4-5000 processor.', 'Product description / spec\r\n\r\nCPU, Memory and Operating System:\r\n\r\n AMD quad core .\r\n A4-5000 processor.\r\n 1.5GHz processor speed.\r\n 6GB RAM.\r\n 1024GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n High definition display.\r\n Resolution 1366 x 768 pixels.\r\n\r\nDVD optical drives:\r\n\r\n DVD+RW/DVD-RW (read/write).\r\n\r\nGraphics:\r\n\r\n Intel UMA.\r\n\r\nInterfaces and connectivity:\r\n\r\n SD media card reader.\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n Bluetooth.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.', 'Acer-E1-522.png', 'Acer-E1-522-2.png', 'Acer-E1-522-3.png', '', '', 'http://www.acer.com.au/ac/en/AU/content/model-datasheet/NX.M81SA.003'),
(23, 20, 15, 1, 0, 'Asus X550CA - Blue', 349.99, 'Laptop', 'Asus', 'X550CA', 'Windows 8', 'Intel Celeron', '6GB', '1TB', '15.6 inch', 'With excellent storage and processing speeds, the blue Asus X550CA 6GB 1TB Laptop has plenty to offer.', 'Product description / spec\r\n\r\nWith excellent storage and processing speeds, the blue Asus X550CA 6GB 1TB Laptop has plenty to offer. A 15.6 screen offers excellent visuals so you can get the most out of your gaming and multimedia. Operated by Windows 8, the Asus X550CA 6GB 1TB Laptop will make a great choice.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Celeron .\r\n 6GB RAM.\r\n 1000GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 15.6 inch screen.\r\n\r\nGraphics:\r\n\r\nInterfaces and connectivity:\r\n\r\nMultimedia features:\r\n\r\n Built-in audio sound system.', 'Asus-X550CA-Blue.png', 'Asus-X550CA-Blue.jpg', 'Asus-X550CA-Blue-2.jpg', 'Asus-X550CA-Blue-3.jpg', '', 'http://www.asus.com/Notebooks_Ultrabooks/X550CA/'),
(24, 15, 20, 1, 1, 'Toshiba C75 - Silver', 479.99, 'Laptop', 'Toshiba', 'C75', 'Windows 8', 'Intel Core i3 dual core 3120M 2.5GHz', '8GB', '1TB', '17.3 inch', 'The Satellite C75 laptop with the latest Intel® processors offers great value and great quality for everyday computing and features a 43.9cm (17.3) display.', 'Product description / spec\r\n\r\nThe Satellite C75 laptop with the latest Intel® processors offers great value and great quality for everyday computing and features a 43.9cm (17.3) display. Finished in a sleek silver colour with a tiled keyboard. Extensive connectivity is included with SuperSpeed USB 3.0, HDMI port and an integrated numeric keypad for added convenience and ease of use.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n Intel Core i3 dual core .\r\n 3120M processor.\r\n 2.5GHz processor speed.\r\n 8GB RAM.\r\n 1000GB hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 17.3 inch screen.\r\n High definition display.\r\n Resolution 1600 x 900 pixels.\r\n DVD+RW/DVD-RW (read/write).\r\n\r\nGraphics:\r\n\r\n Shared graphics card.\r\n Intel HD Graphics 4000.\r\n\r\nInterfaces and connectivity:\r\n\r\n Secure Digital (SD), Memory Stick (MS), Multi-Media Card (MMC) compatible.\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n 1 Ethernet port.\r\n 0 FireWire port.\r\n 1 HDMI port.\r\n Bluetooth.\r\n Wi-Fi enabled.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n Built-in mic.\r\n\r\nGeneral features:\r\n\r\n Up to 3.5 hours battery life.\r\n Size H3.5, W41.3, D26.8cm.\r\n Weight 2.4kg.\r\n\r\n', 'Toshiba-C75-Silver.png', 'Toshiba-C75-Silver.jpg', 'Toshiba-C75-Silver-2.jpg', '', '', 'http://www.toshiba.com/us/computers/laptops/satellite/C70/C75-A7390'),
(25, 20, 20, 1, 1, 'HP Pavillion TouchSmart', 299.99, 'Netbook', 'HP', 'Pavillion TouchSmart', 'Windows 8', 'AMD', '2GB', '500GB', '10.1 inch', 'The HP Pavillion TouchSmart Laptop combines the immersiveness of a tablet with the functionality of a PC thanks to its touchscreen.', 'Product description / spec\r\n\r\nThe HP Pavillion TouchSmart Laptop combines the immersiveness of a tablet with the functionality of a PC thanks to its touchscreen. A 500GB hard drive provides superb storage space and an AMD Radeon HD card offers excellent graphics. With a USB 3.0 port for rapid data sharing, the HP Pavillion TouchSmart is a fun and fabulous choice.\r\n\r\nCPU, Memory and Operating System:\r\n\r\n AMD .\r\n 2GB RAM.\r\n 500GB SATA hard drive.\r\n Microsoft Windows 8.\r\n\r\nDisplay features:\r\n\r\n 10.1 inch screen.\r\n\r\nGraphics:\r\n\r\n Dedicated graphics card.\r\n HD 8180 graphics card.\r\n AMD Radeon HD.\r\n\r\nInterfaces and connectivity:\r\n\r\n 2 USB 2.0 ports.\r\n 1 USB 3.0 port.\r\n\r\nMultimedia features:\r\n\r\n HD webcam.\r\n\r\nGeneral features:\r\n\r\n Weight 1.45kg.', 'HP-Pavillion-TouchSmart.png', 'HP-Pavillion-TouchSmart.jpg', '', '', '', 'http://h20386.www2.hp.com/MalaysiaStore/Product.aspx?pdetail=P315251'),
(26, 20, 20, 1, 0, 'Archos Titanium', 99.99, 'Tablet', 'Archos', 'Titanium', 'Android 4.1 Jelly Bean', '1.6GHz Cortex - A9', '1GB', '8GB', '7 inch', 'The Archos titanium tablet is equipped with an impressive 7 inch IPS screen that brings you amazing image quality and extra wide viewing angles', 'Product description / spec\r\n\r\nThe Archos titanium tablet is equipped with an impressive 7 inch IPS screen that brings you amazing image quality and extra wide viewing angles. This next generation LCD delivers excellent screen sharpness and vivid colours. Thanks to its 1280x800 screen resolution you can see every single detail in your pictures.\r\n\r\n Model number: 502424.\r\n Certified by Google, the Archos Titanium includes full access to Google Play, including DRM support for downloading books, music and movies.\r\n Play app and games - with over 700,000 Android apps and games, your tablet truly is your mobile entertainment system. Thanks to the 1.6 GHz dual-core processor and its powerful graphics co-processor, even graphically demanding games will look amazing.\r\n Play music - millions of tracks hand-picked rising artists and great bands from your favourite genres. You can even transfer your own music library. With over 4 million books to choose from, including millions of free titles, your next great read is never far away.\r\n\r\nDisplay:\r\n\r\n 7 inch screen.\r\n Resolution 1280 x 800 pixels.\r\n Multi-touch screen.\r\n\r\nSpecifications:\r\n\r\n 1.6GHz Cortex - A9 processor.\r\n 1GB RAM.\r\n 8 GB internal storage.\r\n Android 4.1 Jelly Bean operating system.\r\n\r\nGeneral features:\r\n\r\n Built-in speaker.\r\n Webcam.\r\n Wi-Fi enabled.\r\n Bluetooth - enabling you to easily and wirelessly connect with other bluetooth enabled devices.\r\n 3.5mm stereo headphone jack.\r\n Microphone.\r\n microSD memory card slot.\r\n Mini HDMI.\r\n Micro USB.\r\n\r\nAdditional information:\r\n\r\n Up to 6 hours battery life (depending on usage).\r\n 0.9mm thin.\r\n Size H18.8, W11.6cm.\r\n Weight 314g.\r\n EAN: 690590524248.', 'Archos-Titanium.png', 'Archos-Titanium.jpg', '', '', '', 'http://www.archos.com/gb/products/elements/titanium/archos_80titanium/index.html'),
(27, 20, 20, 1, 0, 'NOOK Simple Touch GlowLight', 49, 'E-reader', 'NOOK', 'Simple Touch', 'Android base', 'n/a', '750MB', '2GB', '6 inch', 'The clever Nook Simple Touch GlowLight allows you to read glare-free in the sunshine and late into the night with the easily adjustable lighting.', 'Product description / spec\r\n\r\nThe clever Nook Simple Touch GlowLight allows you to read glare-free in the sunshine and late into the night with the easily adjustable lighting. Lose yourself in over 1 month of reading without having to re-charge and enjoy a customised experience with a choice of font styles and sizes.\r\n\r\nE-reader features:\r\n\r\n 6 inch e-ink touch screen.\r\n Wi-Fi connectivity.\r\n Stores 1000 books.\r\n 2GB holds up to 1,000 eBooks (1GB for content, 750MB reserved for NOOK content).\r\n Extra-long battery life lets you read for over 2 months with GlowLight off, 1 month with GlowLight on.\r\n Comes with a MicroUSB Cable to charge your NOOK.\r\n Charge time of 3.5 hours.\r\n Battery life of 1344 hours.\r\n Choose from 6 adjustable font sizes to improve readability.\r\n Supported formats: ePub, PDF, JPG, GIF, PNG and BMP.\r\n\r\nGeneral information:\r\n\r\n Size H16.54, W12.66, D1.2cm.\r\n Weight 197g.\r\n EAN: 9781400501717.', 'NOOK-Simple-Touch.png', 'NOOK-Simple-Touch.jpg', '', '', '', 'http://www.barnesandnoble.com/p/nook-simple-touch-barnes-noble/1102344735');
Orders details
-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Host: bel.sunderland.ac.uk
-- Generation Time: Feb 02, 2014 at 06:43 PM
-- Server version: 5.0.24-max
-- PHP Version: 5.3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `bg47bp`
--
-- --------------------------------------------------------
--
-- Table structure for table `natty_orders`
--
CREATE TABLE `natty_orders` (
`OrderNum` int(11) NOT NULL auto_increment,
`OrderName` char(50) NOT NULL,
`OrderEmail` char(100) NOT NULL,
`OrderPhone` char(50) NOT NULL,
`OrderItemInCart` int(11) NOT NULL,
`OrderItemID1` int(11) NOT NULL,
`OrderFromMbro1` int(11) NOT NULL,
`OrderFromStock1` int(11) NOT NULL,
`OrderItemID2` int(11) NOT NULL,
`OrderFromMbro2` int(11) NOT NULL,
`OrderFromStock2` int(11) NOT NULL,
`OrderItemID3` int(11) NOT NULL,
`OrderFromMbro3` int(11) NOT NULL,
`OrderFromStock3` int(11) NOT NULL,
`OrderItemID4` int(11) NOT NULL,
`OrderFromMbro4` int(11) NOT NULL,
`OrderFromStock4` int(11) NOT NULL,
`OrderItemID5` int(11) NOT NULL,
`OrderFromMbro5` int(11) NOT NULL,
`OrderFromStock5` int(11) NOT NULL,
`OrderTime` datetime NOT NULL,
`OrderState` char(50) NOT NULL,
PRIMARY KEY (`OrderNum`),
UNIQUE KEY `OrderNum` (`OrderNum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
--
-- Dumping data for table `natty_orders`
--
INSERT INTO `natty_orders` (`OrderNum`, `OrderName`, `OrderEmail`, `OrderPhone`, `OrderItemInCart`, `OrderItemID1`, `OrderFromMbro1`, `OrderFromStock1`, `OrderItemID2`, `OrderFromMbro2`, `OrderFromStock2`, `OrderItemID3`, `OrderFromMbro3`, `OrderFromStock3`, `OrderItemID4`, `OrderFromMbro4`, `OrderFromStock4`, `OrderItemID5`, `OrderFromMbro5`, `OrderFromStock5`, `OrderTime`, `OrderState`) VALUES
(1, 'Lucy Hussain', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 3, 7, 1, 0, 6, 2, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, '2014-01-12 11:16:20', 'Collected'),
(4, 'Anna Goodwin', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-13 08:39:49', 'Expired'),
(5, 'Isobel Adams', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 10, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-14 08:40:51', 'Collected'),
(3, 'Poppy White', This email address is being protected from spambots. You need JavaScript enabled to view it.', '070 8523 5568', 2, 15, 1, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-13 08:38:16', 'Collected'),
(2, 'Yasmin Davison', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 13, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-13 08:24:27', 'Expired'),
(6, 'Billy West', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 7, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-14 13:01:00', 'Collected'),
(7, 'Nicole Sullivan', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 3413 8407', 2, 15, 1, 0, 5, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-14 19:13:22', 'Expired'),
(8, 'Evie Anderson', This email address is being protected from spambots. You need JavaScript enabled to view it.', '079 6162 2036', 2, 15, 0, 1, 5, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-15 09:27:31', 'Collected'),
(9, 'Archie Knight', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 3, 5, 1, 0, 15, 1, 0, 7, 1, 0, 0, 0, 0, 0, 0, 0, '2014-01-15 09:47:42', 'Collected'),
(10, 'Freya Rees', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 2, 7, 0, 1, 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-15 09:53:43', 'Collected'),
(11, 'Gabriel Armstrong', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 078 0737 7148', 2, 3, 1, 0, 15, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-20 08:55:53', 'Collected'),
(12, 'Lucas Jarvis', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 2, 8, 3, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-16 09:39:18', 'Collected'),
(13, 'David Dodd', This email address is being protected from spambots. You need JavaScript enabled to view it.', '078 5867 9567', 1, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-16 10:35:57', 'Collected'),
(14, 'Daisy Ashton', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-16 10:42:35', 'Expired'),
(15, 'Finlay Collier', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 070 1546 5438', 1, 16, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-16 10:44:23', 'Collected'),
(16, 'Tegan Storey', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 079 0267 3056', 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-16 10:51:29', 'Collected'),
(17, 'Grace Schofield', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 070 4671 7047', 2, 1, 1, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-16 10:52:29', 'Expired'),
(18, 'Mia Gregory', This email address is being protected from spambots. You need JavaScript enabled to view it.', '077 1203 8381', 1, 14, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-17 11:46:08', 'Collected'),
(19, 'Mohammad Humphries', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 070 0891 3673', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-17 11:47:35', 'Collected'),
(20, 'Olivia Lawrence', This email address is being protected from spambots. You need JavaScript enabled to view it.', '077 5831 0738', 1, 10, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-17 11:48:49', 'Collected'),
(21, 'Sebastian Barber', This email address is being protected from spambots. You need JavaScript enabled to view it.', '070 3678 9536', 1, 9, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-17 11:49:18', 'Live'),
(22, 'Lara Bishop', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 1537 0772', 1, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-18 12:41:06', 'Collected'),
(23, 'Elliot Davis', This email address is being protected from spambots. You need JavaScript enabled to view it.', '070 5798 2273', 1, 5, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-18 12:43:20', 'Collected'),
(24, 'Amy Cross', This email address is being protected from spambots. You need JavaScript enabled to view it.', '077 8568 4453', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-18 12:53:11', 'Expired'),
(25, 'Grace Wilkins', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 3366 3203', 1, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-19 12:57:10', 'Collected'),
(26, 'Abby Hilton', This email address is being protected from spambots. You need JavaScript enabled to view it.', '078 8784 0970', 1, 10, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-19 01:02:36', 'Collected'),
(27, 'Istvan Franko', This email address is being protected from spambots. You need JavaScript enabled to view it.', '079 7242 1477', 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-19 01:08:41', 'Collected'),
(28, 'Oscar Brady', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-19 01:13:21', 'Collected'),
(29, 'Tyler Kelly', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 070 8271 4320', 1, 16, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-20 01:18:49', 'Collected'),
(34, 'Jamie Pugh', This email address is being protected from spambots. You need JavaScript enabled to view it.', '077 6277 6345', 1, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-21 09:16:32', 'Expired'),
(30, 'Lily Ashton', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 078 6640 8974', 2, 12, 1, 0, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-21 09:00:00', 'Expired'),
(31, 'Jude Arnold', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 3079 2692', 1, 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-21 14:00:00', 'Uncompleted'),
(32, 'Harry Hope', This email address is being protected from spambots. You need JavaScript enabled to view it.', '078 5542 1518', 1, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-21 16:00:00', 'Expired'),
(33, 'Finlay Barrett', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 2902 3616', 3, 3, 0, 1, 5, 0, 1, 9, 0, 1, 0, 0, 0, 0, 0, 0, '2014-01-21 19:00:00', 'Expired'),
(35, 'Cristian Ionut Virciu', This email address is being protected from spambots. You need JavaScript enabled to view it.', '07999222402', 4, 7, 1, 0, 2, 1, 1, 4, 1, 1, 18, 1, 0, 0, 0, 0, '2014-01-24 12:46:45', 'Expired'),
(36, 'Istvan Franko', This email address is being protected from spambots. You need JavaScript enabled to view it.', '07515287044', 1, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-28 06:59:44', 'Expired'),
(37, 'Jack Stewart', '\r\This email address is being protected from spambots. You need JavaScript enabled to view it.', '070 5914 0276', 1, 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-28 09:39:20', 'Expired'),
(38, 'Kian Savage', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 078 5384 5396', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-29 11:33:28', 'Collected'),
(39, 'Reece Davey', This email address is being protected from spambots. You need JavaScript enabled to view it.', '079 0513 7744', 2, 7, 0, 1, 5, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-29 01:18:13', 'Expired'),
(40, 'Megan Forster', This email address is being protected from spambots. You need JavaScript enabled to view it.', '077 3148 1551', 1, 8, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-29 01:19:48', 'Expired'),
(41, 'Caitlin Kennedy', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 3306 0122', 1, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-29 10:38:17', 'Expired'),
(42, 'Istvan Franko', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-01-30 03:24:38', 'Expired'),
(43, 'Lucy Hussain', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 3, 8, 1, 0, 12, 1, 0, 9, 1, 0, 0, 0, 0, 0, 0, 0, '2014-01-30 08:34:51', 'Expired'),
(44, 'Istvan Franko', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-02-01 06:39:37', 'Expired'),
(45, 'Istvans Franko', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 1, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2014-02-02 11:48:29', 'Live');
Admin details
-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Host: bel.sunderland.ac.uk
-- Generation Time: Feb 02, 2014 at 06:48 PM
-- Server version: 5.0.24-max
-- PHP Version: 5.3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `bg47bp`
--
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`AdminID` int(10) NOT NULL auto_increment,
`AdminName` char(50) NOT NULL,
`AdminUserName` char(40) NOT NULL,
`AdminEmail` char(50) NOT NULL,
`AdminPhone` char(50) NOT NULL,
`AdminPassword` char(50) NOT NULL,
PRIMARY KEY (`AdminID`),
UNIQUE KEY `AdminID` (`AdminID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `admins`
--
INSERT INTO `admins` (`AdminID`, `AdminName`, `AdminUserName`, `AdminEmail`, `AdminPhone`, `AdminPassword`) VALUES
(1, 'Istvan Franko', 'bg47bp', This email address is being protected from spambots. You need JavaScript enabled to view it.', '07515287044', '********'),
(2, 'Andrew Smith', 'Andrew', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', '0191 5152920', 'Andrew'),
(3, 'Siobhan Devlin', 'Siobhan', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'Siobhan');
User details
-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Host: bel.sunderland.ac.uk
-- Generation Time: Feb 02, 2014 at 06:36 PM
-- Server version: 5.0.24-max
-- PHP Version: 5.3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `bg47bp`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`UserID` int(9) NOT NULL auto_increment,
`FullName` char(50) NOT NULL,
`UserName` char(40) NOT NULL,
`Email` char(50) NOT NULL,
`Phone` char(40) NOT NULL,
`Pass` char(40) NOT NULL,
PRIMARY KEY (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`UserID`, `FullName`, `UserName`, `Email`, `Phone`, `Pass`) VALUES
(2, 'Istvan Franko', 'fpisti35', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'bence'),
(5, 'Cameron Hudson', 'Cameron', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 078 2467 2769', 'Cameron'),
(25, 'Abby Daniels', 'Abby', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 070 5938 4188', 'Abby'),
(24, 'Isabella Smith', 'Isabella', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 078 7913 7737', 'Isabella'),
(26, 'Ellis Chan', 'Ellis', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 070 5790 0103', 'Ellis'),
(1, 'Lucas Jarvis', 'Lucas', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'Lucas'),
(3, 'Lucy Hussain', 'Lucy', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'Lucy'),
(4, 'Archie Knight', 'Archie', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'Archie'),
(6, 'Gabriel Armstrong', 'Gabriel', This email address is being protected from spambots. You need JavaScript enabled to view it.', '078 0737 7148', 'Gabriel'),
(7, 'Finlay Collier', 'Finlay', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'Finlay'),
(8, 'Grace Schofield', 'Grace', This email address is being protected from spambots. You need JavaScript enabled to view it.', '070 4671 7047', 'Grace'),
(9, 'Mohammad Humphries', 'Mohammad', This email address is being protected from spambots. You need JavaScript enabled to view it.', '070 0891 3673', 'Mohammad'),
(10, 'Oscar Brady', 'Oscar', This email address is being protected from spambots. You need JavaScript enabled to view it.', '', 'Oscar'),
(27, 'Ethan Lane', 'Ethan', This email address is being protected from spambots. You need JavaScript enabled to view it.', '079 5097 2096', 'Ethan'),
(28, 'Daniel Day', 'Daniel', This email address is being protected from spambots. You need JavaScript enabled to view it.', ' 077 5014 6014', 'Daniel');
Feedbacks details
-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Host: bel.sunderland.ac.uk
-- Generation Time: Feb 02, 2014 at 06:45 PM
-- Server version: 5.0.24-max
-- PHP Version: 5.3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `bg47bp`
--
-- --------------------------------------------------------
--
-- Table structure for table `feedbacks`
--
CREATE TABLE `feedbacks` (
`FeedbackID` int(11) NOT NULL auto_increment,
`FeedbackItem` char(50) NOT NULL,
`FeedbackName` char(50) NOT NULL,
`FeedbackSubject` char(100) NOT NULL,
`FeedbackComment` varchar(2000) NOT NULL,
`FeedbackEmail` char(50) NOT NULL,
`FeedbackState` char(10) NOT NULL,
`FeedbackRespond` varchar(2000) NOT NULL,
PRIMARY KEY (`FeedbackID`),
UNIQUE KEY `FeedbackID` (`FeedbackID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Dumping data for table `feedbacks`
--
INSERT INTO `feedbacks` (`FeedbackID`, `FeedbackItem`, `FeedbackName`, `FeedbackSubject`, `FeedbackComment`, `FeedbackEmail`, `FeedbackState`, `FeedbackRespond`) VALUES
(1, '', 'Michael Bradley', 'Memory extension', 'Do you performed on memory upgrades for its products?', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'Yeah, we performed memory expansion if the given product is physically possible.'),
(2, '', 'Sean Stone', 'Refund for Advent laptop', 'I bought an Advent laptop from you two weeks ago.\r\nThe laptops do not meet the purpose you bought.\r\nWe can give it back to the place of purchase? ', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'Sorry, that is not right purchase. To ours clients we offer 28-day refund or replacement at point of purchase.'),
(4, '', 'Riley Mills', 'E-readers battery life?', 'These products is true for more than 1 month battery life?', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'Yes. The product manufacturers guarantees on the products specified parameters.'),
(5, 'Toshiba C50', 'Jennifer Myers', 'Gamming', 'This laptop is capable of running modern games? ', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'About the compatibility with games we can not give information in general. This must be checked in description of particular games.'),
(6, 'Toshiba C50', 'Ellis Holloway', 'Battery life', 'What is this laptops battery life?', This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'Answered'),
(3, '', 'Ben Whitehouse', 'Opening time', 'What is your opening hours of its shops in Stockton? ', This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'The exact opening times available on the website about us menu'),
(21, '', 'Charlotte Whitehead', 'Careers?', 'I live in Middlesbrogh and looking for jobs. You are currently looking for staff? ', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Waiting', ''),
(20, 'Sony Vaio SVF1521A2EW', 'Louis Perkins', 'Purchase a large quantity?', 'Can we get a discount from these laptops if we want to buy more than 10 items ? ', This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'The wholesale buyers of mobile sales rep can provide individual prices.'),
(19, 'Asus X502', 'Charlie Norris', 'Larger hdd?', 'You can buy this product with even bigger hdd? ', ' This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'Greater HDD integration is possible, but the operating system relocation will be another costs.'),
(22, '', 'Kristiyan', 'Acer', 'How unreliable these Acer laptops? ', This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'Acer laptops are one of the most reliable products in the current assortment.'),
(23, 'Sony Vaio SVF1521A2EW', 'Istvan Franko', 'E-mail sytem operation control', 'Test comment', This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Waiting', ''),
(24, '', 'Istvan Franko', 'test feedback with ''', '', This email address is being protected from spambots. You need JavaScript enabled to view it.', 'Answered', 'answer with ''');
References
Argos (Item details)
http://www.argos.co.uk/static/Home.htm
Accessed January of 2014
Fake Name Generator (Dummy personal details)
http://www.fakenamegenerator.com/gen-random-en-uk.php
Accessed 02/02/2014
plus2net, Demo of using session array to create a simple shopping cart
http://www.plus2net.com/php_tutorial/array-session-demo.php
Accessed 22/01/2014
Tutorials Point, Using Paging through PHP
http://www.tutorialspoint.com/php/mysql_paging_php.htm
Accessed 28/01/2014
w3scholls.com
http://www.w3schools.com/default.asp
Accessed January of 2014