DbalInterface

Executes a query and returns the result

Executes a query and returns the result or false on error

Send multiple SQL queries to the database server and execute the first one

returns array with table names for given db

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

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

move into Table

returns array with databases containing extended infos about them

move into ListDatabase?

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

Returns description of a $column in given table

Returns descriptions of columns in given table

Returns all column names in given table

Returns indexes of a table

returns value of given mysql server variable

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

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.

Sets collation connection for user link

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

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

Returns only the first row from the result or null if result is empty.

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

returns all rows in the resultset in one array

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

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

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

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

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

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

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

Get supported SQL compatibility modes

returns warnings for last query

gets the current user with host

Checks if current user is superuser

No description

No description

No description

Get the current user and host

Returns value for lower_case_table_names variable

Connects to the database server.

selects given database

Prepare next result from multi_query

Returns a string representing the type of connection used

returns a string that represents the client library version

Returns last error message or an empty string if no errors occurred.

returns the number of rows returned by last query used with tryQuery as it accepts false

returns last inserted auto_increment id for given $link

returns the number of rows affected by last query

returns metainfo for fields in $result

Returns properly quoted string for use in MySQL queries.

Returns properly escaped string for use in MySQL LIKE clauses.

This method escapes only _, %, and /. It does not escape quotes or any other characters.

Checks if this database server is running on Amazon RDS.

Gets SQL for killing a process.

Get a table with database name and table name

returns collation of given db

returns default server collation from show variables

Server version as number

Server version

Server version comment

Whether connection is MySQL

Whether connection is MariaDB

Whether connection is Percona

Prepare an SQL statement for execution.