Class mssqlDbConnection

Description

Located in /plugins/db/mssql/mssql.dbconnection.php (line 14)

jDbConnection
   |
   --mssqlDbConnection
Method Summary
unknown_type __construct (array $profile)
void commit ()
void errorCode ()
void errorInfo ()
void lastInsertId ([ $fromSequence = ''])
void prepare ( $query)
void rollback ()
void _autoCommitNotify (boolean $state)
void _connect ()
void _disconnect ()
void _doExec ( $query)
void _doLimitQuery ( $queryString,  $offset,  $number)
void _doQuery ( $query)
void _quote ( $text,  $binary)
Variables
Methods
Constructor __construct (line 21)

Default constructor

unknown_type __construct (array $profile)
  • array $profile: profile de connexion

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

begin a transaction

  • access: public
void beginTransaction ()

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

Commit since the last begin

  • access: public
void commit ()

Redefinition of:
jDbConnection::commit()
validate all queries and close a transaction
errorCode (line 63)
  • access: public
void errorCode ()

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

Redefinition of:
jDbConnection::errorInfo()
lastInsertId (line 144)

(non-PHPdoc)

return the last inserted ID incremented in database

  • see: lastInsertId()
  • access: public
void lastInsertId ([ $fromSequence = ''])
  • $fromSequence

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

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

Rollback since the last BEGIN

  • access: public
void rollback ()

Redefinition of:
jDbConnection::rollback()
cancel all queries of a transaction and close the transaction
_autoCommitNotify (line 155)

tell mssql to be implicit commit 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 72)

(non-PHPdoc)

initialize the connection to the database

  • see: _connect()
  • access: protected
void _connect ()

Redefinition of:
jDbConnection::_connect()
return a connection identifier or false/null if there is an error
_disconnect (line 90)

(non-PHPdoc)

close the connection to the database

  • see: _disconnect()
  • access: protected
void _disconnect ()

Redefinition of:
jDbConnection::_disconnect()
do a disconnection
_doExec (line 119)

(non-PHPdoc)

  • see: _doExec()
  • access: protected
void _doExec ( $query)
  • $query

Redefinition of:
jDbConnection::_doExec()
do a query which return nothing
_doLimitQuery (line 134)

WARNING: it doesn't take care about offset and number.

  • see: _doLimitQuery()
  • 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 99)

(non-PHPdoc)

execute an SQL instruction

  • see: _doQuery()
  • access: protected
void _doQuery ( $query)
  • $query

Redefinition of:
jDbConnection::_doQuery()
do a query which return results
_quote (line 167)

escape special characters

  • todo: support of binary strings
  • access: protected
void _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 Thu, 19 Sep 2013 00:08:38 +0200 by phpDocumentor 1.4.3