Sophie

Sophie

distrib > Mandriva > 2008.1 > x86_64 > by-pkgid > 05cd670d8a02b2b4a0ffb1756f2e8308 > files > 2780

php-manual-zh-5.2.4-1mdv2008.1.noarch.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>mysqli_real_connect</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="PHP 手册"
HREF="index.html"><LINK
REL="UP"
TITLE="MySQLi 扩展库"
HREF="ref.mysqli.html"><LINK
REL="PREVIOUS"
TITLE="mysqli_query"
HREF="function.mysqli-query.html"><LINK
REL="NEXT"
TITLE="mysqli_real_escape_string"
HREF="function.mysqli-real-escape-string.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=UTF-8"></HEAD
><BODY
CLASS="refentry"
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="function.mysqli-query.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.mysqli-real-escape-string.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.mysqli-real-connect"
></A
>mysqli_real_connect</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN140679"
></A
><P
>    (PHP 5)</P
>mysqli_real_connect<P
>    (no version information, might be only in CVS)</P
>mysqli-&#62;real_connect()&nbsp;--&nbsp;Opens a connection to a mysql server</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN140683"
></A
><H2
>说明</H2
><P
>Procedural style</P
>bool <B
CLASS="methodname"
>mysqli_real_connect</B
> ( mysqli link [, string host [, string username [, string passwd [, string dbname [, int port [, string socket [, int flags]]]]]]] )<BR
></BR
><P
>Object oriented style (method)</P
>class <B
CLASS="classname"
>mysqli</B
> { <BR
></BR
>bool <B
CLASS="methodname"
>real_connect</B
> ( [string host [, string username [, string passwd [, string dbname [, int port [, string socket [, int flags]]]]]]] )<BR
></BR
>}<P
>&#13;   Establish a connection to a MySQL database engine.
  </P
><P
>&#13;   This function differs from <A
HREF="function.mysqli-connect.html"
><B
CLASS="function"
>mysqli_connect()</B
></A
>:
  </P
><P
></P
><UL
><LI
><P
>&#13;     <B
CLASS="function"
>mysqli_real_connect()</B
> needs a valid object which has
     to be created by function <A
HREF="function.mysqli-init.html"
><B
CLASS="function"
>mysqli_init()</B
></A
>
    </P
></LI
><LI
><P
>&#13;     With function <A
HREF="function.mysqli-options.html"
><B
CLASS="function"
>mysqli_options()</B
></A
> you can set various
     options for connection.
    </P
></LI
><LI
><P
>&#13;     There is a <CODE
CLASS="parameter"
>flags</CODE
> parameter.
    </P
></LI
></UL
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN140755"
></A
><H2
>参数</H2
><P
>&#13;   <P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><CODE
CLASS="parameter"
>&#13;link</CODE
></DT
><DD
><P
>Procedural style only: A link identifier
returned by <A
HREF="function.mysqli-connect.html"
><B
CLASS="function"
>mysqli_connect()</B
></A
> or <A
HREF="function.mysqli-init.html"
><B
CLASS="function"
>mysqli_init()</B
></A
>
</P
></DD
><DT
><CODE
CLASS="parameter"
>host</CODE
></DT
><DD
><P
>&#13;       Can be either a host name or an IP address. Passing the <TT
CLASS="constant"
><B
>NULL</B
></TT
> value
       or the string "localhost" to this parameter, the local host is
       assumed. When possible, pipes will be used instead of the TCP/IP
       protocol.
      </P
></DD
><DT
><CODE
CLASS="parameter"
>username</CODE
></DT
><DD
><P
>&#13;       The MySQL user name.
      </P
></DD
><DT
><CODE
CLASS="parameter"
>passwd</CODE
></DT
><DD
><P
>&#13;       If provided or <TT
CLASS="constant"
><B
>NULL</B
></TT
>, the MySQL server will attempt to authenticate
       the user against those user records which have no password only. This
       allows one username to be used with different permissions (depending
       on if a password as provided or not).
      </P
></DD
><DT
><CODE
CLASS="parameter"
>dbname</CODE
></DT
><DD
><P
>&#13;       If provided will specify the default database to be used when
       performing queries.
      </P
