• Главная
• Contao
• Database
• Statement

PHP Класс Contao\Database\Statement

The class creates the database queries replacing the wildcards and escaping the values. It then executes the query and returns a result object. Usage: $db = Database::getInstance(); $stmt = $db->prepare("SELECT * FROM tl_member WHERE city=?"); $stmt->limit(10); $res = $stmt->execute('London'); Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство	Тип	Описание
$arrCache	array	Result cache
$blnDisableAutocommit	boolean	Autocommit indicator
$resConnection	Doctrine\DBAL\Connection	Connection ID
$statement	Doctrine\DBAL\Driver\Statement	Database statement
$strQuery	string	Query string

Открытые методы

Метод	Описание
__construct ( Doctrine\DBAL\Connection $resConnection, boolean $blnDisableAutocommit = false )	Validate the connection resource and store the query string
__get ( string $strKey ) : mixed | null	Return an object property
execute ( ) : Result | object	Execute the query and return the result object
executeCached ( ) : Result	Always execute the query and add or replace an existing cache entry
executeUncached ( ) : Result	Bypass the cache and always execute the query
explain ( ) : string	Explain the current query
limit ( integer $intRows, integer $intOffset ) : Statement	Handle limit and offset
prepare ( string $strQuery ) : Statement	Prepare a query string so the following functions can handle it
query ( string $strQuery = '' ) : Result | Statement	Directly send a query string to the database
set ( array $arrParams ) : Statement	Autogenerate the SET/VALUES subpart of a query from an associative array

Защищенные методы

Метод	Описание
escapeParams ( array $arrValues ) : array	Escape the values and serialize objects and arrays
replaceWildcards ( array $arrValues )	Replace the wildcards in the query string

Описание методов

Описание свойств