Use the Database Library separately from CodeIgniter 3.
"require": {
"astute/CodeIgniterDB": "^1.0"
}
or with command line : composer require astute/CodeIgniterDB
You can also download it from Github, but no autoloader is provided so you'll need to register it with your own PSR-0 compatible autoloader.
<?php
use astute\CodeIgniterDB as CI;
$db_data = array(
'dsn' => '',
'hostname' => 'localhost',
'username' => 'my_name',
'password' => 'my_password',
'database' => 'my_database',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
$db=& CI\DB($db_data);?
For more information visit CodeIgniter user guide.
I've added the possibility to give a mysql ressource to reuse a already opened connection. Thus to not multiply connections and to use this in parallel with legacy code and proceed to a migration step by step. Works only with the mysql driver !
<?php
use astute\CodeIgniterDB as CI;
$db_data = array(
'dsn' => '',
'hostname' => 'localhost',
'username' => 'root',
'password' => 'my_name',
'database' => 'my_database',
'dbdriver' => 'mysql',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
$rDb = mysql_connect($db_data['hostname'], $db_data['root'], $db_data['password']);
$db=& CI\DB($db_data, null, $rDb);
Config.php
<?php
include('src/DB.php');
use astute\CodeIgniterDB as CI;
$db_data = array(
'dsn' => '',
'hostname' => 'localhost',
'username' => 'my_name',
'password' => 'my_password',
'database' => 'my_database',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
$db =& CI\DB($db_data);
index.php Calling the database object by config.php file
<?php
include('config.php');
$result1 = $db->get('table_name')->row();
$result2 = $db->select('columName')->get('table_name')->row();.
$result3 = $db->select('columName')->where('columName',1)->get('table_name')->row();
print_r($result1);
echo '<br>';
print_r($result2);
echo '<br>';
print_r($result3);
Ok, now we are ready to run our core php web application with Core PHP Wrapper Library Codeigniter Database,
IF you want to download this from git then you can download from here
Share This News