edgardmessias/yii2-informix

Informix Driver for Yii2 Framework.

Informix Extension for Yii 2 (yii2-informix)

, _(*1)

This extension adds Informix database engine extension for the Yii framework 2.0., _(*2)

, _(*3)

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:, _(*4)

• 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., _(*5)

Either run, _(*6)

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

or add, _(*7)

"edgardmessias/yii2-informix": "*"

to the require section of your composer.json., _(*8)

Configuration

To use this extension, simply add the following code in your application configuration:, _(*9)

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:, _(*10)

Example:, _(*11)

    //....
    '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:, _(*12)

    //....
    '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

```html My Bitcoin Wallet Address (BTC) 38hcARGVzgYrcdYPkXxBXKTqScdixvFhZ4, <sub>(*13)</sub>

```html
My Ethereum Wallet Address (ETH)
0xdb77aa3d0e496c73a0dac816ac33ea389cf54681

Another Cryptocurrency: https://freewallet.org/id/edgardmessias, <sub>(*14)</sub>