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
我应该怎么做才能使这段代码运行而没有错误?
如果您使用
MSSQL,请在您的配置数据库中使用 port,如下所示:'port' => "1433",1433 是默认端口
在 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);
}
}