What will be the process to show to data in codeignator using Model View and Controller?
Controller
public function SecondarySchoolLevel() {
$this->load->model('Schoolprogram_model');
$data['progcategoryid'] = $this->Schoolprogram_model->getschoolprog(4);
$this->load->view('SchoolPrograms', $data);
}
View
$query = $this->db->query("SELECT * from programs where progcategoryid = $progcategoryid");
foreach ($query->result_array() as $row){
?>
<tr id="r<?php echo $row["progid"]; ?>">
<td><?php echo $row["progcode"]; ?></td>
<td><?php echo $row["activities"]; ?></td>
<td><?php echo $row["description"]; ?></td>
<td><?php echo $row["session"]; ?></td>
<td><?php echo $row["hours"]; ?></td>
<td><?php echo $row["cost"]; ?></td>
<td><?php echo $row["progcategoryid"]; ?></td>
<td><?php echo $row["agefrom"]; ?></td>
<td><?php echo $row["ageto"]; ?></td>
Model
function getschoolprog($progcategoryid) {
$this->db->where('progcategoryid', $progcategoryid);
$query = $this->db->get('programs');
return $query->result();
}
This is my code.