public function get_all()
{
$department_list = array();
$this->db->connect();
$sql = "SELECT * from tbl_department";
$result = $this->db->fetchQuery($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$department = new department();
$department->set_id($row['id']);
$department->set_name($row['name']);
$department->set_no_of_staff($row['no_of_staff']);
$department->set_no_of_teachers($row['no_of_teachers']);
$department->set_hod($row['hod']);
$department->set_vhod($row['vhod']);
array_push($department_list, $department);
}
}
$this->db->close();
return $department_list;
}
