rexlu/laravelodbc

Adds an ODBC(PDO) driver package to Laravel 4.2, use special method.


Keywords
database, mysql, oracle, laravel
License
MIT

Documentation

odbc-driver

Adds an driver to Laravel 4.2, usable with Fluent and Eloquent.

自定各種 SQL 語法

Installation

Add rexlu/laravelodbc as a requirement to composer.json:

{
    "require": {
        "rexlu/laravelodbc": "dev-master"
    }
}

Update your packages with composer update or install with composer install.

or by command

composer require rexlu/laravelodbc:dev-master -vvv

Once Composer has installed or updated your packages you need to register LaravelODBC and the package it uses (extradb) with Laravel itself. Open up app/config/app.php and find the providers key towards the bottom.

Add the following to the list of providers:

'rexlu\Laravelodbc\ODBCServiceProvider'

Configuration

There is no separate package configuration file for LaravelODBC. You'll just add a new array to the connections array in app/config/database.php.

        'odbc' => array(
                'driver'   => 'odbc',
                'charset'  => 'utf8',
                'username' => 'xxxxxUserxxxxxx',
                'password' => 'xxxxxxpasswordxxxx',
                'database' => 'xxxxxxDBxxxxxx',
                'prefix'   => '',
            ),

        ),

The ODBC driver is different from the pre-installed ones in that you're going to pass in the DSN instead of having Laravel build it for you. There are just too many ways to configure an ODBC database for this package to do it for you. Some sample configurations are at php.net.

Don't forget to update your default database connection.