PHP Class PMA\libraries\DatabaseInterface

Show file Open project: phpmyadmin/phpmyadmin Class Usage Examples

Public Methods

Method	Description
__construct ( PMA\libraries\dbi\DBIExtension $ext )	Constructor
affectedRows ( object $link = null, boolean $get_from_cache = true ) : integer \| boolean	returns the number of rows affected by last query
cacheTableContent ( array $contentPath, mixed $value ) : void	Set an item in table cache using dot notation.
checkDbExtension ( string $extension = 'mysql' ) : boolean	Checks whether database extension is loaded
clearTableCache ( ) : void	Clear the table cache.
connect ( integer $mode, array $server = null ) : mixed	connects to the database server
dataSeek ( object $result, integer $offset ) : boolean	Adjusts the result pointer to an arbitrary row in the result
escapeString ( string $str, mixed $link = null ) : string	returns properly escaped string for use in MySQL queries
fetchArray ( object $result ) : array	returns array of rows with associative and numeric keys from $result
fetchAssoc ( object $result ) : array	returns array of rows with associative keys from $result
fetchResult ( string $query, string \| integer \| array $key = null, string \| integer $value = null, object $link = null, integer $options ) : array	returns all rows in the resultset in one array
fetchRow ( object $result ) : array	returns array of rows with numeric keys from $result
fetchSingleRow ( string $query, string $type = 'ASSOC', object $link = null ) : array \| boolean	returns only the first row from the result
fetchValue ( string $query, integer $row_number, integer \| string $field, object $link = null ) : mixed	returns a single value from the given result or query, if the query or the result has more than one row or field the first field of the first row is returned
fieldFlags ( object $result, integer $i ) : string	returns concatenated string of human readable field flags
fieldLen ( object $result, integer $i ) : integer	returns the length of the given field $i in $result
fieldName ( object $result, integer $i ) : string	returns name of $i. field in $result
formatError ( integer $error_number, string $error_message ) : string	Formats database error message in a friendly way.
freeResult ( object $result ) : void	Frees memory associated with the result
getCachedTableContent ( array $contentPath, mixed $default = null ) : mixed	Get a cached value from table cache.
getClientInfo ( ) : string	returns a string that represents the client library version
getColumnMapFromSql ( string $sql_query, array $view_columns = [] ) : array	returns detailed array with all columns for sql
getColumnNames ( string $database, string $table, mixed $link = null ) : null \| array	Returns all column names in given table
getColumns ( string $database, string $table, string $column = null, boolean $full = false, mixed $link = null ) : array	Returns descriptions of columns in given table (all or given by $column)
getColumnsFull ( string $database = null, string $table = null, string $column = null, mixed $link = null ) : array	returns detailed array with all columns for given table in database, or all tables/databases
getColumnsSql ( string $database, string $table, string $column = null, boolean $full = false ) : string	Returns SQL query for fetching columns for a table
getCompatibilities ( ) : array	Get supported SQL compatibility modes
getConnectionParams ( integer $mode, array $server = null ) : array	Return connection parameters for the database server
getCurrentUser ( ) : string	gets the current user with host
getCurrentUserAndHost ( ) : array	Get the current user and host
getDatabasesFull ( string $database = null, boolean $force_stats = false, object $link = null, string $sort_by = 'SCHEMA_NAME', string $sort_order = 'ASC', integer $limit_offset, boolean \| integer $limit_count = false ) : array	returns array with databases containing extended infos about them
getDbCollation ( string $db ) : string	returns collation of given db
getDefinition ( string $db, string $which, string $name, object $link = null ) : string	returns the definition of a specific PROCEDURE, FUNCTION, EVENT or VIEW
getError ( object $link = null ) : string \| boolean	returns last error message or false if no errors occurred
getEvents ( string $db, string $name = '' ) : array	returns details about the EVENTs for a specific database
getFieldsMeta ( object $result ) : array	returns metainfo for fields in $result
getHostInfo ( object $link = null ) : string	Returns a string representing the type of connection used
getKillQuery ( integer $process ) : string	Gets SQL for killing a process.
getLink ( $link = null )	* Gets correct link object.
getProceduresOrFunctions ( string $db, string $which, object $link = null ) : array	returns an array of PROCEDURE or FUNCTION names for a db
getProtoInfo ( object $link = null ) : integer	Returns the version of the MySQL protocol used
getRoutines ( string $db, string $which = null, string $name = '' ) : array	returns details about the PROCEDUREs or FUNCTIONs for a specific database or details about a specific routine
getServerCollation ( ) : string	returns default server collation from show variables
getSystemDatabase ( ) : SystemDatabase	Get the phpmyadmin database manager
getSystemSchemas ( ) : array	Get the list of system schemas
getTable ( string $db_name, string $table_name ) : Table	Get a table with database name and table name
getTableIndexes ( string $database, string $table, mixed $link = null ) : array	Returns indexes of a table
getTableIndexesSql ( string $database, string $table, string $where = null ) : string	Returns SQL for fetching information on table indexes (SHOW INDEXES)
getTables ( string $database, mixed $link = null ) : array	returns array with table names for given db
getTablesFull ( string $database, string \| array $table = '', boolean $tbl_is_group = false, mixed $link = null, integer $limit_offset, boolean \| integer $limit_count = false, string $sort_by = 'Name', string $sort_order = 'ASC', string $table_type = null ) : array	returns array of all tables in given db or dbs this function expects unquoted names: RIGHT: my_database WRONG: my_database WRONG: my\_database if $tbl_is_group is true, $table is used as filter for table names
getTriggers ( string $db, string $table = '', string $delimiter = '//' ) : array	returns details about the TRIGGERs for a specific table or database
getVariable ( string $var, integer $type = self::GETVAR_SESSION, mixed $link = null ) : mixed	returns value of given mysql server variable
getVirtualTables ( string $db ) : array	Get VIEWs in a particular database
getWarnings ( object $link = null ) : array	returns warnings for last query
insertId ( object $link = null ) : integer \| boolean	returns last inserted auto_increment id for given $link or $GLOBALS['userlink']
isAmazonRds ( ) : boolean	Checks if this database server is running on Amazon RDS.
isSuperuser ( ) : boolean	Checks if current user is superuser
isSystemSchema ( string $schema_name, boolean $testForMysqlSchema = false ) : boolean	Checks whether given schema is a system schema
isUserType ( string $type ) : boolean	Checks if current user has global create user/grant privilege or is a superuser (i.e. SELECT on mysql.users) while caching the result in session.
moreResults ( object $link = null ) : boolean	Check if there are any more query results from a multi query
nextResult ( object $link = null ) : boolean	Prepare next result from multi_query
numFields ( object $result ) : integer	return number of fields in given $result
numRows ( object $result ) : string \| integer	returns the number of rows returned by last query
postConnect ( mixed $link ) : void	Function called just after a connection to the MySQL database server has been established. It sets the connection collation, and determines the version of MySQL which is running.
query ( string $query, mixed $link = null, integer $options, boolean $cache_affected_rows = true ) : mixed	runs a query
selectDb ( string $dbname, object $link = null ) : boolean	selects given database
setVariable ( string $var, string $value, mixed $link = null ) : boolean	Sets new value for a variable if it is different from the current value
storeResult ( object $link = null ) : mixed	Store the result returned from multi query
tryMultiQuery ( string $multi_query = '', mysqli $link = null ) : mysqli_result	Run multi query statement and return results
tryQuery ( string $query, object $link = null, integer $options, boolean $cache_affected_rows = true ) : mixed	runs a query and returns the result

