Informix Functions (PDO_INFORMIX)
Introduction
PDO_INFORMIX is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to Informix databases.
Installation
To build the PDO_INFORMIX extension, the Informix Client SDK 2.81 UC1 or higher must be installed on the same system as PHP. The Informix Client SDK is available from the » IBM Informix Support Site.
PDO_INFORMIX is a » PECL extension, so follow the instructions in Installation of PECL extensions to install the PDO_INFORMIX extension. Issue the configure command to point to the location of your Informix Client SDK header files and libraries as follows:
bash$ ./configure --with-pdo-informix=/path/to/SDK[,shared]
Scrollable cursors
PDO_INFORMIX supports scrollable cursors; however, they are not enabled
by default. To enable scrollable cursor support, you must either set
ENABLESCROLLABLECURSORS=1 in the corresponding ODBC
connection settings in odbc.ini or pass
the EnableScrollableCursors=1 clause in the DSN
connection string.
Table of Contents
- PDO_INFORMIX DSN — Connecting to Informix databases
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Уровни абстракции
- Объекты данных PHP
- CUBRID Functions (PDO_CUBRID)
- Microsoft SQL Server and Sybase Functions (PDO_DBLIB)
- Firebird Functions (PDO_FIREBIRD)
- IBM Functions (PDO_IBM)
- Informix Functions (PDO_INFORMIX)
- MySQL Functions (PDO_MYSQL)
- Microsoft SQL Server Functions (PDO_SQLSRV)
- Oracle Functions (PDO_OCI)
- ODBC and DB2 Functions (PDO_ODBC)
- PostgreSQL Functions (PDO_PGSQL)
- SQLite Functions (PDO_SQLITE)
- 4D Functions (PDO_4D)
Коментарии
Informix PDO needs the INFORMIXDIR system variable available to the script running under the webserver, in my case apache 2.4.
Using setenv did not work, so I added in the systemd startup script /lib/systemd/system/apache2.service the following:
Environment=INFORMIXDIR=/opt/Informix_Software_Bundle
in the [Service] section.
Of course, the installation directory of your informix libraries may be different than /opt/Informix_Software_Bundle....