Php/docs/mysqli.summary
The MySQLi Extension Function Summary
Summary of mysqli methods mysqli Class
OOP Interface
Procedural Interface
Alias (Do not use)
Description
Properties
N/A
Gets the number of affected rows in a previous MySQL operation
N/A
Returns the MySQL client version as a string
N/A
Returns MySQL client version info as an integer
N/A
Returns the error code from last connect call
N/A
Returns a string description of the last connect error
N/A
Returns the error code for the most recent function call
N/A
Returns a string description of the last error
N/A
Returns the number of columns for the most recent query
N/A
Returns a string representing the type of connection used
N/A
Returns the version of the MySQL protocol used
N/A
Returns the version of the MySQL server
N/A
Returns the version of the MySQL server as an integer
N/A
Retrieves information about the most recently executed query
N/A
Returns the auto generated id used in the last query
N/A
Returns the SQLSTATE error from previous MySQL operation
N/A
Returns the number of warnings from the last query for the given link
Methods
N/A
Turns on or off auto-committing database modifications
N/A
Changes the user of the specified database connection
mysqli::character_set_name(), mysqli::client_encoding
mysqli_client_encoding()
Returns the default character set for the database connection
N/A
Closes a previously opened database connection
N/A
Commits the current transaction
N/A
Open a new connection to the MySQL server [Note: static (i.e. class) method]
N/A
Performs debugging operations
N/A
Dump debugging information into the log
N/A
Returns a character set object
mysqli::get_connection_stats()
N/A
Returns client connection statistics. Available only with mysqlnd.
N/A
Returns the MySQL client version as a string
N/A
Returns client per-process statistics. Available only with mysqlnd.
N/A
Returns a string representing the version of the MySQL server that the MySQLi extension is connected to
N/A
NOT DOCUMENTED
N/A
Initializes MySQLi and returns an object for use with mysqli_real_connect.
N/A
Asks the server to kill a MySQL thread
N/A
Check if there are any more query results from a multi query
N/A
Performs a query on the database
N/A
Prepare next result from multi_query
Set options
N/A
Pings a server connection, or tries to reconnect if the connection has gone down
N/A
Prepare an SQL statement for execution
N/A
Performs a query on the database
N/A
Opens a connection to a mysql server
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
N/A
Execute an SQL query
N/A
Flushes tables or caches, or resets the replication server information
N/A
Rolls back current transaction
N/A
Selects the default database for database queries
N/A
Sets the default client character set
N/A
Used for establishing secure connections using SSL
N/A
Gets the current system status
N/A
Initializes a statement and returns an object for use with mysqli_stmt_prepare
N/A
Transfers a result set from the last query
N/A
Returns the thread ID for the current connection
N/A
Returns whether thread safety is given or not
N/A
Initiate a result set retrieval
Summary of mysqli_stmt methods
MySQL_STMT
OOP Interface
Procedural Interface
Alias (Do not use)
Description
Properties
N/A
Returns the total number of rows changed, deleted, or inserted by the last executed statement
N/A
Returns the error code for the most recent statement call
N/A
Returns a string description for last statement error
N/A
Returns the number of field in the given statement - not documented
N/A
Get the ID generated from the previous INSERT operation
N/A
Return the number of rows in statements result set
mysqli_param_count()
Returns the number of parameter for the given statement
N/A
Returns SQLSTATE error from previous statement operation
Methods
N/A
Used to get the current value of a statement attribute
N/A
Used to modify the behavior of a prepared statement
mysqli_bind_param()
Binds variables to a prepared statement as parameters
mysqli_bind_result()
Binds variables to a prepared statement for result storage
N/A
Closes a prepared statement
N/A
Seeks to an arbitrary row in statement result set
Executes a prepared Query
mysqli_fetch()
Fetch results from a prepared statement into the bound variables
N/A
Frees stored result memory for the given statement handle
N/A
Gets a result set from a prepared statement. Available only with mysqlnd.
N/A
NOT DOCUMENTED
N/A
Checks if there are more query results from a multiple query
N/A
Reads the next result from a multiple query
N/A
See also property $mysqli_stmt::num_rows
N/A
Prepare an SQL statement for execution
N/A
Resets a prepared statement
mysqli_stmt::result_metadata()
mysqli_get_metadata()
Returns result set metadata from a prepared statement
mysqli_send_long_data()
Send data in blocks
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
N/A
Get current field offset of a result pointer
N/A
Get the number of fields in a result
N/A
Returns the lengths of the columns of the current row in the result set
N/A
Gets the number of rows in a result
Methods
N/A
Adjusts the result pointer to an arbitrary row in the result
N/A
Fetches all result rows and returns the result set as an associative array, a numeric array, or both. Available only with mysqlnd.
N/A
Fetch a result row as an associative, a numeric array, or both
N/A
Fetch a result row as an associative array
mysqli_result::fetch_field_direct()
N/A
Fetch meta-data for a single field
N/A
Returns the next field in the result set
N/A
Returns an array of objects representing the fields in a result set
N/A
Returns the current row of a result set as an object
N/A
Get a result row as an enumerated array
N/A
Set result pointer to a specified field offset
mysqli_result::free(), mysqli_result::close, mysqli_result::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()
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.