Private Methods

Method	Description
_cacheTableData ( array $tables, string $table ) : void	Caches table data so Table does not require to issue SHOW TABLE STATUS again
_dbgQuery ( string $query, object $link, object \| boolean $result, integer $time ) : void	Stores query data into session data for debugging purposes
_fetchValue ( array $row, string \| null $value ) : mixed	Returns row or element of a row
_getSqlForTablesFull ( string[] $this_databases, string $sql_where_table ) : string	returns the beginning of the SQL statement to fetch the list of tables
_getTableCondition ( array \| string $table, boolean $tbl_is_group, string $table_type ) : string	returns a segment of the SQL WHERE clause regarding table name and type
_usortComparisonCallback ( string $a, string $b ) : integer	usort comparison callback

Method Details

__construct() public method

Constructor

public __construct ( PMA\libraries\dbi\DBIExtension $ext )
$ext	PMA\libraries\dbi\DBIExtension	Object to be used for database queries

affectedRows() public method

returns the number of rows affected by last query

public affectedRows ( object $link = null, boolean $get_from_cache = true ) : integer \| boolean
$link	object	the connection object
$get_from_cache	boolean	whether to retrieve from cache
return	integer \| boolean

cacheTableContent() public method

Set an item in table cache using dot notation.

public cacheTableContent ( array $contentPath, mixed $value ) : void
$contentPath	array	Array with the target path
$value	mixed	Target value
return	void

