alfmel/pdo-via-oci8

Userspace PDO driver for Oracle via the PHP OCI8 driver

PDO Userspace Driver for Oracle (oci8)

PDO via Oci8

The alfmel/pdo-via-oci8 package is a simple userspace driver for PDO that uses the tried and tested OCI8 functions instead of using the still experimental and not all that functional PDO_OCI library., _(*1)

This fork from yajra/laravel-pdo-via-oci8 restores full DSN support (previously removed to fit better within Laravel) making the project fully portable to any installation. This fork also includes improved class names and error handling for strict error reporting configurations., _(*2)

Please report any bugs you may find., _(*3)

• Installation
• Usage
• Credits

Installation

Add alfmel/pdo-via-oci8 as a requirement to composer.json:, _(*4)

{
    "require": {
        "alfmel/pdo-via-oci8": "*"
    }
}

And then run composer update, _(*5)

Note: lastInsertId function returns the current value of the sequence related to the table where record is inserted. The sequence name should follow this format {$table}.'_'.{$column}.'_seq' for it to work properly., _(*6)

Usage

Using the userspace PDO driver is easy. Simply instantiate the alfmel\OCI8\PDO class instead of the PDO class in PHP. Then use the PDO object as you would any other PDO object:, _(*7)

<?php
$pdo = new alfmel\OCI8\PDO($dsn, $username, $password);
$statement = $pdo->prepare("SELECT * FROM MY_TABLE");
$statement->execute();
$result_set = $statement->fetchAll(PDO::FETCH_ASSOC);

Credits

Special thanks to the two projects that started it all:, _(*8)

• crazycodr/pdo-via-oci8
• yajra/laravel-pdo-via-oci8

And thanks to all the contributors to these projects. Your work is truly appreciated!, _(*9)