Codeigniter how to return multiple rows from same column in model

Question

I need to get all the rows which are filters by the query. But only the first row is returned from the model to the controller.

Given below is my model function. How to get all the data needed?

public function getOfferTags($param) {

    $this->db->select('tags.*');
    $this->db->from('tags');
    $this->db->join('offer_tag', 'offer_tag.tag_id = tags.id');
    $this->db->join('offers', 'offers.id = offer_tag.offer_id');
    $this->db->where('offers.id', $param);
    $query = $this->db->get();
    return $query->row();    

}

Could you return the query rather than a single row, then loop over it, or return $query->result_array() — Dale
– Dale, Commented Sep 17, 2018 at 8:33
Sorry I am new to CI. When I check the returned values on the controller only the first row is returning. — shavindip
– shavindip, Commented Sep 17, 2018 at 8:36

Mehta Harshit · Accepted Answer · 2018-09-17 08:36:31Z

2

Simply not return row and on that place fetch as an array form like

return $query->result_array();

After that checks in controller and get the result in array.

answered Sep 17, 2018 at 8:36

Mehta Harshit

1407 bronze badges

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

Comments

Alex · Accepted Answer · 2018-09-17 09:17:44Z

1

I just wanted to add, because you are new to CI, that you should always check if their are rows before using the array to prevent notices or issues. with mehta's method you would do if(count($rows) > 0) { //rows exist } else { // no rows, display error .etc. } or you can do:

$query = $this->db->get();
if ($query->num_rows() > 0) {
    return $query->result_array(); // or result() for obj
}
return false;

Usage:

if ($this->somemodel->getOfferTags($stmt)) {
    // has data
} else {
    // no data
}

It is important to start with good practices and this will help ;)

answered Sep 17, 2018 at 9:17

Alex

9,2958 gold badges43 silver badges90 bronze badges

1 Comment

shavindip Over a year ago

Thank you very much. I will definitely follow the above practise

Collectives™ on Stack Overflow

Codeigniter how to return multiple rows from same column in model

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related