This is my current code:
public function index()
{
$db = ConfigDatabase::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);
}
but it returns error
"message": "Call to undefined method CodeIgniter\Database\MySQLi\Builder::getLastQuery()",
if I changed $builder->getLastQuery() into $builder->db->getLastQuery() it returns this error instead
"message": "Cannot access protected property CodeIgniter\Database\MySQLi\Builder::$db",