>> Reservation.php Conference Room Reservation Form Reserve the Conference Room: Reserve Now >> login.php Login Page Satff Login Page ... Login >> StaffPage.php Staff Page

>> Reservation.php

Reserve the Conference Room:

?>

>> login.php

Satff Login Page ...

>> StaffPage.php

Welcome Staff ...

>> Report.php

Conference Room Reservation Table:

$connection =mysqli_connect('localhost','root','','haddabi') OR die ('no database connection');

$SQL= "select * from room_reservation";

$result = mysqli_query($connection,$SQL);

echo "

"; echo " ";

while ($row=mysqli_fetch_array($result)){ echo "

"; } echo "

Full Name	Department	Date
$row[1]	$row[3]	$row[4]

";

echo "
";

$SQL2= "select * from user_details";

$result2 = mysqli_query($connection,$SQL2);

echo "

Staff Details Table:

"; echo ""; echo "

";

while ($info=mysqli_fetch_array($result2)){ echo "

"; } echo "

User ID	Username	First Name	Last Name	Gender	Password
$info[0]	$info[1]	$info[2]	$info[3]	$info[4]	$info[5]

";

mysqli_close($connection);

?>

SECTION 2- RESERVATION PAGE 10. MARKS Open Reservation she and do the following 1. Declare an indexed Array called "departments and assign the following values to 1.5 Markal Public Relation Dept. Information Technology Dept. Marketing Dept Finance Dept Pepe2016 2. Use foreach loop or any loop to play the values of the above array in a drop-down menu inside the form as the following screenshot 13.5 Marts gure Output of the 3. Once the user clicks Reserve Now" button, save the reservation details in room_reservation table. Then play message "The room reserved successfully [5.75 RESERVE THE CONFERENCE ROOM: SECTION 3 - LOGIN PAGE 17.25 MARKS 1. Opening 2. If the verdicks "Login" button, do the following: 11 Mark 2. Declare two variables SUSIR and SPASS to read the user inouts from the username and password tethos 2 Marks b. Check the name and the periword are correct from the Stable: If usemame and password are correct. Open "SoftPage.php"18.75 Marks! If username and password are not come display a message in the same page: Username or Pasword is not valid 1 Mark 3. in the footer tag use for loop for any loop to print 8 hashes in each row - you need 6 was the following recht (45 Marks] SATFF LOGIN PAGE () SECTION 4-STAFF PAGE 16 MARKS 1. In "StaffPage.php", the PHP code to establish the connection with your database is written Change the name of the database as needed to do the following tasks. 10. Mark] 2. By using if-elseif statement, write the code for the following buttons: ( 4 Marks] Buttons Action Marks Delete Reservation ID textbok should not be empty 1 Reservation If it is empty, display" Fill reservation ID textbox to delete a 0.5 by ID record" If it is not empty. 2.5 Delete the record based on the written in the textbox from room_reservation table. 0.5 o Display a message "Record has been deleted" Update Number of Attendees textbox should be number 1 Number of if it is not number, display Number of Attendees should be 0.5 Attendees number If it is number: 3 o Update the new number of attendees based on the reservation ID in the room_reservation table. 0.5 Display a message "Updated Successfully View All Open "report.php 0.75 Tables Details Reserve the Open "Reservation.php 0.75 Conference Room SECTION 2- RESERVATION PAGE 10. MARKS Open Reservation she and do the following 1. Declare an indexed Array called "departments and assign the following values to 1.5 Markal Public Relation Dept. Information Technology Dept. Marketing Dept Finance Dept Pepe2016 2. Use foreach loop or any loop to play the values of the above array in a drop-down menu inside the form as the following screenshot 13.5 Marts gure Output of the 3. Once the user clicks Reserve Now" button, save the reservation details in room_reservation table. Then play message "The room reserved successfully [5.75 RESERVE THE CONFERENCE ROOM: SECTION 3 - LOGIN PAGE 17.25 MARKS 1. Opening 2. If the verdicks "Login" button, do the following: 11 Mark 2. Declare two variables SUSIR and SPASS to read the user inouts from the username and password tethos 2 Marks b. Check the name and the periword are correct from the Stable: If usemame and password are correct. Open "SoftPage.php"18.75 Marks! If username and password are not come display a message in the same page: Username or Pasword is not valid 1 Mark 3. in the footer tag use for loop for any loop to print 8 hashes in each row - you need 6 was the following recht (45 Marks] SATFF LOGIN PAGE () SECTION 4-STAFF PAGE 16 MARKS 1. In "StaffPage.php", the PHP code to establish the connection with your database is written Change the name of the database as needed to do the following tasks. 10. Mark] 2. By using if-elseif statement, write the code for the following buttons: ( 4 Marks] Buttons Action Marks Delete Reservation ID textbok should not be empty 1 Reservation If it is empty, display" Fill reservation ID textbox to delete a 0.5 by ID record" If it is not empty. 2.5 Delete the record based on the written in the textbox from room_reservation table. 0.5 o Display a message "Record has been deleted" Update Number of Attendees textbox should be number 1 Number of if it is not number, display Number of Attendees should be 0.5 Attendees number If it is number: 3 o Update the new number of attendees based on the reservation ID in the room_reservation table. 0.5 Display a message "Updated Successfully View All Open "report.php 0.75 Tables Details Reserve the Open "Reservation.php 0.75 Conference Room