CODEWITHSUNDEEP
codeignitercodeigniter-2codeigniter-3
loliki
loliki

Reputation: 957

Foreach row array CodeIgniter

I have created a model which joins 2 tables

function list_get($id){
    $this->load->database();
    $query = $this->db-> select('*')
        ->from('lists')
        ->join('list_items', 'list_items.items_list_id = lists.list_id')
        ->where('items_list_id', $id);
    return $query->get()->row_array();
}

In my controller I created the view_list function 

public function view_list($id = !FALSE){
    $this->load->model('model_lists');
    $data["query"] = $this->model_lists->list_get($id);
    $this->load->model('model_lists');
    if($data["query"]){
        $this->load->view('lists/view_list',$data);
    } else {
        redirect('lists');
    }
}

Now my view returns only the first result from the database <?php echo $query['item_url'];?> How can I create a foreach to show all the results?

Upvotes: 0

Views: 3611

Answers (2)

Anish Rai
Anish Rai

Reputation: 686

change this line return $query->get()->row_array();
to return $query->get()->result_array();

in view 

 foreach($query as $querys){

       echo $querys['item_url'];
      echo '</br>';
    }

Upvotes: 1

Abdulla Nilam
Abdulla Nilam

Reputation: 38652

Change this return $query->get()->row_array(); to this

return $query->result_array();

and in view

foreach($query as $row)
{
    echo $row['column_name'];
}

Upvotes: 0

Related Questions