這是我當前的代碼：
public function index()
{
$tbl = 'm_trx';
$db = \Config\Database::connect();
$builder = $db->table($tbl);
$data = [];
$cols = "{$tbl}.*";
$builder->select($cols);
$data = $builder->get()->getResult();
$asd = [
'message' => $builder->getLastQuery(),
'data' => $data,
];
return $this->respond($asd);
}
但它回傳錯誤
"message": "Call to undefined method CodeIgniter\\Database\\MySQLi\\Builder::getLastQuery()",
如果我改成$builder->getLastQuery()它$builder->db->getLastQuery()，則回傳此錯誤
"message": "Cannot access protected property CodeIgniter\\Database\\MySQLi\\Builder::$db",
uj5u.com熱心網友回復：
你只需要通過$db而不是$builder->db
嘗試這個
$db->getLastQuery()
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/489025.html
標籤：php 代码点火器 查询生成器 codeigniter-4