checkDbExtension() public static method

Checks whether database extension is loaded

public static checkDbExtension ( string $extension = 'mysql' ) : boolean
$extension	string	mysql extension to check
return	boolean

clearTableCache() public method

Clear the table cache.

public clearTableCache ( ) : void
return	void

connect() public method

connects to the database server

public connect ( integer $mode, array $server = null ) : mixed
$mode	integer	Connection mode on of CONNECT_USER, CONNECT_CONTROL or CONNECT_AUXILIARY.
$server	array	Server information like host/port/socket/persistent
return	mixed	false on error or a connection object on success

dataSeek() public method

Adjusts the result pointer to an arbitrary row in the result

public dataSeek ( object $result, integer $offset ) : boolean
$result	object	database result
$offset	integer	offset to seek
return	boolean	true on success, false on failure

escapeString() public method

returns properly escaped string for use in MySQL queries

public escapeString ( string $str, mixed $link = null ) : string
$str	string	string to be escaped
$link	mixed	optional database link to use
return	string	a MySQL escaped string

fetchArray() public method

returns array of rows with associative and numeric keys from $result

public fetchArray ( object $result ) : array
$result	object	result set identifier
return	array

fetchAssoc() public method

returns array of rows with associative keys from $result

public fetchAssoc ( object $result ) : array
$result	object	result set identifier
return	array

fetchResult() public method


$sql = 'SELECT * FROM user';
$users = $GLOBALS['dbi']->fetchResult($sql);
produces
$users[] = array('id' => 123, 'name' => 'John Doe')

$sql = 'SELECT id, name FROM user';
$users = $GLOBALS['dbi']->fetchResult($sql, 'id');
produces
$users['123'] = array('id' => 123, 'name' => 'John Doe')

$sql = 'SELECT id, name FROM user';
$users = $GLOBALS['dbi']->fetchResult($sql, 0);
produces
$users['123'] = array(0 => 123, 1 => 'John Doe')

$sql = 'SELECT id, name FROM user';
$users = $GLOBALS['dbi']->fetchResult($sql, 'id', 'name');
or
$users = $GLOBALS['dbi']->fetchResult($sql, 0, 1);
produces
$users['123'] = 'John Doe'

$sql = 'SELECT name FROM user';
$users = $GLOBALS['dbi']->fetchResult($sql);
produces
$users[] = 'John Doe'

$sql = 'SELECT group, name FROM user'
$users = $GLOBALS['dbi']->fetchResult($sql, array('group', null), 'name');
produces
$users['admin'][] = 'John Doe'

$sql = 'SELECT group, name FROM user'
$users = $GLOBALS['dbi']->fetchResult($sql, array('group', 'name'), 'id');
produces
$users['admin']['John Doe'] = '123'

public fetchResult ( string $query, string \| integer \| array $key = null, string \| integer $value = null, object $link = null, integer $options ) : array
$query	string	query to execute
$key	string \| integer \| array	field-name or offset used as key for array or array of those
$value	string \| integer	value-name or offset used as value for array
$link	object	mysql link
$options	integer	query options
return	array	resultrows or values indexed by $key

fetchRow() public method

returns array of rows with numeric keys from $result

public fetchRow ( object $result ) : array
$result	object	result set identifier
return	array

fetchSingleRow() public method


$sql = 'SELECT * FROM user WHERE id = 123';
$user = $GLOBALS['dbi']->fetchSingleRow($sql);
produces
$user = array('id' => 123, 'name' => 'John Doe')

public fetchSingleRow ( string $query, string $type = 'ASSOC', object $link = null ) : array \| boolean
$query	string	The query to execute
$type	string	NUM\|ASSOC\|BOTH returned array should either numeric associative or both
$link	object	mysql link
return	array \| boolean	first row from result or false if result is empty

fetchValue() public method


$sql = 'SELECT name FROM user WHERE id = 123';
$user_name = $GLOBALS['dbi']->fetchValue($sql);
produces
$user_name = 'John Doe'

public fetchValue ( string $query, integer $row_number, integer \| string $field, object $link = null ) : mixed
$query	string	The query to execute
$row_number	integer	row to fetch the value from, starting at 0, with 0 being default
$field	integer \| string	field to fetch the value from, starting at 0, with 0 being default
$link	object	mysql link
return	mixed	value of first field in first row from result or false if not found

fieldFlags() public method

returns concatenated string of human readable field flags

public fieldFlags ( object $result, integer $i ) : string
$result	object	result set identifier
$i	integer	field
return	string	field flags

fieldLen() public method

returns the length of the given field $i in $result

public fieldLen ( object $result, integer $i ) : integer
$result	object	result set identifier
$i	integer	field
return	integer	length of field

fieldName() public method

returns name of $i. field in $result

public fieldName ( object $result, integer $i ) : string
$result	object	result set identifier
$i	integer	field
return	string	name of $i. field in $result

formatError() public method

This is needed because some errors messages cannot be obtained by mysql_error().

public formatError ( integer $error_number, string $error_message ) : string
$error_number	integer	Error code
$error_message	string	Error message as returned by server
return	string	HML text with error details

freeResult() public method

Frees memory associated with the result

public freeResult ( object $result ) : void
$result	object	database result
return	void

getCachedTableContent() public method

Get a cached value from table cache.

public getCachedTableContent ( array $contentPath, mixed $default = null ) : mixed
$contentPath	array	Array of the name of the target value
$default	mixed	Return value on cache miss
return	mixed	cached value or default

getClientInfo() public method

returns a string that represents the client library version

public getClientInfo ( ) : string
return	string	MySQL client library version

getColumnMapFromSql() public method

returns detailed array with all columns for sql

public getColumnMapFromSql ( string $sql_query, array $view_columns = [] ) : array
$sql_query	string	target SQL query to get columns
$view_columns	array	alias for columns
return	array

getColumnNames() public method

Returns all column names in given table

public getColumnNames ( string $database, string $table, mixed $link = null ) : null \| array
$database	string	name of database
$table	string	name of table to retrieve columns from
$link	mixed	mysql link resource
return	null \| array

getColumns() public method

Returns descriptions of columns in given table (all or given by $column)

public getColumns ( string $database, string $table, string $column = null, boolean $full = false, mixed $link = null ) : array
$database	string	name of database
$table	string	name of table to retrieve columns from
$column	string	name of column, null to show all columns
$full	boolean	whether to return full info or only column names
$link	mixed	mysql link resource
return	array	array indexed by column names or, if $column is given, flat array description

getColumnsFull() public method

returns detailed array with all columns for given table in database, or all tables/databases

public getColumnsFull ( string $database = null, string $table = null, string $column = null, mixed $link = null ) : array
$database	string	name of database
$table	string	name of table to retrieve columns from
$column	string	name of specific column
$link	mixed	mysql link resource
return	array

getColumnsSql() public method

The 'Key' column is not calculated properly, use $GLOBALS['dbi']->getColumns() to get correct values.

getCompatibilities() public method

Get supported SQL compatibility modes

public getCompatibilities ( ) : array
return	array	supported SQL compatibility modes

getConnectionParams() public method

Return connection parameters for the database server

public getConnectionParams ( integer $mode, array $server = null ) : array
$mode	integer	Connection mode on of CONNECT_USER, CONNECT_CONTROL or CONNECT_AUXILIARY.
$server	array	Server information like host/port/socket/persistent
return	array	user, host and server settings array

getCurrentUser() public method

gets the current user with host

public getCurrentUser ( ) : string
return	string	the current user i.e. user@host

getCurrentUserAndHost() public method

Get the current user and host

public getCurrentUserAndHost ( ) : array
return	array	array of username and hostname

getDatabasesFull() public method

returns array with databases containing extended infos about them

public getDatabasesFull ( string $database = null, boolean $force_stats = false, object $link = null, string $sort_by = 'SCHEMA_NAME', string $sort_order = 'ASC', integer $limit_offset, boolean \| integer $limit_count = false ) : array
$database	string	database
$force_stats	boolean	retrieve stats also for MySQL < 5
$link	object	mysql link
$sort_by	string	column to order by
$sort_order	string	ASC or DESC
$limit_offset	integer	starting offset for LIMIT
$limit_count	boolean \| integer	row count for LIMIT or true for $GLOBALS['cfg']['MaxDbList']
return	array	$databases

getDbCollation() public method

returns collation of given db

public getDbCollation ( string $db ) : string
$db	string	name of db
return	string	collation of $db

getDefinition() public method

returns the definition of a specific PROCEDURE, FUNCTION, EVENT or VIEW

