Laravel Oracle Database Package
OracleDB (updated for 5.4)
OracleDB is an Oracle Database Driver package for Laravel Framework - thanks @taylorotwell. OracleDB is an extension of Illuminate/Database that uses either the [PDO_OCI] (http://www.php.net/manual/en/ref.pdo-oci.php) extension or the OCI8 Functions wrapped into the PDO namespace.
Please report any bugs you may find.
Installation
Add jfelder/oracledb as a requirement to composer.json:
{
"require": {
"jfelder/oracledb": "5.4.*"
}
}
And then run composer update
Once Composer has installed or updated your packages you need to register OracleDB. Open up config/app.php and find
the providers key and add:
Jfelder\OracleDB\OracleDBServiceProvider::class,
Finally you need to publish a configuration file by running the following Artisan command.
$ php artisan vendor:publish
This will copy the configuration file to config/oracledb.php
Basic Usage
The configuration file for this package is located at 'config/oracledb.php'.
In this file you define all of your oracle database connections. If you need to make more than one connection, just
copy the example one. If you want to make one of these connections the default connection, enter the name you gave the
connection into the "Default Database Connection Name" section in 'config/database.php'.
Once you have configured the OracleDB database connection(s), you may run queries using the 'DB' class as normal.
NEW: The oci8 library in now the default library. If you want to use the pdo library, enter "pdo" as the driver and the code will automatically use the pdo library instead of the oci8 library. Any other value will result in the oci8 library being used.
$results = DB::select('select * from users where id = ?', array(1));
The above statement assumes you have set the default connection to be the oracle connection you setup in
config/database.php file and will always return an 'array' of results.
$results = DB::connection('oracle')->select('select * from users where id = ?', array(1));
Just like the built-in database drivers, you can use the connection method to access the oracle database(s) you setup
in config/oracledb.php file.
Inserting Records Into A Table With An Auto-Incrementing ID
$id = DB::connection('oracle')->table('users')->insertGetId(
array('email' => 'john@example.com', 'votes' => 0), 'userid'
);
Note: When using the insertGetId method, you can specify the auto-incrementing column name as the second
parameter in insertGetId function. It will default to "id" if not specified.
See Laravel Database Basic Docs for more information.
License
Licensed under the MIT License.