Sophie

Sophie

distrib > Mandriva > 9.1 > ppc > media > main > by-pkgid > 0afeee9cca140e167a996902b9a677c5 > files > 580

php-manual-en-4.3.0-2mdk.noarch.rpm

<HTML
><HEAD
><TITLE
>fbsql_fetch_object</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="PHP Manual"
HREF="index.html"><LINK
REL="UP"
TITLE="FrontBase Functions"
HREF="ref.fbsql.html"><LINK
REL="PREVIOUS"
TITLE="fbsql_fetch_lengths"
HREF="function.fbsql-fetch-lengths.html"><LINK
REL="NEXT"
TITLE="fbsql_fetch_row"
HREF="function.fbsql-fetch-row.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></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 Manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.fbsql-fetch-lengths.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.fbsql-fetch-row.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.fbsql-fetch-object"
></A
>fbsql_fetch_object</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN23932"
></A
><P
>    (PHP 4 &#62;= 4.0.6)</P
>fbsql_fetch_object&nbsp;--&nbsp;Fetch a result row as an object</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN23935"
></A
><H2
>Description</H2
>object <B
CLASS="methodname"
>fbsql_fetch_object</B
> ( resource result [, int result_type])<BR
></BR
><P
> 
     Returns an object with properties that correspond to the fetched
     row, or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if there are no more rows.
    </P
><P
> 
     <B
CLASS="function"
>fbsql_fetch_object()</B
> is similar to
     <A
HREF="function.fbsql-fetch-array.html"
><B
CLASS="function"
>fbsql_fetch_array()</B
></A
>, with one difference - an
     object is returned, instead of an array.  Indirectly, that means
     that you can only access the data by the field names, and not by
     their offsets (numbers are illegal property names).
    </P
><P
>&#13;     The optional argument <TT
CLASS="parameter"
><I
>result_type</I
></TT
> is a
     constant and can take the following values: FBSQL_ASSOC,
     FBSQL_NUM, and FBSQL_BOTH.
    </P
><P
>&#13;     Speed-wise, the function is identical to
     <A
HREF="function.fbsql-fetch-array.html"
><B
CLASS="function"
>fbsql_fetch_array()</B
></A
>, and almost as quick as
     <A
HREF="function.fbsql-fetch-row.html"
><B
CLASS="function"
>fbsql_fetch_row()</B
></A
> (the difference is
     insignificant).
     <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN23956"
></A
><P
><B
>Example 1. <B
CLASS="function"
>fbsql_fetch_object()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="php"
>&#60;?php 
fbsql_connect ($host, $user, $password);
$result = fbsql_db_query ("database", "select * from table");
while ($row = fbsql_fetch_object ($result)) {
    echo $row-&#62;user_id;
    echo $row-&#62;fullname;
}
fbsql_free_result ($result);
?&#62;</PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
    </P
><P
> 
     See also: <A
HREF="function.fbsql-fetch-array.html"
><B
CLASS="function"
>fbsql_fetch_array()</B
></A
> and
     <A
HREF="function.fbsql-fetch-row.html"
><B
CLASS="function"
>fbsql_fetch_row()</B
></A
>.
    </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.fbsql-fetch-lengths.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.fbsql-fetch-row.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>fbsql_fetch_lengths</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.fbsql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>fbsql_fetch_row</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>