public function get_all() { $teacher_list = array(); $this->db->connect(); $sql = "SELECT * from tbl_teacher"; $result = $this->db->fetchQuery($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $teacher = new teacher(); $teacher->set_id($row['id']); $teacher->set_first_name($row['first_name']); $teacher->set_last_name($row['last_name']); $teacher->set_contact($row['contact']); $teacher->set_salary($row['salary']); $teacher->set_department_id($row['department_id']); array_push($teacher_list, $teacher); } } $this->db->close(); return $teacher_list; }