function displaySchedule()
{
$dao = new DAO();
$stmt = oci_parse($dao->con, "SELECT TO_CHAR(TIMESTART, 'MM-DD-YYYY HH24:MI') AS TS ,TO_CHAR(TIMEEND, 'MM-DD-YYYY HH24:MI') AS TE, ID, THEATREID, MOVIEID FROM SCREENROOM");
OCIDefineByName($stmt, "TS", $timeS);
OCIDefineByName($stmt, "TE", $timeE);
OCIDefineByName($stmt, "ID", $scroomID);
OCIDefineByName($stmt, "THEATREID", $tID);
OCIDefineByName($stmt, "MOVIEID", $mID);
oci_execute($stmt, OCI_DEFAULT);
echo '<table border=1>';
while (oci_fetch($stmt)) {
echo '<tr>';
// Use the uppercase column names for the associative array indices
$bookLink = '<a href=order.php?sID=' . $scroomID . '>  book</a>';
$detailLink = '<a href=movieDetail.php?mID=' . $mID . '>  detaile</a>';
echo '<td> MOVIE: ' . $dao->fetchMovieName($mID) . '</td>' . ' <td>Start: ' . $timeS . ' </td><td>End: ' . $timeE . ' </td><td> theatre: ' . $dao->fetchTheatreName($tID) . '</td><td>' . $bookLink . ' </td><td>' . $detailLink . '</td>';
echo '</tr>';
}
echo '</table>';
}
function getTheatreName($id)
{
$dao = new DAO();
return $dao->fetchTheatreName($id);
}
function q8()
{
$dao = new DAO();
echo "\n\t\t\t\t<form action=\"\" method=\"post\">\n\t\t\t\tchoose a Theare <select name=\"threadselect\" onchange=\"Q8(this.value)\" required> ";
echo '<option value =\'\' selected=\'selected\' >----must select one---</option>';
foreach ($dao->fetchTheatreIDs() as $rows) {
foreach ($rows as $value) {
echo "<option value ={$value} >" . $dao->fetchTheatreName($value) . '</option>';
}
}
echo "</select>\n\t\t\t\t\n\t\t\t\t</form>";
}
