Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
Description of Assignment: This assignment is both a written and practical assignment that will demonstrate your skills in the creation of database driven web pages TASK 1 Create a MySQL databas
Description of Assignment:
This assignment is both a written and practical assignment that will demonstrate your skills in the creation of database driven web pages
TASK 1
Create a MySQL database containing a single table (games) for an online games store. The games table will store information about games with the minimum of the following fields: game title, genre, year of release, publisher, screenshot, and a written review and (possibly) other fields of data relating to games. Choose appropriate data types and widths for each field.
Note 1) As your database server might not allow you to choose the database name any name is acceptable for this
Note 2) The screenshot data does not need to be stored inside the table. Commonly this will contain a local file path or URL that can be used as a web hyperlink
Use PhpMyAdmin to add 5 records to the games table based on existing information which you will research on existing games websites.
Create a username and password that can access this database using your firstname+lastname and a password of your own choice. This account should have full access to the database.
Create a webpage that connects to your database using PHP. Store the information the connection needs (database name, table name, username /password) in PHP variables. Display a message in the webpage when a successful connection is 2.3]
Create a Word document Task1 that contains
- A screenshot of your working webpage
- A well commented listing of your HTML/PHP code
TASK 2
You will build on your work in task 1 and develop the database to the next stage
Using the existing records in your games db you will need to create the following:
- You will create a display all records page which lists all the items in the database in a html table using a control structure [1.3]
- You will create an insert form to allow games to be added to the database, implement validation checks so that data is correctly entered. [4.2] [5.4]
- Create a complex query by creating an update page which will allow users to edit the games in the database [4.3]
- You will create a delete page which will allow you to delete games records in the database. [4.4]
- You will create a basic search engine form which allows the user to search on multiple fields on the database and give back a results page based on those fields
For this You will need to create a complex query using SQL and execute this query on the remote database. This results page will use single control structures for selection and iteration such as conditional statements and loops to go through all the records. [3.1] [4.1]
- You will extend this page to show a list of games titles outputted as hyperlinks which then take you to more detail about the game that is chosen [3.2] [3.3]
- You will make a single page which has links to all these different pages you have made – all records, insert record, delete record, update records and search .
- Finally you will password protect access to this page [6.1]
To document this work, you will create software documentation for the user, this will have three parts.
Task 2a) Write an introductory section which explains how requirements can vary between the client (games store owner) and end user and explain the importance of an effective user experience [1.1]
Task 2b) Create and justify your user interface by producing design documentation in the form of wireframes and sketches to meet the specific client requirements as outlined below. [1.2]
The client requirements are
- The website application should work on mobile phones
- There should be a main menu to move between the different pages such as display all records, insert, delete, update and search
- Instructional text and menu labels should be intuitive
- There should be prompts where forms are not filled out correctly prompting the user to enter data correctly
Task 2c) Create a user guide document with live links and screenshots of your working pages and well commented page listings to show your understanding. Use current web development conventions in your approach.
TASK 3
You will write a report which addresses the following questions within a word limit of 1500 words. Please indicate supporting references.
- What are the differences and similarities between clientside and server-side scripting. Draw your conclusions by giving some practical examples of code within the types of languages involved and explain where you may use these giving real examples [2.1]
- Explain the environment or framework you have chosen to develop your web database application [2.2]
- What are the differences between (GET and POST) in relation to the published and tested multi-page scripting you have completed using request.form and query strings. [5.3]
- Why would you need to password protect parts of a website? [6.1] Why would you use a hidden form element on a website [6.2]
- Why would you need to validate user input for a website with a database? Describe the validation checks have you implemented? [5.4]
Finally review and evaluate the success of your uploaded files for your web database application suggesting areas for future development [7.2]File naming. Your tasks should be labelled in the following formatfirstname_surname_Task1_ddwp.docfirstname_surname_Task2_ddwp.docfirstname_surname_Task3_ddwp.docUpload this to Moodle to the designated final submission area by the deadline
- @
- 21 orders completed
- ANSWER
-
Tutor has posted answer for $80.00. See answer's preview
****** ******** ** *** EXISTS ************** ******** ******* ********* SET **** */;USE ********************* ***** ******* *********** ******* ******* *** AUTO_INCREMENTdescription ************ *** ************ VARCHAR(255)price DECIMAL(19 * ********* **** ******* ************************* ***************** **** ******* ********************************************** * **** ************** into Product values(NULL'console''PlayStation *************** **** ******* ******************************** *************** **** Product ************************ ***** ****************** into Product values(NULL'games''Grand ***** Auto'40000);INSERT **** ******* values(NULL'games''Call **** ******************** into ******* values(NULL'games''FarCry Primal'140000);INSERT **** Product ****************************************** into ******* *********************** Rally'140000);INSERT **** ******* ************************** ******************** **** Product values(NULL'games''Mario'40000);INSERT **** Product values(NULL'games''Battlefield'40000);INSERT into Product values(NULL'accessories''Xbox one ********************* **** ******* ***************************** *** ********************* **** ******* ***************************** one ********************* **** ******* ***************************** *** controller'20000);INSERT **** ******* **************************** ********************* **** ******* **************************** ********************* **** ******* **************************** charger'30000);INSERT into ******* **************************** ************************ **** ******* **************************** ********************* **** Product values(NULL'accessories''Wii ********************* **** ******* values(NULL'accessories''Wii ********************* **** ******* **************************** ************************ **** ******* **************************** ********************* into ******* ************************* ********************* into ******* ****************************************** **** ******* *********************** ******************** into ******* values(NULL'games''Counter ******************** into ******* values(NULL'games''Mario'40000);INSERT into ******* values(NULL'games''Battlefield'40000);INSERT **** ******* **************************** ************** ***** controller ***************** **** ******* **************************** ******* charger & ********** ***************** into ******* **************************** ******* ******* ***** controller ***************** * **** Product;CREATE TABLE consoles(console_id ******* ******* ************* **************** ************** varchar(255)FOREIGN KEY ********************** ******* (product_id)ON DELETE CASCADE ** ****** *************** ***** ************************ ******* ******* ***************** ******************* ******************* *** ************************ Product (product_id)ON ****** CASCADE ON ****** *************** into ******** *********** 'XBox 360'20'popular ***** ************* **** ******** values(1001 *********************** * Size **** upgradable');INSERT into ******** *********** ************ ************ * Size **** upgradable to 500GB');INSERT **** ******** *********** ************ ************* * **** **** ********** ** ************ * **** consoles;CREATE ***** ************** Integer PRIMARY KEYgames_name *************************** ********************* Integerdetails ********************** ************** *** ******************** Product ************** DELETE CASCADE ** ****** ************** *** (console_fk)REFERENCES ******** ************** ****** ******* ** ****** *************** **** ***** *********** ****** ***** Auto'1632'version ************** **** ***** *********** ****** Theft Auto'816'version ************** **** ***** *********** 'Call **** ****************** ************** into ***** values(1007 ******* Primal'815'version ************** **** ***** *********** *********************** ************** **** ***** *********** ***** ****************** ************** into ***** values(1010 ******** **************** ******* 11'1000);INSERT into ***** *********** ****************** ************** **** ***** values(1012 ************************ *************** **** ***** values(1026 'FarCry Primal'815'version ************** **** ***** *********** 'Division'35100'version ************** into ***** values(1028 'Dirt ****************** ************** **** Games values(1029 ******** **************** ******* *************** **** ***** values(1030 ****************** 5'1000);INSERT **** ***** *********** 'Battlefield'815'version *************** * FROM Games;INSERT **** accessories values(1013 ***** *** *************** ***** available ***** reviews');INSERT **** *********** *********** 'Xbox *** **************** **** available ***** **************** **** *********** *********** ***** *** *********** stock');INSERT **** *********** *********** ***** *** controller''black *** metallic *************** **** *********** *********** **** ************ ************** **** accessories *********** 'PS4 battery''largest size');INSERT into accessories values(1019 **** charger''extendible ************* into *********** *********** **** controller''colors: ***** red gray blue ************** into accessories *********** 'Wii headset''Striker P1 Black');INSERT **** *********** *********** **** ***************************** into accessories values(1023 **** battery''NS-GWII1108');INSERT **** *********** values(1024 'Wii ***************************** into accessories values(1025 **** *************** * * *********** **** *********** values(1032'PS3 batterycharger ***** ********** ******** ***** ***** ****** ** ************** into *********** *************** ************** ***** ********** set''All ***** ***** ****** ** stock');CREATE TABLE ******************** Integer PRIMARY *** *************************** varchar(255)customer_phone ****************** ******************** ***** customer_orders(order_id Integer PRIMARY *** ************************ dateproduct Integerproduct_count *************** ******************* ******************* KEY ******************** ******** (customer_id)ON ****** ******* ** ****** ************** KEY ******************* ******* (product_id)ON ****** CASCADE ** ****** *************** **** ******** ********************************* ******* Road ******* Park- ************** **** ******** values(NULL'Shell''2404576559'"6354 **** *** ******* ***** 20787 ***************** **** ******** ********************************** **** *** Boston- ***** ********************** **** customer values(NULL'Mishika''7694578125'"6528 New **** Ave *** 52483");insert **** ******** ************************************ Austria StreetTexas");insert into ******** ********************************** *** ****** ********** Virginia");insert **** ******** values(NULL'Sam''7255781252'"Calvert Road *********** ***** Virginia");insert **** customer ************************************ **** Ave ******** *** ************* **** customer values(NULL'Coleman''8234576559'"3154 **** *** Boston- ***** Massachussets");insert **** ******** ************************************ 48th *** College Park- 20740 ***************** into customer *********************************** **** *** *** Carrolton ***************** **** ******** values(NULL'Glowman''5634576559'"3154 **** *** ******* ***** ********************** **** ******** ************************************* **** *** ******* ***** ***** Maryland");insert into ******** *********************************** 46th *** ********* 29831 ***************** **** ******** **************** ************************* **** Ave Landmark **** 20740 ***************** **** *************** values(200'2015-09-29'10241105"delivered");insert **** *************** ************************************************ into *************** ************************************************** **** *************** ************************************************** **** *************** ************************************************ into *************** ************************************************ **** *************** ************************************************** **** customer_orders ************************************************** into *************** ************************************************ **** *************** ************************************************ **** *************** ************************************************** **** *************** ************************************************** into *************** values(NULL'2016-03-23'10171102"delivered");insert **** *************** ************************************************ **** *************** ************************************************** **** customer_orders ************************************************** **** customer_orders ************************************************** into *************** ************************************************** **** *************** values(NULL'2016-05-22'10112110"delivered");insert **** customer_orders values(NULL'2016-05-23'10191114"delivered");insert into customer_orders ************************************************ **** *************** ************************************************** **** customer_orders values(NULL'2016-05-14'10211103"delivered");insert **** *************** values(NULL'2016-05-23'10171109"ordered");insert **** customer_orders ************************************************ **** customer_orders ************************************************** **** *************** ************************************************** into customer_orders ************************************************** into *************** ************************************************ into *************** ************************************************** **** customer_orders ************************************************** * **** ********************** ***** ***************** (Product_id ******* ******* **************** ************** *** ********************** ******* ************** ****** CASCADE ** ****** ************** ***** ******************** ********** ************************* ;insert into ***************** *********** 25);insert **** Product_inventory *********** 25);insert **** Product_inventory *********** ********** **** ***************** *********** 25);insert into ***************** *********** 25);insert into ***************** *********** 25);insert **** ***************** *********** ********** **** ***************** values(1007 25);insert **** ***************** *********** ********** **** ***************** values(1009 25);insert **** ***************** values(1010 ********** into ***************** *********** ********** **** Product_inventory *********** ********** **** Product_inventory values(1013 ********** **** Product_inventory values(1014 ********** into ***************** values(1015 ********** **** ***************** values(1016 25);insert **** Product_inventory *********** ********** into Product_inventory values(1018 ********** into ***************** *********** ********** into ***************** *********** ********** into Product_inventory *********** ********** **** ***************** *********** ********** into ***************** *********** 25);insert **** ***************** *********** ********** into ***************** values(1025 25);insert into ***************** *********** ********** into Product_inventory values(1027 ********** into ***************** *********** ********** **** ***************** *********** ********** **** Product_inventory *********** ********** **** Product_inventory *********** 25);insert **** ***************** *********** ********** into ***************** *********** ********** **** ***************** *********** ********** * from ************************* ******** *** ******* ****** **** CUSTOMER ****** **** ****** * ******* ****** ** DECREMENTS COUNT **** ***************** *** **** *********** *** ********* **** ** ****** ** UPDATED TO ***** IT ****** INCREMENT *** COUNT ****** *** ****** ***** ** *** ********* ******* ** ** MADE ** ****** * ******** ** *** count ** ***** made ** **** **** available transaction ********* get ************* ******* ********************** TRIGGER ******************** ** trigger *** ******* during insertion *** new order **** ******* ****** ****** means no ****** ** ******** *********** ******* ******* ***************** ****** ****** ** ****************** EACH ROWBEGINUPDATE Product_inventory *** ************* * product_count * **************** where *************************** * ********** *** Neworder_status ='ordered';UPDATE ***************** *** ************* * ************* * **************** ***** *************************** = ********** AND *************** *************************** ********* **** ***** ** ****** ** product count or when there is ** ***** ****** ****** * am ******** **** ******* should ** **** **** **** \order ****** **** ** changed **** ordered ** ******* or from ******* to ordered ** delivered ** *** **** **** * ****** **** ********* to *************** *********** |CREATE ******* ***************** ****** ****** ON ****************** **** ROWBEGINif **************** <> **************** ********** ***************** *** product_count * ************* - **************** * **************** ***** *************************** = ***************** *************** ******** neworder_status ****** *************** = 'ordered' ********** ***************** set product_count * product_count + **************** ***** *************************** * Newproduct *** Neworder_status ***************** *************** * ********* ********** ***************** set ************* * ************* * **************** where Product_inventoryProduct_id = ********** *** Neworder_status ******************* Product_inventory *** ************* * ************* * **************** ***** Product_inventoryProduct_id * ********** AND *************** ************** ****** if;END;|delimiter *