function q5() { $dao = new DAO(); $q = "SELECT USERID FROM Q5 WHERE NUM = (SELECT MAX(NUM) FROM Q5)"; $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 "User contributed most reviews: " . $dao->fetchUserName($col_values) . '<br>'; } } oci_free_statement($stmt); $q = "SELECT USERID FROM Q5 WHERE NUM = (SELECT MAX(NUM) FROM Q5)"; $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 "User contributed most comments on threads: " . $dao->fetchUserName($col_values) . '<br>'; } } }
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 displayGuestInfo() { $dao = new DAO(); $rs = $dao->fetchGuestList(); echo 'Avalible Guest to View: <br>'; echo '<table border=0>'; foreach ($rs as $row) { foreach ($row as $id) { echo '<tr>'; $loginName = $dao->fetchLoginName($id); $changeLink = "<a href=\"account.php?loginName={$loginName}\">" . 'view' . '</a>'; echo '<td> Guest: ' . $dao->fetchUserName($id) . '</td><td> ' . $changeLink . '</td><td>'; echo '</tr>'; } } echo '</table>'; }