></DD
><DT
><CODE
CLASS="parameter"
>port</CODE
></DT
><DD
><P
>&#13;       Specifies the port number to attempt to connect to the MySQL server.
      </P
></DD
><DT
><CODE
CLASS="parameter"
>socket</CODE
></DT
><DD
><P
>&#13;       Specifies the socket or named pipe that should be used.
      </P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>注意: </B
>
        Specifying the <CODE
CLASS="parameter"
>socket</CODE
> parameter will not
        explicitly determine the type of connection to be used when
        connecting to the MySQL server. How the connection is made to the
        MySQL database is determined by the <CODE
CLASS="parameter"
>host</CODE
>
        parameter.
       </P
></BLOCKQUOTE
></DIV
></DD
><DT
><CODE
CLASS="parameter"
>flags</CODE
></DT
><DD
><P
>&#13;       With the parameter <CODE
CLASS="parameter"
>flags</CODE
> you can set different
       connection options:
      </P
><DIV
CLASS="table"
><A
NAME="AEN140808"
></A
><P
><B
>表 1. Supported flags</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Name</TH
><TH
>Description</TH
></TR
></THEAD
><TBODY
><TR
><TD
><TT
CLASS="constant"
><B
>MYSQLI_CLIENT_COMPRESS</B
></TT
></TD
><TD
>Use compression protocol</TD
></TR
><TR
><TD
><TT
CLASS="constant"
><B
>MYSQLI_CLIENT_FOUND_ROWS</B
></TT
></TD
><TD
>return number of matched rows, not the number of affected rows</TD
></TR
><TR
><TD
><TT
CLASS="constant"
><B
>MYSQLI_CLIENT_IGNORE_SPACE</B
></TT
></TD
><TD
>Allow spaces after function names. Makes all function names reserved words.</TD
></TR
><TR
><TD
><TT
CLASS="constant"
><B
>MYSQLI_CLIENT_INTERACTIVE</B
></TT
></TD
><TD
>&#13;          Allow <TT
CLASS="literal"
>interactive_timeout</TT
> seconds (instead of
          <TT
CLASS="literal"
>wait_timeout</TT
> seconds) of inactivity before closing the connection
         </TD
></TR
><TR
><TD
><TT
CLASS="constant"
><B
>MYSQLI_CLIENT_SSL</B
></TT
></TD
><TD
>Use SSL (encryption)</TD
></TR
></TBODY
></TABLE
></DIV
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>注意: </B
>
        For security reasons the <TT
CLASS="constant"
><B
>MULTI_STATEMENT</B
></TT
> flag is
        not supported in PHP. If you want to execute multiple queries use the
        <A
HREF="function.mysqli-multi-query.html"
><B
CLASS="function"
>mysqli_multi_query()</B
></A
> function.
       </P
