database record fetch issue in codeigniter

Question

I am using a the following approach.

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

in model :-

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(); 

}

but its not giving the results. but if I explicitly give $param = '100' where 100 is the current post id. now, its returning the results

have you tried to run query it in phpmyadmin ? is it giving result ? — Harshal
– Harshal, Commented Jan 23, 2014 at 14:33

Phil · Accepted Answer · 2014-01-23 14:52:26Z

1

This is how you get the post from a form:

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

Try outputing $this->db->last_query() and give it to us

edited Jan 23, 2014 at 14:52

answered Jan 23, 2014 at 14:33

Phil

11.2k18 gold badges73 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3177114 Over a year ago

Sorry, it will sound funny but I am doing this on my view within php tag

Phil Over a year ago

so what is posts['cnv_post_id']? How do you get it?

user3177114 Over a year ago

see post is an array passed to a view posts[] has other data to show. I am just trying to fetch comment for every post.But is fetching null

lighter · Accepted Answer · 2014-01-23 14:46:30Z

0

You try it.

$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(); 

}

answered Jan 23, 2014 at 14:46

lighter

2,8243 gold badges43 silver badges61 bronze badges

Collectives™ on Stack Overflow

database record fetch issue in codeigniter

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related