anovsiradj/ci3db

Standalone CodeIgniter 3 Database

CI3DB

Standalone CodeIgniter3 DataBase Query Builder with monkey-patched technique., _(*1)

Usage

// IMPORTANT: "BASEPATH" must end with slash or directory separator.
define('BASEPATH', 'path/to/vendor/codeigniter/framework/system/'); // relative
define('BASEPATH', realpath('/path/to/vendor/codeigniter/framework/system') . DIRECTORY_SEPARATOR); // absolute

$ci3db =& \anovsiradj\CI3DataBase::init();

$ci3db->set_db_config_file('path/to/config/database.php'); // see ./tests/cfg.php
// or
$ci3db->set_db_config('db-server-0', array(
    ...
    'dbdriver' => '...',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => 'root',
    'database' => '...',
    ...
));
// or
$ci3db->set_db_config('db-server-1', 'dbdriver://username:password@hostname/database');

// Using the query builder
$db =& $ci3db->db(); // or
$db =& $ci3db->db('db-server-0'); // or
$db =& \anovsiradj\CI3DataBase::db(); // or
$db =& \anovsiradj\CI3DataBase::db('db-server-1');

Development

tested on 5.6+,7.0+ and 7.2+., _(*2)

probably work on 5.4.8+ (see https://github.com/bcit-ci/CodeIgniter#server-requirements)., _(*3)

tested with MySQL, SQLite and FirebirdSQL., _(*4)

Caveats

dbutil() is not supported., _(*5)

dbforge() is not supported., _(*6)

DB Cache is not supported., _(*7)

DSN you must provide host (even for sqlite3)., _(*8)

Todo(s)

• Test driver PDO
• Test PostgreSQL

License

MIT, _(*9)

CodeIgniter3 License, _(*10)