generating queries in multiple database connection (codeigniter php) help

Question

Assalamualaykum :)

i have trouble when i want to generate a query in codeigniter, here is the code :

class Pengadilan_negeri extends CI_Controller {

    private function get_database_configuration($database_name) {
        $configuration = array(
            'hostname' => "DREAMBENDER\PENGADILANNEGERI",
            'username' => "sa",
            'password' => "12111993",
            'dbdriver' => "mssql"
        );

        $database_configuration = NULL;

        if ($database_name == "pidana") {
            $database_configuration = $configuration + array('database' => "dataPidana");
        } else if ($database_name == "perdata") {
            $database_configuration = $configuration + array('database' => "dataPerdata");
        }

        return $database_configuration;
    }

    public function biasa() {

        $DB1 = $this->load->database($this->get_database_configuration("pidana"), TRUE);
        $DB2 = $this->load->database($this->get_database_configuration("perdata"), TRUE);

        $DB1->query("SELECT * FROM dbo.DATA_REGISTER");

        foreach ($DB1->result() as $row) {
            print_r($row);
        }
    }
}

and the're some error output like this :

Fatal error: Call to undefined method CI_DB_mssql_driver::result() in E:\xampp\htdocs\pengadilan_negeri\application\controllers\register_perkara\perkara_pidana.php on line 33

what should i do to make this code running without errors ?

couldn't you put both databases in your database config file and then use: $this->load->database('pidana', TRUE); — eyaka1
– eyaka1, Commented May 10, 2011 at 0:22
@Toast: there is the code in line 33 : foreach ($DB1->result() as $row) { if we puth both of them in the config file, and we use $this->database->query($query); there will be ambigous query, because the system won't know the query that we want to execute is a query to "pidana database" or "perdata database". but (alhamdulillah) i have solved this problem 10 menutes ago. btw, thanks for your answer — user745943
– user745943, Commented May 10, 2011 at 1:46

mobs6 · Accepted Answer · 2013-10-28 06:57:48Z

1

if u using MSSQL please use port in your config db like this: 'port' => "1433", 1433 is a default port

answered Oct 28, 2013 at 6:57

mobs6

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

jondavidjohn · Accepted Answer · 2011-05-10 13:36:56Z

0

in your biasa() function change your query like this.

public function biasa() {

    $DB1 = $this->load->database($this->get_database_configuration("pidana"), TRUE);
    $DB2 = $this->load->database($this->get_database_configuration("perdata"), TRUE);

    // execute the query and store it
    $query_db1 = $DB1->query("SELECT * FROM dbo.DATA_REGISTER");

    // call ->result() on the executed query to retrieve the results
    foreach ($query_db1->result() as $row) {
        print_r($row);
    }
}

answered May 10, 2011 at 13:36

jondavidjohn

62.5k21 gold badges120 silver badges159 bronze badges

Collectives™ on Stack Overflow

generating queries in multiple database connection (codeigniter php) help

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related