[eluser]condoace[/eluser]
I am using the model method called content ($this->model_admin->content($limit, offset) to get data. I want to access each of the data from the model method individually
inside the controller, but it gives me an error when trying to do it.
I am not sure if I am correctly accessing the object, e.g.
$db4->first_name (
is this correct or do I need a foreach loop first???)
CONTROLLER
Code:
function ajax_employees($offset = 0)
{
$this->load->model('model_admin');
$this->load->library('Jquery_pagination');
$config['base_url'] = site_url('admin/ajax_employees/');
/* Here i am indicating to the url from where the pagination links and the table section will be fetched */
$limit = 3;
$config['div'] = '#content';
/* CSS selector for the AJAX content */
$config['total_rows'] = $this->model_admin->num_rows();
$config['per_page'] = $limit;
$this->jquery_pagination->initialize($config);
$this->load->library('table');
$tmpl = array ( 'table_open' => '<table border="0" cellpadding="2" cellspacing="1" width="100%" class="main_awesome_row">',
'heading_cell_start' => '<th class="main_awesome_header">',
'heading_cell_end' => '</th>',
);
$this->table->set_template($tmpl);
$this->table->set_heading('ID', 'First Name', 'Surname', 'Email','Other','Job Title','Department','Select');
$db4 = $this->model_admin->content($limit, $offset);
$list = array($db4->first_name, 'Select');
$new_list = $this->table->make_columns($list, 8);
$html = $this->table->generate($new_list).
'<div align="center"><br/><span class="pagination">'.$this->jquery_pagination->create_links().'</span></div>';
echo $html;
}
MODEL
Code:
function num_rows() {
return $this->db->count_all('employees');
}
function content( $limit, $offset ) {
$this->db->select('id, first_name,last_name, email, other, job_title,department');
$result = $this->db->get('employees', $limit, $offset);
return $result->result_array();
}