PHP code example of masoud5070 / laravel-oci8
1. Go to this page and download the library: Download masoud5070/laravel-oci8 library . Choose the download type require .
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
masoud5070 / laravel-oci8 example snippets
Yajra\Oci8\Oci8ServiceProvider::class,
'oracle' => [
'driver' => 'oracle',
'tns' => env('DB_TNS', ''),
'host' => env('DB_HOST', ''),
'port' => env('DB_PORT', '1521'),
'database' => env('DB_DATABASE', ''),
'service_name' => env('DB_SERVICE_NAME', ''),
'username' => env('DB_USERNAME', ''),
'password' => env('DB_PASSWORD', ''),
'charset' => env('DB_CHARSET', 'AL32UTF8'),
'prefix' => env('DB_PREFIX', ''),
'prefix_schema' => env('DB_SCHEMA_PREFIX', ''),
'edition' => env('DB_EDITION', 'ora$base'),
'server_version' => env('DB_SERVER_VERSION', '11g'),
'load_balance' => env('DB_LOAD_BALANCE', 'yes'),
'dynamic' => [],
],
'oracle' => [
'driver' => 'oracle',
'host' => 'oracle.host',
'port' => '1521',
'database' => 'xe',
'service_name' => 'sid_alias',
'username' => 'hr',
'password' => 'hr',
'charset' => '',
'prefix' => '',
]
'oracle' => [
'driver' => 'oracle',
'host' => 'oracle.host',
'port' => '1521',
'service_name' => 'sid_alias',
'prefix' => 'schemaowner',
'dynamic' => [App\Models\Oracle\Config::class, 'dynamicConfig'],
]
namespace App\Models\Oracle;
class Config {
public static function dynamicConfig(&$config) {
if (Illuminate\Support\Facades\Auth::check()) {
$config['username'] = App\Oracle\Config::getOraUser();
$config['password'] = App\Oracle\Config::getOraPass();
}
}
}
'providers' => [
'users' => [
'driver' => 'oracle',
'model' => App\User::class,
],
]
bash
php artisan vendor:publish --tag=oracle