Esempi in PHP per Query_Page_Access::freeResult

Linguaggio di programmazione: PHP

Classe/tipologia: Query_Page_Access

Metodo/funzione: freeResult

Esempi su hotexamples.com: 2

Query_Page_Access::freeResult in PHP: 2 esempi trovati. Questi sono i migliori esempi reali in PHP per Query_Page_Access::freeResult, estratti da progetti open source. Li puoi valutare, per aiutarci a migliorare la qualità dei nostri esempi.

Metodi utilizzati di frequente

Mostra Nascondi

close(2)

fetch(2)

freeResult(2)

getCurrentRow(1)

getPageCount(1)

getRowCount(1)

insert(1)

searchUser(1)

select(1)

setItemsPerPage(1)

Esempio n. 1

Mostra file

File: log_list.php Progetto: edubort/openclinic-1

} else {
    $thead[] = _("Profile");
}
$options = array('align' => 'center', 0 => array('align' => 'right'));
$tbody = array();
for ($i = 1; $log = $logQ->fetch(); $i++) {
    $row = $i . '.';
    $row .= OPEN_SEPARATOR;
    $row .= I18n::localDate($log["access_date"]);
    $row .= OPEN_SEPARATOR;
    $row .= $log["login"];
    $row .= OPEN_SEPARATOR;
    if ($table == 'record') {
        $row .= $log["table_name"];
        $row .= OPEN_SEPARATOR;
        $row .= $log["operation"];
        $row .= OPEN_SEPARATOR;
        $row .= htmlspecialchars(var_export(unserialize($log["affected_row"]), true));
    } else {
        $row .= $profiles[$log["id_profile"]];
    }
    $tbody[] = explode(OPEN_SEPARATOR, $row);
}
// end for
$logQ->freeResult();
$logQ->close();
unset($logQ);
unset($log);
echo HTML::rule();
echo HTML::table($thead, $tbody, null, $options);
require_once "../layout/footer.php";

Esempio n. 2

Mostra file

File: user_access_log.php Progetto: edubort/openclinic-1

echo HTML::section(2, sprintf(_("Access Logs List for user %s"), $login) . ":");
// Printing result stats and page nav
echo HTML::para(HTML::tag('strong', sprintf(_("%d accesses."), $accessQ->getRowCount())));
$params = array('id_user='******'login='******'&', $params);
$pageCount = $accessQ->getPageCount();
$pageLinks = Search::pageLinks($currentPage, $pageCount, $_SERVER['PHP_SELF'] . '?' . $params);
echo $pageLinks;
$profiles = array(OPEN_PROFILE_ADMINISTRATOR => _("Administrator"), OPEN_PROFILE_ADMINISTRATIVE => _("Administrative"), OPEN_PROFILE_DOCTOR => _("Doctor"));
$thead = array(_("Access Date") => array('colspan' => 2), _("Login"), _("Profile"));
$options = array(0 => array('align' => 'right'), 2 => array('align' => 'center'), 3 => array('align' => 'center'));
$tbody = array();
while ($access = $accessQ->fetch()) {
    $row = $accessQ->getCurrentRow() . ".";
    $row .= OPEN_SEPARATOR;
    $row .= I18n::localDate($access["access_date"]);
    $row .= OPEN_SEPARATOR;
    $row .= $access["login"];
    $row .= OPEN_SEPARATOR;
    $row .= $profiles[$access["id_profile"]];
    $tbody[] = explode(OPEN_SEPARATOR, $row);
}
$accessQ->freeResult();
$accessQ->close();
echo HTML::table($thead, $tbody, null, $options);
echo $pageLinks;
unset($accessQ);
unset($access);
unset($profiles);
echo HTML::para(HTML::link(_("Return to users list"), $returnLocation));
require_once "../layout/footer.php";