Download the PHP package thalfm/laravel-db2 without Composer
On this page you can find all versions of the php package thalfm/laravel-db2. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package laravel-db2
laravel-db2
laravel-db2 is a simple DB2 service provider for Laravel. It provides DB2 Connection by extending the Illuminate Database component of the laravel framework.
- Installation
- Configuration
- Usage
Installation
Add laravel-db2 to your composer.json file:
Use composer to install this package.
Registering the Package
Add the laravel-db2 Service Provider to your config in app/config/app.php
:
Configuration
There are two ways to configure laravel-db2. You can choose the most convenient way for you. You can put your DB2 credentials into app/config/database.php
(option 1) file or use package config file which you can generate through command line by artisan (option 2).
Please check appropriate specific DSN parameters for your connection. For instance here are the ODBC keywords for IBMi https://www.ibm.com/support/knowledgecenter/fr/ssw_ibm_i_73/rzaik/connectkeywords.htm
If you encounter issues with char fields containing characters outside the invariant character set (for example: "ü") please see : https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014094907 For PHP applications using the UTF8 locale the workaround to prevent the extra garbage data is to set the following connection string keyword: DEBUG = 65536
Option 1: Configure DB2 using app/config/database.php
file
Simply add this code at the end of your app/config/database.php
file:
driver setting can be:
- 'db2_ibmi_odbc' for IBMi ODBC connection
- 'db2_ibmi_ibm' for IBMi PDO_IBM connection
- 'db2_zos_odbc' for zOS ODBC connection
- 'db2_expressc_odbc for Express-C ODBC connection
Then if driver is 'db2_*_odbc', database must be set to ODBC connection name. if driver is 'db2_ibmi_ibm', database must be set to IBMi database name (WRKRDBDIRE).
Option 2: Configure DB2 using package config file
Run on the command line from the root of your project:
Set your laravel-db2 credentials in app/config/db2.php
the same way as above
Usage
Consult the Laravel framework documentation.