PHP DAO::fetchMovieName方法代碼示例

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 . '>&nbsp book</a>';
        $detailLink = '<a href=movieDetail.php?mID=' . $mID . '>&nbsp 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);
}