<HTML
><HEAD
><TITLE
>ingres_query</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Manual de PHP"
HREF="index.html"><LINK
REL="UP"
TITLE="Ingres II functions"
HREF="ref.ingres.html"><LINK
REL="PREVIOUS"
TITLE="ingres_pconnect"
HREF="function.ingres-pconnect.html"><LINK
REL="NEXT"
TITLE="ingres_rollback"
HREF="function.ingres-rollback.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></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"
>Manual de PHP</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.ingres-pconnect.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.ingres-rollback.html"
ACCESSKEY="N"
>Siguiente</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.ingres-query"
></A
>ingres_query</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN32494"
></A
><P
> (PHP 4 >= 4.0.2)</P
>ingres_query -- Send a SQL query to Ingres II</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN32497"
></A
><H2
>Description</H2
>bool <B
CLASS="methodname"
>ingres_query</B
> ( string query [, resource link])<BR
></BR
><P
> Returns <TT
CLASS="constant"
><B
>TRUE</B
></TT
> on success, or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> on failure.
</P
><P
> <B
CLASS="function"
>ingres_query()</B
> sends the given
<TT
CLASS="parameter"
><I
>query</I
></TT
> to the Ingres server. This query
must be a valid SQL query (see the Ingres SQL reference guide)
</P
><P
> The query becomes part of the currently open transaction.
If there is no open transaction, <B
CLASS="function"
>ingres_query()</B
>
opens a new transaction. To close the transaction, you can either
call <A
HREF="function.ingres-commit.html"
><B
CLASS="function"
>ingres_commit()</B
></A
> to commit the changes made
to the database or <A
HREF="function.ingres-rollback.html"
><B
CLASS="function"
>ingres_rollback()</B
></A
> to cancel these
changes. When the script ends, any open transaction is rolled back
(by calling <A
HREF="function.ingres-rollback.html"
><B
CLASS="function"
>ingres_rollback()</B
></A
>). You can also
use <A
HREF="function.ingres-autocommit.html"
><B
CLASS="function"
>ingres_autocommit()</B
></A
> before opening a new
transaction to have every SQL query immediatly commited.
</P
><P
> Some types of SQL queries can't be sent with this function :
<P
></P
><UL
><LI
><P
>close (see <A
HREF="function.ingres-close.html"
><B
CLASS="function"
>ingres_close()</B
></A
>).</P
></LI
><LI
><P
>commit (see <A
HREF="function.ingres-commit.html"
><B
CLASS="function"
>ingres_commit()</B
></A
>).</P
></LI
><LI
><P
>connect (see <A
HREF="function.ingres-connect.html"
><B
CLASS="function"
>ingres_connect()</B
></A
>).</P
></LI
><LI
><P
>disconnect (see <A
HREF="function.ingres-close.html"
><B
CLASS="function"
>ingres_close()</B
></A
>).</P
></LI
><LI
><P
>get dbevent</P
></LI
><LI
><P
>prepare to commit</P
></LI
><LI
><P
> rollback (see <A
HREF="function.ingres-rollback.html"
><B
CLASS="function"
>ingres_rollback()</B
></A
>).
</P
></LI
><LI
><P
>savepoint</P
></LI
><LI
><P
> set autocommit (see <A
HREF="function.ingres-autocommit.html"
><B
CLASS="function"
>ingres_autocommit()</B
></A
>).
</P
></LI
><LI
><P
>all cursor related queries are unsupported</P
></LI
></UL
>
</P
><P
> <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN32549"
></A
><P
><B
>Ejemplo 1. <B
CLASS="function"
>ingres_query()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="php"
><?php
ingres_connect ($database, $user, $password);
ingres_query ("select * from table");
while ($row = ingres_fetch_row()) {
echo $row[1];
echo $row[2];
}
?></PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
</P
><P
> See also
<A
HREF="function.ingres-fetch-array.html"
><B
CLASS="function"
>ingres_fetch_array()</B
></A
>,
<A
HREF="function.ingres-fetch-object.html"
><B
CLASS="function"
>ingres_fetch_object()</B
></A
>,
<A
HREF="function.ingres-fetch-row.html"
><B
CLASS="function"
>ingres_fetch_row()</B
></A
>,
<A
HREF="function.ingres-commit.html"
><B
CLASS="function"
>ingres_commit()</B
></A
>,
<A
HREF="function.ingres-rollback.html"
><B
CLASS="function"
>ingres_rollback()</B
></A
> and
<A
HREF="function.ingres-autocommit.html"
><B
CLASS="function"
>ingres_autocommit()</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.ingres-pconnect.html"
ACCESSKEY="P"
>Anterior</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Inicio</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.ingres-rollback.html"
ACCESSKEY="N"
>Siguiente</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>ingres_pconnect</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.ingres.html"
ACCESSKEY="U"
>Subir</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>ingres_rollback</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
