pdooci - GitLite

KO | EN

gitlite — search

#generative-ai #cli #framework #pytorch #large-language-models #swift #windows #chatbot #java #animation

pdooci

(★ 67)

Wrapping on PHP OCI functions to simulate a PDO object, since PDO support for OCI is very confuse and slow.

File Explorer

ZIP Download

- PDO.php
- Statement.php
- StatementIterator.php
- connectionTest.php
- statementTest.php
.gitignore
composer.json
LICENSE
README.md

# Use via CDN

jsDelivr

jsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.

Version

File

Link

Example

Command Glossary

Commands referenced in this DOCs, explained below.

🔍

`composer`

View Details ▼

A package-based dependency manager for PHP projects.

composer init

Interactively create a `composer.json` file:

composer require {{user/package}}

Add a package as a dependency for this project, adding an entry to `composer.json`:

composer install

Install all the dependencies in this project's `composer.json` and create `composer.lock`:

🔍

`pecl`

View Details ▼

Manage PHP extensions from the PHP Extension Community Library.

pecl

Display a list of available commands:

pecl install {{package}}

Install a package:

pecl list

List installed packages:

🔍

`php`

View Details ▼

PHP command-line interface.

php {{path/to/file}}

Parse and execute a PHP script:

php {{[-l|--syntax-check]}} {{path/to/file}}

Check syntax on (i.e. [l]int) a PHP script:

php {{[-a|--interactive]}}

Run PHP inter[a]ctively:

🔍

`phpunit`

View Details ▼

PHPUnit test runner.

phpunit

Run tests in the current directory. Note: Expects you to have a `phpunit.xml'`:

phpunit {{path/to/TestFile.php}}

Run tests in a specific file:

phpunit --group {{name}}

Run tests annotated with the given group:

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

| :warning: **WARNING** This software is [abandonware](https://en.wikipedia.org/wiki/Abandonware). As the creator and maintainer, I don't even use PHP or Oracle _for years_, so, I can't support it anymore. It should work ok for PHP untill version 7, but seems that with 8.1 there are some alerts. Feel free to fork it and keep it going. |
| --- |

Wrapping on PHP OCI functions to simulate a PDO object, using just pure PHP and the oci_* functions.

Let's face it. Installing PHP, PDO, Oracle drivers and PDO OCI is not a pleasant
task. Is more pleasant to insert bamboo sticks under your fingernails than make
all the voodoo needed to accomplish that task. And there are two big problems
with that:

1. If you install `pdo_oci` with `pecl` you'll get a version from 2005 (http://pecl.php.net/package/PDO_OCI). 
   Even Christian Bale is now far from the things from 2005, and wow, he had a
   cool suit and a very nice car.
   And all came in black.

2. If you follow the official docs, you'll need to compile PHP and still get an
   *experimental* extension (http://www.php.net/manual/ref.pdo-oci.php). Come on. 
   We can't (yeah, we know how to do it!) compile PHP on every server we need
   and just for an experimental feature?

That's why I made `PDOOCI`.

## Installation

First install the Oracle drivers (I like the instant client versions) and the
`oci8` package (with `pecl`, this one seems to be updated often).

### With Composer

```
$ composer require taq/pdooci
```

```json
{
    "require": {
        "taq/pdooci": "^1.0"
    }
}
```

```php
<?php
require_once 'vendor/autoload.php';

$pdo = new PDOOCI\PDO("mydatabase", "user", "password");
```

### Without Composer

Why are you not using [composer](http://getcomposer.org/)? Download the `src`
folder from the repo and rename it to `PDOOCI`, then require the
`PDOOCI/PDO.php` file.

```php
require_once "PDOOCI/PDO.php";

$pdo = new PDOOCI\PDO("mydatabase", "user", "password");
```

Yeah, the rest should work exactly the same as if you were using a PDO object. :-)

## Testing

There is a test suite (using `PHPUnit` with a version bigger than 6.x) on the
`test` directory. If you want to test (you must test your code!), create a table
called `people` with two columns:

1. `name` as `varchar2(50)`
2. `email` as `varchar2(30)`

And some environment variables:

1. `PDOOCI_user` with the database user name
2. `PDOOCI_pwd` with the database password
3. `PDOOCI_str` with the database connection string

Don't forget to run `composer install`!

And then go to the `test` dir and run `PHPUnit` like:

```
phpunit --colors .
```