dbmaker/laravel-odbc

DBMaker integration for Laravel framework

1.4.0 2023-02-02 02:37 UTC

Requires

• php: >=7.3
• illuminate/database: >5.8
• laravel/framework: >5.8

MIT

• syscom

• database
• pdo
• odbc
• laravel
• dbmaker

README

laravel-dbmaker is a DBMaker service provider for Laravel. It provides DBMaker Connection by extending the Illuminate Database component of the laravel framework.

How to install

composer require dbmaker/laravel-odbc To add source in your project

install php_odbc for dbmaker

We suggest using the libary we build

1. Download URL https://github.com/dbmaker-go/php_ext/releases/download/1.0.0/php_dbmaker-5.4-7.3-Linux2_x86_64.tgz and unzip
2. According to your DBMaker version to choice bundle or standard
3. rename pdo_odbc.ini to 20-pdo_odbc.ini and move to /etc/php.d/
4. copy pdo_odbc.so to /usr/lib64/php/modules/
5. php -m Check if the installation was successful

you can follow this step

# wget https://github.com/dbmaker-go/php_ext/releases/download/1.0.0/php_dbmaker-5.4-7.3-Linux2_x86_64.tgz
# tar zxvf php_dbmaker-5.4-7.3-Linux2_x86_64.tgz
# mv php_dbmaker/bundle/pdo_odbc.ini /etc/php.d/20-pdo-odbc.ini
# mv php_dbmaker/bundle/pdo_odbc.so /usr/lib64/php/modules/pdo-odbc.so
# php -m

Note: If your default installation directory of DBMaker standard is not /home/dbmaker/5.4 or bundle is not /opt/dbmaker, please add installation directory to LD_LIBRARY_PATH environment variable.

Usage Instructions

It's very simple to configure:

1) Add database to database.php file

'dbmaker' => [
    'driver' => 'odbc',
    'dsn' => 'odbc:DSN=DBNAME',
    'database' => 'DBNAME',
    'host' => 'localhost',
    'username' => 'username',
    'password' => 'password',
    'options' => [
            'idcap' => 1   //please set the value same as your server db_idcap
    ]
]

2) set default database to dbmaker

'default' =>  'dbmaker',

3) testing

# php artisan make:command MyCommand

# vi app/Console/Commands/MyCommand.php

find

protected $signature = 'command:name';

change to

protected $signature = 'my:command';

and add test code

public function handle()
{
    $data= \DB::table('TA1')->get('C1');
	print_R($data);
}

# vi app/Console/Kernel.php

protected $commands = [
    // ...
    Commands\MyCommand::class,  //add this
];

run

# php artisan my:command

Laravel DB Usage

Consult the Laravel framework documentation