| Property | Type | Description | |
|---|---|---|---|
| $dbms | string | ..) It is not the driver name. Several drivers could connect to the same database type. This type name is often used to know whish SQL language we should use. | |
| $driverName | string | driver name | |
| $profile | array | the profile the connection is using |
| Property | Type | Description | |
|---|---|---|---|
| $_schema | jDbSchema | ||
| $_tools | jDbTools |
| Method | Description | |
|---|---|---|
| __construct ( array $profile ) | Use a profile to do the connection | |
| encloseName ( string $fieldName ) : string | enclose the field name | |
| hasTablePrefix ( ) : boolean | Check if the current connection has a table prefix set | |
| lastIdInTable ( string $fieldName, string $tableName ) : integer | return the maximum value of the given primary key in a table | |
| lastInsertId ( string $fromSequence = null ) : string | Get the ID of the last inserted row Mssql pdo driver does not support this feature. | |
| limitQuery ( string $queryString, integer $limitOffset = null, integer $limitCount = null ) : jDbPDOResultSet | boolean | Launch a SQL Query with limit parameter (so only a subset of a result) | |
| prefixTable ( $table_name ) : string | Prefix the given table with the prefix specified in the connection's profile If there's no prefix for the connection's profile, return the table's name unchanged. | |
| query ( ) | ||
| quote2 ( string $text, boolean $checknull = true, boolean $binary = false ) : string | Escape and quotes strings. if null, will only return the text "NULL" | |
| schema ( ) : jDbSchema | ||
| setAutoCommit ( boolean $state = true ) | sets the autocommit state | |
| tools ( ) : jDbTools |
| Method | Description | |
|---|---|---|
| _parseSqlitePath ( $path ) |
| public __construct ( array $profile ) | ||
| $profile | array | the profile data. Its content must be normalized by jDbParameters |
| public encloseName ( string $fieldName ) : string | ||
| $fieldName | string | the field name |
| return | string | the enclosed field name |
| public hasTablePrefix ( ) : boolean | ||
| return | boolean | |
| public lastInsertId ( string $fromSequence = null ) : string | ||
| $fromSequence | string | the sequence name, if needed |
| return | string | |
| public limitQuery ( string $queryString, integer $limitOffset = null, integer $limitCount = null ) : jDbPDOResultSet | boolean | ||
| $queryString | string | the SQL query |
| $limitOffset | integer | the offset of the first row to return |
| $limitCount | integer | the maximum of number of rows to return |
| return | jDbPDOResultSet | boolean | SQL Select. False if the query has failed. |
| public prefixTable ( $table_name ) : string | ||
| return | string | the prefixed table's name |
| public setAutoCommit ( boolean $state = true ) | ||
| $state | boolean | the status of autocommit |
| public string $dbms | ||
| return | string | |