<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>MySQL Improved Extension</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.mysql-unbuffered-query.html">mysql_unbuffered_query</a></div> <div class="next" style="text-align: right; float: right;"><a href="intro.mysqli.html">Introduction</a></div> <div class="up"><a href="set.mysqlinfo.html">MySQL</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="book.mysqli" class="book"> <h1 class="title">MySQL Improved Extension</h1> <ul class="chunklist chunklist_book"><li><a href="intro.mysqli.html">Introduction</a></li><li><a href="mysqli.overview.html">Overview</a></li><li><a href="mysqli.quickstart.html">Quick start guide</a><ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli.quickstart.dual-interface.html">Dual procedural and object-oriented interface</a></li><li><a href="mysqli.quickstart.connections.html">Connections</a></li><li><a href="mysqli.quickstart.statements.html">Executing statements</a></li><li><a href="mysqli.quickstart.prepared-statements.html">Prepared Statements</a></li><li><a href="mysqli.quickstart.stored-procedures.html">Stored Procedures</a></li><li><a href="mysqli.quickstart.multiple-statement.html">Multiple Statements</a></li><li><a href="mysqli.quickstart.transactions.html">API support for transactions</a></li><li><a href="mysqli.quickstart.metadata.html">Metadata</a></li></ul></li><li><a href="mysqli.setup.html">Installing/Configuring</a><ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli.requirements.html">Requirements</a></li><li><a href="mysqli.installation.html">Installation</a></li><li><a href="mysqli.configuration.html">Runtime Configuration</a></li><li><a href="mysqli.resources.html">Resource Types</a></li></ul></li><li><a href="mysqli.persistconns.html">The mysqli Extension and Persistent Connections</a></li><li><a href="mysqli.constants.html">Predefined Constants</a></li><li><a href="mysqli.notes.html">Notes</a></li><li><a href="mysqli.summary.html">The MySQLi Extension Function Summary</a></li><li><a href="class.mysqli.html">mysqli</a> — The mysqli class<ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli.affected-rows.html">mysqli::$affected_rows</a> — Gets the number of affected rows in a previous MySQL operation</li><li><a href="mysqli.autocommit.html">mysqli::autocommit</a> — Turns on or off auto-committing database modifications</li><li><a href="mysqli.begin-transaction.html">mysqli::begin_transaction</a> — Starts a transaction</li><li><a href="mysqli.change-user.html">mysqli::change_user</a> — Changes the user of the specified database connection</li><li><a href="mysqli.character-set-name.html">mysqli::character_set_name</a> — Returns the default character set for the database connection</li><li><a href="mysqli.client-info.html">mysqli::$client_info</a> — Get MySQL client info</li><li><a href="mysqli.client-version.html">mysqli::$client_version</a> — Returns the MySQL client version as a string</li><li><a href="mysqli.close.html">mysqli::close</a> — Closes a previously opened database connection</li><li><a href="mysqli.commit.html">mysqli::commit</a> — Commits the current transaction</li><li><a href="mysqli.connect-errno.html">mysqli::$connect_errno</a> — Returns the error code from last connect call</li><li><a href="mysqli.connect-error.html">mysqli::$connect_error</a> — Returns a string description of the last connect error</li><li><a href="mysqli.construct.html">mysqli::__construct</a> — Open a new connection to the MySQL server</li><li><a href="mysqli.debug.html">mysqli::debug</a> — Performs debugging operations</li><li><a href="mysqli.dump-debug-info.html">mysqli::dump_debug_info</a> — Dump debugging information into the log</li><li><a href="mysqli.errno.html">mysqli::$errno</a> — Returns the error code for the most recent function call</li><li><a href="mysqli.error-list.html">mysqli::$error_list</a> — Returns a list of errors from the last command executed</li><li><a href="mysqli.error.html">mysqli::$error</a> — Returns a string description of the last error</li><li><a href="mysqli.field-count.html">mysqli::$field_count</a> — Returns the number of columns for the most recent query</li><li><a href="mysqli.get-charset.html">mysqli::get_charset</a> — Returns a character set object</li><li><a href="mysqli.get-client-info.html">mysqli::get_client_info</a> — Get MySQL client info</li><li><a href="mysqli.get-client-stats.html">mysqli_get_client_stats</a> — Returns client per-process statistics</li><li><a href="mysqli.get-client-version.html">mysqli_get_client_version</a> — Returns the MySQL client version as an integer</li><li><a href="mysqli.get-connection-stats.html">mysqli::get_connection_stats</a> — Returns statistics about the client connection</li><li><a href="mysqli.get-host-info.html">mysqli::$host_info</a> — Returns a string representing the type of connection used</li><li><a href="mysqli.get-proto-info.html">mysqli::$protocol_version</a> — Returns the version of the MySQL protocol used</li><li><a href="mysqli.get-server-info.html">mysqli::$server_info</a> — Returns the version of the MySQL server</li><li><a href="mysqli.get-server-version.html">mysqli::$server_version</a> — Returns the version of the MySQL server as an integer</li><li><a href="mysqli.get-warnings.html">mysqli::get_warnings</a> — Get result of SHOW WARNINGS</li><li><a href="mysqli.info.html">mysqli::$info</a> — Retrieves information about the most recently executed query</li><li><a href="mysqli.init.html">mysqli::init</a> — Initializes MySQLi and returns a resource for use with mysqli_real_connect()</li><li><a href="mysqli.insert-id.html">mysqli::$insert_id</a> — Returns the auto generated id used in the last query</li><li><a href="mysqli.kill.html">mysqli::kill</a> — Asks the server to kill a MySQL thread</li><li><a href="mysqli.more-results.html">mysqli::more_results</a> — Check if there are any more query results from a multi query</li><li><a href="mysqli.multi-query.html">mysqli::multi_query</a> — Performs a query on the database</li><li><a href="mysqli.next-result.html">mysqli::next_result</a> — Prepare next result from multi_query</li><li><a href="mysqli.options.html">mysqli::options</a> — Set options</li><li><a href="mysqli.ping.html">mysqli::ping</a> — Pings a server connection, or tries to reconnect if the connection has gone down</li><li><a href="mysqli.poll.html">mysqli::poll</a> — Poll connections</li><li><a href="mysqli.prepare.html">mysqli::prepare</a> — Prepare an SQL statement for execution</li><li><a href="mysqli.query.html">mysqli::query</a> — Performs a query on the database</li><li><a href="mysqli.real-connect.html">mysqli::real_connect</a> — Opens a connection to a mysql server</li><li><a href="mysqli.real-escape-string.html">mysqli::real_escape_string</a> — Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection</li><li><a href="mysqli.real-query.html">mysqli::real_query</a> — Execute an SQL query</li><li><a href="mysqli.reap-async-query.html">mysqli::reap_async_query</a> — Get result from async query</li><li><a href="mysqli.refresh.html">mysqli::refresh</a> — Refreshes</li><li><a href="mysqli.release-savepoint.html">mysqli::release_savepoint</a> — Rolls back a transaction to the named savepoint</li><li><a href="mysqli.rollback.html">mysqli::rollback</a> — Rolls back current transaction</li><li><a href="mysqli.rpl-query-type.html">mysqli::rpl_query_type</a> — Returns RPL query type</li><li><a href="mysqli.savepoint.html">mysqli::savepoint</a> — Set a named transaction savepoint</li><li><a href="mysqli.select-db.html">mysqli::select_db</a> — Selects the default database for database queries</li><li><a href="mysqli.send-query.html">mysqli::send_query</a> — Send the query and return</li><li><a href="mysqli.set-charset.html">mysqli::set_charset</a> — Sets the default client character set</li><li><a href="mysqli.set-local-infile-default.html">mysqli::set_local_infile_default</a> — Unsets user defined handler for load local infile command</li><li><a href="mysqli.set-local-infile-handler.html">mysqli::set_local_infile_handler</a> — Set callback function for LOAD DATA LOCAL INFILE command</li><li><a href="mysqli.sqlstate.html">mysqli::$sqlstate</a> — Returns the SQLSTATE error from previous MySQL operation</li><li><a href="mysqli.ssl-set.html">mysqli::ssl_set</a> — Used for establishing secure connections using SSL</li><li><a href="mysqli.stat.html">mysqli::stat</a> — Gets the current system status</li><li><a href="mysqli.stmt-init.html">mysqli::stmt_init</a> — Initializes a statement and returns an object for use with mysqli_stmt_prepare</li><li><a href="mysqli.store-result.html">mysqli::store_result</a> — Transfers a result set from the last query</li><li><a href="mysqli.thread-id.html">mysqli::$thread_id</a> — Returns the thread ID for the current connection</li><li><a href="mysqli.thread-safe.html">mysqli::thread_safe</a> — Returns whether thread safety is given or not</li><li><a href="mysqli.use-result.html">mysqli::use_result</a> — Initiate a result set retrieval</li><li><a href="mysqli.warning-count.html">mysqli::$warning_count</a> — Returns the number of warnings from the last query for the given link</li></ul></li><li><a href="class.mysqli-stmt.html">mysqli_stmt</a> — The mysqli_stmt class<ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli-stmt.affected-rows.html">mysqli_stmt::$affected_rows</a> — Returns the total number of rows changed, deleted, or inserted by the last executed statement</li><li><a href="mysqli-stmt.attr-get.html">mysqli_stmt::attr_get</a> — Used to get the current value of a statement attribute</li><li><a href="mysqli-stmt.attr-set.html">mysqli_stmt::attr_set</a> — Used to modify the behavior of a prepared statement</li><li><a href="mysqli-stmt.bind-param.html">mysqli_stmt::bind_param</a> — Binds variables to a prepared statement as parameters</li><li><a href="mysqli-stmt.bind-result.html">mysqli_stmt::bind_result</a> — Binds variables to a prepared statement for result storage</li><li><a href="mysqli-stmt.close.html">mysqli_stmt::close</a> — Closes a prepared statement</li><li><a href="mysqli-stmt.data-seek.html">mysqli_stmt::data_seek</a> — Seeks to an arbitrary row in statement result set</li><li><a href="mysqli-stmt.errno.html">mysqli_stmt::$errno</a> — Returns the error code for the most recent statement call</li><li><a href="mysqli-stmt.error-list.html">mysqli_stmt::$error_list</a> — Returns a list of errors from the last statement executed</li><li><a href="mysqli-stmt.error.html">mysqli_stmt::$error</a> — Returns a string description for last statement error</li><li><a href="mysqli-stmt.execute.html">mysqli_stmt::execute</a> — Executes a prepared Query</li><li><a href="mysqli-stmt.fetch.html">mysqli_stmt::fetch</a> — Fetch results from a prepared statement into the bound variables</li><li><a href="mysqli-stmt.field-count.html">mysqli_stmt::$field_count</a> — Returns the number of field in the given statement</li><li><a href="mysqli-stmt.free-result.html">mysqli_stmt::free_result</a> — Frees stored result memory for the given statement handle</li><li><a href="mysqli-stmt.get-result.html">mysqli_stmt::get_result</a> — Gets a result set from a prepared statement</li><li><a href="mysqli-stmt.get-warnings.html">mysqli_stmt::get_warnings</a> — Get result of SHOW WARNINGS</li><li><a href="mysqli-stmt.insert-id.html">mysqli_stmt::$insert_id</a> — Get the ID generated from the previous INSERT operation</li><li><a href="mysqli-stmt.more-results.html">mysqli_stmt::more_results</a> — Check if there are more query results from a multiple query</li><li><a href="mysqli-stmt.next-result.html">mysqli_stmt::next_result</a> — Reads the next result from a multiple query</li><li><a href="mysqli-stmt.num-rows.html">mysqli_stmt::$num_rows</a> — Return the number of rows in statements result set</li><li><a href="mysqli-stmt.param-count.html">mysqli_stmt::$param_count</a> — Returns the number of parameter for the given statement</li><li><a href="mysqli-stmt.prepare.html">mysqli_stmt::prepare</a> — Prepare an SQL statement for execution</li><li><a href="mysqli-stmt.reset.html">mysqli_stmt::reset</a> — Resets a prepared statement</li><li><a href="mysqli-stmt.result-metadata.html">mysqli_stmt::result_metadata</a> — Returns result set metadata from a prepared statement</li><li><a href="mysqli-stmt.send-long-data.html">mysqli_stmt::send_long_data</a> — Send data in blocks</li><li><a href="mysqli-stmt.sqlstate.html">mysqli_stmt::$sqlstate</a> — Returns SQLSTATE error from previous statement operation</li><li><a href="mysqli-stmt.store-result.html">mysqli_stmt::store_result</a> — Transfers a result set from a prepared statement</li></ul></li><li><a href="class.mysqli-result.html">mysqli_result</a> — The mysqli_result class<ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli-result.current-field.html">mysqli_result::$current_field</a> — Get current field offset of a result pointer</li><li><a href="mysqli-result.data-seek.html">mysqli_result::data_seek</a> — Adjusts the result pointer to an arbitrary row in the result</li><li><a href="mysqli-result.fetch-all.html">mysqli_result::fetch_all</a> — Fetches all result rows as an associative array, a numeric array, or both</li><li><a href="mysqli-result.fetch-array.html">mysqli_result::fetch_array</a> — Fetch a result row as an associative, a numeric array, or both</li><li><a href="mysqli-result.fetch-assoc.html">mysqli_result::fetch_assoc</a> — Fetch a result row as an associative array</li><li><a href="mysqli-result.fetch-field-direct.html">mysqli_result::fetch_field_direct</a> — Fetch meta-data for a single field</li><li><a href="mysqli-result.fetch-field.html">mysqli_result::fetch_field</a> — Returns the next field in the result set</li><li><a href="mysqli-result.fetch-fields.html">mysqli_result::fetch_fields</a> — Returns an array of objects representing the fields in a result set</li><li><a href="mysqli-result.fetch-object.html">mysqli_result::fetch_object</a> — Returns the current row of a result set as an object</li><li><a href="mysqli-result.fetch-row.html">mysqli_result::fetch_row</a> — Get a result row as an enumerated array</li><li><a href="mysqli-result.field-count.html">mysqli_result::$field_count</a> — Get the number of fields in a result</li><li><a href="mysqli-result.field-seek.html">mysqli_result::field_seek</a> — Set result pointer to a specified field offset</li><li><a href="mysqli-result.free.html">mysqli_result::free</a> — Frees the memory associated with a result</li><li><a href="mysqli-result.lengths.html">mysqli_result::$lengths</a> — Returns the lengths of the columns of the current row in the result set</li><li><a href="mysqli-result.num-rows.html">mysqli_result::$num_rows</a> — Gets the number of rows in a result</li></ul></li><li><a href="class.mysqli-driver.html">mysqli_driver</a> — The mysqli_driver class<ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli-driver.embedded-server-end.html">mysqli_driver::embedded_server_end</a> — Stop embedded server</li><li><a href="mysqli-driver.embedded-server-start.html">mysqli_driver::embedded_server_start</a> — Initialize and start embedded server</li><li><a href="mysqli-driver.report-mode.html">mysqli_driver::$report_mode</a> — Enables or disables internal report functions</li></ul></li><li><a href="class.mysqli-warning.html">mysqli_warning</a> — The mysqli_warning class<ul class="chunklist chunklist_book chunklist_children"><li><a href="mysqli-warning.construct.html">mysqli_warning::__construct</a> — The __construct purpose</li><li><a href="mysqli-warning.next.html">mysqli_warning::next</a> — The next purpose</li></ul></li><li><a href="class.mysqli-sql-exception.html">mysqli_sql_exception</a> — The mysqli_sql_exception class</li><li><a href="ref.mysqli.html">Aliases and deprecated Mysqli Functions</a><ul class="chunklist chunklist_book chunklist_children"><li><a href="function.mysqli-bind-param.html">mysqli_bind_param</a> — Alias for mysqli_stmt_bind_param</li><li><a href="function.mysqli-bind-result.html">mysqli_bind_result</a> — Alias for mysqli_stmt_bind_result</li><li><a href="function.mysqli-client-encoding.html">mysqli_client_encoding</a> — Alias of mysqli_character_set_name</li><li><a href="function.mysqli-connect.html">mysqli_connect</a> — Alias of mysqli::__construct</li><li><a href="function.mysqli-disable-reads-from-master.html">mysqli::disable_reads_from_master</a> — Disable reads from master</li><li><a href="function.mysqli-disable-rpl-parse.html">mysqli_disable_rpl_parse</a> — Disable RPL parse</li><li><a href="function.mysqli-enable-reads-from-master.html">mysqli_enable_reads_from_master</a> — Enable reads from master</li><li><a href="function.mysqli-enable-rpl-parse.html">mysqli_enable_rpl_parse</a> — Enable RPL parse</li><li><a href="function.mysqli-escape-string.html">mysqli_escape_string</a> — Alias of mysqli_real_escape_string</li><li><a href="function.mysqli-execute.html">mysqli_execute</a> — Alias for mysqli_stmt_execute</li><li><a href="function.mysqli-fetch.html">mysqli_fetch</a> — Alias for mysqli_stmt_fetch</li><li><a href="function.mysqli-get-cache-stats.html">mysqli_get_cache_stats</a> — Returns client Zval cache statistics</li><li><a href="function.mysqli-get-metadata.html">mysqli_get_metadata</a> — Alias for mysqli_stmt_result_metadata</li><li><a href="function.mysqli-master-query.html">mysqli_master_query</a> — Enforce execution of a query on the master in a master/slave setup</li><li><a href="function.mysqli-param-count.html">mysqli_param_count</a> — Alias for mysqli_stmt_param_count</li><li><a href="function.mysqli-report.html">mysqli_report</a> — Alias of of mysqli_driver->report_mode</li><li><a href="function.mysqli-rpl-parse-enabled.html">mysqli_rpl_parse_enabled</a> — Check if RPL parse is enabled</li><li><a href="function.mysqli-rpl-probe.html">mysqli_rpl_probe</a> — RPL probe</li><li><a href="function.mysqli-send-long-data.html">mysqli_send_long_data</a> — Alias for mysqli_stmt_send_long_data</li><li><a href="function.mysqli-set-opt.html">mysqli::set_opt</a> — Alias of mysqli_options</li><li><a href="function.mysqli-slave-query.html">mysqli_slave_query</a> — Force execution of a query on a slave in a master/slave setup</li></ul></li><li><a href="changelog.mysqli.html">Changelog</a></li></ul></div><hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.mysql-unbuffered-query.html">mysql_unbuffered_query</a></div> <div class="next" style="text-align: right; float: right;"><a href="intro.mysqli.html">Introduction</a></div> <div class="up"><a href="set.mysqlinfo.html">MySQL</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>
