<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >fbsql_read_clob</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_read_blob" HREF="function.fbsql-read-blob.html"><LINK REL="NEXT" TITLE="fbsql_result" HREF="function.fbsql-result.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-read-blob.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.fbsql-result.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.fbsql-read-clob" ></A >fbsql_read_clob</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN60418" ></A ><P > (PHP 4 >= 4.2.0, PHP 5)</P >fbsql_read_clob -- Read a CLOB from the database</DIV ><DIV CLASS="refsect1" ><A NAME="AEN60421" ></A ><H2 >说明</H2 >string <B CLASS="methodname" >fbsql_read_clob</B > ( string clob_handle [, resource link_identifier] )<BR ></BR ><P > Reads CLOB 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_clob()</B > to get the actual CLOB data from the database. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN60436" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >clob_handle</CODE ></DT ><DD ><P > A CLOB handle, returned by <A HREF="function.fbsql-create-clob.html" ><B CLASS="function" >fbsql_create_clob()</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="AEN60455" ></A ><H2 >返回值</H2 ><P > Returns a string containing the specified CLOB data. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN60458" ></A ><H2 >范例</H2 ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN60461" ></A ><P ><B >例 1. <B CLASS="function" >fbsql_read_clob()</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 CLOB_COLUMN FROM CLOB_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 clob 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 CLOB data in the first row<br /></font><font color="#0000BB">$clob_data </font><font color="#007700">= </font><font color="#0000BB">fbsql_read_clob</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="AEN60465" ></A ><H2 >参见</H2 ><P > <P ></P ><TABLE BORDER="0" ><TBODY ><TR ><TD ><A HREF="function.fbsql-create-clob.html" ><B CLASS="function" >fbsql_create_clob()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.fbsql-read-blob.html" ><B CLASS="function" >fbsql_read_blob()</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-read-blob.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-result.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >fbsql_read_blob</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_result</TD ></TR ></TABLE ></DIV ></BODY ></HTML >