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