function displayFollowUp() { $dao = new DAO(); $rs = $dao->fetchFollowUpIDs($_GET['tid']); foreach ($rs as $rows) { foreach ($rows as $value) { echo '<div class="container">'; echo '<p> To:' . $dao->fetchThreadName($value) . '  Reply By ' . $dao->fetchUserName($dao->fetchUserIDByThreadID($value)) . '<br>' . $dao->fetchThreadContent($value) . '</p>'; echo '</div>'; } } }
function Q2() { $dao = new DAO(); $q = "SELECT * FROM (SELECT ID FROM THREAD WHERE PARENTTHREADID IS NULL order by id DESC) WHERE ROWNUM <=3 "; $stmt = oci_parse($dao->con, $q); oci_execute($stmt, OCI_DEFAULT); oci_fetch_all($stmt, $rs); foreach ($rs as $rows) { echo ""; foreach ($rows as $col_values) { echo "Comment/discussion Content: " . $dao->fetchThreadContent($col_values) . '    ThreadName: ' . $dao->fetchThreadName($col_values) . '<br>'; } } }
function __autoload($class_name) { $path = str_replace('_', '/', $class_name); require_once $path . '.class.php'; } session_start(); $tid = array_key_exists('tid', $_REQUEST) ? $_REQUEST['tid'] : null; $ttid = array_key_exists('ttid', $_REQUEST) ? $_REQUEST['ttid'] : null; if ($tid != null) { $rs = getThreadContent($_REQUEST['tid']); $dao = new DAO(); foreach ($rs as $rows) { echo ""; foreach ($rows as $col_values) { echo "Comment/discussion Content: " . $dao->fetchThreadContent($col_values) . '    ThreadName: ' . $dao->fetchThreadName($col_values) . '<br>'; } } } if ($ttid != null) { $dao = new DAO(); $rs = getStaffID($_REQUEST['ttid']); foreach ($rs as $rows) { echo ""; foreach ($rows as $col_values) { echo "Staffs on duty on mondays: " . $dao->fetchStaffName($col_values) . '    type: ' . $dao->fetchStaffTypeName($dao->fetchstaffType($col_values)) . ' schedule: ' . $dao->fetchStaffStartTime($col_values) . ' ' . $dao->fetchStaffEndTime($col_values) . '<br>'; } } } function getStaffID($tid) {
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>'; }