function displayRecentTopics() { $dao = new DAO(); $rsRw = $dao->fetchRewiewIDbyUserName($_SESSION['LoginName']); //result set of reviewIDs by this user. $rsTh = $dao->fetchTopicIDbyUserName($_SESSION['LoginName']); // result set of TopicsIDs by $rsFu = $dao->fetchFollowUpIDbyUserName($_SESSION['LoginName']); // result set of FollowUpsID by echo '<div class="container">'; echo '<h1>reviews</h1>'; foreach ($rsRw as $rows) { echo "<br>"; foreach ($rows as $col_values) { //echo $col_values; $mID = $dao->fetchMovieIDbyReviewID($col_values); echo "<a href=movieDetail.php?mID={$mID}>" . ' review for ' . $dao->fetchMovieName($mID) . '</a></br>'; } } echo '</div>'; echo '<div class="container">'; echo '<h1> Threads </h1>'; foreach ($rsTh as $rows) { echo ""; foreach ($rows as $col_values) { //echo $col_values; echo "<a href=thread.php?tid={$col_values}>" . ' Thread: ' . $dao->fetchThreadName($col_values) . '</a></br>'; } } echo '</div>'; echo '<div class="container">'; echo '<h1> Thread FollowUps </h1>'; foreach ($rsFu as $rows) { echo ""; foreach ($rows as $col_values) { //echo $col_values.'<br>'; $tid = $dao->fetchParentThreadID($col_values); //echo $tid; echo "<a href=thread.php?tid={$tid}>" . ' Thread: ' . $dao->fetchThreadName($tid) . '</a></br>'; } } echo '</div>'; }
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 getMovieName($id) { $dao = new DAO(); return $dao->fetchMovieName($id); }
function displayMovieName() { global $movieID; $dao = new DAO(); echo $dao->fetchMovieName($movieID); }