<!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 >= 4.2.0, PHP 5)</P >fbsql_read_blob -- 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 > Reads BLOB data from the database. </P ><P > 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 > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >blob_handle</CODE ></DT ><DD ><P > 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" > 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 > Returns a string containing the specified BLOB data. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN60400" ></A ><H2 >范例</H2 ><P > <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"><?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 /> 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">?></font> </font> </code></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN60407" ></A ><H2 >参见</H2 ><P > <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 >