[eluser]Unknown[/eluser]
Hello i have a view with table to view all records , and its get the results form a controller which contact a model method then send results as array to the view.
controller gallery
====================
Code:
function category() //view images categories
{
$this->load->library('pagination');
$this->load->model('adminme/gallery_model');
$config['base_url'] = base_url().'index.php/adminme/gallery/category';
$config['total_rows'] = $this->gallery_model->cat_record_count();
$config['per_page'] = 10;
$config['num_links'] = 5;
$config['uri_segment'] = 4;
$this->pagination->initialize($config);
$limit = $config['per_page'] ;
$start = $this->uri->segment(4);
$data['results'] = $this->gallery_model->cat_get_records($limit,$start);
$data['links'] = $this->pagination->create_links();
$data['main_content'] = 'adminme/cat_gallery';
$this->load->view('adminme/includes/template',$data);
Model gallery_model
===================
Code:
function cat_get_records($limit,$start)
{
$this->db->limit($limit,$start);
$this->db->select(' category_id, category_name,category_parent_id ,category_status');
$this->db->order_by("category_name", "asc");
$query = $this->db->get('img_g_category');
if($query->num_rows() > 0)
{
foreach ($query->result() as $row){
$data[] = $row;}
return $data;
}
else { return FALSE; }
}
view
=====
Code:
<?php foreach($results as $item){ ?>
<tr >
<td><input type="checkbox"/></td>
<td><?php echo $item->category_id ;?> </td>
<td><?php echo $item->category_name ;?></td>
<td><?php echo $item->category_parent_id ;?></td>
<td>soon</td>
<td><?php echo $item->category_status ;?></td>
</tr>
<?php } ?>
how can i change the value of
Code:
<td><?php echo $item->category_parent_id ;?></td>
to get the category_name instead of category_parent_id
also how can i get the results of another model method which its:
Code:
function cat_images_record_count($id) // RETRIVE images/itesm/ COUNT for an category
{
$query = $this->db->get_where('img_gallery', array('image_parent_id' => $id));
$count = $query->num_rows();
return $count;
}
to put $count value instead of <td>soon</td> ?
i need all of them form one controller !!
please check the attached image for more understanding .
Thank you very much in advance