• Главная
• Prado
• Data
• TDbConnection

PHP Класс Prado\Data\TDbConnection

TDbConnection represents a connection to a database. TDbConnection works together with {@link TDbCommand}, {@link TDbDataReader} and {@link TDbTransaction} to provide data access to various DBMS in a common set of APIs. They are a thin wrapper of the {@link http://www.php.net/manual/en/ref.pdo.php PDO} PHP extension. To establish a connection, set {@link setActive Active} to true after specifying {@link setConnectionString ConnectionString}, {@link setUsername Username} and {@link setPassword Password}. Since 3.1.2, the connection charset can be set (for MySQL and PostgreSQL databases only) using the {@link setCharset Charset} property. The value of this property is database dependant. e.g. for mysql, you can use 'latin1' for cp1252 West European, 'utf8' for unicode, ... The following example shows how to create a TDbConnection instance and establish the actual connection: $connection=new TDbConnection($dsn,$username,$password); $connection->Active=true; After the DB connection is established, one can execute an SQL statement like the following: $command=$connection->createCommand($sqlStatement); $command->execute(); // a non-query SQL statement execution or execute an SQL query and fetch the result set $reader=$command->query(); each $row is an array representing a row of data foreach($reader as $row) ... One can do prepared SQL execution and bind parameters to the prepared SQL: $command=$connection->createCommand($sqlStatement); $command->bindParameter($name1,$value1); $command->bindParameter($name2,$value2); $command->execute(); To use transaction, do like the following: $transaction=$connection->beginTransaction(); try { $connection->createCommand($sql1)->execute(); $connection->createCommand($sql2)->execute(); .... other SQL executions $transaction->commit(); } catch(Exception $e) { $transaction->rollBack(); } TDbConnection provides a set of methods to support setting and querying of certain DBMS attributes, such as {@link getNullConversion NullConversion}. Показать файл Открыть проект Примеры использования класса

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

Метод	Описание
__construct ( $dsn = '', $username = '', $password = '', $charset = '' )	Constructor.
__sleep ( )	Close the connection when serializing.
beginTransaction ( ) : TDbTransaction	Starts a transaction.
createCommand ( $sql ) : TDbCommand	Creates a command for execution.
getActive ( ) : boolean
getAttribute ( $name ) : mixed	Obtains a specific DB connection attribute information.
getAutoCommit ( ) : boolean
getAvailableDrivers ( ) : array
getCharset ( ) : string
getClientVersion ( ) : string
getColumnCase ( ) : TDbColumnCaseMode
getConnectionStatus ( ) : string
getConnectionString ( ) : string
getCurrentTransaction ( ) : TDbTransaction
getDbMetaData ( ) : TDbMetaData
getDriverName ( ) : string
getLastInsertID ( $sequenceName = '' ) : string	Returns the ID of the last inserted row or sequence value.
getNullConversion ( ) : TDbNullConversionMode
getPassword ( ) : string
getPdoInstance ( ) : PDO
getPersistent ( ) : boolean
getPrefetch ( ) : boolean
getServerInfo ( ) : string
getServerVersion ( ) : string
getTimeout ( ) : integer
getTransactionClass ( ) : string
getUsername ( ) : string
quoteColumnAlias ( string $name ) : string	Quotes a column alias for use in a query.
quoteColumnName ( string $name ) : string	Quotes a column name for use in a query.
quoteString ( $str ) : string	Quotes a string for use in a query.
quoteTableName ( string $name ) : string	Quotes a table name for use in a query.
setActive ( $value )	Open or close the DB connection.
setAttribute ( $name, $value )	Sets an attribute on the database connection.
setAutoCommit ( $value )
setCharset ( $value )
setColumnCase ( $value )
setConnectionString ( $value )
setNullConversion ( $value )
setPassword ( $value )
setPersistent ( $value )
setTransactionClass ( $value )
setUsername ( $value )

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

Метод	Описание
close ( )	Closes the currently active DB connection.
open ( )	Opens DB connection if it is currently not
setConnectionCharset ( )	* Set the database connection charset.

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