SWIN BUR * NE * Swinburne University of Technology School of Science, Computing and Engineering Technologies SWINBURNE UNIVERSITY OF TECHNOLOGY COS10026 Computing Technology Inquiry Project Assignment Part 2, Semester 2, 2023 Server-Side Programming Important Information Due Date 10 pm on Monday in Week 13 (Late submission penalty: 10% of total available marks per day) Submission Method Canvas + Mercury Contribution to Final Assessment 50% Purpose of the assignment In this part of the assignment you will further enhance the Web site you developed in Parts 1. 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 attempt record should include the following: · EOInumber (auto-generated id) · Job Reference number · First name · Last name · Address: o Street address 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 so that the form data is sent to a PHP script (processEOI . php) that adds an EOI record to the table.