yajra\Oci8\Connectors\OracleConnector::connect PHP Method

connect() public method

Establish a database connection.
public connect ( array $config ) : PDO
$config array
return PDO
    public function connect(array $config)
    {
        $tns = !empty($config['tns']) ? $config['tns'] : $this->getDsn($config);
        $options = $this->getOptions($config);
        $connection = $this->createConnection($tns, $config, $options);
        return $connection;
    }

Usage Example

 /**
  * Register the service provider.
  *
  * @return void
  */
 public function register()
 {
     $this->app['db']->extend('oracle', function ($config) {
         $connector = new Connector();
         $connection = $connector->connect($config);
         $db = new Oci8Connection($connection, $config["database"], $config["prefix"]);
         // set oracle session variables
         $sessionVars = ['NLS_TIME_FORMAT' => 'HH24:MI:SS', 'NLS_DATE_FORMAT' => 'YYYY-MM-DD HH24:MI:SS', 'NLS_TIMESTAMP_FORMAT' => 'YYYY-MM-DD HH24:MI:SS', 'NLS_TIMESTAMP_TZ_FORMAT' => 'YYYY-MM-DD HH24:MI:SS TZH:TZM', 'NLS_NUMERIC_CHARACTERS' => '.,'];
         // Like Postgres, Oracle allows the concept of "schema"
         if (isset($config['schema'])) {
             $sessionVars['CURRENT_SCHEMA'] = $config['schema'];
         }
         $db->setSessionVars($sessionVars);
         return $db;
     });
 }
All Usage Examples Of yajra\Oci8\Connectors\OracleConnector::connect