ADODBCONECT Facilitates the use of adodb php in laravel
Via Composer
$ composer require felixarenas/adodbconect
'providers' => [
farenas\AdodbConect\Providers\AdodbConectServiceProvider::class,
Yajra\Oci8\Oci8ServiceProvider::class,
]
'aliases' => [
'AdodbConect' => farenas\AdodbConect\Facades\AdodbConectFacade::class,
]
php artisan vendor:publish --provider="farenas\AdodbConect\Providers\AdodbConectServiceProvider"
php artisan vendor:publish --tag=oracle
This will copy the configuration file to php config/oracle.php
return [
'oracle' => [
'driver' => config('dbConfig.DB_DRIVER'),
'tns' => config('dbConfig.DB_TNS'),
'host' => config('dbConfig.DB_HOST'),
'port' => config('dbConfig.DB_PORT'),
'database' => config('dbConfig.DB_DATABASE'),
'username' => config('dbConfig.DB_USERNAME'),
'password' => config('dbConfig.DB_PASSWORD'),
'charset' => config('dbConfig.DB_CHARSET'),
'prefix' => config('dbConfig.DB_PREFIX'),
'prefix_schema' => config('dbConfig.DB_SCHEMA_PREFIX'),
'server_version' => config('dbConfig.DB_SERVER_VERSION'),
],
];
and copy the configuration file to php config/dbConfig.php
return [
'DB_DRIVER' => 'oracle',
'DB_CONNECTION' => 'oracle',
'DB_HOST' => 'localhost',
'DB_PORT' => '1070',
'DB_DATABASE' => 'name_db',
'DB_USERNAME' => 'root',
'DB_PASSWORD' => 'password',
'DB_TNS' => 'tns_names',
'DB_CHARSET' => 'AL32UTF8',
'DB_PREFIX' => '',
'DB_SCHEMA_PREFIX' => '',
'DB_SERVER_VERSION' => '11g',
'STRIP_TAGS' => true,
'EXCEP_TAGS' => '', //'<p><a><h1>'
];
php artisan vendor:publish --provider="farenas\AdodbConect\Providers\AdodbConectServiceProvider"
php artisan vendor:publish --tag=oracle
use AdodbConect;
$paramAdoDb = [
'cursor' => true,
'plsql' => 'PackageOracle.function_package(:codUser, :codCompany);',
'datos' => [
'codUser' => 2222,
'codCompany' => 6655
]
];
AdodbConect::param($paramAdoDb)->run();
Please see CHANGELOG for more information on what has changed recently.
Please see CONTRIBUTING and CODE_OF_CONDUCT for details.
If you discover any security related issues, please email felixarenas7@gmail.com instead of using the issue tracker.
- [Felix Arenas Lourido]
- [All Contributors]
The MIT License (MIT). Please see License File for more information.