프로퍼티 | 타입 | 설명 | |
---|---|---|---|
$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 |
프로퍼티 | 타입 | 설명 | |
---|---|---|---|
$_schema | jDbSchema | ||
$_tools | jDbTools |
메소드 | 설명 | |
---|---|---|
__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 |
메소드 | 설명 | |
---|---|---|
_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 |
리턴 | string | the enclosed field name |
public hasTablePrefix ( ) : boolean | ||
리턴 | boolean |
public lastInsertId ( string $fromSequence = null ) : string | ||
$fromSequence | string | the sequence name, if needed |
리턴 | 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 |
리턴 | jDbPDOResultSet | boolean | SQL Select. False if the query has failed. |
public prefixTable ( $table_name ) : string | ||
리턴 | string | the prefixed table's name |
public setAutoCommit ( boolean $state = true ) | ||
$state | boolean | the status of autocommit |
public string $dbms | ||
리턴 | string |