PHP SchoolQuery::setItemsPerPage Examples

Example #1

File: scl_search.php Project: vishnu35/Granthalay

#*  Retrieving post vars and scrubbing the data
#****************************************************************************
if (isset($_POST["page"])) {
    $currentPageNmbr = $_POST["page"];
} else {
    $currentPageNmbr = 1;
}
$searchType = $_POST["searchType"];
$searchText = trim($_POST["searchText"]);
# remove redundant whitespace
$searchText = preg_replace('/\\s+/', " ", $searchText);
#****************************************************************************
#*  Search database
#****************************************************************************
$sclQ = new SchoolQuery();
$sclQ->setItemsPerPage(OBIB_ITEMS_PER_PAGE);
$sclQ->connect();
$sclQ->execSearch($searchType, $searchText, $currentPageNmbr);
#**************************************************************************
#*  Show member view screen if only one result from barcode query
#**************************************************************************
if ($searchType == "schoolCode" && $sclQ->getRowCount() == 1) {
    $scl = $sclQ->fetchMember();
    $sclQ->close();
    header("Location: ../circ/scl_view.php?sclid=" . U($scl->getSchoolid()) . "&reset=Y");
    exit;
}
#**************************************************************************
#*  Show search results
#**************************************************************************
require_once "../shared/header.php";