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 QMySqli5Database

QBaseClass
Extended by QDatabaseBase
Extended by QMySqliDatabase
Extended by QMySqli5Database

Direct known subclasses

QMySqli5ClusterDatabase
Package: DatabaseAdapters
Located at includes/database/QMySqli5Database.class.php
Methods summary
public mixed|string[]
# GetTables( )

Returns the list of tables in the database (as string)

Returns the list of tables in the database (as string)

Returns

mixed|string[]
List of tables

Overrides

QMySqliDatabase::GetTables()
protected mixed
# ExecuteQuery( string $strQuery )

Sends a SQL query for execution to the database In this regard, a query is a 'SELECT' statement

Sends a SQL query for execution to the database In this regard, a query is a 'SELECT' statement

Parameters

$strQuery
The Query to be executed

Returns

mixed
Result that the database returns after running the query.

Overrides

QMySqliDatabase::ExecuteQuery()
public QMySqli5DatabaseResult[]
# MultiQuery( string $strQuery )

Performs a Multi Result-Set Query, which is available with Stored Procs in MySQL 5 Written by Mike Hostetler

Performs a Multi Result-Set Query, which is available with Stored Procs in MySQL 5 Written by Mike Hostetler

Parameters

$strQuery

Returns

QMySqli5DatabaseResult[]
array of results
public QMySqli5DatabaseResult[]
# ExecuteProcedure( string $strProcName, array|null $params = null )

Generic stored procedure executor. For Mysql 5, you can have your stored procedure return results by "SELECT"ing the results. The results will be returned as an array.

Generic stored procedure executor. For Mysql 5, you can have your stored procedure return results by "SELECT"ing the results. The results will be returned as an array.

Parameters

$strProcName
Name of stored procedure
$params

Returns

QMySqli5DatabaseResult[]

Throws

QMySqliDatabaseException

Overrides

QDatabaseBase::ExecuteProcedure()
Methods inherited from QMySqliDatabase
Close(), Connect(), ExecuteNonQuery(), ExecuteTransactionBegin(), ExecuteTransactionCommit(), ExecuteTransactionRollBack(), ExplainStatement(), GetFieldsForTable(), GetForeignKeysForTable(), GetFoundRows(), GetIndexesForTable(), InsertId(), InsertOrUpdate(), SqlLimitVariablePrefix(), SqlLimitVariableSuffix(), SqlSortByVariable(), __get()
Methods inherited from QDatabaseBase
EnableProfiling(), EscapeIdentifier(), EscapeIdentifiers(), EscapeIdentifiersAndValues(), EscapeValues(), ExtractCommentOptions(), NonQuery(), OutputProfiling(), PrepareStatement(), Query(), SqlVariable(), TransactionBegin(), TransactionCommit(), TransactionRollBack(), __construct(), __set(), transactionCacheFlush(), transactionCacheRestore()
Methods inherited from QBaseClass
OverrideAttributes(), __call()
Constants inherited from QDatabaseBase
Adapter
Properties inherited from QMySqliDatabase
$objMySqli, $strEscapeIdentifierBegin, $strEscapeIdentifierEnd
Properties inherited from QDatabaseBase
$blnConnectedFlag, $blnEnableProfiling, $blnOnlyFullGroupBy, $intDatabaseIndex, $intTransactionDepth, $objCacheProviderStack, $objConfigArray, $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