PHP paginator::getPaginatorQuery示例

function dbGetDataTable($devName, $limit, $page, $links)
{
    $conn = dbConnect();
    $query = "SELECT devTableName,devNumOfFields FROM devices WHERE devName='" . $devName . "'";
    $result = mysqli_query($conn, $query) or die("impossible to do query1 - getDataTable: " . $query);
    $devMainInfo = mysqli_fetch_assoc($result);
    $query = "SELECT * FROM " . $devMainInfo['devTableName'] . " ORDER BY tableLogId DESC";
    $paginator = new paginator($conn, $query);
    $query = $paginator->getPaginatorQuery($limit, $page);
    $result = mysqli_query($conn, $query) or die("impossible to do query2 - getDataTable: " . $query);
    if (mysqli_num_rows($result) > 0) {
        for ($i = 0; $i < mysqli_num_rows($result); $i++) {
            $dataTableRow = mysqli_fetch_array($result);
            $myRow['logId'] = $dataTableRow['tableLogId'];
            $myRow['logDate'] = $dataTableRow['logDate'];
            $myRow['logTime'] = $dataTableRow['logTime'];
            $data = array();
            for ($j = 0; $j < $devMainInfo['devNumOfFields']; $j++) {
                $data[] = $dataTableRow[$j + 3];
            }
            $myRow['data'] = $data;
            $table[] = $myRow;
        }
    } else {
        $conn->close();
        return false;
    }
    //              ['logId']                 ['devName']['logDate']['logTime'] ['data']
    //table[][] = {logId(tbaleName+tableLogId), devName,   logDate,   logTime, (array)data}
    $extraGetParams = "&devName=" . $devName;
    $table['links'] = $paginator->createLinks($links, 'pagination pagination-sm', $extraGetParams);
    $conn->close();
    return $table;
}