felixarenas/adodbconect

Facilitates the use of adodb php in laravel

adodbconect

ADODBCONECT Facilitates the use of adodb php in laravel, _(*1)

• README.md
• CHANGELOG.md
• LICENSE.md
• composer.json

Install

Via Composer, _(*2)

``` bash $ composer require felixarenas/adodbconect, <sub>(*3)</sub>

## Providers

``` php
'providers' => [
    farenas\AdodbConect\Providers\AdodbConectServiceProvider::class,
    Yajra\Oci8\Oci8ServiceProvider::class,
]

Aliases

``` php 'aliases' => [ 'AdodbConect' => farenas\AdodbConect\Facades\AdodbConectFacade::class, ], <sub>(*4)</sub>

## Publish

``` php
php artisan vendor:publish --provider="farenas\AdodbConect\Providers\AdodbConectServiceProvider"

php artisan vendor:publish --tag=oracle

Config

This will copy the configuration file to php config/oracle.php, <sub>(*5)</sub>

``` 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'), ], ];, <sub>(*6)</sub>

and copy the configuration file to ``` php config/dbConfig.php ```

``` 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 php artisan vendor:publish --provider="farenas\AdodbConect\Providers\AdodbConectServiceProvider", <sub>(*7)</sub>

php artisan vendor:publish --tag=oracle, <sub>(*8)</sub>

## Usage

``` php
use AdodbConect;

$paramAdoDb = [
    'cursor' => true,
    'plsql'  => 'PackageOracle.function_package(:codUser, :codCompany);',
    'datos'  => [
        'codUser' => 2222,
        'codCompany' => 6655
    ]
];

AdodbConect::param($paramAdoDb)->run();

Change log

Please see CHANGELOG for more information on what has changed recently., <sub>(*9)</sub>

Contributing

Please see CONTRIBUTING and CODE_OF_CONDUCT for details., <sub>(*10)</sub>

Security

If you discover any security related issues, please email felixarenas7@gmail.com instead of using the issue tracker., <sub>(*11)</sub>

Credits

• [Felix Arenas Lourido]
• [All Contributors]

License

The MIT License (MIT). Please see License File for more information., <sub>(*12)</sub>