Skip to content

edgardmessias/yii2-informix

Repository files navigation

Informix Extension for Yii 2 (yii2-informix)

Latest Stable Version Total Downloads Latest Unstable Version License

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

Yii2 Build Status Total Downloads Dependency Status Reference Status

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