Php/docs/mysqli.summary

From Get docs

The MySQLi Extension Function Summary

Summary of mysqli methods mysqli Class

OOP Interface

Procedural Interface

Alias (Do not use)

Description

Properties

$mysqli::affected_rows

mysqli_affected_rows()

N/A

Gets the number of affected rows in a previous MySQL operation

$mysqli::client_info

mysqli_get_client_info()

N/A

Returns the MySQL client version as a string

$mysqli::client_version

mysqli_get_client_version()

N/A

Returns MySQL client version info as an integer

$mysqli::connect_errno

mysqli_connect_errno()

N/A

Returns the error code from last connect call

$mysqli::connect_error

mysqli_connect_error()

N/A

Returns a string description of the last connect error

$mysqli::errno

mysqli_errno()

N/A

Returns the error code for the most recent function call

$mysqli::error

mysqli_error()

N/A

Returns a string description of the last error

$mysqli::field_count

mysqli_field_count()

N/A

Returns the number of columns for the most recent query

$mysqli::host_info

mysqli_get_host_info()

N/A

Returns a string representing the type of connection used

$mysqli::protocol_version

mysqli_get_proto_info()

N/A

Returns the version of the MySQL protocol used

$mysqli::server_info

mysqli_get_server_info()

N/A

Returns the version of the MySQL server

$mysqli::server_version

mysqli_get_server_version()

N/A

Returns the version of the MySQL server as an integer

$mysqli::info

mysqli_info()

N/A

Retrieves information about the most recently executed query

$mysqli::insert_id

mysqli_insert_id()

N/A

Returns the auto generated id used in the last query

$mysqli::sqlstate

mysqli_sqlstate()

N/A

Returns the SQLSTATE error from previous MySQL operation

$mysqli::warning_count

mysqli_warning_count()

N/A

Returns the number of warnings from the last query for the given link

Methods

mysqli::autocommit()

mysqli_autocommit()

N/A

Turns on or off auto-committing database modifications

mysqli::change_user()

mysqli_change_user()

N/A

Changes the user of the specified database connection

mysqli::character_set_name(), mysqli::client_encoding

mysqli_character_set_name()

mysqli_client_encoding()

Returns the default character set for the database connection

mysqli::close()

mysqli_close()

N/A

Closes a previously opened database connection

mysqli::commit()

mysqli_commit()

N/A

Commits the current transaction

mysqli::__construct()

mysqli_connect()

N/A

Open a new connection to the MySQL server [Note: static (i.e. class) method]

mysqli::debug()

mysqli_debug()

N/A

Performs debugging operations

mysqli::dump_debug_info()

mysqli_dump_debug_info()

N/A

Dump debugging information into the log

mysqli::get_charset()

mysqli_get_charset()

N/A

Returns a character set object

mysqli::get_connection_stats()

mysqli_get_connection_stats()

N/A

Returns client connection statistics. Available only with mysqlnd.

mysqli::get_client_info()

mysqli_get_client_info()

N/A

Returns the MySQL client version as a string

mysqli::get_client_stats()

mysqli_get_client_stats()

N/A

Returns client per-process statistics. Available only with mysqlnd.

mysqli::get_server_info()

mysqli_get_server_info()

N/A

Returns a string representing the version of the MySQL server that the MySQLi extension is connected to

mysqli::get_warnings()

mysqli_get_warnings()

N/A

NOT DOCUMENTED

mysqli::init()

mysqli_init()

N/A

Initializes MySQLi and returns an object for use with mysqli_real_connect.

mysqli::kill()

mysqli_kill()

N/A

Asks the server to kill a MySQL thread

mysqli::more_results()

mysqli_more_results()

N/A

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

mysqli::multi_query()

mysqli_multi_query()

N/A

Performs a query on the database

mysqli::next_result()

mysqli_next_result()

N/A

Prepare next result from multi_query

mysqli::options()

mysqli_options()

mysqli_set_opt()

Set options

mysqli::ping()

mysqli_ping()

N/A

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

mysqli::prepare()

mysqli_prepare()

N/A

Prepare an SQL statement for execution

mysqli::query()

mysqli_query()

N/A

Performs a query on the database

mysqli::real_connect()

mysqli_real_connect()

N/A

Opens a connection to a mysql server

mysqli::real_escape_string(), mysqli::escape_string()

mysqli_real_escape_string()

mysqli_escape_string()

Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection

mysqli::real_query()

mysqli_real_query()

N/A

Execute an SQL query

mysqli::refresh()

mysqli_refresh()

N/A

Flushes tables or caches, or resets the replication server information

mysqli::rollback()

mysqli_rollback()

N/A

Rolls back current transaction

mysqli::select_db()

mysqli_select_db()

N/A

Selects the default database for database queries

mysqli::set_charset()

mysqli_set_charset()

N/A

Sets the default client character set

mysqli::ssl_set()

mysqli_ssl_set()

N/A

Used for establishing secure connections using SSL

mysqli::stat()

mysqli_stat()

N/A

Gets the current system status

mysqli::stmt_init()

mysqli_stmt_init()

N/A

Initializes a statement and returns an object for use with mysqli_stmt_prepare

mysqli::store_result()

mysqli_store_result()

N/A

Transfers a result set from the last query

mysqli::thread_id()

mysqli_thread_id()

N/A

Returns the thread ID for the current connection

mysqli::thread_safe()

mysqli_thread_safe()

N/A

Returns whether thread safety is given or not

mysqli::use_result()

mysqli_use_result()

N/A

Initiate a result set retrieval

Summary of mysqli_stmt methods

MySQL_STMT

OOP Interface

Procedural Interface

Alias (Do not use)

Description

Properties

$mysqli_stmt::affected_rows

mysqli_stmt_affected_rows()

