CDbConnection

$connection=new CDbConnection($dsn,$username,$password);
$connection->active=true;

$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) ...

$command=$connection->createCommand($sqlStatement);
$command->bindParam($name1,$value1);
$command->bindParam($name2,$value2);
$command->execute();

$transaction=$connection->beginTransaction();
try
{
   $connection->createCommand($sql1)->execute();
   $connection->createCommand($sql2)->execute();
   //.... other SQL executions
   $transaction->commit();
}
catch(Exception $e)
{
   $transaction->rollBack();
}

array(
    'components'=>array(
        'db'=>array(
            'class'=>'CDbConnection',
            'connectionString'=>'sqlite:path/to/dbfile',
        ),
    ),
)

Property Details

whether the DB connection is established

whether creating or updating a DB record will be automatically committed. Some DBMS (such as sqlite) may not support this feature.

whether the database connection should be automatically established the component is being initialized. Defaults to true. Note, this property is only effective when the CDbConnection object is used as an application component.

the charset used for database connection. The property is only used for MySQL and PostgreSQL databases. Defaults to null, meaning using default charset as specified by the database.

the version information of the DB driver

the case of the column names

Returns the SQL command builder for the current DB connection.

the status of the connection Some DBMS (such as sqlite) may not support this feature.

The Data Source Name, or DSN, contains the information required to connect to the database.

the currently active transaction. Null if no active transaction.

name of the DB driver

whether to turn on prepare emulation. Defaults to false, meaning PDO will use the native prepare support if available. For some databases (such as MySQL), this may need to be set true so that PDO can emulate the prepare support to bypass the buggy native prepare support. Note, this property is only effective for PHP 5.1.3 or above.

whether to log the values that are bound to a prepare SQL statement. Defaults to false. During development, you may consider setting this property to true so that parameter values bound to SQL statements are logged for debugging purpose. You should be aware that logging parameter values could be expensive and have significant impact on the performance of your application.

whether to enable profiling the SQL statements being executed. Defaults to false. This should be mainly enabled and used during development to find out the bottleneck of SQL executions.

Returns the ID of the last inserted row or sequence value.

how the null and empty strings are converted

the password for establishing DB connection. Defaults to empty string.

the PDO instance, null if the connection is not established yet

whether the connection is persistent or not Some DBMS (such as sqlite) may not support this feature.

whether the connection performs data prefetching

the database schema for the current connection

the ID of the cache application component that is used to cache the table metadata. Defaults to 'cache' which refers to the primary cache application component. Set this property to false if you want to disable caching table metadata.

number of seconds that table metadata can remain valid in cache. Use 0 or negative value to indicate not caching schema. If greater than 0 and the primary cache is enabled, the table metadata will be cached.

list of tables whose metadata should NOT be cached. Defaults to empty array.

the information of DBMS server

the version information of DBMS server

Returns the statistical results of SQL executions. The results returned include the number of SQL statements executed and the total time spent. In order to use this method, enableProfiling has to be set true.

timeout settings for the connection

the username for establishing DB connection. Defaults to empty string.

Method Details

Constructor. Note, the DB connection is not established when this connection instance is created. Set active property to true to establish the connection.

Close the connection when serializing.

Starts a transaction.

Closes the currently active DB connection. It does nothing if the connection is already closed.

Creates a command for execution.

Creates the PDO instance. When some functionalities are missing in the pdo driver, we may use an adapter class to provides them.

Obtains a specific DB connection attribute information.

Returns the SQL command builder for the current DB connection.

Returns the ID of the last inserted row or sequence value.

Determines the PDO type for the specified PHP type.

Returns the statistical results of SQL executions. The results returned include the number of SQL statements executed and the total time spent. In order to use this method, enableProfiling has to be set true.

Initializes the component. This method is required by IApplicationComponent and is invoked by application when the CDbConnection is used as an application component. If you override this method, make sure to call the parent implementation so that the component can be marked as initialized.

Initializes the open db connection. This method is invoked right after the db connection is established. The default implementation is to set the charset for MySQL and PostgreSQL database connections.

Opens DB connection if it is currently not

Quotes a column name for use in a query.

Quotes a table name for use in a query.

Quotes a string value for use in a query.

Open or close the DB connection.

Sets an attribute on the database connection.