Oracle DB driver for Laravel 4|5 via OCI8
- You will find user friendly and updated documentation in the wiki here: Laravel-OCI8 Wiki
- You will find updated API documentation here: Laravel-OCI8 API
Quick Installation [Laravel 5.3]
$ composer require yajra/laravel-oci8:"5.3.*"
Quick Installation [Laravel 5.2]
$ composer require yajra/laravel-oci8:"5.2.*"
Quick Installation [Laravel 5.1]
$ composer require yajra/laravel-oci8:"5.1.*"
Laravel 4.2 & 5.0 Users
Please use 2.4 branch.
Once Composer has installed or updated your packages you need to register Laravel-OCI8. Open up
config/app.php and find the providers key and add:
Important: Since v4.0, the package will now use
Yajra\Oci8(capital Y) namespace from
yajra\Oci8to follow the name standard for vendor name.
Finally you can optionally publish a configuration file by running the following Artisan command.
If config file is not publish, the package will automatically use what is declared on your
.env file database configuartion.
$ php artisan vendor:publish --tag=oracle
This will copy the configuration file to
Note: For Laravel Lumen configuration, make sure you have a
config/database.phpfile on your project and append the configuration below:
'oracle' => [ 'driver' => 'oracle', 'tns' => env('DB_TNS', ''), 'host' => env('DB_HOST', ''), 'port' => env('DB_PORT', '1521'), 'database' => env('DB_DATABASE', ''), 'username' => env('DB_USERNAME', ''), 'password' => env('DB_PASSWORD', ''), 'charset' => env('DB_CHARSET', 'AL32UTF8'), 'prefix' => env('DB_PREFIX', ''), 'prefix_schema' => env('DB_SCHEMA_PREFIX', ''), ],
And run your laravel installation…
[Laravel 5.2++] Oracle User Provider
When using oracle, we may encounter a problem on authentication because oracle queries are case sensitive by default. By using this oracle user provider, we will now be able to avoid user issues when logging in and doing a forgot password failure because of case sensitive search.
To use, just update
auth.php config and set the driver to
'providers' => [ 'users' => [ 'driver' => 'oracle', 'model' => App\User::class, ], ]
The MIT License (MIT). Please see License File for more information.