<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>ibase_query</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="PHP 手册"
HREF="index.html"><LINK
REL="UP"
TITLE="Firebird/InterBase Functions"
HREF="ref.ibase.html"><LINK
REL="PREVIOUS"
TITLE="ibase_prepare"
HREF="function.ibase-prepare.html"><LINK
REL="NEXT"
TITLE="ibase_restore"
HREF="function.ibase-restore.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.ibase-prepare.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.ibase-restore.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.ibase-query"
></A
>ibase_query</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN57462"
></A
><P
> (PHP 3 >= 3.0.6, PHP 4, PHP 5)</P
>ibase_query -- Execute a query on an InterBase database</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN57465"
></A
><H2
>Description</H2
>resource <B
CLASS="methodname"
>ibase_query</B
> ( [resource link_identifier, string query [, int bind_args]] )<BR
></BR
><P
> Performs a query on an InterBase database. If the query raises an error,
returns <TT
CLASS="constant"
><B
>FALSE</B
></TT
>. If it is successful and there is a (possibly empty)
result set (such as with a SELECT query), returns a result identifier. If
the query was successful and there were no results, returns <TT
CLASS="constant"
><B
>TRUE</B
></TT
>.
</P
><P
> <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN57483"
></A
><P
><B
>例 1. <B
CLASS="function"
>ibase_query()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br /><br /> $host </font><font color="#007700">= </font><font color="#DD0000">'localhost:/path/to/your.gdb'</font><font color="#007700">;<br /><br /> </font><font color="#0000BB">$dbh </font><font color="#007700">= </font><font color="#0000BB">ibase_connect</font><font color="#007700">(</font><font color="#0000BB">$host</font><font color="#007700">, </font><font color="#0000BB">$username</font><font color="#007700">, </font><font color="#0000BB">$password</font><font color="#007700">);<br /> </font><font color="#0000BB">$stmt </font><font color="#007700">= </font><font color="#DD0000">'SELECT * FROM tblname'</font><font color="#007700">;<br /><br /> </font><font color="#0000BB">$sth </font><font color="#007700">= </font><font color="#0000BB">ibase_query</font><font color="#007700">(</font><font color="#0000BB">$dbh</font><font color="#007700">, </font><font color="#0000BB">$stmt</font><font color="#007700">) or die(</font><font color="#0000BB">ibase_errmsg</font><font color="#007700">());<br /><br /></font><font color="#0000BB">?></font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
</P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>注意: </B
>
In PHP 5.0.0 and up, this function will return the number of rows affected by
the query for INSERT, UPDATE and DELETE statements. In order to retain backward
compatibility, it will return <TT
CLASS="constant"
><B
>TRUE</B
></TT
> for these statements if the query succeeded
without affecting any rows.
</P
></BLOCKQUOTE
></DIV
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>注意: </B
>
If you get some error like "arithmetic exception, numeric overflow,
or string truncation. Cannot transliterate character between character
sets" (this occurs when you try use some character with accents)
when using this and after <B
CLASS="function"
>ibase_query()</B
> you must
set the character set (i.e. ISO8859_1 or your current character set).
</P
></BLOCKQUOTE
></DIV
><P
> See also <A
HREF="function.ibase-errmsg.html"
><B
CLASS="function"
>ibase_errmsg()</B
></A
>,
<A
HREF="function.ibase-fetch-row.html"
><B
CLASS="function"
>ibase_fetch_row()</B
></A
>,
<A
HREF="function.ibase-fetch-object.html"
><B
CLASS="function"
>ibase_fetch_object()</B
></A
>, and
<A
HREF="function.ibase-free-result.html"
><B
CLASS="function"
>ibase_free_result()</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.ibase-prepare.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.ibase-restore.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>ibase_prepare</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.ibase.html"
ACCESSKEY="U"
>上一级</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>ibase_restore</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
