|
static | query ($sql, Connection $connection, $numberOfRecords, $pageNumber, $numberOfRecordsPerPage, $backward=false) |
|
static | calculateQueryLimits ($numberOfRecords, $pageNumber, $numberOfRecordsPerPage, $backward) |
|
См. определение в файле paginator.php строка 9
◆ calculateQueryLimits()
static calculateQueryLimits |
( |
| $numberOfRecords, |
|
|
| $pageNumber, |
|
|
| $numberOfRecordsPerPage, |
|
|
| $backward ) |
|
static |
Returns two element array with offset and limit based on paging parameters.
- Аргументы
-
integer | $numberOfRecords | Total number of records returned by Sql query. |
integer | $pageNumber | Page to be displayed. |
integer | $numberOfRecordsPerPage | Page size. |
boolean | $backward | Use backward paging. |
- Возвращает
- array
См. определение в файле paginator.php строка 43
◆ query()
static query |
( |
| $sql, |
|
|
Connection | $connection, |
|
|
| $numberOfRecords, |
|
|
| $pageNumber, |
|
|
| $numberOfRecordsPerPage, |
|
|
| $backward = false ) |
|
static |
Makes offset and limit calculations and executes limited query against $connection.
- Аргументы
-
string | $sql | Sql query. |
Connection | $connection | Database connection for query execution. |
integer | $numberOfRecords | Total number of records returned by Sql query. |
integer | $pageNumber | Page to be displayed. |
integer | $numberOfRecordsPerPage | Page size. |
boolean | $backward | Use backward paging. |
- Возвращает
- Result
- Исключения
-
Bitrix\Main\Db\SqlQueryException
См. определение в файле paginator.php строка 24