The mysqli class

mysqli::$affected_rows

Gets the number of affected rows in a previous MySQL operation

mysqli::$client_info

Get MySQL client info

mysqli::$client_version

Returns the MySQL client version as an integer

mysqli::$connect_errno

Returns the error code from last connect call

mysqli::$connect_error

Returns a description of the last connection error

mysqli::$errno

Returns the error code for the most recent function call

mysqli::$error

Returns a string description of the last error

mysqli::$error_list

Returns a list of errors from the last command executed

mysqli::$field_count

Returns the number of columns for the most recent query

mysqli::$host_info

Returns a string representing the type of connection used

mysqli::$info

Retrieves information about the most recently executed query

mysqli::$insert_id

Returns the value generated for an AUTO_INCREMENT column by the last query

mysqli::$protocol_version

Returns the version of the MySQL protocol used

mysqli::$server_info

Returns the version of the MySQL server

mysqli::$server_version

Returns the version of the MySQL server as an integer

mysqli::$sqlstate

Returns the SQLSTATE error from previous MySQL operation

mysqli::$thread_id

Returns the thread ID for the current connection

mysqli::$warning_count

Returns the number of warnings generated by the most recently executed query

mysqli::__construct

Open a new connection to the MySQL server

mysqli::autocommit

Turns on or off auto-committing database modifications

mysqli::begin_transaction

Starts a transaction

mysqli::change_user

Changes the user of the database connection

mysqli::character_set_name

Returns the current character set of the database connection

mysqli::close

Closes a previously opened database connection

mysqli::commit

Commits the current transaction

mysqli::debug

Performs debugging operations

mysqli::dump_debug_info

Dump debugging information into the log

mysqli::escape_string

Alias mysqli_real_escape_string

mysqli::execute_query

Prepares, binds parameters, and executes SQL statement

mysqli::get_charset

Returns a character set object

mysqli::get_connection_stats

Returns statistics about the client connection

mysqli::get_warnings

Get result of SHOW WARNINGS

mysqli::init

Initializes MySQLi and returns an object for use with mysqli_real_connect()

mysqli::kill

Asks the server to kill a MySQL thread

mysqli::more_results

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

mysqli::multi_query

Performs one or more queries on the database

mysqli::next_result

Prepare next result from multi_query

mysqli::options

Set options

mysqli::ping

Pings a server connection, or tries to reconnect if the connection has gone down

mysqli::poll

Poll connections

mysqli::prepare

Prepares an SQL statement for execution

mysqli::query

Performs a query on the database

mysqli::real_connect

Opens a connection to the MySQL server

mysqli::real_escape_string

Escapes special characters in a string for use in an SQL statement, taking into account th...

mysqli::real_query

Execute an SQL query

mysqli::reap_async_query

Get result from async query

mysqli::refresh

Refreshes

mysqli::release_savepoint

Removes the named savepoint from the set of savepoints of the current transaction

mysqli::rollback

Rolls back current transaction

mysqli::savepoint

Set a named transaction savepoint

mysqli::select_db

Selects the default database for database queries

mysqli::set_charset

Sets the client character set

mysqli::set_opt

Alias mysqli_options

mysqli::ssl_set

Used for establishing secure connections using SSL

mysqli::stat

Gets the current system status

mysqli::stmt_init

Initializes a statement and returns an object for use with mysqli_stmt_prepare

mysqli::store_result

Transfers a result set from the last query

mysqli::thread_safe

Returns whether thread safety is given or not

mysqli::use_result

Initiate a result set retrieval