📄 class.mysqli.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>The MySQLi class</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="mysqli.constants.html">Predefined Constants</a></div> <div class="next" style="text-align: right; float: right;"><a href="mysqli.affected-rows.html">mysqli->affected_rows</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> <h1 class="title">The MySQLi class</h1> <div class="partintro"> <div id="mysqli.intro" class="section"> <h2 class="title">Introduction</h2> <p class="para"> Represents a connection between PHP and a MySQL database. </p> </div> <div id="mysqli.synopsis" class="section"> <h2 class="title">Class synopsis</h2> <div class="classsynopsis"> <div class="ooclass"><b class="classname">MySQLi</b></div> <div class="classsynopsisinfo"> <span class="ooclass"> <b class="classname">MySQLi</b> </span> {</div> <div class="classsynopsisinfo classsynopsisinfo_comment">/* Properties */</div> <div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$affected_rows</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$connect_errno</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$connect_error</var>;</div><div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$errno</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$error</var>;</div><div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$field_count</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$host_info</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$protocol_version</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$server_info</var>;</div><div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$server_version</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$info</var>;</div><div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$insert_id</var>;</div><div class="fieldsynopsis"><span class="type">string</span> <var class="varname">$sqlstate</var>;</div><div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$thread_id</var>;</div><div class="fieldsynopsis"><span class="type">int</span> <var class="varname">$warning_count</var>;</div> <div class="classsynopsisinfo classsynopsisinfo_comment">/* Methods */</div> <div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.affected-rows.html" class="function">mysqli_affected_rows</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.autocommit.html" class="function">mysqli::autocommit</a></b></span> ( <span class="methodparam"><span class="type">bool</span> <tt class="parameter">$mode</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.change-user.html" class="function">mysqli::change_user</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$user</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$password</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$database</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.character-set-name.html" class="function">mysqli::character_set_name</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.close.html" class="function">mysqli::close</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.commit.html" class="function">mysqli::commit</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.connect-errno.html" class="function">mysqli_connect_errno</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.connect-error.html" class="function">mysqli_connect_error</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">mysqli</span> <span class="methodname"><b><a href="mysqli.connect.html" class="function">mysqli_connect</a></b></span> ([ <span class="methodparam"><span class="type">string</span> <tt class="parameter">$host</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$username</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$passwd</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$dbname</tt></span> [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$port</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$socket</tt></span> ]]]]]] )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.debug.html" class="function">mysqli::debug</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$message</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.dump-debug-info.html" class="function">mysqli::dump_debug_info</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.errno.html" class="function">mysqli_errno</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.error.html" class="function">mysqli_error</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.field-count.html" class="function">mysqli_field_count</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">object</span> <span class="methodname"><b><a href="mysqli.get-charset.html" class="function">mysqli::get_charset</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.get-client-info.html" class="function">mysqli::get_client_info</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.get-client-version.html" class="function">mysqli::get_client_version</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.get-host-info.html" class="function">mysqli_get_host_info</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.get-proto-info.html" class="function">mysqli_get_proto_info</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.get-server-info.html" class="function">mysqli_get_server_info</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.get-server-version.html" class="function">mysqli_get_server_version</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">object</span> <span class="methodname"><b><a href="mysqli.get-warnings.html" class="function">mysqli::get_warnings</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.info.html" class="function">mysqli_info</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">mysqli</span> <span class="methodname"><b><b>init</b></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.insert-id.html" class="function">mysqli_insert_id</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.kill.html" class="function">mysqli::kill</a></b></span> ( <span class="methodparam"><span class="type">int</span> <tt class="parameter">$processid</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.more-results.html" class="function">mysqli::more_results</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.multi-query.html" class="function">mysqli::multi_query</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$query</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.next-result.html" class="function">mysqli::next_result</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.options.html" class="function">mysqli::options</a></b></span> ( <span class="methodparam"><span class="type">int</span> <tt class="parameter">$option</tt></span> , <span class="methodparam"><span class="type"><a href="language.pseudo-types.html#language.types.mixed" class="type mixed">mixed</a></span> <tt class="parameter">$value</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.ping.html" class="function">mysqli::ping</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">mysqli_stmt</span> <span class="methodname"><b><b>prepare</b></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$query</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">mixed</span> <span class="methodname"><b><a href="mysqli.query.html" class="function">mysqli::query</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$query</tt></span> [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$resultmode</tt></span> ] )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.real-connect.html" class="function">mysqli::real_connect</a></b></span> ([ <span class="methodparam"><span class="type">string</span> <tt class="parameter">$host</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$username</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$passwd</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$dbname</tt></span> [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$port</tt></span> [, <span class="methodparam"><span class="type">string</span> <tt class="parameter">$socket</tt></span> [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$flags</tt></span> ]]]]]]] )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="function.mysqli-escape-string.html" class="function">mysqli::escape_string</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$escapestr</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><b>real_query</b></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$query</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.rollback.html" class="function">mysqli::rollback</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.select-db.html" class="function">mysqli::select_db</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$dbname</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.set-charset.html" class="function">mysqli::set_charset</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$charset</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">void</span> <span class="methodname"><b><a href="mysqli.set-local-infile-default.html" class="function">mysqli_set_local_infile_default</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.set-local-infile-handler.html" class="function">mysqli_set_local_infile_handler</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> , <span class="methodparam"><span class="type"><a href="language.pseudo-types.html#language.types.callback" class="type callback">callback</a></span> <tt class="parameter">$read_func</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.sqlstate.html" class="function">mysqli_sqlstate</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.ssl-set.html" class="function">mysqli::ssl_set</a></b></span> ( <span class="methodparam"><span class="type">string</span> <tt class="parameter">$key</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$cert</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$ca</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$capath</tt></span> , <span class="methodparam"><span class="type">string</span> <tt class="parameter">$cipher</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">string</span> <span class="methodname"><b><a href="mysqli.stat.html" class="function">mysqli::stat</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">mysqli_stmt</span> <span class="methodname"><b><b>stmt_init</b></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">mysqli_result</span> <span class="methodname"><b><b>store_result</b></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.thread-id.html" class="function">mysqli_thread_id</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div><div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><a href="mysqli.thread-safe.html" class="function">mysqli_thread_safe</a></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">mysqli_result</span> <span class="methodname"><b><b>use_result</b></b></span> ( <span class="methodparam">void</span> )</div><div class="methodsynopsis dc-description"> <span class="type">int</span> <span class="methodname"><b><a href="mysqli.warning-count.html" class="function">mysqli_warning_count</a></b></span> ( <span class="methodparam"><span class="type"><a href="class.mysqli.html" class="type mysqli">mysqli</a></span> <tt class="parameter">$link</tt></span> )</div> }</div> </div> </div> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -