Using Oracle with PHP and CodeIgniter
Step 1:
Install OCI & enable OCI8 in WAMP(Please click How to Install & enable oci8 in WAMP)
Step 2: Configuration database.php
CodeIgniter has a config file that lets you store your database connection values (username, password, database name, etc.). The config file is located atapplication/config/database.php. You can also set database connection values for specific environments by placing database.php it the respective environment config folder.
The config settings are stored in a multi-dimensional array with this prototype:
$db['pblmig']['hostname'] = '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.200)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =pblmig )))';
$db['pblmig']['username'] = 'cib';
$db['pblmig']['password'] = 'cib';
$db['pblmig']['database'] = 'pblmig';
$db['pblmig']['dbdriver'] = 'oci8';
$db['pblmig']['dbprefix'] = '';
$db['pblmig']['pconnect'] = FALSE;
$db['pblmig']['db_debug'] = TRUE;
$db['pblmig']['cache_on'] = FALSE;
$db['pblmig']['cachedir'] = '';
$db['pblmig']['char_set'] = 'utf8';
$db['pblmig']['dbcollat'] = 'utf8_general_ci';
$db['pblmig']['swap_pre'] = '';
$db['pblmig']['autoinit'] = TRUE;
$db['pblmig']['stricton'] = FALSE;
Step 3: Data Fetch from Oracle & Show
Controllers
Create a controller db_controller.php file which in CI/application/controllers location
<?php
class db_controller extends CI_Controller{
function __construct(){
parent::__construct();
}
public function db_data(){
$this->load->model('db_model');
$data[dtl]=$this->db_model->get_data( );
$data[row]=$this->db_model->get_tot_data();
$this->load->view('pages/show_data', $data);
}
}
?>
Model
Create a model db_model.php file which in CI/application/models location
<?php
class db_model extends CI_Controller{
function __construct(){
parent::__construct();
}
public function get_data(){
$this->pblmig_db = $this->load->database('pblmig', true);
$sql="SELECT CUST_NAME FROM CUSTOMER “;
$stmt = oci_parse($this->pblmig_db->conn_id, $sql);
oci_execute($stmt);
$row = oci_fetch_all($stmt, $result);
oci_free_statement($stmt);
oci_close($this->pblmig_db->conn_id);
return $result;
}
// Return no of row
public function get_tot_data(){
$this->pblmig_db = $this->load->database('pblmig', true);
$sql="SELECT CUST_NAME FROM CUSTOMER “;
$stmt = oci_parse($this->pblmig_db->conn_id, $sql);
oci_execute($stmt);
$row = oci_fetch_all($stmt, $result);
oci_free_statement($stmt);
oci_close($this->pblmig_db->conn_id);
return $row;
}
}
?>
VIEW
Create a page show_data.php file which in CI/application/views/pages location
<table>
<tr>
<td style="FONT-SIZE: 12px;text-align:center">
</td>
</tr>
<?
for ($i = 0; $i <$row; $i++) {
?>
<tr>
<td style="FONT-SIZE: 12px;text-align:left">
</td>
<? foreach ($dtl as $key=>$data) { ?>
<td style="FONT-SIZE: 12px;text-align:left">
<?
echo $data[$i];
?>
</td>
<?
}
?>
</tr>
<?
}
?>
</table>
Now, test your application. Point your browser using this URL
http://localhost/CI/index.php/db_data / get_data
