Codeigniter-函数总是返回null

Question

getlocal是一个数据库查询函数，但即使我在名为local的表中插入数据，该函数也不能返回与null 不同的值

class denuncia_model extends CI_Model {
function __construct(){
parent::__construct();
}
public function insertlocal($local){
$insertquery = "INSERT INTO local(estado,lng,lat) VALUES (?,?,?)";
$this->db->query($insertquery,$local);
}
public function getlocal($local){
$queryteste = "SELECT * FROM local WHERE estado = ? AND lng = ? AND lat = ?";
$query = $this->db->query($queryteste,$local);
$row = $query->row_array();
$id = $row['id'];
return $id;
}
public function insertdenuncia($denuncia){
$insertdenunciaquery = "INSERT INTO denuncias(descricao,data,forma,genero,preconceito,idade,id_local) VALUES (?,?,?,?,?,?,?)";
$this->db->query($insertdenunciaquery,$denuncia);
}

文件退出控制器

$local = array($estado,$lng,$lat);
$denuncia = array($descricao,$data,$agressao,$gender,$preconceito,$age);
$this->denuncia_model->insertlocal($local);
$id = $this->denuncia_model->getlocal($local);
array_push($denuncia,$id);
$this->denuncia_model->insertdenuncia($denuncia,$local);

Answer 1

class denuncia_model extends CI_Model {
function __construct(){
parent::__construct();
}
public function insertlocal($local){
$insertquery = "INSERT INTO local(estado,lng,lat) VALUES (?,?,?)";
$this->db->query($insertquery,$local);
return $this->db->insert_id();
}

Answer 2

您应该在函数的末尾使用带有insert_id((的return语句

return $this->db->insert_id();