Overview

Packages

  • Actions
  • Codegen
  • Controls
    • Base
  • DatabaseAdapters
  • Events
  • None
  • Sessions
  • Tests

Classes

  • QDatabaseBase
  • QDatabaseFieldType
  • QDatabaseForeignKey
  • QDatabaseIndex
  • QDatabaseRowBase
  • QInformixPdoDatabase
  • QMySqlDatabase
  • QMySqlDatabaseField
  • QMySqli5ClusterDatabase
  • QMySqli5Database
  • QMySqli5DatabaseField
  • QMySqli5DatabaseResult
  • QMySqliDatabase
  • QMySqliDatabaseField
  • QMySqliDatabaseResult
  • QMySqliDatabaseRow
  • QOracleDatabase
  • QOracleDatabaseRow
  • QPdoDatabase
  • QPostgreSqlDatabase
  • QPostgreSqlDatabaseField
  • QPostgreSqlDatabaseResult
  • QPostgreSqlDatabaseRow
  • QPostgreSqlPdoDatabase
  • QSqLite3PdoDatabase
  • QSqlServer2005Database
  • QSqlServer2005DatabaseField
  • QSqlServer2005DatabaseResult
  • QSqlServer2005DatabaseRow
  • QSqlServerDatabase
  • QSqlServerDatabaseField
  • QSqlServerDatabaseResult
  • QSqlServerDatabaseRow

Exceptions

  • QDatabaseExceptionBase
  • QMySqliDatabaseException
  • QOracleDatabaseException
  • QPostgreSqlDatabaseException
  • QSqlServer2005DatabaseException
  • QSqlServerDatabaseException
  • Overview
  • Package
  • Class

Class QPdoDatabase

PDO Generic database driver

QBaseClass
Extended by QDatabaseBase
Extended by QPdoDatabase

Direct known subclasses

QInformixPdoDatabase, QPostgreSqlPdoDatabase, QSqLite3PdoDatabase
Abstract
Package: DatabaseAdapters
Author: Marcos Sanchez [marcosdsanchez at thinkclear dot com dot ar]
Located at includes/database/QPdoDatabase.class.php
Methods summary
protected mixed
# ExecuteNonQuery( string $strNonQuery )

Sends a non-SELECT query (such as INSERT, UPDATE, DELETE, TRUNCATE) to DB server. In most cases, the results of this function are not used and you should not send 'SELECT' queries using this method because a result is not guaranteed to be returned

Sends a non-SELECT query (such as INSERT, UPDATE, DELETE, TRUNCATE) to DB server. In most cases, the results of this function are not used and you should not send 'SELECT' queries using this method because a result is not guaranteed to be returned

If there was an error, it would most probably be caught as an exception.

Parameters

$strNonQuery
The Query to be executed

Returns

mixed
Result that the database returns after running the query
public mixed
# __get( string $strName )

PHP magic method

PHP magic method

Parameters

$strName
Property name

Returns

mixed

Throws

Exception|QCallerException

Overrides

QDatabaseBase::__get()
public mixed
# Close( )

Closes the database connection

Closes the database connection

Returns

mixed
protected
# ExecuteTransactionBegin( )

This function actually begins the database transaction. Must be implemented in all subclasses. The "TransactionBegin" wrapper are meant to be called by end-user code

This function actually begins the database transaction. Must be implemented in all subclasses. The "TransactionBegin" wrapper are meant to be called by end-user code

Returns


Nothing
protected
# ExecuteTransactionCommit( )

This function actually commits the database transaction. Must be implemented in all subclasses. The "TransactionCommit" wrapper are meant to be called by end-user code

This function actually commits the database transaction. Must be implemented in all subclasses. The "TransactionCommit" wrapper are meant to be called by end-user code

Returns


Nothing
protected
# ExecuteTransactionRollBack( )

This function actually rolls back the database transaction. Must be implemented in all subclasses. The "TransactionRollBack" wrapper are meant to be called by end-user code

This function actually rolls back the database transaction. Must be implemented in all subclasses. The "TransactionRollBack" wrapper are meant to be called by end-user code

Returns


Nothing
Methods inherited from QDatabaseBase
Connect(), EnableProfiling(), EscapeIdentifier(), EscapeIdentifiers(), EscapeIdentifiersAndValues(), EscapeValues(), ExecuteProcedure(), ExecuteQuery(), ExplainStatement(), ExtractCommentOptions(), GetFieldsForTable(), GetForeignKeysForTable(), GetIndexesForTable(), GetTables(), InsertId(), InsertOrUpdate(), NonQuery(), OutputProfiling(), PrepareStatement(), Query(), SqlLimitVariablePrefix(), SqlLimitVariableSuffix(), SqlSortByVariable(), SqlVariable(), TransactionBegin(), TransactionCommit(), TransactionRollBack(), __construct(), __set(), transactionCacheFlush(), transactionCacheRestore()
Methods inherited from QBaseClass
OverrideAttributes(), __call()
Constants inherited from QDatabaseBase
Adapter
Properties summary
protected PDO $objPdo

connection handler

connection handler

#
protected PDOStatement $objMostRecentResult

most recent query result

most recent query result

#
Properties inherited from QDatabaseBase
$blnConnectedFlag, $blnEnableProfiling, $blnOnlyFullGroupBy, $intDatabaseIndex, $intTransactionDepth, $objCacheProviderStack, $objConfigArray, $strEscapeIdentifierBegin, $strEscapeIdentifierEnd, $strProfileArray
Magic properties inherited from QDatabaseBase
$Adapter, $AffectedRows, $Caching, $Database, $DatabaseIndex, $DateFormat, $EnableProfiling, $EscapeIdentifierBegin, $EscapeIdentifierEnd, $Host, $OnlyFullGroupBy, $Password, $Port, $Profile, $Protocol, $Server, $Service, $Username
API documentation generated by ApiGen