Questions
»
Writing
»
Essay
»
Create simple MySQL tables for storing, updating…
Create simple MySQL tables for storing, updating and retrieving information from a Web site….
86
+
Users Viewed
22
+
Downloaded Solutions
Washington, US
Mostly Asked From
Purpose of the assignment
In this part of the assignment you will further enhance the Web site you developed in
Parts 1 and 2. You will:
• Extend the functionality of the web site by creating server-side PHP scripts to
process job application data sent from the Web forms you created in the previous
parts of the assignment.
• Create simple MySQL tables for storing, updating and retrieving information from a
Web site.
• Create a Web page that allows the Human Resources (HR) manager at the
company to view, update and delete applications.
There will be an opportunity to enhance your website beyond the basic requirements.
A: Specified Requirements
Use only mysqli commands in this assignment.
1. Use PHP to reuse common elements in your Web site
PHP provides us with techniques to modularise and reuse our web application code. Rewrite
your web pages so that the common static HTML elements such a menu, header and footer
are written in common text files that are then “included” back into your web pages. Name the
include file(s) with a .inc extension, replace the sections of HTML in your main pages with
‘include’ statements, and rename your main pages with a .php extension, so the php
includes will be included.
2. Create a file to store your database connection variables “settings.php”
As you have done in the labs use a PHP include file “settings.php” that contains the
host, user, password and database name connection variables, and use this in your PHP to
connect to your MySQL database on the feenix-mariadb database server.
3. Create an EOI table (expressions of interest)
Create a table eoi in your MySQL database. The information in each record should include
the following:
COS60004 Creating Web Applications 2019S1 Assignment Part 3 Page 2 of 6
• EOInumber (auto-generated id)
• Job Reference number
• First name
• Last name
• Address:
o Street address
o Suburb/town
o State
o Postcode
• Email address
• Phone number
• Skills (Note: the data here will depend on your job description. Although there are better ways
to design this, you could just have a number of generic fields called skill1, skill2, … etc.)
• Other skills. Text description
In addition to the above information, each record should have a Status field. The values in
this field can be New, Current or Final. When an EOI record is first created the Status is
set to New.
4. Adding validated records to the EOI table (processEOI.php)
Use (or adapt) the application form you developed in Assignment Part 1 and Part 2 so that
the form data is sent to a PHP script (processEOI.php) that adds an EOI record to the
table. When the database has accepted the expression of interest from the form, a Web
page should display a confirmation message with the unique auto-generated EOInumber to
the user.
When a user submits an EOI, if an EOI table does not already exist in your database the
table should be programmatically created by your code.
The “processEOI.php” page, should not be able to be accessed directly by url through a
browser. Hint: check what data has been set and redirect.
While you will have done client-side validation in Parts 1 & 2, in order to preserve the
integrity of the server data you should also implement server-side data format checking.
Check the integrity of the data input by the users. All data should be sanitized to remove
leading and trailing spaces, backslashes and HTML control characters. If the data does not
validate an appropriate user-friendly error page should be displayed to the user.
Attachments:
3087170_1_COS60004-A3-2019-S1.pdf
3087170_2_New-folder.zip
May 20 2019 04:41 AM
Expert’s Answer
SOLUTION.PDF
Previous
Next
Related Questions in
Writing
Featured
Measuring QoS performance based on actual customer behaviour…
Learner guide ICTWEB501 – Build adynamic websiteVersion Control Unit code Document version Release date Comments/actions ICTWEB501 1.0 30.11.2017 First draft ICTWEB501 2.0 25.7.2018 Second draft Table of contents Introduction. 3Chapter 1: Identify…
VIEW ANSWERS
Posted
4 months ago
ITECH1400 – Assignment 1 – Container Recycling Machine…
ITECH1400 – Assignment 1 – Container Recycling Machine Due Date: 5pm, Friday of Week 7This assignment will test your skills in designing and programming applications to specification and is worth 20% of your non-invigilated (type A) marks for this…
VIEW ANSWERS
Posted
4 months ago
. Case Study: Web Presence and Exegesis In Brief
This assignment is worth…
Case Study: Web Presence and Exegesis In Brief This assignment is worth 50% of your mark for this unit.?Your Web Presence Creation should have a Central Node that contains an About page amongst other content. The Central Node should be linked with…
VIEW ANSWERS
Posted
4 months ago
Depending on which provider you use and the type of music that you want to stream there are…
Depending on which provider you use and the type of music that you want to stream there are currently multiple music streamingservices available such as Spotify, Deezer, Tidal, Amazon Prime Music, Apple Music, PrimePhonic, and YouTube Music.In this…
VIEW ANSWERS
Posted
4 months ago
In this assignment you will extend the website you developed in assignment 1. You will create…
1. PurposeIn this assignment you will extend the website you developed in assignment 1. You will createserver-side PHP scripts to process and store the quiz data sent from the form on quiz.html. Itwill involve the creation of simple MySQL tables to…
VIEW ANSWERS
Posted
4 months ago
Recent Questions in
Essay
State the line of interpretation of To Kill A Mockingbird that you wish to defend…
State the line of interpretation of To Kill A Mockingbird that you wish to defend in an essay. You may choose one of the four quotes given below or one of your own. Keep in mind that your interpretation will be from a Biblical perspective. ? “I…
VIEW ANSWERS
Posted
4 months ago
Compare and contrast Shakespeare’s perspective to those of Machiavelli, Confucius,…
Compare and contrast Shakespeare’s perspective to those of Machiavelli, Confucius, and Tzu. Be sure to include applicable quotations to support your answer. Remember, every quotation needs a sentence to explain why you put it in your response….
VIEW ANSWERS
Posted
4 months ago
TRUE OR FALSE When Thomas Edison left Biograph films, he put out a full page…
TRUE OR FALSE When Thomas Edison left Biograph films, he put out a full page advertisement listing all of his films and accomplishments he had made there. TRUE OR FALSE Harold Lloyd learned slapstick on the vaudeville circuit. TRUE OR FALSE When…
VIEW ANSWERS
Posted
4 months ago
In order to make your writing more concise, you should a. add adjectives and…
In order to make your writing more concise, you should a. add adjectives and adverbs into each sentence b. avoid overlapping sentences and repeating meaning c. include prepositional phrases to introduce your main idea d. use active voice and strong…
VIEW ANSWERS
Posted
4 months ago
A Reflection Analysis and explanation of the film “Coffee to Go: Café para llevar”…
A Reflection Analysis and explanation of the film “Coffee to Go: Café para llevar” Directed by Patricia Font. Featuring Daniel Grao Alexandra Jiménez. Refer to link for exact film https://www.kanopy.com/en/mdc/video/5878559
VIEW ANSWERS
Posted
4 months ago
In Juno and the Paycock, respond to O’Casey’s play and also to Hitchcock’s film…
In Juno and the Paycock, respond to O’Casey’s play and also to Hitchcock’s film version. Some of the key themes in Juno are: love, poverty, isolation, misinformation, truth, gender, deception, expectations, work ethic, illusions, civil strife,…
VIEW ANSWERS
Posted
4 months ago
All the animals were now present except Moses, the tame raven, who slept on a…
All the animals were now present except Moses, the tame raven, who slept on a perch behind the back door. When Major saw that they had all made themselves comfortable and were waiting attentively, he cleared his throat and began: “Comrades, you have…
VIEW ANSWERS
Posted
4 months ago
The Value of Sherpa Life Grayson Schaffer WORD LIST physiology mortality…
The Value of Sherpa Life Grayson Schaffer WORD LIST physiology mortality reincarnation A. DIRECTIONS: In each of the following items, think about the meaning of the italicized word or phrase, and then answer the question. 1. Would someone studying…
VIEW ANSWERS
Posted
4 months ago
Chapter 8 On page 85, Elwood thinks about an Archimedes quote: “Violence is the…
Chapter 8 On page 85, Elwood thinks about an Archimedes quote: “Violence is the only lever big enough to move the world.” React to this quote: do you agree with Archimedes? Why/why not? What is Elwood’s new plan in this chapter? Be specific. Do you…
VIEW ANSWERS
Posted
4 months ago
The world is too much with us; late and soon, Getting and spending, we lay waste…
The world is too much with us; late and soon, Getting and spending, we lay waste our powers;— Little we see in Nature that is ours; We have given our hearts away, a sordid boon! (5) This Sea that bares her bosom to the moon; The winds that will…
VIEW ANSWERS
Posted
4 months ago
Leave a Reply