<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>mysqli_fetch_object</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_fetch_lengths"
HREF="function.mysqli-fetch-lengths.html"><LINK
REL="NEXT"
TITLE="mysqli_fetch_row"
HREF="function.mysqli-fetch-row.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-fetch-lengths.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-fetch-row.html"
ACCESSKEY="N"
>Próxima</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.mysqli-fetch-object"
></A
>mysqli_fetch_object</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN134098"
></A
><P
> (PHP 5)</P
>mysqli_fetch_object<P
> (no version information, might be only in CVS)</P
>result->fetch_object -- Retorna a linha atual do conjunto de resultados como um objeto</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN134102"
></A
><H2
>Descrição</H2
><P
>Estilo de procedimento:</P
>mixed <B
CLASS="methodname"
>mysqli_fetch_object</B
> ( object result )<BR
></BR
><P
>Estilo orientado a objeto (metodo):</P
>class <B
CLASS="classname"
>result</B
> { <BR
></BR
>mixed <B
CLASS="methodname"
>fetch_object</B
> ( void )<BR
></BR
>}<P
> A função <B
CLASS="function"
>mysqli_fetch_object()</B
> irá retornar a linha atual do conjunto de resultados
como um objeto aonde os atributos do objeto representam os nomes dos campos encontrados
no conjunto de resultados. Se não existirem mais linhas no conjunto de resultados atual, é retornado <TT
CLASS="constant"
><B
>NULL</B
></TT
>.
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN134122"
></A
><H2
>Valores de retorno</H2
><P
> Retorna um objeto que corresponde a linha obtida ou <TT
CLASS="constant"
><B
>NULL</B
></TT
> se não houverem mais linhas no conjunto de resultados.
</P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>Nota: </B
>Nomes de campos nesta função
<SPAN
CLASS="emphasis"
><I
CLASS="emphasis"
>diferenciam maiúsculas e minusculas</I
></SPAN
>.</P
></BLOCKQUOTE
></DIV
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>Nota: </B
>Esta função assimila campos NULL para o
o <TT
CLASS="constant"
><B
>NULL</B
></TT
> do PHP.</P
></BLOCKQUOTE
></DIV
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN134132"
></A
><H2
>Veja também</H2
><P
> <A
HREF="function.mysqli-fetch-array.html"
><B
CLASS="function"
>mysqli_fetch_array()</B
></A
>,
<A
HREF="function.mysqli-fetch-assoc.html"
><B
CLASS="function"
>mysqli_fetch_assoc()</B
></A
>,
<A
HREF="function.mysqli-fetch-row.html"
><B
CLASS="function"
>mysqli_fetch_row()</B
></A
>.
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN134138"
></A
><H2
>Exemplo</H2
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN134140"
></A
><P
><B
>Exemplo 1. Estilo orientado a objeto</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br />$mysqli </font><font color="#007700">= new </font><font color="#0000BB">mysqli</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">$query </font><font color="#007700">= </font><font color="#DD0000">"SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5"</font><font color="#007700">;<br /><br />if (</font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">query</font><font color="#007700">(</font><font color="#0000BB">$query</font><font color="#007700">)) {<br /><br /> </font><font color="#FF8000">/* fetch object array */<br /> </font><font color="#007700">while (</font><font color="#0000BB">$obj </font><font color="#007700">= </font><font color="#0000BB">$result</font><font color="#007700">-></font><font color="#0000BB">fetch_object</font><font color="#007700">()) {<br /> </font><font color="#0000BB">printf </font><font color="#007700">(</font><font color="#DD0000">"%s (%s)\n"</font><font color="#007700">, </font><font color="#0000BB">$obj</font><font color="#007700">-></font><font color="#0000BB">Name</font><font color="#007700">, </font><font color="#0000BB">$obj</font><font color="#007700">-></font><font color="#0000BB">CountryCode</font><font color="#007700">);<br /> }<br /><br /> </font><font color="#FF8000">/* free result set */<br /> </font><font color="#0000BB">$result</font><font color="#007700">-></font><font color="#0000BB">close</font><font color="#007700">();<br />}<br /><br /></font><font color="#FF8000">/* close connection */<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="AEN134143"
></A
><P
><B
>Exemplo 2. Estilo de procedimento</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br />$link </font><font color="#007700">= </font><font color="#0000BB">mysqli_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">$query </font><font color="#007700">= </font><font color="#DD0000">"SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5"</font><font color="#007700">;<br /><br />if (</font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">mysqli_query</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">, </font><font color="#0000BB">$query</font><font color="#007700">)) {<br /><br /> </font><font color="#FF8000">/* fetch associative array */<br /> </font><font color="#007700">while (</font><font color="#0000BB">$obj </font><font color="#007700">= </font><font color="#0000BB">mysqli_fetch_object</font><font color="#007700">(</font><font color="#0000BB">$result</font><font color="#007700">)) {<br /> </font><font color="#0000BB">printf </font><font color="#007700">(</font><font color="#DD0000">"%s (%s)\n"</font><font color="#007700">, </font><font color="#0000BB">$obj</font><font color="#007700">-></font><font color="#0000BB">Name</font><font color="#007700">, </font><font color="#0000BB">$obj</font><font color="#007700">-></font><font color="#0000BB">CountryCode</font><font color="#007700">);<br /> }<br /><br /> </font><font color="#FF8000">/* free result set */<br /> </font><font color="#0000BB">mysqli_free_result</font><font color="#007700">(</font><font color="#0000BB">$result</font><font color="#007700">);<br />}<br /><br /></font><font color="#FF8000">/* close connection */<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
> Os exemplos acima devem produzir a seguinte saída:
</P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="screen"
>Pueblo (USA)
Arvada (USA)
Cape Coral (USA)
Green Bay (USA)
Santa Clara (USA)</PRE
></TD
></TR
></TABLE
></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-fetch-lengths.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-fetch-row.html"
ACCESSKEY="N"
>Próxima</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>mysqli_fetch_lengths</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_fetch_row</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
