在多个数据库连接中生成查询（codeigniter php）帮助

Question

Assalamualaykum :)

当我想在 codeigniter 中生成查询时遇到麻烦， 这是代码：

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);
        }
    }
}

并且有一些像这样的错误输出：

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

我应该做什么才能使此代码运行没有错误？

Answer 1

如果您使用 MSSQL，请在您的配置数据库中使用端口，如下所示：
'端口' => “1433”，
1433是默认端口

Answer 2

在您的 biasa() 函数中像这样更改您的查询。

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);
    }
}