codeigniter中数据库记录获取问题

Question

$param = $posts['cnv_post_id']; //$posts['cnv_post_id']holds the current post id 
$comments = $this->post_model->get_comments($param);

在模型中:-

public function get_comments($cnv_post_id) 
{
  $get_comments = 
           $this->db->query('select * from cnv_comment where blog_tbl='.$cnv_post_id.'');
   if($get_comments->num_rows > 0) 
   return $get_comments->result_array(); 

}

但是如果我显式地指定$param = ' 100‘，其中100是当前的帖子id。

Answer 1

下面是从表单中获取帖子的方法：

$param = $this->input->post('cnv_post_id');

尝试输出$this->db->last_query()并将其提供给我们

Answer 2

你试试吧。

$param = $this->input->post('cnv_post_id'); //$posts['cnv_post_id']holds the current post id 
$comments = $this->post_model->get_comments($param);

public function get_comments($cnv_post_id) 
{
  $get_comments = 
           $this->db->query("select * from cnv_comment where blog_tbl = '$cnv_post_id'");
   if($get_comments->num_rows() > 0) 
      return $get_comments->result_array(); 

}