Class QMySqliDatabase

QBaseClass

Extended by

QDatabaseBase

Extended by

QMySqliDatabase

Direct known subclasses

QMySqlDatabase, QMySqli5Database

Indirect known subclasses

QMySqli5ClusterDatabase

Package: DatabaseAdapters
Located at includes/database/QMySqliDatabase.class.php

Methods summary
`public`	# `SqlLimitVariablePrefix( $strLimitInfo )`
`public`	# `SqlLimitVariableSuffix( $strLimitInfo )`
`public`	# `SqlSortByVariable( $strSortByInfo )`
`public`	# `InsertOrUpdate( string $strTable, array $mixColumnsAndValuesArray, null\|string\|array $strPKNames = null )` INSERTs or UPDATEs a table INSERTs or UPDATEs a table Parameters `$strTable` Table name `$mixColumnsAndValuesArray` column=>value array (they are given to 'EscapeIdentifiersAndValues' method) `$strPKNames` Name(s) of primary key column(s) (expressed as string or array) Overrides `QDatabaseBase::InsertOrUpdate()`
`public`	# `Connect( )` Connects to the database Connects to the database
`public mixed`	# `__get( string $strName )` PHP magic method PHP magic method Parameters `$strName` Property name Returns mixed Throws Exception\|`QCallerException` Overrides `QDatabaseBase::__get()`
`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.
`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\|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
`public mixed`	# `GetFieldsForTable( string $strTableName )` Get the list of columns/fields for a given table Get the list of columns/fields for a given table Parameters `$strTableName` Name of table whose fields we have to get Returns mixed
`public mixed`	# `InsertId( null\|string $strTableName = null, null\|string $strColumnName = null )` Returns the ID to be inserted in a table column (normally it an autoincrement column) Returns the ID to be inserted in a table column (normally it an autoincrement column) Parameters `$strTableName` Table name where the ID has to be inserted `$strColumnName` Column name where the ID has to be inserted Returns mixed
`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
`public`	# `GetFoundRows( )`
`public mixed`	# `GetIndexesForTable( string $strTableName )` Get list of indexes for a table Get list of indexes for a table Parameters `$strTableName` Name of table whose column indexes we have to get Returns mixed
`public mixed`	# `GetForeignKeysForTable( string $strTableName )` Get list of foreign keys for a table Get list of foreign keys for a table Parameters `$strTableName` Name of table whose foreign keys we are trying to get Returns mixed
`public QMySqliDatabaseResult`	# `ExplainStatement( string $sql )` Parameters `$sql` Returns `QMySqliDatabaseResult` Overrides `QDatabaseBase::ExplainStatement()`

Methods inherited from QDatabaseBase
`EnableProfiling(), EscapeIdentifier(), EscapeIdentifiers(), EscapeIdentifiersAndValues(), EscapeValues(), ExecuteProcedure(), 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 summary
`protected`	`$objMySqli`	#
`protected string`	`$strEscapeIdentifierBegin` The beginning part of characters which can escape identifiers in a SQL query for the database The beginning part of characters which can escape identifiers in a SQL query for the database	# '`'
`protected string`	`$strEscapeIdentifierEnd` The ending part of characters which can escape identifiers in a SQL query for the database The ending part of characters which can escape identifiers in a SQL query for the database	# '`'

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`