Sophie

Sophie

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

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
>fbsql_read_blob</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="PHP 手册"
HREF="index.html"><LINK
REL="UP"
TITLE="FrontBase Functions"
HREF="ref.fbsql.html"><LINK
REL="PREVIOUS"
TITLE="fbsql_query"
HREF="function.fbsql-query.html"><LINK
REL="NEXT"
TITLE="fbsql_read_clob"
HREF="function.fbsql-read-clob.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.fbsql-query.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.fbsql-read-clob.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.fbsql-read-blob"
></A
>fbsql_read_blob</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN60360"
></A
><P
>    (PHP 4 &#62;= 4.2.0, PHP 5)</P
>fbsql_read_blob&nbsp;--&nbsp;Read a BLOB from the database</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN60363"
></A
><H2
>说明</H2
>string <B
CLASS="methodname"
>fbsql_read_blob</B
> ( string blob_handle [, resource link_identifier] )<BR
></BR
><P
>&#13;   Reads BLOB data from the database.
  </P
><P
>&#13;   If a select statement contains BLOB and/or CLOB columns FrontBase will
   return the data directly when data is fetched. This default behavior can
   be changed with <A
HREF="function.fbsql-set-lob-mode.html"
><B
CLASS="function"
>fbsql_set_lob_mode()</B
></A
> so the fetch
   functions will return handles to BLOB and CLOB data.  If a handle is
   fetched a user must call <B
CLASS="function"
>fbsql_read_blob()</B
> to get the
   actual BLOB data from the database.
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN60378"
></A
><H2
>参数</H2
><P
>&#13;   <P
></P
><DIV
CLASS="variablelist"
><DL
><DT
><CODE
CLASS="parameter"
>blob_handle</CODE
></DT
><DD
><P
>&#13;       A BLOB handle, returned by <A
HREF="function.fbsql-create-blob.html"
><B
CLASS="function"
>fbsql_create_blob()</B
></A
>.
      </P
></DD
><DT
><CODE
CLASS="parameter"
>&#13;link_identifier</CODE
></DT
><DD
><P
>A FrontBase link identifier
returned by <A
HREF="function.fbsql-connect.html"
><B
CLASS="function"
>fbsql_connect()</B
></A
> or 
<A
HREF="function.fbsql-pconnect.html"
><B
CLASS="function"
>fbsql_pconnect()</B
></A
>.</P
><P
>If optional and not specified,
the function will try to find an open link to the FrontBase server and if no
such link is found it will try to create one as if 
<A
HREF="function.fbsql-connect.html"
><B
CLASS="function"
>fbsql_connect()</B
></A
> was called with no arguments</P
></DD
></DL
></DIV
>
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN60397"
></A
><H2
>返回值</H2
><P
>&#13;   Returns a string containing the specified BLOB data.
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN60400"
></A
><H2
>范例</H2
><P
>&#13;   <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN60403"
></A
><P
><B
>例 1. <B
CLASS="function"
>fbsql_read_blob()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB">&lt;?php<br />$link </font><font color="#007700">= </font><font color="#0000BB">fbsql_pconnect</font><font color="#007700">(</font><font color="#DD0000">"localhost"</font><font color="#007700">, </font><font color="#DD0000">"_SYSTEM"</font><font color="#007700">, </font><font color="#DD0000">"secret"</font><font color="#007700">)<br />&nbsp;&nbsp;&nbsp;&nbsp;or die(</font><font color="#DD0000">"Could not connect"</font><font color="#007700">);<br /></font><font color="#0000BB">$sql </font><font color="#007700">= </font><font color="#DD0000">"SELECT BLOB_COLUMN FROM BLOB_TABLE;"</font><font color="#007700">;<br /></font><font color="#0000BB">$rs </font><font color="#007700">= </font><font color="#0000BB">fbsql_query</font><font color="#007700">(</font><font color="#0000BB">$sql</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">$row_data </font><font color="#007700">= </font><font color="#0000BB">fbsql_fetch_row</font><font color="#007700">(</font><font color="#0000BB">$rs</font><font color="#007700">);<br /></font><font color="#FF8000">// $row_data[0] will now contain the blob data for the first row<br /></font><font color="#0000BB">fbsql_free_result</font><font color="#007700">(</font><font color="#0000BB">$rs</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$rs </font><font color="#007700">= </font><font color="#0000BB">fbsql_query</font><font color="#007700">(</font><font color="#0000BB">$sql</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">fbsql_set_lob_mode</font><font color="#007700">(</font><font color="#0000BB">$rs</font><font color="#007700">, </font><font color="#0000BB">FBSQL_LOB_HANDLE</font><font color="#007700">);<br /></font><font color="#0000BB">$row_data </font><font color="#007700">= </font><font color="#0000BB">fbsql_fetch_row</font><font color="#007700">(</font><font color="#0000BB">$rs</font><font color="#007700">);<br /></font><font color="#FF8000">// $row_data[0] will now contain a handle to the BLOB data in the first row<br /></font><font color="#0000BB">$blob_data </font><font color="#007700">= </font><font color="#0000BB">fbsql_read_blob</font><font color="#007700">(</font><font color="#0000BB">$row_data</font><font color="#007700">[</font><font color="#0000BB">0</font><font color="#007700">]);<br /></font><font color="#0000BB">fbsql_free_result</font><font color="#007700">(</font><font color="#0000BB">$rs</font><font color="#007700">);<br /><br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
  </P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN60407"
></A
><H2
>参见</H2
><P
>&#13;   <P
></P
><TABLE
BORDER="0"
><TBODY
><TR
><TD
><A
HREF="function.fbsql-create-blob.html"
><B
CLASS="function"
>fbsql_create_blob()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.fbsql-read-clob.html"
><B
CLASS="function"
>fbsql_read_clob()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.fbsql-set-lob-mode.html"
><B
CLASS="function"
>fbsql_set_lob_mode()</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.fbsql-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.fbsql-read-clob.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>fbsql_query</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.fbsql.html"
ACCESSKEY="U"
>上一级</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>fbsql_read_clob</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>