Skip to content

This extension adds IBM DB2 database engine extension for the Yii framework 2.0.

License

Notifications You must be signed in to change notification settings

edgardmessias/yii2-ibm-db2

Repository files navigation

IBM DB2 Extension for Yii 2 (yii2-ibm-db2)

Latest Stable Version Total Downloads Latest Unstable Version License

This extension adds IBM DB2 database engine extension for the Yii framework 2.0.

This branch use the last developer version of Yii2 (dev-master)

Yii2 Build Status Dependency Status Reference Status Code Coverage Scrutinizer Code Quality

Requirements

  • IBM DB2 Client SDK installed
  • PHP module pdo_ibm or pdo_odbc
  • IBM DB2 Database Server 10.1 or greater

Installation

The preferred way to install this extension is through composer.

Either run

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

or add

"edgardmessias/yii2-ibm-db2": "*"

to the require section of your composer.json.

Configuration

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

Using IBM DB2:

return [
    //....
    'components' => [
        'db' => [
            'class'         => 'edgardmessias\db\ibm\db2\Connection',
            'dsn'           => 'ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=test;HOSTNAME=127.0.0.1;PORT=50000;PROTOCOL=TCPIP',
            'username'      => 'username',
            'password'      => 'password',
            'defaultSchema' => '',
            'isISeries'     => false
        ],
    ],
];

Using ODBC IBM iAccess driver:

return [
    //....
    'components' => [
        'db' => [
            'class'         => 'edgardmessias\db\ibm\db2\Connection',
            'dsn'           => 'odbc:DRIVER={IBM i Access ODBC Driver 64-bit};SYSTEM=127.0.0.1;PROTOCOL=TCPIP',
            'username'      => 'username',
            'password'      => 'password',
            'defaultSchema' => '',
            'isISeries'     => false
        ],
    ],
];

If working on iSeries set isISeries parameter to true and fill defaultSchema.

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

About

This extension adds IBM DB2 database engine extension for the Yii framework 2.0.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages