PHP Manual
Prev |  | Next

# LXII. Ingres II Functions

# Introduction

These functions allow you to access Ingres II database servers.

> Note: 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 committed or rolled back before opening another transaction (which is automatically done when sending the first query).

# Requirements

To compile PHP with Ingres support, you need the Open API library and header files included with Ingres II.

# Installation

This PECL extension is not bundled with PHP. Additional information such as new releases, downloads, source files, maintainer information, and a CHANGELOG, can be located here: http://pecl.php.net/package/ingres.

In order to have these functions available, you must compile PHP with Ingres support by using the --with-ingres[=DIR] option, where DIR is the Ingres base directory, which defaults to `/II/ingres`. If the II_SYSTEM environment variable isn't correctly set you may have to use --with-ingres=DIR to specify your Ingres installation directory.

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 environment 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.

# Runtime Configuration

The behaviour of these functions is affected by settings in `php.ini`.

Table 1. Ingres configuration options

Name | Default | Changeable | Changelog
--- | --- | --- | ---
ingres.allow_persistent | "1" | PHP_INI_SYSTEM | Available since PHP 4.0.2.
ingres.max_persistent | "-1" | PHP_INI_SYSTEM | Available since PHP 4.0.2.
ingres.max_links | "-1" | PHP_INI_SYSTEM | Available since PHP 4.0.2.
ingres.default_database | NULL | PHP_INI_ALL | Available since PHP 4.0.2.
ingres.default_user | NULL | PHP_INI_ALL | Available since PHP 4.0.2.
ingres.default_password | NULL | PHP_INI_ALL | Available since PHP 4.0.2.
ingres.report_db_warnings | "1" | PHP_INI_ALL | Available since version 1.1.0 of the PECL extension.
ingres.cursor_mode | "0" | PHP_INI_ALL | Available since version 1.1.0 of the PECL extension.
ingres.blob_segment_length | "4096" | PHP_INI_ALL | Available since version 1.2.0 of the PECL extension.

For further details and definitions of the PHP_INI_* constants, see the Appendix G.

# Resource Types

This extension has no resource types defined.

# Predefined Constants

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.

`INGRES_ASSOC` (integer)

  Columns are returned into the array having the fieldname as the array index.

`INGRES_NUM` (integer)

  Columns are returned into the array having a numerical index to the fields. This index starts with 1, the first field in the result.

`INGRES_BOTH` (integer)

  Columns are returned into the array having both a numerical index and the fieldname as the array index.

`INGRES_EXT_VERSION` (string)

  Specifies the version of the Ingres Extension. Available since version 1.2.0 of the PECL extension.

`INGRES_API_VERSION` (integer)

  Specifies the version of Ingres OpenAPI the extension was built against. Available since version 1.2.0 of the PECL extension.

`INGRES_CURSOR_READONLY` (integer)

  Specifies that Ingres cursors should be opened in 'readonly' mode. Available since version 1.2.0 of the PECL extension.

`INGRES_CURSOR_UPDATE` (integer)

  Specifies that Ingres cursors should be opened 'for update'. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_MULTINATIONAL` (integer)

  Equivalent to the II_DATE_FORMAT setting of MULTINATIONAL. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_MULTINATIONAL4` (integer)

  Equivalent to the II_DATE_FORMAT setting of MULTINATIONAL4. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_FINNISH` (integer)

  Equivalent to the II_DATE_FORMAT setting of FINNISH. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_ISO` (integer)

  Equivalent to the II_DATE_FORMAT setting of ISO. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_ISO4` (integer)

  Equivalent to the II_DATE_FORMAT setting of ISO4. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_GERMAN` (integer)

  Equivalent to the II_DATE_FORMAT setting of GERMAN. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_MDY` (integer)

  Equivalent to the II_DATE_FORMAT setting of MDY. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_DMY` (integer)

  Equivalent to the II_DATE_FORMAT setting of DMY. Available since version 1.2.0 of the PECL extension.

`INGRES_DATE_YMD` (integer)

  Equivalent to the II_DATE_FORMAT setting of YMD. Available since version 1.2.0 of the PECL extension.

`INGRES_MONEY_LEADING` (integer)

  Specifies the currency character that should be placed at the start of a money value. Equivalent to setting II_MONEY_FORMAT to 'L:'. Available since version 1.2.0 of the PECL extension.

`INGRES_MONEY_TRAILING` (integer)

  Specifies the currency character that should be placed at the end of a money value. Equivalent to setting II_MONEY_FORMAT to 'T:'. Available since version 1.2.0 of the PECL extension.

Prev | Home | Next
PDO_INFORMIX DSN | Up | ingres_autocommit