D7 API documentation
What's New
Modules
Main module in old core
Connection constructor
add
clearCaches
commitTransaction
connect
createIndex
createPrimaryIndex
disableQueryExecuting
disconnect
dropColumn
dropTable
enableQueryExecuting
executeSqlBatch
getAffectedRowsCount
getDbHost
getDbLogin
getDbName
getDisabledQueryExecutingDump
getIndexName
getNodeId
getSqlHelper
getTableField
getTableFields
getTracker
getType
getVersion
isIndexExists
isTableExists
query
queryExecute
queryScalar
renameTable
rollbackTransaction
setConnectionResourceNoDemand
setNodeId
setTracker
startTracker
startTransaction
stopTracker
truncateTable
query
\Bitrix\Main\DB\Result public \Bitrix\Main\DB\Connection::query( string $sql, array $binds, integer $offset, integer $limit );
This non-static method executes the following queries:
- query($sql)
- query($sql, $limit)
- query($sql, $offset, $limit)
- query($sql, $binds)
- query($sql, $binds, $limit)
- query($sql, $binds, $offset, $limit)
Similar methodic the legacy kernel: CDatabase::Query.
Parameters
Parameter | Description | Version |
---|---|---|
$sql | SQL query. | |
$binds | Array of binds. | |
$offset | Offset the of the first row to return, starting from 0. | |
$limit | Limit rows count. |
Exception
Examples
© «Bitrix24», 2001-2024
Up