Rewrite the code so it looks different but has the same output connect_error);    $facultyQuery = "select Name, Fid

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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);
}

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Array
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education