• 홈
• Contao
• Database

PHP 클래스 Contao\Database

The class is responsible for connecting to the database, listing tables and fields, handling transactions and locking tables. It also creates the related Database\Statement and Database\Result objects. Usage: $db = Database::getInstance(); $stmt = $db->prepare("SELECT * FROM tl_user WHERE id=?"); $res = $stmt->execute(4); 파일 보기 프로젝트 열기: contao/core-bundle 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$arrCache	array	Cache
$arrInstances	array	Object instances (Singleton)
$blnDisableAutocommit	boolean	Disable autocommit
$resConnection	Doctrine\DBAL\Connection	Connection ID

공개 메소드들

메소드	설명
__clone ( )	Prevent cloning of the object (Singleton)
__destruct ( )	Close the database connection
__get ( string $strKey ) : string | null	Return an object property
beginTransaction ( )	Begin a transaction
commitTransaction ( )	Commit a transaction
execute ( string $strQuery ) : Result | object	Execute a query and return a Database\Result object
executeCached ( string $strQuery ) : Result | object	Always execute the query and add or replace an existing cache entry
executeUncached ( string $strQuery ) : Result | object	Execute a query and do not cache the result
fieldExists ( string $strField, string $strTable, boolean $blnNoCache = false ) : boolean	Determine if a particular column exists
findInSet ( string $strKey, mixed $varSet, boolean $blnIsField = false ) : string	Auto-generate a FIND_IN_SET() statement
getChildRecords ( mixed $arrParentIds, string $strTable, boolean $blnSorting = false, array $arrReturn = [], string $strWhere = '' ) : array	Return the IDs of all child records of a particular record (see #2475)
getFieldNames ( string $strTable, boolean $blnNoCache = false ) : array	Return the field names of a particular table as array
getInstance ( array $arrCustomConfig = null ) : Database	Instantiate the Database object (Factory)
getNextId ( string $strTable ) : integer	Return the next autoincrement ID of a table
getParentRecords ( integer $intId, string $strTable ) : array	Return the IDs of all parent records of a particular record
getSizeOf ( string $strTable ) : integer	Return the table size in bytes
getUuid ( ) : string	Return a universal unique identifier
indexExists ( string $strName, string $strTable, boolean $blnNoCache = false ) : boolean	Determine if a particular index exists
isUniqueValue ( string $strTable, string $strField, mixed $varValue, integer $intId = null ) : boolean	Check whether a field value in the database is unique
listFields ( string $strTable, boolean $blnNoCache = false ) : array	Return all columns of a particular table as array
listTables ( string $strDatabase = null, boolean $blnNoCache = false ) : array	Return all tables as array
lockTables ( array $arrTables )	Lock one or more tables
prepare ( string $strQuery ) : Statement	Prepare a query and return a Database\Statement object
query ( string $strQuery ) : Result | object	Execute a raw query and return a Database\Result object
rollbackTransaction ( )	Rollback a transaction
setDatabase ( string $strDatabase )	Change the current database
tableExists ( string $strTable, string $strDatabase = null, boolean $blnNoCache = false ) : boolean	Determine if a particular database table exists
unlockTables ( )	Unlock all tables

보호된 메소드들

메소드	설명
__construct ( array $arrConfig )	Establish the database connection

메소드 상세

프로퍼티 상세