Thread

MY CONTROLLER PAGE:

$arrCourse = $this->model_curriculum->array_numrowscourse($curriculumID);
      foreach ($arrCourse as $value){
$YEARLEVEL = $value -> year;
$SEMESTER = $value -> sem;
$data['result_getCourse'] = $this->model_curriculum->get_course($curriculumID,$YEARLEVEL, $SEMESTER);
}

$this->load->view(‘header’);
  $this->load->view(‘view_curriculumPreview’, $data);

MY MODEL PAGE:

function array_numrowscourse($curriculumID){
$this->db->distinct();
$this->db->select('year,sem');
$this->db->where('curr_id', $curriculumID);
$query = $this->db->get('rar_tbl_course');
return $query -> result();
}
    function get_course($curriculumID,$YEARLEVEL, $SEMESTER){
$this->db->select('year,sem,course_code,course_desc,course_preq,unit_lec,unit_lab');
$this->db->where('curr_id',$curriculumID );
$this->db->where('year', $YEARLEVEL);
$this->db->where('sem', $SEMESTER);
$query = $this->db->get('rar_tbl_course');

return $query->result();
}

MY VIEW PAGE:

  <?php
                 
                  foreach($result_getCourse as $value){
$COURSECODE = $value -> course_code;
$COURSEDESC = $value -> course_desc;
$COURSEPREQ = $value -> course_preq;
$UNITLEC = $value -> unit_lec;
$UNITLAB = $value -> unit_lab;

?>
<tr>
<td><?php echo $COURSECODE;?></td>
<td><?php echo $COURSEDESC;?></td>
<td><?php echo $COURSEPREQ;?></td>
<td><?php echo $UNITLEC;?></td>
<td><?php echo $UNITLAB?></td>
</tr>
<?php }?>

OUTPUT:
there is only 1(one) row output.

How can loop in the controller page so that i can have many row output?

thanks.

use result_array() as data return in model..

In views, call it using $value[‘col_name’]...

try it in your model

function array_numrowscourse($curriculumID){
    $this->db->distinct();
    $this->db->select('year,sem');
    $this->db->where('curr_id', $curriculumID);
    $query = $this->db->get('rar_tbl_course');
    return $query -> row();
}

use get()->row() method for return one value
is no need for foreach loop