PHP代写 | COSC7369C/COSC7372C PROJECT ASSESSMENT TASK

阅读和分析商业网站的技术要求文档, 然后编写规范文档并创建一个基于PHP和MySQL的网站

PROJECT ASSESSMENT TASK

Version Number: 3

 

Task Number2 of 3Task NameDynamic Website Project (part 1)
National unit(s) codeICTWEB501

ICTDBS504

National unit(s) titleBuild a dynamic website

Integrate database with a website

National qualification codeICT50115National qualification titleDiploma of Information Technology
RMIT Program codeC5341RMIT Course codeCOSC7369C

COSC7372C

Section A –   Assessment Information

Duration and/or due date: 

Week 10

Task instructions
Summary and Purpose of Assessment

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.

Conditions for assessment
●      Assessment will be conducted in a safe environment where evidence gathered demonstrates consistent performance of typical activities experienced in the database field of work

●      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).

 

 

Instructions on submitting your project
·       Create a ZIP file containing all project files (on RMIT Jupiter) – include the following files

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

 

 

Equipment/resources students must supply:Equipment/resources to be provided by RMIT or the workplace:
·       Laptop

·       XAMPP virtual server

·       Browsers

·       Computer and Internet access

·       Web server – RMIT Jupiter

·       Database server – RMIT SQL

·       Database

·       Web development environment

 
  • Assessment Guide

Below is a checklist for how this assessment task will be judged as satisfactory or not satisfactory.

Criteria for assessment
Activity 1

Write answers to the following questions in a Word document

Name the Word document – design_specifications.docx

 

1.     Website Topic & Design
o   What is the theme/topic of your website?

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

 

2.     Website functionality
Read the technical specifications document

 

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

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

3.     Data Storage
Read the technical specifications document

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

 

 

 

Activity 2 – Database
1.     Create a database table on the RMIT SQL server
Create a database table to store the main website content.

 

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

 

Activity 3 – Create the required website functions
1.     Create an object-oriented PHP class
Create an object-oriented class file

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

2.     Write a script to connect to the database
In your class file, create an object-oriented method to connect to the database

 

o Use variables to store database details

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

 

3.     Create include files for HTML structure and navigation
 

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

 

4.     Style each page with CSS styles
 

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

 

5.     Write scripts to insert data into the database with user-supplied input from a form
Form

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.

 

6.     Write scripts to retrieve data from the database and display on web pages
 

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.

 

Activity 4 – Testing
1.     Test the functionality and user interfaces
Test your website against the design specifications as you build your website and document this testing as you go

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

 

Optional Activity – Search Bar
 

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

 

 

 

 


程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: [email protected]  微信:itcsdx


如果您使用手机请先保存二维码,微信识别。如果用电脑,直接掏出手机果断扫描。

发表评论