<!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>The MySQLi Extension Function Summary</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="mysqli.notes.html">Notes</a></div>
<div class="next" style="text-align: right; float: right;"><a href="class.mysqli.html">mysqli</a></div>
<div class="up"><a href="book.mysqli.html">Mysqli</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="mysqli.summary" class="chapter">
<h1>The MySQLi Extension Function Summary</h1>
<table class="doctable table">
<caption><strong>Summary of <a href="class.mysqli.html" class="classname">mysqli</a> methods</strong></caption>
<thead>
<tr>
<th>mysqli Class</th>
</tr>
<tr>
<th>OOP Interface</th>
<th>Procedural Interface</th>
<th>Alias (Do not use)</th>
<th>Description</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><em class="emphasis">Properties</em></td>
</tr>
<tr>
<td><a href="mysqli.affected-rows.html" class="link">$mysqli::affected_rows</a></td>
<td> <span class="function"><a href="mysqli.affected-rows.html" class="function">mysqli_affected_rows()</a></span></td>
<td>N/A</td>
<td>Gets the number of affected rows in a previous MySQL operation</td>
</tr>
<tr>
<td><a href="mysqli.client-info.html" class="link">$mysqli::client_info</a></td>
<td> <span class="function"><a href="mysqli.get-client-info.html" class="function">mysqli_get_client_info()</a></span></td>
<td>N/A</td>
<td>Returns the MySQL client version as a string</td>
</tr>
<tr>
<td><a href="mysqli.client-version.html" class="link">$mysqli::client_version</a></td>
<td> <span class="function"><a href="mysqli.get-client-version.html" class="function">mysqli_get_client_version()</a></span></td>
<td>N/A</td>
<td>Returns MySQL client version info as an integer</td> </tr>
<tr>
<td><a href="mysqli.connect-errno.html" class="link">$mysqli::connect_errno</a></td>
<td> <span class="function"><a href="mysqli.connect-errno.html" class="function">mysqli_connect_errno()</a></span></td>
<td>N/A</td>
<td>Returns the error code from last connect call</td>
</tr>
<tr>
<td><a href="mysqli.connect-error.html" class="link">$mysqli::connect_error</a></td>
<td> <span class="function"><a href="mysqli.connect-error.html" class="function">mysqli_connect_error()</a></span></td>
<td>N/A</td>
<td>Returns a string description of the last connect error</td>
</tr>
<tr>
<td><a href="mysqli.errno.html" class="link">$mysqli::errno</a></td>
<td> <span class="function"><a href="mysqli.errno.html" class="function">mysqli_errno()</a></span></td>
<td>N/A</td>
<td>Returns the error code for the most recent function call</td>
</tr>
<tr>
<td><a href="mysqli.error.html" class="link">$mysqli::error</a></td>
<td> <span class="function"><a href="mysqli.error.html" class="function">mysqli_error()</a></span></td>
<td>N/A</td>
<td>Returns a string description of the last error</td>
</tr>
<tr>
<td><a href="mysqli.field-count.html" class="link">$mysqli::field_count</a></td>
<td> <span class="function"><a href="mysqli.field-count.html" class="function">mysqli_field_count()</a></span></td>
<td>N/A</td>
<td>Returns the number of columns for the most recent query</td>
</tr>
<tr>
<td><a href="mysqli.get-host-info.html" class="link">$mysqli::host_info</a></td>
<td> <span class="function"><a href="mysqli.get-host-info.html" class="function">mysqli_get_host_info()</a></span></td>
<td>N/A</td>
<td>Returns a string representing the type of connection used</td>
</tr>
<tr>
<td><a href="mysqli.get-proto-info.html" class="link">$mysqli::protocol_version</a></td>
<td> <span class="function"><a href="mysqli.get-proto-info.html" class="function">mysqli_get_proto_info()</a></span></td>
<td>N/A</td>
<td>Returns the version of the MySQL protocol used</td>
</tr>
<tr>
<td><a href="mysqli.get-server-info.html" class="link">$mysqli::server_info</a></td>
<td> <span class="function"><a href="mysqli.get-server-info.html" class="function">mysqli_get_server_info()</a></span></td>
<td>N/A</td>
<td>Returns the version of the MySQL server</td>
</tr>
<tr>
<td><a href="mysqli.get-server-version.html" class="link">$mysqli::server_version</a></td>
<td> <span class="function"><a href="mysqli.get-server-version.html" class="function">mysqli_get_server_version()</a></span></td>
<td>N/A</td>
<td>Returns the version of the MySQL server as an integer</td>
</tr>
<tr>
<td><a href="mysqli.info.html" class="link">$mysqli::info</a></td>
<td> <span class="function"><a href="mysqli.info.html" class="function">mysqli_info()</a></span></td>
<td>N/A</td>
<td>Retrieves information about the most recently executed query</td>
</tr>
<tr>
<td><a href="mysqli.insert-id.html" class="link">$mysqli::insert_id</a></td>
<td> <span class="function"><a href="mysqli.insert-id.html" class="function">mysqli_insert_id()</a></span></td>
<td>N/A</td>
<td>Returns the auto generated id used in the last query</td>
</tr>
<tr>
<td><a href="mysqli.sqlstate.html" class="link">$mysqli::sqlstate</a></td>
<td> <span class="function"><a href="mysqli.sqlstate.html" class="function">mysqli_sqlstate()</a></span></td>
<td>N/A</td>
<td>Returns the SQLSTATE error from previous MySQL operation</td>
</tr>
<tr>
<td><a href="mysqli.warning-count.html" class="link">$mysqli::warning_count</a></td>
<td> <span class="function"><a href="mysqli.warning-count.html" class="function">mysqli_warning_count()</a></span></td>
<td>N/A</td>
<td>Returns the number of warnings from the last query for the given link</td>
</tr>
<tr>
<td><em class="emphasis">Methods</em></td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.autocommit.html" class="methodname">mysqli::autocommit()</a></span></td>
<td> <span class="function"><a href="mysqli.autocommit.html" class="function">mysqli_autocommit()</a></span></td>
<td>N/A</td>
<td>Turns on or off auto-committing database modifications</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.change-user.html" class="methodname">mysqli::change_user()</a></span></td>
<td> <span class="function"><a href="mysqli.change-user.html" class="function">mysqli_change_user()</a></span></td>
<td>N/A</td>
<td>Changes the user of the specified database connection</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.character-set-name.html" class="methodname">mysqli::character_set_name()</a></span>,<a href="mysqli.character-set-name.html" class="link">
mysqli::client_encoding</a></td>
<td> <span class="function"><a href="mysqli.character-set-name.html" class="function">mysqli_character_set_name()</a></span></td>
<td> <span class="function"><a href="function.mysqli-client-encoding.html" class="function">mysqli_client_encoding()</a></span></td>
<td>Returns the default character set for the database connection</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.close.html" class="methodname">mysqli::close()</a></span></td>
<td> <span class="function"><a href="mysqli.close.html" class="function">mysqli_close()</a></span></td>
<td>N/A</td>
<td>Closes a previously opened database connection</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.commit.html" class="methodname">mysqli::commit()</a></span></td>
<td> <span class="function"><a href="mysqli.commit.html" class="function">mysqli_commit()</a></span></td>
<td>N/A</td>
<td>Commits the current transaction</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.construct.html" class="methodname">mysqli::__construct()</a></span></td>
<td> <span class="function"><a href="function.mysqli-connect.html" class="function">mysqli_connect()</a></span></td>
<td>N/A</td>
<td>Open a new connection to the MySQL server [Note: static (i.e. class)
method]</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.debug.html" class="methodname">mysqli::debug()</a></span></td>
<td> <span class="function"><a href="mysqli.debug.html" class="function">mysqli_debug()</a></span></td>
<td>N/A</td>
<td>Performs debugging operations</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.dump-debug-info.html" class="methodname">mysqli::dump_debug_info()</a></span></td>
<td> <span class="function"><a href="mysqli.dump-debug-info.html" class="function">mysqli_dump_debug_info()</a></span></td>
<td>N/A</td>
<td>Dump debugging information into the log</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.get-charset.html" class="methodname">mysqli::get_charset()</a></span></td>
<td> <span class="function"><a href="mysqli.get-charset.html" class="function">mysqli_get_charset()</a></span></td>
<td>N/A</td>
<td>Returns a character set object</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.get-connection-stats.html" class="methodname">mysqli::get_connection_stats()</a></span></td>
<td> <span class="function"><a href="mysqli.get-connection-stats.html" class="function">mysqli_get_connection_stats()</a></span></td>
<td>N/A</td>
<td>Returns client connection statistics. Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.get-client-info.html" class="methodname">mysqli::get_client_info()</a></span></td>
<td> <span class="function"><a href="mysqli.get-client-info.html" class="function">mysqli_get_client_info()</a></span></td>
<td>N/A</td>
<td>Returns the MySQL client version as a string</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.get-client-stats.html" class="methodname">mysqli::get_client_stats()</a></span></td>
<td> <span class="function"><a href="mysqli.get-client-stats.html" class="function">mysqli_get_client_stats()</a></span></td>
<td>N/A</td>
<td>Returns client per-process statistics. Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td> <span class="methodname"><a href="function.mysqli-get-cache-stats.html" class="methodname">mysqli::get_cache_stats()</a></span></td>
<td> <span class="function"><a href="function.mysqli-get-cache-stats.html" class="function">mysqli_get_cache_stats()</a></span></td>
<td>N/A</td>
<td>Returns client Zval cache statistics. Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.get-server-info.html" class="methodname">mysqli::get_server_info()</a></span></td>
<td> <span class="function"><a href="mysqli.get-server-info.html" class="function">mysqli_get_server_info()</a></span></td>
<td>N/A</td>
<td>NOT DOCUMENTED</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.get-warnings.html" class="methodname">mysqli::get_warnings()</a></span></td>
<td> <span class="function"><a href="mysqli.get-warnings.html" class="function">mysqli_get_warnings()</a></span></td>
<td>N/A</td>
<td>NOT DOCUMENTED</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.init.html" class="methodname">mysqli::init()</a></span></td>
<td> <span class="function"><a href="mysqli.init.html" class="function">mysqli_init()</a></span></td>
<td>N/A</td>
<td>Initializes MySQLi and returns a resource for use with
mysqli_real_connect. [Not called on an object, as it returns a
$mysqli object.]</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.kill.html" class="methodname">mysqli::kill()</a></span></td>
<td> <span class="function"><a href="mysqli.kill.html" class="function">mysqli_kill()</a></span></td>
<td>N/A</td>
<td>Asks the server to kill a MySQL thread</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.more-results.html" class="methodname">mysqli::more_results()</a></span></td>
<td> <span class="function"><a href="mysqli.more-results.html" class="function">mysqli_more_results()</a></span></td>
<td>N/A</td>
<td>Check if there are any more query results from a multi query</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.multi-query.html" class="methodname">mysqli::multi_query()</a></span></td>
<td> <span class="function"><a href="mysqli.multi-query.html" class="function">mysqli_multi_query()</a></span></td>
<td>N/A</td>
<td>Performs a query on the database</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.next-result.html" class="methodname">mysqli::next_result()</a></span></td>
<td> <span class="function"><a href="mysqli.next-result.html" class="function">mysqli_next_result()</a></span></td>
<td>N/A</td>
<td>Prepare next result from multi_query</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.options.html" class="methodname">mysqli::options()</a></span></td>
<td> <span class="function"><a href="mysqli.options.html" class="function">mysqli_options()</a></span></td>
<td> <span class="function"><a href="function.mysqli-set-opt.html" class="function">mysqli_set_opt()</a></span></td>
<td>Set options</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.ping.html" class="methodname">mysqli::ping()</a></span></td>
<td> <span class="function"><a href="mysqli.ping.html" class="function">mysqli_ping()</a></span></td>
<td>N/A</td>
<td>Pings a server connection, or tries to reconnect if the connection has
gone down</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.prepare.html" class="methodname">mysqli::prepare()</a></span></td>
<td> <span class="function"><a href="mysqli.prepare.html" class="function">mysqli_prepare()</a></span></td>
<td>N/A</td>
<td>Prepare an SQL statement for execution</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.query.html" class="methodname">mysqli::query()</a></span></td>
<td> <span class="function"><a href="mysqli.query.html" class="function">mysqli_query()</a></span></td>
<td>N/A</td>
<td>Performs a query on the database</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.real-connect.html" class="methodname">mysqli::real_connect()</a></span></td>
<td> <span class="function"><a href="mysqli.real-connect.html" class="function">mysqli_real_connect()</a></span></td>
<td>N/A</td>
<td>Opens a connection to a mysql server</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.real-escape-string.html" class="methodname">mysqli::real_escape_string()</a></span>,
<span class="methodname"><a href="function.mysqli-escape-string.html" class="methodname">mysqli::escape_string()</a></span></td>
<td> <span class="function"><a href="mysqli.real-escape-string.html" class="function">mysqli_real_escape_string()</a></span></td>
<td> <span class="function"><a href="function.mysqli-escape-string.html" class="function">mysqli_escape_string()</a></span></td>
<td>Escapes special characters in a string for use in an SQL statement,
taking into account the current charset of the connection</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.real-query.html" class="methodname">mysqli::real_query()</a></span></td>
<td> <span class="function"><a href="mysqli.real-query.html" class="function">mysqli_real_query()</a></span></td>
<td>N/A</td>
<td>Execute an SQL query</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.refresh.html" class="methodname">mysqli::refresh()</a></span></td>
<td> <span class="function"><a href="mysqli.refresh.html" class="function">mysqli_refresh()</a></span></td>
<td>N/A</td>
<td>Flushes tables or caches, or resets the replication server information</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.rollback.html" class="methodname">mysqli::rollback()</a></span></td>
<td> <span class="function"><a href="mysqli.rollback.html" class="function">mysqli_rollback()</a></span></td>
<td>N/A</td>
<td>Rolls back current transaction</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.select-db.html" class="methodname">mysqli::select_db()</a></span></td>
<td> <span class="function"><a href="mysqli.select-db.html" class="function">mysqli_select_db()</a></span></td>
<td>N/A</td>
<td>Selects the default database for database queries</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.set-charset.html" class="methodname">mysqli::set_charset()</a></span></td>
<td> <span class="function"><a href="mysqli.set-charset.html" class="function">mysqli_set_charset()</a></span></td>
<td>N/A</td>
<td>Sets the default client character set</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.set-local-infile-default.html" class="methodname">mysqli::set_local_infile_default()</a></span></td>
<td> <span class="function"><a href="mysqli.set-local-infile-default.html" class="function">mysqli_set_local_infile_default()</a></span></td>
<td>N/A</td>
<td>Unsets user defined handler for load local infile command</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.set-local-infile-handler.html" class="methodname">mysqli::set_local_infile_handler()</a></span></td>
<td> <span class="function"><a href="mysqli.set-local-infile-handler.html" class="function">mysqli_set_local_infile_handler()</a></span></td>
<td>N/A</td>
<td>Set callback function for LOAD DATA LOCAL INFILE command</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.ssl-set.html" class="methodname">mysqli::ssl_set()</a></span></td>
<td> <span class="function"><a href="mysqli.ssl-set.html" class="function">mysqli_ssl_set()</a></span></td>
<td>N/A</td>
<td>Used for establishing secure connections using SSL</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.stat.html" class="methodname">mysqli::stat()</a></span></td>
<td> <span class="function"><a href="mysqli.stat.html" class="function">mysqli_stat()</a></span></td>
<td>N/A</td>
<td>Gets the current system status</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.stmt-init.html" class="methodname">mysqli::stmt_init()</a></span></td>
<td> <span class="function"><a href="mysqli.stmt-init.html" class="function">mysqli_stmt_init()</a></span></td>
<td>N/A</td>
<td>Initializes a statement and returns an object for use with
mysqli_stmt_prepare</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.store-result.html" class="methodname">mysqli::store_result()</a></span></td>
<td> <span class="function"><a href="mysqli.store-result.html" class="function">mysqli_store_result()</a></span></td>
<td>N/A</td>
<td>Transfers a result set from the last query</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.thread-id.html" class="methodname">mysqli::thread_id()</a></span></td>
<td> <span class="function"><a href="mysqli.thread-id.html" class="function">mysqli_thread_id()</a></span></td>
<td>N/A</td>
<td>Returns the thread ID for the current connection</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.thread-safe.html" class="methodname">mysqli::thread_safe()</a></span></td>
<td> <span class="function"><a href="mysqli.thread-safe.html" class="function">mysqli_thread_safe()</a></span></td>
<td>N/A</td>
<td>Returns whether thread safety is given or not</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli.use-result.html" class="methodname">mysqli::use_result()</a></span></td>
<td> <span class="function"><a href="mysqli.use-result.html" class="function">mysqli_use_result()</a></span></td>
<td>N/A</td>
<td>Initiate a result set retrieval</td>
</tr>
</tbody>
</table>
<table class="doctable table">
<caption><strong>Summary of <a href="class.mysqli-stmt.html" class="classname">mysqli_stmt</a> methods</strong></caption>
<thead>
<tr>
<th>MySQL_STMT</th>
</tr>
<tr>
<th>OOP Interface</th>
<th>Procedural Interface</th>
<th>Alias (Do not use)</th>
<th>Description</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><em class="emphasis">Properties</em></td>
</tr>
<tr>
<td><a href="mysqli-stmt.affected-rows.html" class="link">$mysqli_stmt::affected_rows</a></td>
<td> <span class="function"><a href="mysqli-stmt.affected-rows.html" class="function">mysqli_stmt_affected_rows()</a></span></td>
<td>N/A</td>
<td>Returns the total number of rows changed, deleted, or inserted by the
last executed statement</td>
</tr>
<tr>
<td><a href="mysqli-stmt.errno.html" class="link">$mysqli_stmt::errno</a></td>
<td> <span class="function"><a href="mysqli-stmt.errno.html" class="function">mysqli_stmt_errno()</a></span></td>
<td>N/A</td>
<td>Returns the error code for the most recent statement call</td>
</tr>
<tr>
<td><a href="mysqli-stmt.error.html" class="link">$mysqli_stmt::error</a></td>
<td> <span class="function"><a href="mysqli-stmt.error.html" class="function">mysqli_stmt_error()</a></span></td>
<td>N/A</td>
<td>Returns a string description for last statement error</td>
</tr>
<tr>
<td><a href="mysqli-stmt.field-count.html" class="link">$mysqli_stmt::field_count</a></td>
<td> <span class="function"><a href="mysqli-stmt.field-count.html" class="function">mysqli_stmt_field_count()</a></span></td>
<td>N/A</td>
<td>Returns the number of field in the given statement - not documented</td>
</tr>
<tr>
<td><a href="mysqli-stmt.insert-id.html" class="link">$mysqli_stmt::insert_id</a></td>
<td> <span class="function"><a href="mysqli-stmt.insert-id.html" class="function">mysqli_stmt_insert_id()</a></span></td>
<td>N/A</td>
<td>Get the ID generated from the previous INSERT operation</td>
</tr>
<tr>
<td><a href="mysqli-stmt.num-rows.html" class="link">$mysqli_stmt::num_rows</a></td>
<td> <span class="function"><a href="mysqli-stmt.num-rows.html" class="function">mysqli_stmt_num_rows()</a></span></td>
<td>N/A</td>
<td>Return the number of rows in statements result set</td>
</tr>
<tr>
<td><a href="mysqli-stmt.param-count.html" class="link">$mysqli_stmt::param_count</a></td>
<td> <span class="function"><a href="mysqli-stmt.param-count.html" class="function">mysqli_stmt_param_count()</a></span></td>
<td> <span class="function"><a href="function.mysqli-param-count.html" class="function">mysqli_param_count()</a></span></td>
<td>Returns the number of parameter for the given statement</td>
</tr>
<tr>
<td><a href="mysqli-stmt.sqlstate.html" class="link">$mysqli_stmt::sqlstate</a></td>
<td> <span class="function"><a href="mysqli-stmt.sqlstate.html" class="function">mysqli_stmt_sqlstate()</a></span></td>
<td>N/A</td>
<td>Returns SQLSTATE error from previous statement operation</td>
</tr>
<tr>
<td><em class="emphasis">Methods</em></td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.attr-get.html" class="methodname">mysqli_stmt::attr_get()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.attr-get.html" class="function">mysqli_stmt_attr_get()</a></span></td>
<td>N/A</td>
<td>Used to get the current value of a statement attribute</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.attr-set.html" class="methodname">mysqli_stmt::attr_set()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.attr-set.html" class="function">mysqli_stmt_attr_set()</a></span></td>
<td>N/A</td>
<td>Used to modify the behavior of a prepared statement</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.bind-param.html" class="methodname">mysqli_stmt::bind_param()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.bind-param.html" class="function">mysqli_stmt_bind_param()</a></span></td>
<td> <span class="function"><a href="function.mysqli-bind-param.html" class="function">mysqli_bind_param()</a></span></td>
<td>Binds variables to a prepared statement as parameters</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.bind-result.html" class="methodname">mysqli_stmt::bind_result()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.bind-result.html" class="function">mysqli_stmt_bind_result()</a></span></td>
<td> <span class="function"><a href="function.mysqli-bind-result.html" class="function">mysqli_bind_result()</a></span></td>
<td>Binds variables to a prepared statement for result storage</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.close.html" class="methodname">mysqli_stmt::close()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.close.html" class="function">mysqli_stmt_close()</a></span></td>
<td>N/A</td>
<td>Closes a prepared statement</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.data-seek.html" class="methodname">mysqli_stmt::data_seek()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.data-seek.html" class="function">mysqli_stmt_data_seek()</a></span></td>
<td>N/A</td>
<td>Seeks to an arbitrary row in statement result set</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.execute.html" class="methodname">mysqli_stmt::execute()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.execute.html" class="function">mysqli_stmt_execute()</a></span></td>
<td> <span class="function"><a href="function.mysqli-execute.html" class="function">mysqli_execute()</a></span></td>
<td>Executes a prepared Query</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.fetch.html" class="methodname">mysqli_stmt::fetch()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.fetch.html" class="function">mysqli_stmt_fetch()</a></span></td>
<td> <span class="function"><a href="function.mysqli-fetch.html" class="function">mysqli_fetch()</a></span></td>
<td>Fetch results from a prepared statement into the bound variables</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.free-result.html" class="methodname">mysqli_stmt::free_result()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.free-result.html" class="function">mysqli_stmt_free_result()</a></span></td>
<td>N/A</td>
<td>Frees stored result memory for the given statement handle</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.get-result.html" class="methodname">mysqli_stmt::get_result()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.get-result.html" class="function">mysqli_stmt_get_result()</a></span></td>
<td>N/A</td>
<td>Gets a result set from a prepared statement. Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.get-warnings.html" class="methodname">mysqli_stmt::get_warnings()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.get-warnings.html" class="function">mysqli_stmt_get_warnings()</a></span></td>
<td>N/A</td>
<td>NOT DOCUMENTED</td>
</tr>
<tr>
<td>$mysqli_stmt::more_results()</td>
<td>mysqli_stmt_more_results()</td>
<td>N/A</td>
<td>NOT DOCUMENTED Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td>$mysqli_stmt::next_result()</td>
<td>mysqli_stmt_next_result()</td>
<td>N/A</td>
<td>NOT DOCUMENTED Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.num-rows.html" class="methodname">mysqli_stmt::num_rows()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.num-rows.html" class="function">mysqli_stmt_num_rows()</a></span></td>
<td>N/A</td>
<td>See also property <a href="mysqli-stmt.num-rows.html" class="link">$mysqli_stmt::num_rows</a></td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.prepare.html" class="methodname">mysqli_stmt::prepare()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.prepare.html" class="function">mysqli_stmt_prepare()</a></span></td>
<td>N/A</td>
<td>Prepare an SQL statement for execution</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.reset.html" class="methodname">mysqli_stmt::reset()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.reset.html" class="function">mysqli_stmt_reset()</a></span></td>
<td>N/A</td>
<td>Resets a prepared statement</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.result-metadata.html" class="methodname">mysqli_stmt::result_metadata()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.result-metadata.html" class="function">mysqli_stmt_result_metadata()</a></span></td>
<td> <span class="function"><a href="function.mysqli-get-metadata.html" class="function">mysqli_get_metadata()</a></span></td>
<td>Returns result set metadata from a prepared statement</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.send-long-data.html" class="methodname">mysqli_stmt::send_long_data()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.send-long-data.html" class="function">mysqli_stmt_send_long_data()</a></span></td>
<td> <span class="function"><a href="function.mysqli-send-long-data.html" class="function">mysqli_send_long_data()</a></span></td>
<td>Send data in blocks</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-stmt.store-result.html" class="methodname">mysqli_stmt::store_result()</a></span></td>
<td> <span class="function"><a href="mysqli-stmt.store-result.html" class="function">mysqli_stmt_store_result()</a></span></td>
<td>N/A</td>
<td>Transfers a result set from a prepared statement</td>
</tr>
</tbody>
</table>
<table class="doctable table">
<caption><strong>Summary of <a href="class.mysqli-result.html" class="classname">mysqli_result</a> methods</strong></caption>
<thead>
<tr>
<th>mysqli_result</th>
</tr>
<tr>
<th>OOP Interface</th>
<th>Procedural Interface</th>
<th>Alias (Do not use)</th>
<th>Description</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><em class="emphasis">Properties</em></td>
</tr>
<tr>
<td><a href="mysqli-result.current-field.html" class="link">$mysqli_result::current_field</a></td>
<td> <span class="function"><a href="mysqli-result.current-field.html" class="function">mysqli_field_tell()</a></span></td>
<td>N/A</td>
<td>Get current field offset of a result pointer</td>
</tr>
<tr>
<td><a href="mysqli-result.field-count.html" class="link">$mysqli_result::field_count</a></td>
<td> <span class="function"><a href="mysqli-result.field-count.html" class="function">mysqli_num_fields()</a></span></td>
<td>N/A</td>
<td>Get the number of fields in a result</td>
</tr>
<tr>
<td><a href="mysqli-result.lengths.html" class="link">$mysqli_result::lengths</a></td>
<td> <span class="function"><a href="mysqli-result.lengths.html" class="function">mysqli_fetch_lengths()</a></span></td>
<td>N/A</td>
<td>Returns the lengths of the columns of the current row in the result set</td>
</tr>
<tr>
<td><a href="mysqli-result.num-rows.html" class="link">$mysqli_result::num_rows</a></td>
<td> <span class="function"><a href="mysqli-result.num-rows.html" class="function">mysqli_num_rows()</a></span></td>
<td>N/A</td>
<td>Gets the number of rows in a result</td>
</tr>
<tr>
<td><em class="emphasis">Methods</em></td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.data-seek.html" class="methodname">mysqli_result::data_seek()</a></span></td>
<td> <span class="function"><a href="mysqli-result.data-seek.html" class="function">mysqli_data_seek()</a></span></td>
<td>N/A</td>
<td>Adjusts the result pointer to an arbitrary row in the result</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-all.html" class="methodname">mysqli_result::fetch_all()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-all.html" class="function">mysqli_fetch_all()</a></span></td>
<td>N/A</td>
<td>Fetches all result rows and returns the result set as an associative array, a numeric array, or both. Available only with <a href="book.mysqlnd.html" class="link">mysqlnd</a>.</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-array.html" class="methodname">mysqli_result::fetch_array()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-array.html" class="function">mysqli_fetch_array()</a></span></td>
<td>N/A</td>
<td>Fetch a result row as an associative, a numeric array, or both</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-assoc.html" class="methodname">mysqli_result::fetch_assoc()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-assoc.html" class="function">mysqli_fetch_assoc()</a></span></td>
<td>N/A</td>
<td>Fetch a result row as an associative array</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-field-direct.html" class="methodname">mysqli_result::fetch_field_direct()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-field-direct.html" class="function">mysqli_fetch_field_direct()</a></span></td>
<td>N/A</td>
<td>Fetch meta-data for a single field</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-field.html" class="methodname">mysqli_result::fetch_field()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-field.html" class="function">mysqli_fetch_field()</a></span></td>
<td>N/A</td>
<td>Returns the next field in the result set</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-fields.html" class="methodname">mysqli_result::fetch_fields()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-fields.html" class="function">mysqli_fetch_fields()</a></span></td>
<td>N/A</td>
<td>Returns an array of objects representing the fields in a result set</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-object.html" class="methodname">mysqli_result::fetch_object()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-object.html" class="function">mysqli_fetch_object()</a></span></td>
<td>N/A</td>
<td>Returns the current row of a result set as an object</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.fetch-row.html" class="methodname">mysqli_result::fetch_row()</a></span></td>
<td> <span class="function"><a href="mysqli-result.fetch-row.html" class="function">mysqli_fetch_row()</a></span></td>
<td>N/A</td>
<td>Get a result row as an enumerated array</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.field-seek.html" class="methodname">mysqli_result::field_seek()</a></span></td>
<td> <span class="function"><a href="mysqli-result.field-seek.html" class="function">mysqli_field_seek()</a></span></td>
<td>N/A</td>
<td>Set result pointer to a specified field offset</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-result.free.html" class="methodname">mysqli_result::free()</a></span>,
<a href="mysqli-result.free.html" class="link">mysqli_result::close</a>,
<a href="mysqli-result.free.html" class="link">mysqli_result::free_result</a></td>
<td> <span class="function"><a href="mysqli-result.free.html" class="function">mysqli_free_result()</a></span></td>
<td>N/A</td>
<td>Frees the memory associated with a result</td>
</tr>
</tbody>
</table>
<table class="doctable table">
<caption><strong>Summary of <a href="class.mysqli-driver.html" class="classname">mysqli_driver</a> methods</strong></caption>
<thead>
<tr>
<th>MySQL_Driver</th>
</tr>
<tr>
<th>OOP Interface</th>
<th>Procedural Interface</th>
<th>Alias (Do not use)</th>
<th>Description</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><em class="emphasis">Properties</em></td>
</tr>
<tr>
<td>N/A</td>
</tr>
<tr>
<td><em class="emphasis">Methods</em></td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-driver.embedded-server-end.html" class="methodname">mysqli_driver::embedded_server_end()</a></span></td>
<td> <span class="function"><a href="mysqli-driver.embedded-server-end.html" class="function">mysqli_embedded_server_end()</a></span></td>
<td>N/A</td>
<td>NOT DOCUMENTED</td>
</tr>
<tr>
<td> <span class="methodname"><a href="mysqli-driver.embedded-server-start.html" class="methodname">mysqli_driver::embedded_server_start()</a></span></td>
<td> <span class="function"><a href="mysqli-driver.embedded-server-start.html" class="function">mysqli_embedded_server_start()</a></span></td>
<td>N/A</td>
<td>NOT DOCUMENTED</td>
</tr>
</tbody>
</table>
<blockquote class="note"><p><strong class="note">Note</strong>:
<p class="para">
Alias functions are provided for backward compatibility purposes
only. Do not use them in new projects.
</p>
</p></blockquote>
</div>
<hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="mysqli.notes.html">Notes</a></div>
<div class="next" style="text-align: right; float: right;"><a href="class.mysqli.html">mysqli</a></div>
<div class="up"><a href="book.mysqli.html">Mysqli</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