public getDefinition ( string $db, string $which, string $name, object $link = null ) : string
$db	string	db name
$which	string	PROCEDURE \| FUNCTION \| EVENT \| VIEW
$name	string	the procedure\|function\|event\|view name
$link	object	MySQL link
return	string	the definition

getError() public method

returns last error message or false if no errors occurred

public getError ( object $link = null ) : string \| boolean
$link	object	connection link
return	string \| boolean	$error or false

getEvents() public method

returns details about the EVENTs for a specific database

public getEvents ( string $db, string $name = '' ) : array
$db	string	db name
$name	string	event name
return	array	information about EVENTs

getFieldsMeta() public method

returns metainfo for fields in $result

public getFieldsMeta ( object $result ) : array
$result	object	result set identifier
return	array	meta info for fields in $result

getHostInfo() public method

Returns a string representing the type of connection used

public getHostInfo ( object $link = null ) : string
$link	object	mysql link
return	string	type of connection used

getKillQuery() public method

Gets SQL for killing a process.

public getKillQuery ( integer $process ) : string
$process	integer	Process ID
return	string

getLink() public method

* Gets correct link object.

public getLink ( $link = null )
$link		optional database link to use

getProceduresOrFunctions() public method

returns an array of PROCEDURE or FUNCTION names for a db

public getProceduresOrFunctions ( string $db, string $which, object $link = null ) : array
$db	string	db name
$which	string	PROCEDURE \| FUNCTION
$link	object	mysql link
return	array	the procedure names or function names

getProtoInfo() public method

Returns the version of the MySQL protocol used

public getProtoInfo ( object $link = null ) : integer
$link	object	mysql link
return	integer	version of the MySQL protocol used

getRoutines() public method

returns details about the PROCEDUREs or FUNCTIONs for a specific database or details about a specific routine

public getRoutines ( string $db, string $which = null, string $name = '' ) : array
$db	string	db name
$which	string	PROCEDURE \| FUNCTION or null for both
$name	string	name of the routine (to fetch a specific routine)
return	array	information about ROCEDUREs or FUNCTIONs

getServerCollation() public method

returns default server collation from show variables

public getServerCollation ( ) : string
return	string	$server_collation

getSystemDatabase() public method

Get the phpmyadmin database manager

public getSystemDatabase ( ) : SystemDatabase
return	SystemDatabase

getSystemSchemas() public method

Get the list of system schemas

public getSystemSchemas ( ) : array
return	array	list of system schemas

getTable() public method

Get a table with database name and table name

public getTable ( string $db_name, string $table_name ) : Table
$db_name	string	DB name
$table_name	string	Table name
return	Table

getTableIndexes() public method

Returns indexes of a table

public getTableIndexes ( string $database, string $table, mixed $link = null ) : array
$database	string	name of database
$table	string	name of the table whose indexes are to be retrieved
$link	mixed	mysql link resource
return	array	$indexes

getTableIndexesSql() public method

Returns SQL for fetching information on table indexes (SHOW INDEXES)

public getTableIndexesSql ( string $database, string $table, string $where = null ) : string
$database	string	name of database
$table	string	name of the table whose indexes are to be retrieved
$where	string	additional conditions for WHERE
return	string	SQL for getting indexes

getTables() public method

returns array with table names for given db

public getTables ( string $database, mixed $link = null ) : array
$database	string	name of database
$link	mixed	mysql link resource\|object
return	array	tables names

getTablesFull() public method


$GLOBALS['dbi']->getTablesFull('my_database');
$GLOBALS['dbi']->getTablesFull('my_database', 'my_table'));
$GLOBALS['dbi']->getTablesFull('my_database', 'my_tables_', true));

public getTablesFull ( string $database, string \| array $table = '', boolean $tbl_is_group = false, mixed $link = null, integer $limit_offset, boolean \| integer $limit_count = false, string $sort_by = 'Name', string $sort_order = 'ASC', string $table_type = null ) : array
$database	string	database
$table	string \| array	table name(s)
$tbl_is_group	boolean	$table is a table group
$link	mixed	mysql link
$limit_offset	integer	zero-based offset for the count
$limit_count	boolean \| integer	number of tables to return
$sort_by	string	table attribute to sort by
$sort_order	string	direction to sort (ASC or DESC)
$table_type	string	whether table or view
return	array	list of tables in given db(s)

getTriggers() public method

returns details about the TRIGGERs for a specific table or database

public getTriggers ( string $db, string $table = '', string $delimiter = '//' ) : array
$db	string	db name
$table	string	table name
$delimiter	string	the delimiter to use (may be empty)
return	array	information about triggers (may be empty)

