<!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="Manual do PHP" HREF="index.html"><LINK REL="UP" TITLE="MySQL Melhorada" 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" >Manual do PHP</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.mysqli-query.html" ACCESSKEY="P" >Anterior</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" >Próxima</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="AEN135457" ></A ><P > (PHP 5)</P >mysqli_real_connect<P > (no version information, might be only in CVS)</P >mysqli->real_connect() -- Opens a connection to a mysql server</DIV ><DIV CLASS="refsect1" ><A NAME="AEN135461" ></A ><H2 >Descrição</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 > Establish a connection to a MySQL database engine. </P ><P > This function differs from <A HREF="function.mysqli-connect.html" ><B CLASS="function" >mysqli_connect()</B ></A >: </P ><P ></P ><UL ><LI ><P > <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 > 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 > There is a <CODE CLASS="parameter" >flags</CODE > parameter. </P ></LI ></UL ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN135533" ></A ><H2 >Parâmetros</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" > link</CODE ></DT ><DD ><P >Apenas para estilo de procedimento: Um identificador de conexão retornado por <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 > 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 > The MySQL user name. </P ></DD ><DT ><CODE CLASS="parameter" >passwd</CODE ></DT ><DD ><P > 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 > If provided will specify the default database to be used when performing queries. </P ></DD ><DT ><CODE CLASS="parameter" >port</CODE ></DT ><DD ><P > Specifies the port number to attempt to connect to the MySQL server. </P ></DD ><DT ><CODE CLASS="parameter" >socket</CODE ></DT ><DD ><P > Specifies the socket or named pipe that should be used. </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >Nota: </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 > With the parameter <CODE CLASS="parameter" >flags</CODE > you can set different connection options: </P ><DIV CLASS="table" ><A NAME="AEN135586" ></A ><P ><B >Tabela 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 > 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 >Nota: </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="AEN135620" ></A ><H2 >Valores de retornado</H2 ><P > Retorna <TT CLASS="constant" ><B >TRUE</B ></TT > em caso de sucesso ou <TT CLASS="constant" ><B >FALSE</B ></TT > em falhas. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN135625" ></A ><H2 >Exemplos</H2 ><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN135627" ></A ><P ><B >Exemplo 1. Object oriented style</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?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">-></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">-></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">-></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 /> </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 /> 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">-></font><font color="#0000BB">host_info</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">close</font><font color="#007700">();<br /></font><font color="#0000BB">?></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="AEN135630" ></A ><P ><B >Exemplo 2. Procedural style</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?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 /> </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 /> 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">?></font> </font> </code></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE ><P >O exemplo acima irá imprimir:</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="AEN135635" ></A ><H2 >Veja também</H2 ><P > <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" >Anterior</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Principal</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.mysqli-real-escape-string.html" ACCESSKEY="N" >Próxima</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" >Acima</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >mysqli_real_escape_string</TD ></TR ></TABLE ></DIV ></BODY ></HTML >