Class jDbConnection
Located in /db/jDbConnection.class.php (line 23)
The database type name (mysql, pgsql ...) 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.
driver name
last executed query
The last error message if any
profile properties used by the connector
the internal connection.
do a connection to the database, using properties of the given profile
- array $profile: profile properties
begin a transaction. Call it before query, limitQuery, exec
And then commit() or rollback()
- mysqlDbConnection::beginTransaction() : Begin a transaction
- sqlite3DbConnection::beginTransaction() : begin a transaction
- mysqliDbConnection::beginTransaction() : begin a transaction
- sqliteDbConnection::beginTransaction() : begin a transaction
- pgsqlDbConnection::beginTransaction()
- mssqlDbConnection::beginTransaction() : begin a transaction
validate all queries and close a transaction
- mysqlDbConnection::commit() : Commit since the last begin
- sqlite3DbConnection::commit() : Commit since the last begin
- mysqliDbConnection::commit() : Commit since the last begin
- sqliteDbConnection::commit() : Commit since the last begin
- pgsqlDbConnection::commit()
- mssqlDbConnection::commit() : Commit since the last begin
enclose the field name
- string $fieldName: the field name
- mysqlDbConnection::encloseName() : Enclose the field name
- mysqliDbConnection::encloseName() : enclose the field name
- pgsqlDbConnection::encloseName() : enclose the field name
Launch a SQL Query (update, delete..) which doesn't return rows
- string $query: the SQL query
- integer $id: the attribut id
Check if the current connection has a table prefix set
return the maximum value of the given primary key in a table
- string $fieldName: the name of the primary key
- string $tableName: the name of the table
return the id value of the last inserted row.
Some driver need a sequence name, so give it at first parameter
- string $fromSequence: the sequence name
Launch a SQL Query with limit parameter, so it returns only a subset of a result
- string $queryString: the SQL query
- integer $limitOffset: the offset of the first row to return
- integer $limitCount: the maximum of number of rows to return
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.
- string $table: the table's name
- $table_name
prepare a query
- string $query: a sql query with parameters
Launch a SQL Query which returns rows (typically, a SELECT statement)
- string $queryString: the SQL query
- integer $fetchmode: FETCH_OBJ, FETCH_CLASS or FETCH_INTO
- string|object $param: class name if FETCH_CLASS, an object if FETCH_INTO. else null.
- array $ctoargs: arguments for the constructor if FETCH_CLASS
- $arg1
Escape and quotes strings.
- string $text: string to quote
- int $parameter_type: unused, just for compatibility with PDO
Escape and quotes strings. if null, will only return the text "NULL"
- string $text: string to quote
- boolean $checknull: if true, check if $text is a null value, and then return NULL
- boolean $binary: set to true if $text contains a binary string
cancel all queries of a transaction and close the transaction
- mysqlDbConnection::rollback() : Rollback since the last BEGIN
- sqlite3DbConnection::rollback() : Rollback since the last BEGIN
- mysqliDbConnection::rollback() : Rollback since the last begin
- sqliteDbConnection::rollback() : Rollback since the last BEGIN
- pgsqlDbConnection::rollback()
- mssqlDbConnection::rollback() : Rollback since the last BEGIN
- integer $id: the attribut id
- string $value: the attribute value
sets the autocommit state
- boolean $state: the status of autocommit
Notify the changes on autocommit
Drivers may overload this
- boolean $state: the new state of autocommit
- mysqlDbConnection::_autoCommitNotify() : tell mysql to be autocommit or not
- sqlite3DbConnection::_autoCommitNotify() : tell sqlite to be autocommit or not
- mysqliDbConnection::_autoCommitNotify() : tell mysql to be autocommit or not
- sqliteDbConnection::_autoCommitNotify() : tell mysql to be autocommit or not
- pgsqlDbConnection::_autoCommitNotify()
- mssqlDbConnection::_autoCommitNotify() : tell mssql to be implicit commit or not
return a connection identifier or false/null if there is an error
- mysqlDbConnection::_connect()
- sqlite3DbConnection::_connect()
- mysqliDbConnection::_connect()
- sqliteDbConnection::_connect()
- pgsqlDbConnection::_connect()
- mssqlDbConnection::_connect() : initialize the connection to the database
do a disconnection
(no need to do a test on the connection id)
do a query which return nothing
- $queryString
do a query which return a limited number of results
- $queryString
- $offset
- $number
do a query which return results
- $queryString
do the escaping of a string.
you should override it into the driver
- string $text: the text to escape
- boolean $binary: true if the content of the string is a binary content
ATTR_AUTOCOMMIT
= 0
(line 28)
ATTR_CASE
= 8
(line 36)
ATTR_CLIENT_VERSION
= 5
(line 34)
ATTR_CONNECTION_STATUS
= 7
(line 35)
ATTR_CURSOR
= 10
(line 37)
ATTR_DRIVER_NAME
= 16
(line 40)
ATTR_ERRMODE
= 3
(line 31)
ATTR_ORACLE_NULLS
= 11
(line 38)
ATTR_PERSISTENT
= 12
(line 39)
ATTR_PREFETCH
= 1
(line 29)
ATTR_SERVER_INFO
= 6
(line 33)
ATTR_SERVER_VERSION
= 4
(line 32)
ATTR_TIMEOUT
= 2
(line 30)
CURSOR_FWDONLY
= 0
(line 41)
CURSOR_SCROLL
= 1
(line 42)
FETCH_CLASS
= 8
(line 26)
FETCH_INTO
= 9
(line 27)
FETCH_OBJ
= 5
(line 25)
Documentation generated on Mon, 26 Oct 2015 21:53:12 +0100 by phpDocumentor 1.4.3