Rewrite the code so it looks different but has the same output connect_error); $facultyQuery = "select Name, Fid
Rewrite the code so it looks different but has the same output
<?php
$cookie_name = "user";
if(!isset($_COOKIE[$cookie_name])){
echo "please login in first!
";
exit();
}
else {
echo "logout";
include 'dbconfig.php';
$conn = new mysqli($hostname, $username, $password, $dbname) or die($conn->connect_error);
$facultyQuery = "select Name, Fid from TECH3740.Faculty";
$roomQuery = "Select CONCAT(Building,Number) as BuR, size from TECH3740.Rooms";
$facultyResult = mysqli_query($conn, $facultyQuery);
$roomResult = mysqli_query($conn, $roomQuery);
$rooms = mysqli_num_rows($roomResult);
echo "
";
echo "Add a course
";
echo "Course ID: (ex: CPS1231)
";
echo "Course Name:
";
echo "Term: Spring ";
echo "Summer ";
echo "Fall
";
echo "Enrollment: (# of registered students)
";
echo "Select a faculty: Select a faculty"; echo ""; while($row = mysqli_fetch_array($facultyResult)){ echo "" . $row['Name'] ; } echo "
";
echo "Room: "; echo ""; while($row = mysqli_fetch_array($roomResult)){ echo "" .$row['BuR'], " has ", $row['size'], " seats" ; } echo "";
echo "";
echo "
";
mysqli_close($conn);
}
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
