PHP DAO::fetchThreadName примеры использования

Пример #1

Файл: thread.php Проект: a4501150/CS425

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) . '&nbsp Reply By ' . $dao->fetchUserName($dao->fetchUserIDByThreadID($value)) . '<br>' . $dao->fetchThreadContent($value) . '</p>';
            echo '</div>';
        }
    }
}

Пример #2

Файл: QUERIES.php Проект: a4501150/CS425

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) . '&nbsp &nbsp ThreadName: ' . $dao->fetchThreadName($col_values) . '<br>';
        }
    }
}

Пример #3

Файл: getContent.php Проект: a4501150/CS425

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) . '&nbsp &nbsp 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) . '&nbsp &nbsp type: ' . $dao->fetchStaffTypeName($dao->fetchstaffType($col_values)) . ' schedule: ' . $dao->fetchStaffStartTime($col_values) . '&nbsp' . $dao->fetchStaffEndTime($col_values) . '<br>';
        }
    }
}
function getStaffID($tid)
{

Пример #4

Файл: account.php Проект: a4501150/CS425

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