PHP code example of ioigoume / cakephp5-oracle-driver

1. Go to this page and download the library: Download ioigoume/cakephp5-oracle-driver library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

ioigoume / cakephp5-oracle-driver example snippets


        
return [
    'Datasources' => [
        'default' => [
            'className' => 'Ioigoume\OracleDriver\Database\OracleConnection',
            'driver' => 'Ioigoume\OracleDriver\Database\Driver\OracleOCI', # For OCI8
            #'driver' => 'Ioigoume\\OracleDriver\\Database\\Driver\\OraclePDO', # For PDO_OCI
            'persistent' => true,           // Database persistent connection between http requests
            'host' => 'oracle11g',          // Database host name or IP address
            //'port' => 'nonstandard_port', // Database port number (default: 1521)
            'username' => 'blogs',          // Database username
            'password' => 'password',       // Database password
            'database' => 'XE',             // Database name (maps to Oracle's `SERVICE_NAME`)
            'sid' => '',                    // Database System ID (maps to Oracle's `SID`)
            'instance' => '',               // Database instance name (maps to Oracle's `INSTANCE_NAME`)
            'pooled' => '',                 // Database pooling (maps to Oracle's `SERVER=POOLED`)
            'flags' => [],                  // Database low level parameters for OCI or PDO connection. Auto-generated by default
            'encoding' => '',               // Database charset (default same as database charset)
            'init' => [],                   // Array of queries executed at connection
            'cacheMetadata' => true,        // Enable cakephp schema caching
            'server_version' => 12,         // Oracle server numeric version ex.: 11,12,19
            'autoincrement' => true,        // Enable autoincrement insteadof custom triggers in case of oracle 12+
            'case' => 'lower' | 'upper' | 'natural' // Oracle case sensitivity
        ]
    ]
];


[
    'oracle' => [
        'driver' => Ioigoume\OracleDriver\Database\Driver\Oracle::class, 
        //...
        'case' => 'lower', // or 'upper' or 'natural',
    ],
]


[ 
    'oracle' => [
        'driver' => Ioigoume\OracleDriver\Database\Driver\Oracle::class,
        // ...
        'flags' => [ PDO::ATTR_CASE => PDO::CASE_LOWER ], // or PDO::CASE_UPPER / PDO::CASE_NATURAL
    ],
]


    /**
     * {@inheritdoc}
     */
    public function bootstrap()
    {
        parent::bootstrap();

        $this->addPlugin(\Ioigoume\OracleDriver\Plugin::class, ['bootstrap' => true]);
    }