Exemplos de Krugozor_Pagination_Manager::getStartLimit em PHP

Exemplo n.º 1

Arquivo: model.php Projeto: v31project/GISTaxi

function reviews($mysqli)
{
    if ($_SESSION['status'] == 'superadmin') {
        $selConditionString = "";
    } elseif ($_SESSION['status'] == 'admin') {
        $selConditionString = " WHERE Passengers.idCity = " . $_SESSION['idCity'] . " ";
    }
    $paginationManager = new Krugozor_Pagination_Manager(15, 5, $_REQUEST);
    $result = $mysqli->query("SELECT SQL_CALC_FOUND_ROWS idReview,  \n\t\t\t\t\t\t\t\t\t\ttextReview, \n\t\t\t\t\t\t\t\t\t\ttimeReview, \n\t\t\t\t\t\t\t\t\t\trating, \n\t\t\t\t\t\t\t\t\t\tstatus, \n\t\t\t\t\t\t\t\t\t\tDrivers.phone AS phoneDriver, \n\t\t\t\t\t\t\t\t\t\tPassengers.phone AS phonePassenger \n\t\t\t\t\t\t\t\t\tFROM Reviews \n\t\t\t\t\t\t\t\t\tINNER JOIN \n\t\t\t\t\t\t\t\t\t\tDrivers ON Drivers.idDriver = Reviews.idDriver \n\t\t\t\t\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\t\t\t\t\tPassengers ON Passengers.idPassenger = Reviews.idPassenger \n\t\t\t\t\t\t\t\t\t" . $selConditionString . "ORDER BY status DESC \n\t\t\t\t\t\t\t\t\tLIMIT " . $paginationManager->getStartLimit() . "," . $paginationManager->getStopLimit());
    if ($result) {
        $data['reviews'] = db2Array($result);
        $result = $mysqli->query("SELECT FOUND_ROWS()");
        $numCity = db2Array($result);
        $paginationManager->setCount($numCity[0]['FOUND_ROWS()']);
        $data['paginationManager'] = $paginationManager;
    } else {
        $data['errors'] = $mysqli->error;
    }
    return $data;
}