10-30-2013, 01:58 AM
[eluser]hrg.vincent[/eluser]
I've problem in getting data from second database. First is used mysql and another is odbc. My default database is mysql.
=== application/config/custom.php ===
=== Controller ===
=== Data Model ===
=== View ===
Note: All data from mysql is working, only odbc is not working. Pls help.
I've problem in getting data from second database. First is used mysql and another is odbc. My default database is mysql.
=== application/config/custom.php ===
Code:
// get special condition
$isDb = isset($_GET['ndb']) && $_GET['ndb'] == 'y' ? false : true;
$config['doCron'] = true;
if($isDb){
$config['dbconn'] = @odbc_connect(MY_DATABASE_HOST, MY_DATABASE_NAME, MY_DATABASE_PSWD) or showDBError(MY_DB_ERROR_HEAD, MY_DB_ERROR_MSG);
}
else{
$config['dbconn'] = false;
}
function showDBError($heading, $message){
require_once APPPATH.'errors/error_db.php';
exit();
}
=== Controller ===
Code:
$data['company'] = $this->Data_m->getCompany();
=== Data Model ===
Code:
class Data_m extends CI_Model
{
function __construct()
{
parent::__construct();
$this->dbconn = $this->config->config['dbconn'];
$this->NOW = date(TSTAMPT);
}
function getCompany()
{
$sql = "SELECT company_id, company_name FROM dev.company";
$result = odbc_exec($this->dbconn, $sql);
while (odbc_fetch_row($result))
{
foreach($result->result_array() as $row) {
$return[$row['company_id']] = $row['company_name'];
}
}
return $return;
}
}
=== View ===
Code:
<?php echo form_dropdown('company', $company) ?>
Note: All data from mysql is working, only odbc is not working. Pls help.