></BLOCKQUOTE
></DIV
></DD
></DL
></DIV
>
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN140842"
></A
><H2
>返回值</H2
><P
>&#13;   如果成功则返回 <TT
CLASS="constant"
><B
>TRUE</B
></TT
>，失败则返回 <TT
CLASS="constant"
><B
>FALSE</B
></TT
>。
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN140847"
></A
><H2
>范例</H2
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN140849"
></A
><P
><B
>例 1. Object oriented style</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB">&lt;?php<br /><br /></font><font color="#FF8000">/* create a connection object which is not connected */<br /></font><font color="#0000BB">$mysqli </font><font color="#007700">= </font><font color="#0000BB">mysqli_init</font><font color="#007700">();<br /><br /></font><font color="#FF8000">/* set connection options */<br /></font><font color="#0000BB">$mysqli</font><font color="#007700">-&gt;</font><font color="#0000BB">options</font><font color="#007700">(</font><font color="#0000BB">MYSQLI_INIT_COMMAND</font><font color="#007700">, </font><font color="#DD0000">"SET AUTOCOMMIT=0"</font><font color="#007700">);<br /></font><font color="#0000BB">$mysqli</font><font color="#007700">-&gt;</font><font color="#0000BB">options</font><font color="#007700">(</font><font color="#0000BB">MYSQLI_OPT_CONNECT_TIMEOUT</font><font color="#007700">, </font><font color="#0000BB">5</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* connect to server */<br /></font><font color="#0000BB">$mysqli</font><font color="#007700">-&gt;</font><font color="#0000BB">real_connect</font><font color="#007700">(</font><font color="#DD0000">'localhost'</font><font color="#007700">, </font><font color="#DD0000">'my_user'</font><font color="#007700">, </font><font color="#DD0000">'my_password'</font><font color="#007700">, </font><font color="#DD0000">'world'</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* check connection */<br /></font><font color="#007700">if (</font><font color="#0000BB">mysqli_connect_errno</font><font color="#007700">()) {<br />&nbsp;&nbsp;&nbsp;&nbsp;</font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"Connect failed: %s\n"</font><font color="#007700">, </font><font color="#0000BB">mysqli_connect_error</font><font color="#007700">());<br />&nbsp;&nbsp;&nbsp;&nbsp;exit();<br />}<br /><br /></font><font color="#0000BB">printf </font><font color="#007700">(</font><font color="#DD0000">"Connection: %s\n."</font><font color="#007700">, </font><font color="#0000BB">$mysqli</font><font color="#007700">-&gt;</font><font color="#0000BB">host_info</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$mysqli</font><font color="#007700">-&gt;</font><font color="#0000BB">close</font><font color="#007700">();<br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN140852"
></A
><P
><B
>例 2. Procedural style</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB">&lt;?php<br /><br /></font><font color="#FF8000">/* create a connection object which is not connected */<br /></font><font color="#0000BB">$link </font><font color="#007700">= </font><font color="#0000BB">mysqli_init</font><font color="#007700">();<br /><br /></font><font color="#FF8000">/* set connection options */<br /></font><font color="#0000BB">mysqli_options</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">, </font><font color="#0000BB">MYSQLI_INIT_COMMAND</font><font color="#007700">, </font><font color="#DD0000">"SET AUTOCOMMIT=0"</font><font color="#007700">);<br /></font><font color="#0000BB">mysqli_options</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">, </font><font color="#0000BB">MYSQLI_OPT_CONNECT_TIMEOUT</font><font color="#007700">, </font><font color="#0000BB">5</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* connect to server */<br /></font><font color="#0000BB">mysqli_real_connect</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">, </font><font color="#DD0000">'localhost'</font><font color="#007700">, </font><font color="#DD0000">'my_user'</font><font color="#007700">, </font><font color="#DD0000">'my_password'</font><font color="#007700">, </font><font color="#DD0000">'world'</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* check connection */<br /></font><font color="#007700">if (</font><font color="#0000BB">mysqli_connect_errno</font><font color="#007700">()) {<br />&nbsp;&nbsp;&nbsp;&nbsp;</font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"Connect failed: %s\n"</font><font color="#007700">, </font><font color="#0000BB">mysqli_connect_error</font><font color="#007700">());<br />&nbsp;&nbsp;&nbsp;&nbsp;exit();<br />}<br /><br /></font><font color="#0000BB">printf </font><font color="#007700">(</font><font color="#DD0000">"Connection: %s\n."</font><font color="#007700">, </font><font color="#0000BB">mysqli_get_host_info</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">));<br /><br /></font><font color="#0000BB">mysqli_close</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
><P
>上例将输出：</P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="screen"
>Connection: Localhost via UNIX socket</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN140857"
></A
><H2
>参见</H2
><P
>&#13;   <P
></P
><TABLE
BORDER="0"
><TBODY
><TR
><TD
><A
HREF="function.mysqli-connect.html"
><B
CLASS="function"
>mysqli_connect()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.mysqli-init.html"
><B
CLASS="function"
>mysqli_init()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.mysqli-options.html"
><B
CLASS="function"
>mysqli_options()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.mysqli-ssl-set.html"
><B
CLASS="function"
>mysqli_ssl_set()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.mysqli-close.html"
><B
CLASS="function"
>mysqli_close()</B
></A
></TD
></TR
></TBODY
></TABLE
><P
></P
>
  </P
></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="function.mysqli-query.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-real-escape-string.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>mysqli_query</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.mysqli.html"
ACCESSKEY="U"
>上一级</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>mysqli_real_escape_string</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>

Perl :: Catalyst :: PostgreSQL :: RPM Valid HTML 4.01 Transitional