Sophie: php-manual-pt_BR-5.2.4-1mdv2008.1 noarch

php-manual-pt_BR-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
>mysql_ping</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="Funções do MySQL"
HREF="ref.mysql.html"><LINK
REL="PREVIOUS"
TITLE="mysql_pconnect"
HREF="function.mysql-pconnect.html"><LINK
REL="NEXT"
TITLE="mysql_query"
HREF="function.mysql-query.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.mysql-pconnect.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.mysql-query.html"
ACCESSKEY="N"
>Próxima</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.mysql-ping"
></A
>mysql_ping</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN131706"
></A
><P
>    (PHP 4 &#62;= 4.3.0, PHP 5)</P
>mysql_ping&nbsp;--&nbsp;pinga uma conexão com o servidor ou reconecta se não houver conexão</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN131709"
></A
><H2
>Descrição</H2
>bool <B
CLASS="methodname"
>mysql_ping</B
> ( [resource link_identifier] )<BR
></BR
><P
>&#13;   Confere se uma conexão com um servidor esta funcionando
   ou não. Se ela tiver caído, tenta realizar uma conexão automatica.
   Esta função pode ser usada em scripts que permanecem inativos por
   um longo tempo, para conferir se o servidor fechou ou não a conexão
   e reconectar se necessário.
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN131718"
></A
><H2
>Parâmetros</H2
><P
>&#13;   <P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><CODE
CLASS="parameter"
>&#13; link_identifier</CODE
></DT
><DD
><P
>A conexão MySQL. se o identificador
 de conexão não for especificado, a ultima conexão aberta por
 <A
HREF="function.mysql-connect.html"
><B
CLASS="function"
>mysql_connect()</B
></A
> é assumida. Se uma conexão assim não for encontrada,
 ela irá tentar criar uma como se a função <A
HREF="function.mysql-connect.html"
><B
CLASS="function"
>mysql_connect()</B
></A
> fosse chamada
 sem argumentos. Se uma conexão não for encontrada ou estabelecida, um
 aviso de nível <TT
CLASS="constant"
><B
>E_WARNING</B
></TT
> é gerado.</P
></DD
></DL
></DIV
>
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN131730"
></A
><H2
>Valores de retornado</H2
><P
>&#13;   Retorna <TT
CLASS="constant"
><B
>TRUE</B
></TT
> se a conexão com o servidor MySQL esta funcionando,
   se não retorna <TT
CLASS="constant"
><B
>FALSE</B
></TT
>.
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN131735"
></A
><H2
>Exemplos</H2
><P
>&#13;   <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN131738"
></A
><P
><B
>Exemplo 1. Exemplo <B
CLASS="function"
>mysql_ping()</B
></B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB">&lt;?php<br />set_time_limit</font><font color="#007700">(</font><font color="#0000BB">0</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$conn </font><font color="#007700">= </font><font color="#0000BB">mysql_connect</font><font color="#007700">(</font><font color="#DD0000">'localhost'</font><font color="#007700">, </font><font color="#DD0000">'mysqluser'</font><font color="#007700">, </font><font color="#DD0000">'mypass'</font><font color="#007700">);<br /></font><font color="#0000BB">$db&nbsp;&nbsp;&nbsp;</font><font color="#007700">= </font><font color="#0000BB">mysql_select_db</font><font color="#007700">(</font><font color="#DD0000">'mydb'</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* Assuming this query will take a long time */<br /></font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">mysql_query</font><font color="#007700">(</font><font color="#0000BB">$sql</font><font color="#007700">);<br />if (!</font><font color="#0000BB">$result</font><font color="#007700">) {<br />&nbsp;&nbsp;&nbsp;&nbsp;echo </font><font color="#DD0000">'Query #1 failed, exiting.'</font><font color="#007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;exit;<br />}<br /><br /></font><font color="#FF8000">/* Make sure the connection is still alive, if not, try to reconnect */<br /></font><font color="#007700">if (!</font><font color="#0000BB">mysql_ping</font><font color="#007700">(</font><font color="#0000BB">$conn</font><font color="#007700">)) {<br />&nbsp;&nbsp;&nbsp;&nbsp;echo </font><font color="#DD0000">'Lost connection, exiting after query #1'</font><font color="#007700">;<br />&nbsp;&nbsp;&nbsp;&nbsp;exit;<br />}<br /></font><font color="#0000BB">mysql_free_result</font><font color="#007700">(</font><font color="#0000BB">$result</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* So the connection is still alive, let's run another query */<br /></font><font color="#0000BB">$result2 </font><font color="#007700">= </font><font color="#0000BB">mysql_query</font><font color="#007700">(</font><font color="#0000BB">$sql2</font><font color="#007700">);<br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN131742"
></A
><H2
>Veja também</H2
><P
>&#13;   <P
></P
><TABLE
BORDER="0"
><TBODY
><TR
><TD
><A
HREF="function.mysql-thread-id.html"
><B
CLASS="function"
>mysql_thread_id()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.mysql-list-processes.html"
><B
CLASS="function"
>mysql_list_processes()</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.mysql-pconnect.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.mysql-query.html"
ACCESSKEY="N"
>Próxima</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>mysql_pconnect</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.mysql.html"
ACCESSKEY="U"
>Acima</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>mysql_query</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>