Informix Extension for Yii 2 (yii2-informix)

This extension adds Informix database engine extension for the Yii framework 2.0.

Requirements

• Informix Client SDK installed
• PHP module pdo_informix
• Informix Database Server 11.50 or greater

Unsupported

• Enable/Disable checkIntegrity (Bug with PHP)

Functions not supported by the Informix database:

• INSERT, UPDATE, DELETE with READ UNCOMMITTED transaction
• Batch Insert with TEXT, BLOB or CLOB data type

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist "edgardmessias/yii2-informix:*"

or add

"edgardmessias/yii2-informix": "*"

to the require section of your composer.json.

Configuration

To use this extension, simply add the following code in your application configuration:

return [
    //....
    'components' => [
        'db' => [
            'class'    => 'edgardmessias\db\informix\Connection',
            'dsn'      => 'informix:host=127.0.0.1;service=9088;database=test;server=dev;protocol=onsoctcp;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.utf8;EnableScrollableCursors=1',
            'username' => 'username',
            'password' => 'password',
        ],
    ],
];

To use CamelCase column names or aliases, enable the DELIMIDENT:

Example:

    //....
    'db' => [
        'class'    => 'edgardmessias\db\informix\Connection',
        'dsn'      => 'informix:host=127.0.0.1;service=9088;database=test;server=dev;protocol=onsoctcp;CLIENT_LOCALE=en_US.utf8;DB_LOCALE=en_US.utf8;EnableScrollableCursors=1;DELIMIDENT=y',
        'username' => 'username',
        'password' => 'password',
    ],

Or:

    //....
    'db' => [
        'class'        => 'edgardmessias\db\informix\Connection',
        'dsn'          => 'informix:DSN_NAME', //WITH DELIMIDENT ENABLED
        'isDelimident' => true,
        'username'     => 'username',
        'password'     => 'password',
    ],

Donations

• Donation is as per your goodwill to support my development.
• If you are interested in my future developments, i would really appreciate a small donation to support this project.

My Monero Wallet Address (XMR)
429VTmDsAw4aKgibxkk4PzZbxzj8txYtq5XrKHc28pXsUtMDWniL749WbwaVe4vUMveKAzAiA4j8xgUi29TpKXpm41bmrwQ

My Bitcoin Wallet Address (BTC)
38hcARGVzgYrcdYPkXxBXKTqScdixvFhZ4

My Ethereum Wallet Address (ETH)
0xdb77aa3d0e496c73a0dac816ac33ea389cf54681

Another Cryptocurrency: https://freewallet.org/id/edgardmessias