N/A

Returns the total number of rows changed, deleted, or inserted by the last executed statement

$mysqli_stmt::errno

mysqli_stmt_errno()

N/A

Returns the error code for the most recent statement call

$mysqli_stmt::error

mysqli_stmt_error()

N/A

Returns a string description for last statement error

$mysqli_stmt::field_count

mysqli_stmt_field_count()

N/A

Returns the number of field in the given statement - not documented

$mysqli_stmt::insert_id

mysqli_stmt_insert_id()

N/A

Get the ID generated from the previous INSERT operation

$mysqli_stmt::num_rows

mysqli_stmt_num_rows()

N/A

Return the number of rows in statements result set

$mysqli_stmt::param_count

mysqli_stmt_param_count()

mysqli_param_count()

Returns the number of parameter for the given statement

$mysqli_stmt::sqlstate

mysqli_stmt_sqlstate()

N/A

Returns SQLSTATE error from previous statement operation

Methods

mysqli_stmt::attr_get()

mysqli_stmt_attr_get()

N/A

Used to get the current value of a statement attribute

mysqli_stmt::attr_set()

mysqli_stmt_attr_set()

N/A

Used to modify the behavior of a prepared statement

mysqli_stmt::bind_param()

mysqli_stmt_bind_param()

mysqli_bind_param()

Binds variables to a prepared statement as parameters

mysqli_stmt::bind_result()

mysqli_stmt_bind_result()

mysqli_bind_result()

Binds variables to a prepared statement for result storage

mysqli_stmt::close()

mysqli_stmt_close()

N/A

Closes a prepared statement

mysqli_stmt::data_seek()

mysqli_stmt_data_seek()

N/A

Seeks to an arbitrary row in statement result set

mysqli_stmt::execute()

mysqli_stmt_execute()

mysqli_execute()

Executes a prepared Query

mysqli_stmt::fetch()

mysqli_stmt_fetch()

mysqli_fetch()

Fetch results from a prepared statement into the bound variables

mysqli_stmt::free_result()

mysqli_stmt_free_result()

N/A

Frees stored result memory for the given statement handle

mysqli_stmt::get_result()

mysqli_stmt_get_result()

N/A

Gets a result set from a prepared statement. Available only with mysqlnd.

mysqli_stmt::get_warnings()

mysqli_stmt_get_warnings()

N/A

NOT DOCUMENTED

mysqli_stmt::more_results()

mysqli_stmt_more_results()

N/A

Checks if there are more query results from a multiple query

mysqli_stmt::next_result()

mysqli_stmt_next_result()

N/A

Reads the next result from a multiple query

mysqli_stmt::num_rows()

mysqli_stmt_num_rows()

N/A

See also property $mysqli_stmt::num_rows

mysqli_stmt::prepare()

mysqli_stmt_prepare()

N/A

Prepare an SQL statement for execution

mysqli_stmt::reset()

mysqli_stmt_reset()

N/A

Resets a prepared statement

mysqli_stmt::result_metadata()

mysqli_stmt_result_metadata()

mysqli_get_metadata()

Returns result set metadata from a prepared statement

mysqli_stmt::send_long_data()

mysqli_stmt_send_long_data()

mysqli_send_long_data()

Send data in blocks

mysqli_stmt::store_result()

mysqli_stmt_store_result()

N/A

Transfers a result set from a prepared statement

Summary of mysqli_result methods

mysqli_result

OOP Interface

Procedural Interface

Alias (Do not use)

Description

Properties

$mysqli_result::current_field

mysqli_field_tell()

N/A

Get current field offset of a result pointer

$mysqli_result::field_count

mysqli_num_fields()

N/A

Get the number of fields in a result

$mysqli_result::lengths

mysqli_fetch_lengths()

N/A

Returns the lengths of the columns of the current row in the result set

$mysqli_result::num_rows

mysqli_num_rows()

N/A

Gets the number of rows in a result

Methods

mysqli_result::data_seek()

mysqli_data_seek()

N/A

Adjusts the result pointer to an arbitrary row in the result

mysqli_result::fetch_all()

mysqli_fetch_all()

N/A

Fetches all result rows and returns the result set as an associative array, a numeric array, or both. Available only with mysqlnd.

mysqli_result::fetch_array()

mysqli_fetch_array()

N/A

Fetch a result row as an associative, a numeric array, or both

mysqli_result::fetch_assoc()

mysqli_fetch_assoc()

N/A

Fetch a result row as an associative array

mysqli_result::fetch_field_direct()

mysqli_fetch_field_direct()

N/A

Fetch meta-data for a single field

mysqli_result::fetch_field()

mysqli_fetch_field()

N/A

Returns the next field in the result set

mysqli_result::fetch_fields()

mysqli_fetch_fields()

N/A

Returns an array of objects representing the fields in a result set

mysqli_result::fetch_object()

mysqli_fetch_object()

N/A

Returns the current row of a result set as an object

mysqli_result::fetch_row()

mysqli_fetch_row()

N/A

Get a result row as an enumerated array

mysqli_result::field_seek()

mysqli_field_seek()

N/A

Set result pointer to a specified field offset

mysqli_result::free(), mysqli_result::close, mysqli_result::free_result

mysqli_free_result()

N/A

Frees the memory associated with a result

Summary of mysqli_driver methods

MySQL_Driver

OOP Interface

Procedural Interface

Alias (Do not use)

Description

Properties

N/A

Methods

mysqli_driver::embedded_server_end()

mysqli_embedded_server_end()

N/A

NOT DOCUMENTED

mysqli_driver::embedded_server_start()

mysqli_embedded_server_start()

N/A

NOT DOCUMENTED

Note:

Alias functions are provided for backward compatibility purposes only. Do not use them in new projects.