<HTML ><HEAD ><TITLE >Ingres II functions</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="Function Reference" HREF="funcref.html"><LINK REL="PREVIOUS" TITLE="ibase_trans" HREF="function.ibase-trans.html"><LINK REL="NEXT" TITLE="ingres_autocommit" HREF="function.ingres-autocommit.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="reference" 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 Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.ibase-trans.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.ingres-autocommit.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="reference" ><A NAME="ref.ingres" ></A ><DIV CLASS="TITLEPAGE" ><H1 CLASS="title" >XLV. Ingres II functions</H1 ><DIV CLASS="PARTINTRO" ><A NAME="AEN40953" ></A ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ingres.intro" ></A >Introduction</H1 ><P > These functions allow you to access Ingres II database servers. </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >Note: </B > If you already used PHP extensions to access other database servers, note that Ingres doesn't allow concurrent queries and/or transaction over one connection, thus you won't find any result or transaction handle in this extension. The result of a query must be treated before sending another query, and a transaction must be commited or rolled back before opening another transaction (which is automaticaly done when sending the first query). </P ></BLOCKQUOTE ></DIV ><DIV CLASS="warning" ><P ></P ><TABLE CLASS="warning" BORDER="1" WIDTH="100%" ><TR ><TD ALIGN="CENTER" ><B >Warning</B ></TD ></TR ><TR ><TD ALIGN="LEFT" ><P >This extension is <SPAN CLASS="emphasis" ><I CLASS="emphasis" >EXPERIMENTAL</I ></SPAN >. The behaviour of this extension -- including the names of its functions and anything else documented about this extension -- may change without notice in a future release of PHP. Use this extension at your own risk.</P ></TD ></TR ></TABLE ></DIV ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ingres.requirements" ></A >Requirements</H1 ><P > To compile PHP with Ingres support, you need the Open API library and header files included with Ingres II. </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ingres.installation" ></A >Installation</H1 ><P > In order to have these functions available, you must compile PHP with Ingres support by using the <TT CLASS="option" >--with-ingres[=DIR]</TT > option, where DIR is the Ingres base directory, which defaults to <TT CLASS="filename" >/II/ingres</TT >. If the II_SYSTEM environment variable isn't correctly set you may have to use <TT CLASS="option" >--with-ingres=DIR</TT > to specify your Ingres installation directory. </P ><P > When using this extension with Apache, if Apache does not start and complains with "PHP Fatal error: Unable to start ingres_ii module in Unknown on line 0" then make sure the environement variable II_SYSTEM is correctly set. Adding "export II_SYSTEM="/home/ingres/II" in the script that starts Apache, just before launching httpd, should be fine. </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ingres.configuration" ></A >Runtime Configuration</H1 ><P > The behaviour of these functions is affected by settings in <TT CLASS="filename" >php.ini</TT >. </P ><P > <DIV CLASS="table" ><A NAME="AEN40977" ></A ><P ><B >Table 1. Ingres II configuration options</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Name</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Default</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Changeable</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ingres.allow_persistent</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"1"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ingres.max_persistent</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"-1"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ingres.max_links</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >"-1"</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_SYSTEM</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ingres.default_database</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >NULL</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ingres.default_user</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >NULL</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >ingres.default_password</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >NULL</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >PHP_INI_ALL</TD ></TR ></TBODY ></TABLE ></DIV > For further details and definition of the PHP_INI_* constants see <A HREF="function.ini-set.html" ><B CLASS="function" >ini_set()</B ></A >. </P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ingres.resources" ></A >Resource Types</H1 ><P >This extension has no resource types defined.</P ></DIV ><DIV CLASS="section" ><H1 CLASS="section" ><A NAME="ingres.constants" ></A >Predefined Constants</H1 ><P > The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime. </P ><P ></P ><DIV CLASS="variablelist" ><DL ><DT ><TT CLASS="constant" ><B >INGRES_ASSOC</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >INGRES_NUM</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ><DT ><TT CLASS="constant" ><B >INGRES_BOTH</B ></TT > (<A HREF="language.types.integer.html" >integer</A >)</DT ><DD ><P > </P ></DD ></DL ></DIV ></DIV ></DIV ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT ><A HREF="function.ingres-autocommit.html" >ingres_autocommit</A > -- Switch autocommit on or off</DT ><DT ><A HREF="function.ingres-close.html" >ingres_close</A > -- Close an Ingres II database connection</DT ><DT ><A HREF="function.ingres-commit.html" >ingres_commit</A > -- Commit a transaction</DT ><DT ><A HREF="function.ingres-connect.html" >ingres_connect</A > -- Open a connection to an Ingres II database </DT ><DT ><A HREF="function.ingres-fetch-array.html" >ingres_fetch_array</A > -- Fetch a row of result into an array</DT ><DT ><A HREF="function.ingres-fetch-object.html" >ingres_fetch_object</A > -- Fetch a row of result into an object.</DT ><DT ><A HREF="function.ingres-fetch-row.html" >ingres_fetch_row</A > -- Fetch a row of result into an enumerated array </DT ><DT ><A HREF="function.ingres-field-length.html" >ingres_field_length</A > -- Get the length of a field</DT ><DT ><A HREF="function.ingres-field-name.html" >ingres_field_name</A > -- Get the name of a field in a query result.</DT ><DT ><A HREF="function.ingres-field-nullable.html" >ingres_field_nullable</A > -- Test if a field is nullable</DT ><DT ><A HREF="function.ingres-field-precision.html" >ingres_field_precision</A > -- Get the precision of a field</DT ><DT ><A HREF="function.ingres-field-scale.html" >ingres_field_scale</A > -- Get the scale of a field</DT ><DT ><A HREF="function.ingres-field-type.html" >ingres_field_type</A > -- Get the type of a field in a query result </DT ><DT ><A HREF="function.ingres-num-fields.html" >ingres_num_fields</A > -- Get the number of fields returned by the last query </DT ><DT ><A HREF="function.ingres-num-rows.html" >ingres_num_rows</A > -- Get the number of rows affected or returned by the last query </DT ><DT ><A HREF="function.ingres-pconnect.html" >ingres_pconnect</A > -- Open a persistent connection to an Ingres II database </DT ><DT ><A HREF="function.ingres-query.html" >ingres_query</A > -- Send a SQL query to Ingres II</DT ><DT ><A HREF="function.ingres-rollback.html" >ingres_rollback</A > -- Roll back a transaction</DT ></DL ></DIV ></DIV ></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-trans.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.ingres-autocommit.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >ibase_trans</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="funcref.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ingres_autocommit</TD ></TR ></TABLE ></DIV ></BODY ></HTML >