• 홈
• 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'); 파일 보기 프로젝트 열기: contao/core-bundle 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$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

메소드 상세

프로퍼티 상세