Ejemplos de DAO::fetchStaffName en PHP

Ejemplo n.º 1

Archivo: getContent.php Proyecto: a4501150/CS425

    $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)
{
    $dao = new DAO();
    $q = "select workerid from schedule where theatreid = {$tid} and q8(workerid)>0";
    $stid = oci_parse($dao->con, $q);
    oci_execute($stid, OCI_DEFAULT);
    oci_fetch_all($stid, $rs);
    return $rs;
}
function getThreadContent($TID)
{
    $dao = new DAO();

Ejemplo n.º 2

Archivo: staff.php Proyecto: a4501150/CS425

function displayManagerInfo()
{
    $dao = new DAO();
    $rs = $dao->fetchManagerIDsWithoutRights();
    echo 'Manager have not rights to update movie: <br>';
    echo '<table border=0>';
    foreach ($rs as $row) {
        foreach ($row as $id) {
            echo '<tr>';
            $changeLink = "<a href=\"staff.php?cmd=addRight&staffid={$id}\">" . 'addRights' . '</a>';
            echo '<td> Manager: ' . $dao->fetchStaffName($id) . '</td><td> ' . $changeLink . '</td><td>';
            echo '</tr>';
        }
    }
    echo '</table>';
    $rss = $dao->fetchManagerIDsWithRights();
    echo 'Manager have rights to update movie: <br>';
    echo '<table border=0>';
    foreach ($rss as $row) {
        foreach ($row as $id) {
            echo '<tr>';
            $changeLink = "<a href=\"staff.php?cmd=delRight&staffid={$id}\">" . 'delRights' . '</a>';
            echo '<td> Manager: ' . $dao->fetchStaffName($id) . '</td><td> ' . $changeLink . '</td><td>';
            echo '</tr>';
        }
    }
    echo '</table>';
}