<?php
// models/UsersModel.php
class Users_model extends CI_model {
public function getUsers() {
$query = $this->db->get('users_table');
$users = $query->result();
return $users;
}
}
// controllers/users.php
class Users extends CI_Controller {
public function userlist() {
$this->load->model('users_model');
$viewData['userList'] = $this->users_model->getUsers();
$this->load->view('someViewName', $viewData);
}
}
<?
// views/someViewName.php
<html>
...
<body>
<table>
<? foreach ($userList as $user) {?>
...
<? } ?>
</table>
</body>
</html>
PD9waHAKLy8gbW9kZWxzL1VzZXJzTW9kZWwucGhwCmNsYXNzIFVzZXJzX21vZGVsIGV4dGVuZHMgQ0lfbW9kZWwgewoJcHVibGljIGZ1bmN0aW9uIGdldFVzZXJzKCkgewoJCSRxdWVyeSA9ICR0aGlzLT5kYi0+Z2V0KCd1c2Vyc190YWJsZScpOwoJCSR1c2VycyA9ICRxdWVyeS0+cmVzdWx0KCk7CgkJcmV0dXJuICR1c2VyczsKCX0gCgp9CgoKLy8gY29udHJvbGxlcnMvdXNlcnMucGhwCgpjbGFzcyBVc2VycyBleHRlbmRzIENJX0NvbnRyb2xsZXIgewoJCglwdWJsaWMgZnVuY3Rpb24gdXNlcmxpc3QoKSB7CgkJJHRoaXMtPmxvYWQtPm1vZGVsKCd1c2Vyc19tb2RlbCcpOwoJCSR2aWV3RGF0YVsndXNlckxpc3QnXSA9ICR0aGlzLT51c2Vyc19tb2RlbC0+Z2V0VXNlcnMoKTsKCQkKCQkkdGhpcy0+bG9hZC0+dmlldygnc29tZVZpZXdOYW1lJywgJHZpZXdEYXRhKTsKCX0KfQo8PwovLyB2aWV3cy9zb21lVmlld05hbWUucGhwCgo8aHRtbD4KLi4uCjxib2R5PgoJPHRhYmxlPgoJPD8gZm9yZWFjaCAoJHVzZXJMaXN0IGFzICR1c2VyKSB7Pz4KCQkuLi4KCTw/IH0gPz4KCTwvdGFibGU+CjwvYm9keT4KPC9odG1sPg==