Class mysqlDbConnection

Description

Located in /plugins/db/mysql/mysql.dbconnection.php (line 25)

jDbConnection
   |
   --mysqlDbConnection
Variable Summary
mixed $_charsets
Method Summary
mysqlDbConnection __construct ( $profile)
void commit ()
string encloseName (string $fieldName)
void errorCode ()
void errorInfo ()
string getAttribute (integer $id)
void lastInsertId ([ $fromSequence = ''])
void prepare ( $query)
void rollback ()
void setAttribute (integer $id, string $value)
void _autoCommitNotify (boolean $state)
void _connect ()
void _disconnect ()
void _doExec ( $query)
void _doLimitQuery ( $queryString,  $offset,  $number)
void _doQuery ( $query)
string _quote ( $text,  $binary)
Variables
mixed $_charsets = array( 'UTF-8'=>'utf8', 'ISO-8859-1'=>'latin1') (line 27)
  • access: protected

Inherited Variables

Inherited from jDbConnection

jDbConnection::$dbms
jDbConnection::$lastQuery
jDbConnection::$msgError
jDbConnection::$profile
jDbConnection::$_connection
jDbConnection::$_schema
jDbConnection::$_tools
Methods
Constructor __construct (line 29)
mysqlDbConnection __construct ( $profile)
  • $profile

Redefinition of:
jDbConnection::__construct()
do a connection to the database, using properties of the given profile
beginTransaction (line 51)

begin a transaction

  • access: public
void beginTransaction ()

Redefinition of:
jDbConnection::beginTransaction()
begin a transaction. Call it before query, limitQuery, exec
commit (line 59)

Commit since the last begin

  • access: public
void commit ()

Redefinition of:
jDbConnection::commit()
validate all queries and close a transaction
encloseName (line 44)

enclose the field name

  • return: the enclosed field name
  • since: 1.1.1
  • access: public
string encloseName (string $fieldName)
  • string $fieldName: the field name

Redefinition of:
jDbConnection::encloseName()
enclose the field name
errorCode (line 83)
  • access: public
void errorCode ()

Redefinition of:
jDbConnection::errorCode()
errorInfo (line 79)
  • access: public
void errorInfo ()

Redefinition of:
jDbConnection::errorInfo()
getAttribute (line 165)
  • return: the attribute value
  • see: PDO::getAttribute()
  • access: public
string getAttribute (integer $id)
  • integer $id: the attribut id

Redefinition of:
jDbConnection::getAttribute()
lastInsertId (line 139)
  • access: public
void lastInsertId ([ $fromSequence = ''])
  • $fromSequence

Redefinition of:
jDbConnection::lastInsertId()
return the id value of the last inserted row.
prepare (line 75)
  • access: public
void prepare ( $query)
  • $query

Redefinition of:
jDbConnection::prepare()
prepare a query
rollback (line 67)

Rollback since the last BEGIN

  • access: public
void rollback ()

Redefinition of:
jDbConnection::rollback()
cancel all queries of a transaction and close the transaction
setAttribute (line 184)
  • see: PDO::setAttribute()
  • access: public
void setAttribute (integer $id, string $value)
  • integer $id: the attribut id
  • string $value: the attribute value

Redefinition of:
jDbConnection::setAttribute()
_autoCommitNotify (line 148)

tell mysql to be autocommit or not

  • access: protected
void _autoCommitNotify (boolean $state)
  • boolean $state: the state of the autocommit value

Redefinition of:
jDbConnection::_autoCommitNotify()
Notify the changes on autocommit
_connect (line 87)
  • access: protected
void _connect ()

Redefinition of:
jDbConnection::_connect()
return a connection identifier or false/null if there is an error
_disconnect (line 100)
  • access: protected
void _disconnect ()

Redefinition of:
jDbConnection::_disconnect()
do a disconnection
_doExec (line 121)
  • access: protected
void _doExec ( $query)
  • $query

Redefinition of:
jDbConnection::_doExec()
do a query which return nothing
_doLimitQuery (line 132)
  • access: protected
void _doLimitQuery ( $queryString,  $offset,  $number)
  • $queryString
  • $offset
  • $number

Redefinition of:
jDbConnection::_doLimitQuery()
do a query which return a limited number of results
_doQuery (line 105)
  • access: protected
void _doQuery ( $query)
  • $query

Redefinition of:
jDbConnection::_doQuery()
do a query which return results
_quote (line 155)
  • return: escaped text or binary string
  • access: protected
string _quote ( $text,  $binary)
  • $text
  • $binary

Redefinition of:
jDbConnection::_quote()
do the escaping of a string.

Inherited Methods

Inherited From jDbConnection

jDbConnection::__construct()
jDbConnection::beginTransaction()
jDbConnection::commit()
jDbConnection::encloseFieldName()
jDbConnection::encloseName()
jDbConnection::errorCode()
jDbConnection::errorInfo()
jDbConnection::exec()
jDbConnection::getAttribute()
jDbConnection::hasTablePrefix()
jDbConnection::lastIdInTable()
jDbConnection::lastInsertId()
jDbConnection::limitQuery()
jDbConnection::prefixTable()
jDbConnection::prepare()
jDbConnection::query()
jDbConnection::quote()
jDbConnection::quote2()
jDbConnection::rollback()
jDbConnection::schema()
jDbConnection::setAttribute()
jDbConnection::setAutoCommit()
jDbConnection::tools()
jDbConnection::_autoCommitNotify()
jDbConnection::_connect()
jDbConnection::_disconnect()
jDbConnection::_doExec()
jDbConnection::_doLimitQuery()
jDbConnection::_doQuery()
jDbConnection::_quote()
jDbConnection::__destruct()
Class Constants

Documentation generated on Mon, 19 Sep 2011 14:14:02 +0200 by phpDocumentor 1.4.3