Codeigniter put values from db in array and print them

Question

All I want is to get some place_ids from db, put them in array and echo that array in view. Could you please check the code below and help me to find the mistake. I think the problem is in view part.

Model:

$this->db->select('place_id');
$this->db->from('table');
$this->db->where('ses_id', $ses_id);
$query = $this->db->get();
if ($query && $query->num_rows() > 0) {
return $query->result_array();
}
else {return false;}

Controller:

$ses_id = $this->uri->segment(3);
$data["results"] = $this->mymodel->did_get($ses_id);                   
$this->load->view("my_view", $data);

View:

<?php
$place_id = array();
foreach($results as $row){
$place_id[] = $row['place_id'];
}
print_r($place_id);
?>

are you getting any error if yes than show me your error too. — Yogesh Shakya
– Yogesh Shakya, Commented Feb 26, 2016 at 9:43

naseeba c · Accepted Answer · 2016-02-26 09:43:29Z

1

checking the $results is empty or not

<?php
$place_id = array();
if(!empty($results)
{
   foreach($results as $row)
   {
    $place_id[] = $row['place_id'];
   }
}else
{ echo "no data found";}
print_r($place_id);
?>

answered Feb 26, 2016 at 9:43

naseeba c

1,0603 gold badges14 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter put values from db in array and print them

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related