billcunha / laravel-oci8 by billcunha
forked from yajra/laravel-oci8

Oracle DB driver for Laravel 4|5 via OCI8
21
0
2
oracle laravel laravel4 oci8 pdo_oci laravel5
Github Link
Packagist Link
Package Data
Maintainer Username: billcunha
Maintainer Contact: billcunha@gmail.com (Bill Cunha)
Package Create Date: 2017-08-25
Package Last Update: 2017-08-25
Home Page: https://yajrabox.com/docs/laravel-oci8
Language: PHP
License: MIT
Last Refreshed: 2024-05-03 15:10:39
Package Statistics
Total Downloads: 21
Monthly Downloads: 0
Daily Downloads: 0
Total Stars: 0
Total Watchers: 2
Total Forks: 0
Total Open Issues: 0

Oracle DB driver for Laravel 4|5 via OCI8

Laravel-OCI8

Latest Version on Packagist Software License Build Status Coverage Status Quality Score Total Downloads

Laravel-OCI8 is an Oracle Database Driver package for Laravel. Laravel-OCI8 is an extension of Illuminate/Database that uses OCI8 extension to communicate with Oracle. Thanks to @taylorotwell.

Documentations

Quick Installation [Laravel 5.4]

$ composer require yajra/laravel-oci8:"5.4.*"

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.

Service Provider

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:

Yajra\Oci8\Oci8ServiceProvider::class,

Important: Since v4.0, the package will now use Yajra\Oci8 (capital Y) namespace from yajra\Oci8 to follow the name standard for vendor name.

Configuration (OPTIONAL)

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 configuration.

$ php artisan vendor:publish --tag=oracle

This will copy the configuration file to config/oracle.php.

Note: For Laravel Lumen configuration, make sure you have a config/database.php file 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 oracle

'providers' => [
	'users' => [
		'driver' => 'oracle',
		'model' => App\User::class,
	],
]

Credits

License

The MIT License (MIT). Please see License File for more information.

Buy me a beer