<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >fbsql_list_fields</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_list_dbs" HREF="function.fbsql-list-dbs.html"><LINK REL="NEXT" TITLE="fbsql_list_tables" HREF="function.fbsql-list-tables.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-list-dbs.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.fbsql-list-tables.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.fbsql-list-fields" ></A >fbsql_list_fields</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN59916" ></A ><P > (PHP 4 >= 4.0.6, PHP 5)</P >fbsql_list_fields -- List FrontBase result fields</DIV ><DIV CLASS="refsect1" ><A NAME="AEN59919" ></A ><H2 >说明</H2 >resource <B CLASS="methodname" >fbsql_list_fields</B > ( string database_name, string table_name [, resource link_identifier] )<BR ></BR ><P > Retrieves information about the given table. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN59934" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >database_name</CODE ></DT ><DD ><P > The database name. </P ></DD ><DT ><CODE CLASS="parameter" >table_name</CODE ></DT ><DD ><P > The table name. </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="AEN59957" ></A ><H2 >返回值</H2 ><P > Returns a result pointer which can be used with the <TT CLASS="literal" >fbsql_field_xxx</TT > functions, or <TT CLASS="constant" ><B >FALSE</B ></TT > on error. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN59962" ></A ><H2 >错误/异常</H2 ><P > A string describing the error will be placed in <TT CLASS="literal" >$phperrmsg</TT >, and unless the function was called as <TT CLASS="literal" >@fbsql()</TT > then this error string will also be printed out. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN59967" ></A ><H2 >范例</H2 ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN59970" ></A ><P ><B >例 1. <B CLASS="function" >fbsql_list_fields()</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_connect</font><font color="#007700">(</font><font color="#DD0000">'localhost'</font><font color="#007700">, </font><font color="#DD0000">'myname'</font><font color="#007700">, </font><font color="#DD0000">'secret'</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$fields </font><font color="#007700">= </font><font color="#0000BB">fbsql_list_fields</font><font color="#007700">(</font><font color="#DD0000">"database1"</font><font color="#007700">, </font><font color="#DD0000">"table1"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">$columns </font><font color="#007700">= </font><font color="#0000BB">fbsql_num_fields</font><font color="#007700">(</font><font color="#0000BB">$fields</font><font color="#007700">);<br /><br />for (</font><font color="#0000BB">$i </font><font color="#007700">= </font><font color="#0000BB">0</font><font color="#007700">; </font><font color="#0000BB">$i </font><font color="#007700">< </font><font color="#0000BB">$columns</font><font color="#007700">; </font><font color="#0000BB">$i</font><font color="#007700">++) {<br /> echo </font><font color="#0000BB">fbsql_field_name</font><font color="#007700">(</font><font color="#0000BB">$fields</font><font color="#007700">, </font><font color="#0000BB">$i</font><font color="#007700">) . </font><font color="#DD0000">"\n"</font><font color="#007700">;;<br />}<br /></font><font color="#0000BB">?></font> </font> </code></TD ></TR ></TABLE ><P >上例的输出类似于:</P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="screen" >field1 field2 field3 ...</PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN59976" ></A ><H2 >参见</H2 ><P > <P ></P ><TABLE BORDER="0" ><TBODY ><TR ><TD ><A HREF="function.fbsql-field-len.html" ><B CLASS="function" >fbsql_field_len()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.fbsql-field-name.html" ><B CLASS="function" >fbsql_field_name()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.fbsql-field-type.html" ><B CLASS="function" >fbsql_field_type()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.fbsql-field-flags.html" ><B CLASS="function" >fbsql_field_flags()</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-list-dbs.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-list-tables.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >fbsql_list_dbs</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_list_tables</TD ></TR ></TABLE ></DIV ></BODY ></HTML >