<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>MySQLi 扩展库</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="PHP 手册"
HREF="index.html"><LINK
REL="UP"
TITLE="函数参考"
HREF="funcref.html"><LINK
REL="PREVIOUS"
TITLE="PDO_MYSQL DSN"
HREF="ref.pdo-mysql.connection.html"><LINK
REL="NEXT"
TITLE="mysqli_affected_rows"
HREF="function.mysqli-affected-rows.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=UTF-8"></HEAD
><BODY
CLASS="reference"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PHP 手册</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="ref.pdo-mysql.connection.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.mysqli-affected-rows.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="reference"
><A
NAME="ref.mysqli"
></A
><DIV
CLASS="TITLEPAGE"
><H1
CLASS="title"
>C. MySQLi 扩展库</H1
><DIV
CLASS="PARTINTRO"
><A
NAME="AEN136634"
></A
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="mysqli.intro"
>简介</A
></H1
><P
> mysqli 扩展允许用户访问由 MySQL 4.1 或更高版本所提供的功能。有关 MySQL
数据库服务器的更多信息见 <A
HREF="http://www.mysql.com/"
TARGET="_top"
>http://www.mysql.com/</A
>。
</P
><P
> MySQL 的文档见 <A
HREF="http://dev.mysql.com/doc/"
TARGET="_top"
>http://dev.mysql.com/doc/</A
>。
</P
><P
> 经 MySQL AB 授权，本文档中包括部分 MySQL 手册的内容。
</P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="mysqli.requirements"
>需求</A
></H1
><P
> 要使用本扩展库中的函数，必须在编译 PHP 时加入 mysqli 扩展的支持。
</P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>注意: </B
>
mysqli 扩展库是设计用于同 MySQL 4.1.3 或更高版本协同工作的。对之前版本，请参考
<A
HREF="ref.mysql.html"
>MySQL</A
> 扩展库文档。
</P
></BLOCKQUOTE
></DIV
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="mysqli.installation"
>安装</A
></H1
><P
> 要安装 PHP 的 mysqli 扩展，配置时加上
<CODE
CLASS="option"
>--with-mysqli=mysql_config_path/mysql_config</CODE
>。其中
<TT
CLASS="literal"
>mysql_config_path</TT
> 表示 <TT
CLASS="literal"
>mysql_config</TT
>
程序的路径，该程序随 MySQL 大于 4.1 版本一起发布。
</P
><P
> 如果要同时安装 mysql 和 mysqli 扩展，必须使用同一个客户端库以避免冲突。
</P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="mysqli.configuration"
>运行时配置</A
></H1
><P
>这些函数的行为受 <TT
CLASS="filename"
>php.ini</TT
> 的影响。</P
><P
> <DIV
CLASS="table"
><A
NAME="AEN136660"
></A
><P
><B
>表 1. MySQLi 配置选项</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><COL><COL><THEAD
><TR
><TH
>名称</TH
><TH
>默认值</TH
><TH
>可修改范围</TH
><TH
>更新日志</TH
></TR
></THEAD
><TBODY
><TR
><TD
>mysqli.max_links</TD
><TD
>"-1"</TD
><TD
>PHP_INI_SYSTEM</TD
><TD
>自 PHP 5.0.0 起可用。</TD
></TR
><TR
><TD
>mysqli.default_port</TD
><TD
>"3306"</TD
><TD
>PHP_INI_ALL</TD
><TD
>自 PHP 5.0.0 起可用。</TD
></TR
><TR
><TD
>mysqli.default_socket</TD
><TD
>NULL</TD
><TD
>PHP_INI_ALL</TD
><TD
>自 PHP 5.0.0 起可用。</TD
></TR
><TR
><TD
>mysqli.default_host</TD
><TD
>NULL</TD
><TD
>PHP_INI_ALL</TD
><TD
>自 PHP 5.0.0 起可用。</TD
></TR
><TR
><TD
>mysqli.default_user</TD
><TD
>NULL</TD
><TD
>PHP_INI_ALL</TD
><TD
>自 PHP 5.0.0 起可用。</TD
></TR
><TR
><TD
>mysqli.default_pw</TD
><TD
>NULL</TD
><TD
>PHP_INI_ALL</TD
><TD
>自 PHP 5.0.0 起可用。</TD
></TR
></TBODY
></TABLE
></DIV
>
</P
><P
> 以上 PHP_INI_* 常量的进一步细节及定义，见<A
HREF="configuration.changes.html"
>怎样修改配置设定</A
>一节。
</P
><P
>以下是配置选项的简要解释。</P
><P
> <P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><A
NAME="ini.mysqli.max-links"
></A
><CODE
CLASS="parameter"
>mysqli.max_links</CODE
>
<A
HREF="language.types.integer.html"
><B
CLASS="type"
>integer</B
></A
></DT
><DD
><P
> 每个进程的 MySQL 连接的最大数目。
</P
></DD
><DT
><A
NAME="ini.mysqli.default-port"
></A
><CODE
CLASS="parameter"
>mysqli.default_port</CODE
>
<A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
> The default TCP port number to use when connecting to
the database server if no other port is specified. If
no default is specified, the port will be obtained
from the <TT
CLASS="literal"
>MYSQL_TCP_PORT</TT
> environment
variable, the <TT
CLASS="literal"
>mysql-tcp</TT
> entry in
<TT
CLASS="filename"
>/etc/services</TT
> or the compile-time
<TT
CLASS="literal"
>MYSQL_PORT</TT
> constant, in that order. Win32
will only use the <TT
CLASS="literal"
>MYSQL_PORT</TT
> constant.
</P
></DD
><DT
><A
NAME="ini.mysqli.default-socket"
></A
><CODE
CLASS="parameter"
>mysqli.default_socket</CODE
>
<A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
> The default socket name to use when connecting to a local
database server if no other socket name is specified.
</P
></DD
><DT
><A
NAME="ini.mysqli.default-host"
></A
><CODE
CLASS="parameter"
>mysqli.default_host</CODE
>
<A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
> The default server host to use when connecting to the database
server if no other host is specified. Doesn't apply in
<A
HREF="features.safe-mode.html#ini.safe-mode"
>safe mode</A
>.
</P
></DD
><DT
><A
NAME="ini.mysqli.default-user"
></A
><CODE
CLASS="parameter"
>mysqli.default_user</CODE
>
<A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
> The default user name to use when connecting to the database
server if no other name is specified. Doesn't apply in
<A
HREF="features.safe-mode.html#ini.safe-mode"
>safe mode</A
>.
</P
></DD
><DT
><A
NAME="ini.mysqli.default-pw"
></A
><CODE
CLASS="parameter"
>mysqli.default_pw</CODE
>
<A
HREF="language.types.string.html"
><B
CLASS="type"
>string</B
></A
></DT
><DD
><P
> The default password to use when connecting to the database
server if no other password is specified. Doesn't apply in
<A
HREF="features.safe-mode.html#ini.safe-mode"
>safe mode</A
>.
</P
></DD
></DL
></DIV
>
</P
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="mysqli.classes"
>预定义类</A
></H1
><DIV
CLASS="section"
><H2
CLASS="section"
><A
NAME="mysqli.class.mysql"
><B
CLASS="classname"
>mysqli</B
></A
></H2
><P
> 表达了 PHP 和 MySQL 数据库之间的连接。
</P
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.mysql.constructor"
>构造函数</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-connect.html"
>mysqli</A
> - 构造一个新的 mysqli 对象</P
></LI
></UL
></DIV
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.mysql.methods"
>方法</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-autocommit.html"
>autocommit</A
> - 打开或关闭自动提交的数据库选项</P
></LI
><LI
><P
><A
HREF="function.mysqli-change-user.html"
>change_user</A
> - 改变指定的数据库连接的用户</P
></LI
><LI
><P
><A
HREF="function.mysqli-character-set-name.html"
>character_set_name</A
> - 返回数据库连接的默认字符集</P
></LI
><LI
><P
><A
HREF="function.mysqli-close.html"
>close</A
> - 关闭一个之前打开的连接</P
></LI
><LI
><P
><A
HREF="function.mysqli-commit.html"
>commit</A
> - 提交当前事务</P
></LI
><LI
><P
><A
HREF="function.mysqli-connect.html"
>connect</A
> - 打开一个到 MySQL 数据库服务器的新连接</P
></LI
><LI
><P
><A
HREF="function.mysqli-debug.html"
>debug</A
> - 执行排错操作</P
></LI
><LI
><P
><A
HREF="function.mysqli-dump-debug-info.html"
>dump_debug_info</A
> - 取得排错信息</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-client-info.html"
>get_client_info</A
> - 返回客户端版本</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-host-info.html"
>get_host_info</A
> - 返回连接使用的类型</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-server-info.html"
>get_server_info</A
> - 返回 MySQL 服务器的版本</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-server-version.html"
>get_server_version</A
> - 返回 MySQL 服务器的版本</P
></LI
><LI
><P
><A
HREF="function.mysqli-init.html"
>init</A
> - 初始化 mysqli 对象</P
></LI
><LI
><P
><A
HREF="function.mysqli-info.html"
>info</A
> - 取得最近执行的查询的信息</P
></LI
><LI
><P
><A
HREF="function.mysqli-kill.html"
>kill</A
> - 要求服务器停止一个 mysql 线程</P
></LI
><LI
><P
><A
HREF="function.mysqli-multi-query.html"
>multi_query</A
> - 执行多个查询</P
></LI
><LI
><P
><A
HREF="function.mysqli-more-results.html"
>more_results</A
> - check if more results exist from currently executed multi-query</P
></LI
><LI
><P
><A
HREF="function.mysqli-next-result.html"
>next_result</A
> - reads next result from currently executed multi-query</P
></LI
><LI
><P
><A
HREF="function.mysqli-options.html"
>options</A
> - set options</P
></LI
><LI
><P
><A
HREF="function.mysqli-ping.html"
>ping</A
> - pings a server connection or reconnects if there is no connection</P
></LI
><LI
><P
><A
HREF="function.mysqli-prepare.html"
>prepare</A
> - prepares a SQL query</P
></LI
><LI
><P
><A
HREF="function.mysqli-query.html"
>query</A
> - performs a query</P
></LI
><LI
><P
><A
HREF="function.mysqli-real-connect.html"
>real_connect</A
> - attempts to open a connection to MySQL database server</P
></LI
><LI
><P
><A
HREF="function.mysqli-real-escape-string.html"
>escape_string</A
> - escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection</P
></LI
><LI
><P
><A
HREF="function.mysqli-rollback.html"
>rollback</A
> - rolls back the current transaction</P
></LI
><LI
><P
><A
HREF="function.mysqli-select-db.html"
>select_db</A
> - selects the default database</P
></LI
><LI
><P
><A
HREF="function.mysqli-set-charset.html"
>set_charset</A
> - sets the default client character set</P
></LI
><LI
><P
><A
HREF="function.mysqli-ssl-set.html"
>ssl_set</A
> - sets ssl parameters</P
></LI
><LI
><P
><A
HREF="function.mysqli-stat.html"
>stat</A
> - gets the current system status</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-init.html"
>stmt_init</A
>- initializes a statement for use with <A
HREF="function.mysqli-stmt-prepare.html"
>mysqli_stmt_prepare</A
></P
></LI
><LI
><P
><A
HREF="function.mysqli-store-result.html"
>store_result</A
> - transfers a resultset from last query</P
></LI
><LI
><P
><A
HREF="function.mysqli-thread-safe.html"
>thread_safe</A
> - returns whether thread safety is given or not</P
></LI
><LI
><P
><A
HREF="function.mysqli-use-result.html"
>use_result</A
> - transfers an unbuffered resultset from last query</P
></LI
></UL
></DIV
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.mysql.properties"
>属性</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-affected-rows.html"
>affected_rows</A
> - gets the number of affected rows in a previous MySQL operation</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-client-info.html"
>client_info</A
> - returns the MySQL client version as a string</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-client-version.html"
>client_version</A
> - returns the MySQL client version as an integer</P
></LI
><LI
><P
><A
HREF="function.mysqli-errno.html"
>errno</A
> - returns the error code for the most recent function call</P
></LI
><LI
><P
><A
HREF="function.mysqli-error.html"
>error</A
> - returns the error string for the most recent function call</P
></LI
><LI
><P
><A
HREF="function.mysqli-field-count.html"
>field_count</A
> - returns the number of columns for the most recent query</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-host-info.html"
>host_info</A
> - returns a string representing the type of connection used</P
></LI
><LI
><P
><A
HREF="function.mysqli-info.html"
>info</A
> - retrieves information about the most recently executed query</P
></LI
><LI
><P
><A
HREF="function.mysqli-insert-id.html"
>insert_id</A
> - returns the auto generated id used in the last query</P
></LI
><LI
><P
><A
HREF="function.mysqli-get-proto-info.html"
>protocol_version</A
> - returns the version of the MySQL protocol used</P
></LI
><LI
><P
>server_info - returns a string that represents the server version number</P
></LI
><LI
><P
>server_version - returns the version number of the server as an integer</P
></LI
><LI
><P
><A
HREF="function.mysqli-sqlstate.html"
>sqlstate</A
> - returns a string containing the SQLSTATE error code for the last error</P
></LI
><LI
><P
><A
HREF="function.mysqli-thread-id.html"
>thread_id</A
> - returns the thread ID for the current connection</P
></LI
><LI
><P
><A
HREF="function.mysqli-warning-count.html"
>warning_count</A
> - returns the number of warnings generated during execution of the previous SQL statement</P
></LI
></UL
></DIV
></DIV
><DIV
CLASS="section"
><H2
CLASS="section"
><A
NAME="mysqli.classes.stmt"
><B
CLASS="classname"
>mysqli_stmt</B
></A
></H2
><P
> 表达了一个预备好的语句。
</P
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.stmt.methods"
>方法</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-stmt-bind-param.html"
>bind_param</A
> - binds variables to a prepared statement</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-bind-result.html"
>bind_result</A
> - binds variables to a prepared statement for result storage</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-close.html"
>close</A
> - closes a prepared statement</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-data-seek.html"
>data_seek</A
> - seeks to an arbitrary row in a statement result set</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-execute.html"
>execute</A
> - executes a prepared statement</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-fetch.html"
>fetch</A
> - fetches result from a prepared statement into bound variables</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-free-result.html"
>free_result</A
> - frees stored result memory for the given statement handle</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-prepare.html"
>prepare</A
> - prepares a SQL query</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-reset.html"
>reset</A
> - resets a prepared statement</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-result-metadata.html"
>result_metadata</A
> - retrieves a resultset from a prepared statement for metadata information</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-send-long-data.html"
>send_long_data</A
> - sends data in chunks</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-store-result.html"
>store_result</A
> - buffers complete resultset from a prepared statement</P
></LI
></UL
></DIV
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.stmt.properties"
>属性</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-stmt-affected-rows.html"
>affected_rows</A
> - returns affected rows from last statement execution</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-errno.html"
>errno</A
> - returns errorcode for last statement function</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-error.html"
>error</A
> - returns errormessage for last statement function</P
></LI
><LI
><P
><A
HREF="function.mysqli-field-count.html"
>field_count</A
> - returns the number of columns in a result set</P
></LI
><LI
><P
>id - returns the statement identifier</P
></LI
><LI
><P
><A
HREF="function.mysqli-insert-id.html"
>insert_id</A
> - returns the value generated for an AUTO_INCREMENT column by the prepared statement</P
></LI
><LI
><P
><A
HREF="function.mysqli-num-rows.html"
>num_rows</A
> - returns the number of rows in the result set</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-param-count.html"
>param_count</A
> - returns number of parameter for a given prepare statement</P
></LI
><LI
><P
><A
HREF="function.mysqli-stmt-sqlstate.html"
>sqlstate</A
> - returns a string containing the SQLSTATE error code for the last statement function</P
></LI
></UL
></DIV
></DIV
><DIV
CLASS="section"
><H2
CLASS="section"
><A
NAME="mysqli.classes.result"
><B
CLASS="classname"
>mysqli_result</B
></A
></H2
><P
> 表达了对数据库的查询所返回的结果集。
</P
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.result.methods"
>方法</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-free-result.html"
>close</A
> - closes resultset</P
></LI
><LI
><P
><A
HREF="function.mysqli-data-seek.html"
>data_seek</A
> - moves internal result pointer</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-array.html"
>fetch_array</A
> - fetches a result row as an associative array, a numeric array, or both.</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-assoc.html"
>fetch_assoc</A
> - fetches a result row as an associative array</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-field.html"
>fetch_field</A
> - gets column information from a resultset</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-fields.html"
>fetch_fields</A
> - gets information for all columns from a resulset</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-field-direct.html"
>fetch_field_direct</A
> - gets column information for specified column</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-object.html"
>fetch_object</A
> - fetches a result row as an object</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-row.html"
>fetch_row</A
> - gets a result row as an enumerated array</P
></LI
><LI
><P
><A
HREF="function.mysqli-field-seek.html"
>field_seek</A
> - set result pointer to a specified field offset</P
></LI
><LI
><P
><A
HREF="function.mysqli-free-result.html"
>free_result</A
> - frees result memory</P
></LI
></UL
></DIV
><DIV
CLASS="section"
><H3
CLASS="section"
><A
NAME="mysqli.class.result.properties"
>属性</A
></H3
><P
></P
><UL
><LI
><P
><A
HREF="function.mysqli-field-tell.html"
>current_field</A
> - returns offset of current fieldpointer</P
></LI
><LI
><P
><A
HREF="function.mysqli-field-count.html"
>field_count</A
> - returns number of fields in resultset</P
></LI
><LI
><P
><A
HREF="function.mysqli-fetch-lengths.html"
>lengths</A
> - returns an array of columnlengths</P
></LI
><LI
><P
><A
HREF="function.mysqli-num-rows.html"
>num_rows</A
> - returns number of rows in resultset</P
></LI
><LI
><P
>type - returns <TT
CLASS="constant"
><B
>MYSQLI_STORE_RESULT</B
></TT
> or <TT
CLASS="constant"
><B
>MYSQLI_USE_RESULT</B
></TT
></P
></LI
></UL
></DIV
></DIV
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="mysqli.constants"
>预定义常量</A
></H1
><DIV
CLASS="table"
><A
NAME="AEN137043"
></A
><P
><B
>表 2. MySQLi 常量</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>名称</TH
><TH
>说明</TH
></TR
></THEAD
><TBODY
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_READ_DEFAULT_GROUP</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Read options from the named group from `my.cnf' or the file specified with <TT
CLASS="literal"
>MYSQLI_READ_DEFAULT_FILE</TT
>
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_READ_DEFAULT_FILE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Read options from the named option file instead of from <TT
CLASS="literal"
>my.cnf</TT
>
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_OPT_CONNECT_TIMEOUT</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Connect timeout in seconds
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_OPT_LOCAL_INFILE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Enables command <TT
CLASS="literal"
>LOAD LOCAL INFILE</TT
>
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_INIT_COMMAND</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Command to execute when connecting to MySQL server. Will automatically be re-executed when reconnecting.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_CLIENT_SSL</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Use SSL (encrypted protocol). This option should not be set by application programs;
it is set internally in the MySQL client library
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_CLIENT_COMPRESS</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Use compression protocol
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_CLIENT_INTERACTIVE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client's session wait_timeout variable will be set to the value of the session interactive_timeout variable.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_CLIENT_IGNORE_SPACE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Allow spaces after function names. Makes all functions names reserved words.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_CLIENT_NO_SCHEMA</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Don't allow the db_name.tbl_name.col_name syntax.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_CLIENT_MULTI_QUERIES</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> </TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_STORE_RESULT</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> For using buffered resultsets
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_USE_RESULT</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> For using unbuffered resultsets
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_ASSOC</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Columns are returned into the array having the fieldname as the array index.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_NUM</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Columns are returned into the array having an enumerated index.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_BOTH</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Columns are returned into the array having both a numerical index and the fieldname as the associative index.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_NOT_NULL_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Indicates that a field is defined as <TT
CLASS="literal"
>NOT NULL</TT
>
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_PRI_KEY_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Field is part of a primary index
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_UNIQUE_KEY_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Field is part of a unique index.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_MULTIPLE_KEY_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Field is part of an index.
</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_BLOB_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>BLOB</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_UNSIGNED_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>UNSIGNED</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_ZEROFILL_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>ZEROFILL</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_AUTO_INCREMENT_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>AUTO_INCREMENT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TIMESTAMP_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>TIMESTAMP</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_SET_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>SET</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_NUM_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>NUMERIC</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_PART_KEY_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is part of an multi-index</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_GROUP_FLAG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is part of <TT
CLASS="literal"
>GROUP BY</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_DECIMAL</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>DECIMAL</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_NEWDECIMAL</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Precision math <TT
CLASS="literal"
>DECIMAL</TT
> or <TT
CLASS="literal"
>NUMERIC</TT
> field (MySQL 5.0.3 and up)</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_BIT</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>BIT</TT
> (MySQL 5.0.3 and up)</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_TINY</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>TINYINT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_SHORT</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>INT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_LONG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>INT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_FLOAT</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>FLOAT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_DOUBLE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>DOUBLE</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_NULL</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>DEFAULT NULL</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_TIMESTAMP</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>TIMESTAMP</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_LONGLONG</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>BIGINT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_INT24</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>MEDIUMINT</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_DATE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>DATE</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_TIME</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>TIME</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_DATETIME</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>DATETIME</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_YEAR</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>YEAR</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_NEWDATE</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>DATE</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_ENUM</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>ENUM</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_SET</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>SET</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_TINY_BLOB</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>TINYBLOB</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_MEDIUM_BLOB</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>MEDIUMBLOB</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_LONG_BLOB</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>LONGBLOB</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_BLOB</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>BLOB</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_VAR_STRING</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>VARCHAR</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_STRING</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>CHAR</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_TYPE_GEOMETRY</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>Field is defined as <TT
CLASS="literal"
>GEOMETRY</TT
></TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_NEED_DATA</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>More data available for bind variable</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_NO_DATA</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
>No more data available for bind variable</TD
></TR
><TR
><TD
> <TT
CLASS="constant"
><B
>MYSQLI_DATA_TRUNCATED</B
></TT
>
(<A
HREF="language.types.integer.html"
>integer</A
>)
</TD
><TD
> Data truncation occurred. Available since PHP 5.1.0 and MySQL 5.0.5.
</TD
></TR
></TBODY
></TABLE
></DIV
></DIV
><DIV
CLASS="section"
><H1
CLASS="section"
><A
NAME="AEN137380"
>例子</A
></H1
><P
> 在 MySQLI 文档中的所有例子都使用了来自 MySQL AB 的 world 数据库。数据库
world 可以在此地址下载：<A
HREF="http://dev.mysql.com/get/Downloads/Manual/world.sql.gz/from/pick"
TARGET="_top"
>http://dev.mysql.com/get/Downloads/Manual/world.sql.gz/from/pick</A
>。
</P
></DIV
></DIV
><DIV
CLASS="TOC"
><DL
><DT
><B
>目录</B
></DT
><DT
><A
HREF="function.mysqli-affected-rows.html"
>mysqli_affected_rows</A
> -- Gets the number of affected rows in a previous MySQL operation</DT
><DT
><A
HREF="function.mysqli-autocommit.html"
>mysqli_autocommit</A
> -- Turns on or off auto-commiting database modifications</DT
><DT
><A
HREF="function.mysqli-bind-param.html"
>mysqli_bind_param</A
> -- Alias for <A
HREF="function.mysqli-stmt-bind-param.html"
><B
CLASS="function"
>mysqli_stmt_bind_param()</B
></A
></DT
><DT
><A
HREF="function.mysqli-bind-result.html"
>mysqli_bind_result</A
> -- Alias for <A
HREF="function.mysqli-stmt-bind-result.html"
><B
CLASS="function"
>mysqli_stmt_bind_result()</B
></A
></DT
><DT
><A
HREF="function.mysqli-change-user.html"
>mysqli_change_user</A
> -- Changes the user of the specified database connection</DT
><DT
><A
HREF="function.mysqli-character-set-name.html"
>mysqli_character_set_name</A
> -- Returns the default character set for the database connection</DT
><DT
><A
HREF="function.mysqli-client-encoding.html"
>mysqli_client_encoding</A
> -- Alias of <A
HREF="function.mysqli-character-set-name.html"
><B
CLASS="function"
>mysqli_character_set_name()</B
></A
></DT
><DT
><A
HREF="function.mysqli-close.html"
>mysqli_close</A
> -- Closes a previously opened database connection</DT
><DT
><A
HREF="function.mysqli-commit.html"
>mysqli_commit</A
> -- Commits the current transaction</DT
><DT
><A
HREF="function.mysqli-connect-errno.html"
>mysqli_connect_errno</A
> -- Returns the error code from last connect call</DT
><DT
><A
HREF="function.mysqli-connect-error.html"
>mysqli_connect_error</A
> -- Returns a string description of the last connect error</DT
><DT
><A
HREF="function.mysqli-connect.html"
>mysqli_connect</A
> -- Open a new connection to the MySQL server</DT
><DT
><A
HREF="function.mysqli-data-seek.html"
>mysqli_data_seek</A
> -- Adjusts the result pointer to an arbitary row in the result</DT
><DT
><A
HREF="function.mysqli-debug.html"
>mysqli_debug</A
> -- Performs debugging operations</DT
><DT
><A
HREF="function.mysqli-disable-reads-from-master.html"
>mysqli_disable_reads_from_master</A
> -- Disable reads from master</DT
><DT
><A
HREF="function.mysqli-disable-rpl-parse.html"
>mysqli_disable_rpl_parse</A
> -- Disable RPL parse</DT
><DT
><A
HREF="function.mysqli-dump-debug-info.html"
>mysqli_dump_debug_info</A
> -- Dump debugging information into the log</DT
><DT
><A
HREF="function.mysqli-embedded-server-end.html"
>mysqli_embedded_server_end</A
> -- </DT
><DT
><A
HREF="function.mysqli-embedded-server-start.html"
>mysqli_embedded_server_start</A
> -- </DT
><DT
><A
HREF="function.mysqli-enable-reads-from-master.html"
>mysqli_enable_reads_from_master</A
> -- Enable reads from master</DT
><DT
><A
HREF="function.mysqli-enable-rpl-parse.html"
>mysqli_enable_rpl_parse</A
> -- Enable RPL parse</DT
><DT
><A
HREF="function.mysqli-errno.html"
>mysqli_errno</A
> -- Returns the error code for the most recent function call</DT
><DT
><A
HREF="function.mysqli-error.html"
>mysqli_error</A
> -- Returns a string description of the last error</DT
><DT
><A
HREF="function.mysqli-escape-string.html"
>mysqli_escape_string</A
> -- Alias of <A
HREF="function.mysqli-real-escape-string.html"
><B
CLASS="function"
>mysqli_real_escape_string()</B
></A
></DT
><DT
><A
HREF="function.mysqli-execute.html"
>mysqli_execute</A
> -- Alias for <A
HREF="function.mysqli-stmt-execute.html"
><B
CLASS="function"
>mysqli_stmt_execute()</B
></A
></DT
><DT
><A
HREF="function.mysqli-fetch-array.html"
>mysqli_fetch_array</A
> -- Fetch a result row as an associative, a numeric array, or both</DT
><DT
><A
HREF="function.mysqli-fetch-assoc.html"
>mysqli_fetch_assoc</A
> -- Fetch a result row as an associative array</DT
><DT
><A
HREF="function.mysqli-fetch-field-direct.html"
>mysqli_fetch_field_direct</A
> -- Fetch meta-data for a single field</DT
><DT
><A
HREF="function.mysqli-fetch-field.html"
>mysqli_fetch_field</A
> -- Returns the next field in the result set</DT
><DT
><A
HREF="function.mysqli-fetch-fields.html"
>mysqli_fetch_fields</A
> -- Returns an array of objects representing the fields in a result set</DT
><DT
><A
HREF="function.mysqli-fetch-lengths.html"
>mysqli_fetch_lengths</A
> -- Returns the lengths of the columns of the current row in the result set</DT
><DT
><A
HREF="function.mysqli-fetch-object.html"
>mysqli_fetch_object</A
> -- Returns the current row of a result set as an object</DT
><DT
><A
HREF="function.mysqli-fetch-row.html"
>mysqli_fetch_row</A
> -- Get a result row as an enumerated array</DT
><DT
><A
HREF="function.mysqli-fetch.html"
>mysqli_fetch</A
> -- Alias for <A
HREF="function.mysqli-stmt-fetch.html"
><B
CLASS="function"
>mysqli_stmt_fetch()</B
></A
></DT
><DT
><A
HREF="function.mysqli-field-count.html"
>mysqli_field_count</A
> -- Returns the number of columns for the most recent query</DT
><DT
><A
HREF="function.mysqli-field-seek.html"
>mysqli_field_seek</A
> -- Set result pointer to a specified field offset</DT
><DT
><A
HREF="function.mysqli-field-tell.html"
>mysqli_field_tell</A
> -- Get current field offset of a result pointer</DT
><DT
><A
HREF="function.mysqli-free-result.html"
>mysqli_free_result</A
> -- Frees the memory associated with a result</DT
><DT
><A
HREF="function.mysqli-get-charset.html"
>mysqli_get_charset</A
> -- Returns a character set object</DT
><DT
><A
HREF="function.mysqli-get-client-info.html"
>mysqli_get_client_info</A
> -- Returns the MySQL client version as a string</DT
><DT
><A
HREF="function.mysqli-get-client-version.html"
>mysqli_get_client_version</A
> -- Get MySQL client info</DT
><DT
><A
HREF="function.mysqli-get-host-info.html"
>mysqli_get_host_info</A
> -- Returns a string representing the type of connection used</DT
><DT
><A
HREF="function.mysqli-get-metadata.html"
>mysqli_get_metadata</A
> -- Alias for <A
HREF="function.mysqli-stmt-result-metadata.html"
><B
CLASS="function"
>mysqli_stmt_result_metadata()</B
></A
></DT
><DT
><A
HREF="function.mysqli-get-proto-info.html"
>mysqli_get_proto_info</A
> -- Returns the version of the MySQL protocol used</DT
><DT
><A
HREF="function.mysqli-get-server-info.html"
>mysqli_get_server_info</A
> -- Returns the version of the MySQL server</DT
><DT
><A
HREF="function.mysqli-get-server-version.html"
>mysqli_get_server_version</A
> -- Returns the version of the MySQL server as an integer</DT
><DT
><A
HREF="function.mysqli-get-warnings.html"
>mysqli_get_warnings</A
> -- </DT
><DT
><A
HREF="function.mysqli-info.html"
>mysqli_info</A
> -- Retrieves information about the most recently executed query</DT
><DT
><A
HREF="function.mysqli-init.html"
>mysqli_init</A
> -- Initializes MySQLi and returns a resource for use with mysqli_real_connect()</DT
><DT
><A
HREF="function.mysqli-insert-id.html"
>mysqli_insert_id</A
> -- Returns the auto generated id used in the last query</DT
><DT
><A
HREF="function.mysqli-kill.html"
>mysqli_kill</A
> -- Asks the server to kill a MySQL thread</DT
><DT
><A
HREF="function.mysqli-master-query.html"
>mysqli_master_query</A
> -- Enforce execution of a query on the master in a master/slave setup</DT
><DT
><A
HREF="function.mysqli-more-results.html"
>mysqli_more_results</A
> -- Check if there are any more query results from a multi query</DT
><DT
><A
HREF="function.mysqli-multi-query.html"
>mysqli_multi_query</A
> -- Performs a query on the database</DT
><DT
><A
HREF="function.mysqli-next-result.html"
>mysqli_next_result</A
> -- Prepare next result from multi_query</DT
><DT
><A
HREF="function.mysqli-num-fields.html"
>mysqli_num_fields</A
> -- Get the number of fields in a result</DT
><DT
><A
HREF="function.mysqli-num-rows.html"
>mysqli_num_rows</A
> -- Gets the number of rows in a result</DT
><DT
><A
HREF="function.mysqli-options.html"
>mysqli_options</A
> -- Set options</DT
><DT
><A
HREF="function.mysqli-param-count.html"
>mysqli_param_count</A
> -- Alias for <A
HREF="function.mysqli-stmt-param-count.html"
><B
CLASS="function"
>mysqli_stmt_param_count()</B
></A
></DT
><DT
><A
HREF="function.mysqli-ping.html"
>mysqli_ping</A
> -- Pings a server connection, or tries to reconnect if the connection has gone down</DT
><DT
><A
HREF="function.mysqli-prepare.html"
>mysqli_prepare</A
> -- Prepare a SQL statement for execution</DT
><DT
><A
HREF="function.mysqli-query.html"
>mysqli_query</A
> -- Performs a query on the database</DT
><DT
><A
HREF="function.mysqli-real-connect.html"
>mysqli_real_connect</A
> -- Opens a connection to a mysql server</DT
><DT
><A
HREF="function.mysqli-real-escape-string.html"
>mysqli_real_escape_string</A
> -- Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection</DT
><DT
><A
HREF="function.mysqli-real-query.html"
>mysqli_real_query</A
> -- Execute an SQL query</DT
><DT
><A
HREF="function.mysqli-report.html"
>mysqli_report</A
> -- Enables or disables internal report functions</DT
><DT
><A
HREF="function.mysqli-rollback.html"
>mysqli_rollback</A
> -- Rolls back current transaction</DT
><DT
><A
HREF="function.mysqli-rpl-parse-enabled.html"
>mysqli_rpl_parse_enabled</A
> -- Check if RPL parse is enabled</DT
><DT
><A
HREF="function.mysqli-rpl-probe.html"
>mysqli_rpl_probe</A
> -- RPL probe</DT
><DT
><A
HREF="function.mysqli-rpl-query-type.html"
>mysqli_rpl_query_type</A
> -- Returns RPL query type</DT
><DT
><A
HREF="function.mysqli-select-db.html"
>mysqli_select_db</A
> -- Selects the default database for database queries</DT
><DT
><A
HREF="function.mysqli-send-long-data.html"
>mysqli_send_long_data</A
> -- Alias for <A
HREF="function.mysqli-stmt-send-long-data.html"
><B
CLASS="function"
>mysqli_stmt_send_long_data()</B
></A
></DT
><DT
><A
HREF="function.mysqli-send-query.html"
>mysqli_send_query</A
> -- Send the query and return</DT
><DT
><A
HREF="function.mysqli-server-end.html"
>mysqli_server_end</A
> -- Shut down the embedded server</DT
><DT
><A
HREF="function.mysqli-server-init.html"
>mysqli_server_init</A
> -- Initialize embedded server</DT
><DT
><A
HREF="function.mysqli-set-charset.html"
>mysqli_set_charset</A
> -- Sets the default client character set</DT
><DT
><A
HREF="function.mysqli-set-local-infile-default.html"
>mysqli_set_local_infile_default</A
> -- Unsets user defined handler for load local infile command</DT
><DT
><A
HREF="function.mysqli-set-local-infile-handler.html"
>mysqli_set_local_infile_handler</A
> -- Set callback functions for LOAD DATA LOCAL INFILE command</DT
><DT
><A
HREF="function.mysqli-set-opt.html"
>mysqli_set_opt</A
> -- Alias of <A
HREF="function.mysqli-options.html"
><B
CLASS="function"
>mysqli_options()</B
></A
></DT
><DT
><A
HREF="function.mysqli-slave-query.html"
>mysqli_slave_query</A
> -- Force execution of a query on a slave in a master/slave setup</DT
><DT
><A
HREF="function.mysqli-sqlstate.html"
>mysqli_sqlstate</A
> -- Returns the SQLSTATE error from previous MySQL operation</DT
><DT
><A
HREF="function.mysqli-ssl-set.html"
>mysqli_ssl_set</A
> -- Used for establishing secure connections using SSL</DT
><DT
><A
HREF="function.mysqli-stat.html"
>mysqli_stat</A
> -- Gets the current system status</DT
><DT
><A
HREF="function.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
</DT
><DT
><A
HREF="function.mysqli-stmt-attr-get.html"
>mysqli_stmt_attr_get</A
> -- </DT
><DT
><A
HREF="function.mysqli-stmt-attr-set.html"
>mysqli_stmt_attr_set</A
> -- </DT
><DT
><A
HREF="function.mysqli-stmt-bind-param.html"
>mysqli_stmt_bind_param</A
> -- Binds variables to a prepared statement as parameters</DT
><DT
><A
HREF="function.mysqli-stmt-bind-result.html"
>mysqli_stmt_bind_result</A
> -- Binds variables to a prepared statement for result storage</DT
><DT
><A
HREF="function.mysqli-stmt-close.html"
>mysqli_stmt_close</A
> -- Closes a prepared statement</DT
><DT
><A
HREF="function.mysqli-stmt-data-seek.html"
>mysqli_stmt_data_seek</A
> -- Seeks to an arbitray row in statement result set</DT
><DT
><A
HREF="function.mysqli-stmt-errno.html"
>mysqli_stmt_errno</A
> -- Returns the error code for the most recent statement call</DT
><DT
><A
HREF="function.mysqli-stmt-error.html"
>mysqli_stmt_error</A
> -- Returns a string description for last statement error</DT
><DT
><A
HREF="function.mysqli-stmt-execute.html"
>mysqli_stmt_execute</A
> -- Executes a prepared Query</DT
><DT
><A
HREF="function.mysqli-stmt-fetch.html"
>mysqli_stmt_fetch</A
> -- Fetch results from a prepared statement into the bound variables</DT
><DT
><A
HREF="function.mysqli-stmt-field-count.html"
>mysqli_stmt_field_count</A
> -- Returns the number of field in the given statement</DT
><DT
><A
HREF="function.mysqli-stmt-free-result.html"
>mysqli_stmt_free_result</A
> -- Frees stored result memory for the given statement handle</DT
><DT
><A
HREF="function.mysqli-stmt-get-warnings.html"
>mysqli_stmt_get_warnings</A
> -- </DT
><DT
><A
HREF="function.mysqli-stmt-init.html"
>mysqli_stmt_init</A
> -- Initializes a statement and returns an object for use with mysqli_stmt_prepare</DT
><DT
><A
HREF="function.mysqli-stmt-insert-id.html"
>mysqli_stmt_insert_id</A
> -- Get the ID generated from the previous INSERT operation</DT
><DT
><A
HREF="function.mysqli-stmt-num-rows.html"
>mysqli_stmt_num_rows</A
> -- Return the number of rows in statements result set</DT
><DT
><A
HREF="function.mysqli-stmt-param-count.html"
>mysqli_stmt_param_count</A
> -- Returns the number of parameter for the given statement</DT
><DT
><A
HREF="function.mysqli-stmt-prepare.html"
>mysqli_stmt_prepare</A
> -- Prepare a SQL statement for execution</DT
><DT
><A
HREF="function.mysqli-stmt-reset.html"
>mysqli_stmt_reset</A
> -- Resets a prepared statement</DT
><DT
><A
HREF="function.mysqli-stmt-result-metadata.html"
>mysqli_stmt_result_metadata</A
> -- Returns result set metadata from a prepared statement</DT
><DT
><A
HREF="function.mysqli-stmt-send-long-data.html"
>mysqli_stmt_send_long_data</A
> -- Send data in blocks</DT
><DT
><A
HREF="function.mysqli-stmt-sqlstate.html"
>mysqli_stmt_sqlstate</A
> -- Returns SQLSTATE error from previous statement operation</DT
><DT
><A
HREF="function.mysqli-stmt-store-result.html"
>mysqli_stmt_store_result</A
> -- Transfers a result set from a prepared statement</DT
><DT
><A
HREF="function.mysqli-store-result.html"
>mysqli_store_result</A
> -- Transfers a result set from the last query</DT
><DT
><A
HREF="function.mysqli-thread-id.html"
>mysqli_thread_id</A
> -- Returns the thread ID for the current connection</DT
><DT
><A
HREF="function.mysqli-thread-safe.html"
>mysqli_thread_safe</A
> -- Returns whether thread safety is given or not</DT
><DT
><A
HREF="function.mysqli-use-result.html"
>mysqli_use_result</A
> -- Initiate a result set retrieval</DT
><DT
><A
HREF="function.mysqli-warning-count.html"
>mysqli_warning_count</A
> -- Returns the number of warnings from the last query for the given link</DT
></DL
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="ref.pdo-mysql.connection.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>起始页</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.mysqli-affected-rows.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>PDO_MYSQL DSN</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="funcref.html"
ACCESSKEY="U"
>上一级</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>mysqli_affected_rows</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
