Create simple MySQL tables for storing, updating and
Create simple MySQL tables for storing, updating and
Purpose of the assignmentIn this part of the assignment you will further enhance the Web site you developed inParts 1 and 2. You will:• Extend the functionality of the web site by creating server-side PHP scripts toprocess job application data sent from the Web forms you created in the previousparts of the assignment.• Create simple MySQL tables for storing, updating and retrieving information from aWeb site.• Create a Web page that allows the Human Resources (HR) manager at thecompany to view, update and delete applications.There will be an opportunity to enhance your website beyond the basic requirements.A: Specified RequirementsUse only mysqli commands in this assignment.1. Use PHP to reuse common elements in your Web sitePHP provides us with techniques to modularise and reuse our web application code. Rewriteyour web pages so that the common static HTML elements such a menu, header and footerare written in common text files that are then “included” back into your web pages. Name theinclude 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 phpincludes 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 thehost, user, password and database name connection variables, and use this in your PHP toconnect 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 includethe 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 addresso Suburb/towno Stateo Postcode• Email address• Phone number• Skills (Note: the data here will depend on your job description. Although there are better waysto design this, you could just have a number of generic fields called skill1, skill2, … etc.)• Other skills. Text descriptionIn addition to the above information, each record should have a Status field. The values inthis field can be New, Current or Final. When an EOI record is first created the Status isset 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 thatthe form data is sent to a PHP script (processEOI.php) that adds an EOI record to thetable. When the database has accepted the expression of interest from the form, a Webpage should display a confirmation message with the unique auto-generated EOInumber tothe user.When a user submits an EOI, if an EOI table does not already exist in your database thetable should be programmatically created by your code.The “processEOI.php” page, should not be able to be accessed directly by url through abrowser. 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 theintegrity 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 removeleading and trailing spaces, backslashes and HTML control characters. If the data does notvalidate an appropriate user-friendly error page should be displayed to the user.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
WHATSAPP CHAT: +1 (781) 253-4162
Click ORDER NOW..