getVariable() public method

returns value of given mysql server variable

public getVariable ( string $var, integer $type = self::GETVAR_SESSION, mixed $link = null ) : mixed
$var	string	mysql server variable name
$type	integer	DatabaseInterface::GETVAR_SESSION \| DatabaseInterface::GETVAR_GLOBAL
$link	mixed	mysql link resource\|object
return	mixed	value for mysql server variable

getVirtualTables() public method

Get VIEWs in a particular database

public getVirtualTables ( string $db ) : array
$db	string	Database name to look in
return	array	$views Set of VIEWs inside the database

getWarnings() public method

returns warnings for last query

public getWarnings ( object $link = null ) : array
$link	object	mysql link resource
return	array	warnings

insertId() public method

returns last inserted auto_increment id for given $link or $GLOBALS['userlink']

public insertId ( object $link = null ) : integer \| boolean
$link	object	the connection object
return	integer \| boolean

isAmazonRds() public method

Checks if this database server is running on Amazon RDS.

public isAmazonRds ( ) : boolean
return	boolean

isSuperuser() public method

Checks if current user is superuser

public isSuperuser ( ) : boolean
return	boolean	Whether user is a superuser

isSystemSchema() public method

Checks whether given schema is a system schema

public isSystemSchema ( string $schema_name, boolean $testForMysqlSchema = false ) : boolean
$schema_name	string	Name of schema (database) to test
$testForMysqlSchema	boolean	Whether 'mysql' schema should be treated the same as IS and DD
return	boolean

isUserType() public method

Checks if current user has global create user/grant privilege or is a superuser (i.e. SELECT on mysql.users) while caching the result in session.

public isUserType ( string $type ) : boolean
$type	string	type of user to check for i.e. 'create', 'grant', 'super'
return	boolean	Whether user is a given type of user

moreResults() public method

Check if there are any more query results from a multi query

public moreResults ( object $link = null ) : boolean
$link	object	the connection object
return	boolean	true or false

nextResult() public method

Prepare next result from multi_query

public nextResult ( object $link = null ) : boolean
$link	object	the connection object
return	boolean	true or false

numFields() public method

return number of fields in given $result

public numFields ( object $result ) : integer
$result	object	result set identifier
return	integer	field count

numRows() public method

returns the number of rows returned by last query

public numRows ( object $result ) : string \| integer
$result	object	result set identifier
return	string \| integer

postConnect() public method

Function called just after a connection to the MySQL database server has been established. It sets the connection collation, and determines the version of MySQL which is running.

public postConnect ( mixed $link ) : void
$link	mixed	mysql link resource\|object
return	void

query() public method

runs a query

public query ( string $query, mixed $link = null, integer $options, boolean $cache_affected_rows = true ) : mixed
$query	string	SQL query to execute
$link	mixed	optional database link to use
$options	integer	optional query options
$cache_affected_rows	boolean	whether to cache affected rows
return	mixed

selectDb() public method

selects given database

public selectDb ( string $dbname, object $link = null ) : boolean
$dbname	string	database name to select
$link	object	connection object
return	boolean

setVariable() public method

Sets new value for a variable if it is different from the current value

public setVariable ( string $var, string $value, mixed $link = null ) : boolean
$var	string	variable name
$value	string	value to set
$link	mixed	mysql link resource\|object
return	boolean	whether query was a successful

storeResult() public method

Store the result returned from multi query

public storeResult ( object $link = null ) : mixed
$link	object	the connection object
return	mixed	false when empty results / result set when not empty

tryMultiQuery() public method

Run multi query statement and return results

public tryMultiQuery ( string $multi_query = '', mysqli $link = null ) : mysqli_result
$multi_query	string	multi query statement to execute
$link	mysqli	mysqli object
return	mysqli_result	collection \| boolean(false)

tryQuery() public method

runs a query and returns the result

public tryQuery ( string $query, object $link = null, integer $options, boolean $cache_affected_rows = true ) : mixed
$query	string	query to run
$link	object	mysql link resource
$options	integer	query options
$cache_affected_rows	boolean	whether to cache affected row
return	mixed

public getColumnsSql ( string $database, string $table, string $column = null, boolean $full = false ) : string
$database	string	name of database
$table	string	name of table to retrieve columns from
$column	string	name of column, null to show all columns
$full	boolean	whether to return full info or only column names
return	string