How to convert a CodeIgniter result set object into an array of arrays?

Question

I am new to CodeIgniter. In the model, I have the following code:

public function get_all_subjects() { return $this->db->get('subjects'); }

In the controller, I have:

public function index() { $this->load->model('subjects'); $data['content'] = $this->subjects->get_all_subjects(); $this->load->view('home', $data); }

I am trying to get the values in the view:

foreach($content as $val) { echo $val['subject']; //i am getting error, Message: Undefined index: subject }

The fields in the subjects table are subject_id and subject.

I am getting this error message:

Undefined index: subject

DeiForm · Accepted Answer · 2013-07-31 17:57:26Z

7

public function get_all_subjects() { return $this->db->get('subjects')->result_array(); }

You are not returning result from your query. You have just run the query.

edited Jul 31, 2013 at 17:57

answered Jul 31, 2013 at 17:18

DeiForm

6749 silver badges31 bronze badges

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

2 Comments

igasparetto Over a year ago

return $this->db->get('subjects')->result_array(); should do the trick and would avoid you from creating unnecessary variables: $q. Maybe @DeiForm wants to update his function.

DeiForm Over a year ago

Yes I heard of this chaining method. But for beginers the step by step method is easily to understand

Collectives™ on Stack Overflow

How to convert a CodeIgniter result set object into an array of arrays?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related