Section A –   Assessment Information

Week 10

You are required to read and analyse a technical requirements document for a business website. You will then produce a design specifications document outlining how you will create the website and then build the dynamic website according to your design plans

You will need to build a small MySQL database and integrate it with the website; and then, use PHP (object-oriented) scripting language and SQL queries to provide the required functionality. The website must be hosted on the RMIT Jupiter and SQL servers and undergo thorough testing.

This assessment task is part 1 of a website project which has 2 parts

Completing this assessment task allows you to demonstrate that you can

§ define and analyse technical requirements

§ produce design specifications for a website

§ access a database using a web-development language

§ retrieve and display web-based data

§ insert web-based data

§ develop a website to the specified design

§ test a web application

Assessment Instructions

What

This assessment task is part 1 of your dynamic website project. You are required to complete the following 4 activities.

Write a design specification document based on the technical requirements and user needs specified in the project brief. The document must address the following.

• • Purpose of the website
  • Data Storage

• • Required website functionality

Create a MySQL database table

o   Create a database table with a minimum of 5 fields (including 1 image field)

o   An id field must be specified as the primary key and set to auto-increment

o   Populate the table with data for 6 records and store the required images in a folder

Use object-oriented PHP and SQL queries to create the required web-site functions:

o   Write a script to connect to the database

o   Write a script to insert data into the database with user-supplied input from a form

o   Apply validation and error checking constructs

o   Write a script to retrieve data from the database and display on a web page

o   Use HTML5 and CSS to format and style all data displayed in the website

o   Create a navigation to link all website components

Test the website functionality against the technical requirements

o   You are required to conduct user and function testing in class during week 10

o   You will be provided with testing documentation

o   The completed tests need to be scanned and submitted with this assessment

Where

Your dynamic website files and database must be hosted on the RMIT Jupiter and SQL servers.

All files required for the website (sql, php, css and images) and written documents (content.txt, design specifications & testing) are to be zipped and uploaded to Canvas by the due date

The ZIP file must be named – A2_student name

You are required to demonstrate your project during class in week 10

You will be provided some class time to work on this assessment, however, it is expected that most of this assessment will be completed outside of class.

How

You will be assessed against the criteria as listed in the observation checklist in Section B of this task. To achieve a satisfactory result, you will need to address all criteria satisfactorily.

You are required to submit a ZIP file of all website project files to Canvas by the due date.

●      You must be assessed by a qualified assessor (NVR/AQTF assessor requirements)

●      You must complete the task by week 10

●      This is an individual task, however, you may work with other students in resolving errors and testing your PHP scripts

●      You must complete all tasks listed in the checklist to the standard described in Section B to be deemed satisfactory in this assessment

●      Please make arrangements with your assessor at least one week prior to the assessment due date if you feel you require special allowance or allowable adjustment to this task

●      You will have the opportunity to re-submit should you be deemed unsatisfactory (one resubmit allowed).

o   class file (connection and other methods required to run scripts)

o   display scripts (incl details)

o   insert script & form

o   css files

o   sql backup

o   any other files that are necessary for the working of your web application

o   written documents (content.txt, design specifications & testing)

·       Name the zip file with your student id and name – A2_studentname

·       Upload the zip file to Canvas in week 10

·       XAMPP virtual server

·       Browsers

·       Web server – RMIT Jupiter

·       Database server – RMIT SQL

·       Database

·       Web development environment

Write answers to the following questions in a Word document

Name the Word document – design_specifications.docx

o   Find an example website on the internet which is related to your chosen theme

o   Take a screen capture and annotate it with comments about the data being displayed, the design and available functions

Refer to example provided

o What should general users be able to do on the website?

o What should company employees be able to do on the website?

o What are the two database tables required?

o What fields (as a minimum) must be created for each table?

o What field is required for the primary key?

o Consider your own topic and the example websites you have looked at. What additional information would you like to display on your web pages?

o Write a list of all data (text and images) you will need to store in your product table

Collect information and images for 6 records

o Create a text document named content.txt

o Write all text information required for your database in this text file

o Create an images folder and place the 6 images required for your database in this folder

o Text and one image should also be stored for testing purposes

Refer to example provided

Content.txt MUST be submitted with your project files

o Minimum 5 data fields (id, name, description, image, caption)

o An id field must be specified as the primary key and set to auto-increment

o Input 6 genuine records

Once the database table has been created and all data inputted, create a backup by exporting the table as an SQL file

This SQL file needs to be submitted along with your project files

This class will contain all PHP methods and properties required for the website functionality including a construct which automatically runs a new connection to the database

o Use variables to store database details

o Use error control functions to capture connection issues and display messages

o Create a folder named includes

o Create php files containing the standard HTML structural elements required for each page in your website – save as head.php and footer.php

o Create a php file containing the HTML navigation containing the options – Display Records and Add Records. Save as nav.php

These files MUST be included on each php page – to ensure the user requirements and W3C standards are met

o   One style sheet should be created to provide a simple design layout.

o   As a minimum, modify the class example CSS file and link it to each page via the include files

o   The navigation must be styled and easy to use

o Create an HTML form for user input

o The form fields need to reflect your database fields

o ID should not be included on the form as this should be auto generated

o The form should use the HTTP request method POST and include image browse functionality

Insert script

o Sanitise all POST data from the form using either escape strings or prepared statements

o Create variables for the post data

o Write an SQL query to insert the post data variables into the database table

o Pass the SQL query to an execute query function in your class file

o Use conditional statements to test the success of your query and provide error control messages as needed

o Use HTML elements to display a user message about the success or failure of the query

Write an execute query function in the class file

o Create an object-oriented method to insert a new record into the database table using an SQL query passed to it.

o The method should execute the SQL query return success or failure to calling script.

Write a PHP script to display all records on one page

o Write an SQL query to select records and pass this to a get records function in your class file

o Use conditional statements to test the success of your query and provide error control messages as needed

o Use PHP loops and HTML elements to display the data retrieved

o The display should include a hyperlink passing the product id to a details page

Write a PHP script to display the product details

o Using the id passed, write an SQL query to select the one record required and pass this to a get records function in your class file

o Use HTML to display the data retrieved

Write a get records function in the class file

o Create an object-oriented method to run a query on a database table using an SQL query passed to it.

o The method should retrieve the required records; store them in an array; and return the array to the calling script.

o You are required to participate in a user testing workshop in week 10, where you will test another student’s website using a testing document and document the results.

o You will then need to fix any errors or missing components prior to submission

A scanned PDF file of the testing document MUST be submitted with your project files

HTML search form

o Create an HTML form (text input and submit) to allow users to search for products (by name or description)

o The form should use HTTP request GET method

o Use your own research for examples of where the search bar could be positioned on the page

PHP search script

o Create an SQL query containing the search keywords and pass this to the get records function in the class file

o Display the search results in a similar format to the display product details page

o If no records are found, provide the user with a message