PHP Query_Page_Patient::getRowCount Exemples

Exemple #1

Fichier : patient_search.php Projet : edubort/openclinic-1

// remove slashes added by form post
$searchText = stripslashes(Check::postGetSessionString('search_text'));
// remove redundant whitespace
$searchText = preg_replace("/[[:space:]]+/i", " ", $searchText);
// transform string in array of strings
$arraySearch = Search::explodeQuoted($searchText);
/**
 * Search database
 */
$patQ = new Query_Page_Patient();
$patQ->setItemsPerPage(OPEN_ITEMS_PER_PAGE);
$patQ->search($searchType, $arraySearch, $currentPage, $logical, $limit);
/**
 * No results message if no results returned from search.
 */
if ($patQ->getRowCount() == 0) {
    $patQ->close();
    FlashMsg::add(sprintf(_("No results found for '%s'."), $searchText));
    header("Location: ../medical/patient_search_form.php");
    exit;
}
/**
 * Show patient view screen if only one result from query
 */
if ($patQ->getRowCount() == 1) {
    $pat = $patQ->fetch();
    $patQ->freeResult();
    $patQ->close();
    header("Location: ../medical/patient_view.php?id_patient=" . $pat->getIdPatient());
    exit;
}