简介

mysqli 扩展允许用户访问由 MySQL 4.1 或更高版本所提供的功能。有关 MySQL 数据库服务器的更多信息见 » http://www.mysql.com/。

MySQL 的文档见 » http://dev.mysql.com/doc/。

经 MySQL AB 授权，本文档中包括部分 MySQL 手册的内容。

需求

要使用本扩展库中的函数，必须在编译 PHP 时加入 mysqli 扩展的支持。

注意: mysqli 扩展库是设计用于同 MySQL 4.1.3 或更高版本协同工作的。对之前版本，请参考 MySQL 扩展库文档。

安装

要安装 PHP 的 mysqli 扩展，配置时加上 --with-mysqli=mysql_config_path/mysql_config。其中 mysql_config_path 表示 mysql_config 程序的路径，该程序随 MySQL 大于 4.1 版本一起发布。

如果要同时安装 mysql 和 mysqli 扩展，必须使用同一个客户端库以避免冲突。

运行时配置

这些函数的行为受 php.ini 的影响。

以上 PHP_INI_* 常量的进一步细节及定义，见怎样修改配置设定一节。

以下是配置选项的简要解释。

预定义类

预定义常量

例子

在 MySQLI 文档中的所有例子都使用了来自 MySQL AB 的 world 数据库。数据库 world 可以在此地址下载：» http://dev.mysql.com/get/Downloads/Manual/world.sql.gz/from/pick。

目录

mysqli_affected_rows Gets the number of affected rows in a previous MySQL operation

mysqli_autocommit Turns on or off auto-commiting database modifications

mysqli_bind_param Alias for mysqli_stmt_bind_param()

mysqli_bind_result Alias for mysqli_stmt_bind_result()

mysqli_change_user Changes the user of the specified database connection

mysqli_character_set_name Returns the default character set for the database connection

mysqli_client_encoding Alias of mysqli_character_set_name()

mysqli_close Closes a previously opened database connection

mysqli_commit Commits the current transaction

mysqli_connect_errno Returns the error code from last connect call

mysqli_connect_error Returns a string description of the last connect error

mysqli_connect Open a new connection to the MySQL server

mysqli_data_seek Adjusts the result pointer to an arbitary row in the result

mysqli_debug Performs debugging operations

mysqli_disable_reads_from_master Disable reads from master

mysqli_disable_rpl_parse Disable RPL parse

mysqli_dump_debug_info Dump debugging information into the log

mysqli_embedded_server_end

mysqli_embedded_server_start

mysqli_enable_reads_from_master Enable reads from master

mysqli_enable_rpl_parse Enable RPL parse

mysqli_errno Returns the error code for the most recent function call

mysqli_error Returns a string description of the last error

mysqli_escape_string Alias of mysqli_real_escape_string()

mysqli_execute Alias for mysqli_stmt_execute()

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

mysqli_fetch_assoc Fetch a result row as an associative array

mysqli_fetch_field_direct Fetch meta-data for a single field

mysqli_fetch_field Returns the next field in the result set

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

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

mysqli_fetch_object Returns the current row of a result set as an object

mysqli_fetch_row Get a result row as an enumerated array

mysqli_fetch Alias for mysqli_stmt_fetch()

mysqli_field_count Returns the number of columns for the most recent query

mysqli_field_seek Set result pointer to a specified field offset

mysqli_field_tell Get current field offset of a result pointer

mysqli_free_result Frees the memory associated with a result

mysqli_get_charset Returns a character set object

mysqli_get_client_info Returns the MySQL client version as a string

mysqli_get_client_version Get MySQL client info

mysqli_get_host_info Returns a string representing the type of connection used

mysqli_get_metadata Alias for mysqli_stmt_result_metadata()

mysqli_get_proto_info Returns the version of the MySQL protocol used

mysqli_get_server_info Returns the version of the MySQL server

mysqli_get_server_version Returns the version of the MySQL server as an integer

mysqli_get_warnings

mysqli_info Retrieves information about the most recently executed query

mysqli_init Initializes MySQLi and returns a resource for use with mysqli_real_connect()

mysqli_insert_id Returns the auto generated id used in the last query

mysqli_kill Asks the server to kill a MySQL thread

mysqli_master_query Enforce execution of a query on the master in a master/slave setup

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

mysqli_multi_query Performs a query on the database

mysqli_next_result Prepare next result from multi_query

mysqli_num_fields Get the number of fields in a result

mysqli_num_rows Gets the number of rows in a result

mysqli_options Set options

mysqli_param_count Alias for mysqli_stmt_param_count()

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

mysqli_prepare Prepare a SQL statement for execution

mysqli_query Performs a query on the database

mysqli_real_connect Opens a connection to a mysql server

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

mysqli_real_query Execute an SQL query

mysqli_report Enables or disables internal report functions

mysqli_rollback Rolls back current transaction

mysqli_rpl_parse_enabled Check if RPL parse is enabled

mysqli_rpl_probe RPL probe

mysqli_rpl_query_type Returns RPL query type

mysqli_select_db Selects the default database for database queries

mysqli_send_long_data Alias for mysqli_stmt_send_long_data()

mysqli_send_query Send the query and return

mysqli_server_end Shut down the embedded server

mysqli_server_init Initialize embedded server

mysqli_set_charset Sets the default client character set

mysqli_set_local_infile_default Unsets user defined handler for load local infile command

mysqli_set_local_infile_handler Set callback functions for LOAD DATA LOCAL INFILE command

mysqli_set_opt Alias of mysqli_options()

mysqli_slave_query Force execution of a query on a slave in a master/slave setup

mysqli_sqlstate Returns the SQLSTATE error from previous MySQL operation

mysqli_ssl_set Used for establishing secure connections using SSL

mysqli_stat Gets the current system status

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

mysqli_stmt_attr_get

mysqli_stmt_attr_set

mysqli_stmt_bind_param Binds variables to a prepared statement as parameters

mysqli_stmt_bind_result Binds variables to a prepared statement for result storage

mysqli_stmt_close Closes a prepared statement

mysqli_stmt_data_seek Seeks to an arbitray row in statement result set

mysqli_stmt_errno Returns the error code for the most recent statement call

mysqli_stmt_error Returns a string description for last statement error

mysqli_stmt_execute Executes a prepared Query

mysqli_stmt_fetch Fetch results from a prepared statement into the bound variables

mysqli_stmt_field_count Returns the number of field in the given statement

mysqli_stmt_free_result Frees stored result memory for the given statement handle

mysqli_stmt_get_warnings

mysqli_stmt_init Initializes a statement and returns an object for use with mysqli_stmt_prepare

mysqli_stmt_insert_id Get the ID generated from the previous INSERT operation

mysqli_stmt_num_rows Return the number of rows in statements result set

mysqli_stmt_param_count Returns the number of parameter for the given statement

mysqli_stmt_prepare Prepare a SQL statement for execution

mysqli_stmt_reset Resets a prepared statement

mysqli_stmt_result_metadata Returns result set metadata from a prepared statement

mysqli_stmt_send_long_data Send data in blocks

mysqli_stmt_sqlstate Returns SQLSTATE error from previous statement operation

mysqli_stmt_store_result Transfers a result set from a prepared statement

mysqli_store_result Transfers a result set from the last query

mysqli_thread_id Returns the thread ID for the current connection

mysqli_thread_safe Returns whether thread safety is given or not

mysqli_use_result Initiate a result set retrieval

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