CodeIgniter: Populating a table (HTML/ form) from database (table)

Question

I need to fill in a table in my view with the data extracted from a database table. However when I tried this, it returned error:

Fatal error: Call to a member function result_array() on a non-object in C:\xampp\htdocs\bit\application\views\admin\add_new_room.php on line 32

View:

<table class="table table-hover">
<?php foreach ($query->result_array() as $row): { ?> // Line 32
<tr>
    <td><?php echo $row['room_number'];?></td>
    <td><?php echo $row['rt_name'];?></td>
    <td><?php echo $row['housekeeping_status'];?></td>
</tr>    
<?php } ?>
<?php endforeach; ?>
</table>

Controller:

function index() {
    $this->load->model('admin/edit_other_details');     
    $roomType['rt_name'] = $this->edit_other_details->get_room_details();
    $data['query'] = $this->edit_other_details->roomsTable();
    $tmp = array_merge($roomType, $data);
    $this->load->view('/admin/add_new_room', $tmp);
}

Model:

function roomsTable() {
    $query = $this->db->select(array('room_number','rt_name'))->get('rooms');
}

bipen · Accepted Answer · 2013-07-11 10:33:56Z

4

That is because you forgot to return data in your model.

try this

Model

 function roomsTable() {
   $query = $this->db->select(array('room_number','rt_name'))->get('rooms');
   return $query;  //<---here
}

answered Jul 11, 2013 at 10:33

bipen

36.6k9 gold badges51 silver badges62 bronze badges

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

1 Comment

Madhawa Ratnayake Over a year ago

Thank you and you were quick. It worked! Now I have to wait for few minutes to accept this as the answer by the way. :)

Collectives™ on Stack Overflow

CodeIgniter: Populating a table (HTML/ form) from database (table)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related