COS60004: Human Resources (HR) - EOInumber - Management Assessment Answer

Subject Code: COS60004

Management Assessment Answer

TASK: 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. 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 • Other skills. Text description

This Management Assessment has been solved by our Management experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.