private function _map_posted_data() { $student = new Student(); $student->set_first_name($_POST['first_name']); $student->set_last_name($_POST['last_name']); $student->set_dob($_POST['dob']); $student->set_blood_group($_POST['blood_group']); $student->set_email($_POST['email']); $student->set_contact($_POST['contact']); $student->set_program_id($_POST['program_id']); return $student; }
public function get_all() { $student_list = array(); $this->db->connect(); $sql = "SELECT * from tbl_student"; $result = $this->db->fetchQuery($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $student = new Student(); $student->set_id($row['id']); $student->set_first_name($row['first_name']); $student->set_last_name($row['last_name']); $student->set_dob($row['dob']); $student->set_blood_group($row['blood_group']); $student->set_email($row['email']); $student->set_contact($row['contact']); $student->set_program_id($row['program_id']); array_push($student_list, $student); } } $this->db->close(); return $student_list; }
public function get_by_id($id) { $student = null; $this->db->connect(); $sql = "SELECT id,first_name,last_name,dob,blood_group,email,contact,program_id from tbl_student WHERE id=?"; $stmt = $this->db->initStatement($sql); $stmt->bind_param("i", $id); $stmt->execute(); $stmt->bind_result($id, $first_name, $last_name, $dob, $blood_group, $email, $contact, $program_id); while ($stmt->fetch()) { $student = new Student(); $student->set_id($id); $student->set_first_name($first_name); $student->set_last_name($last_name); $student->set_dob($dob); $student->set_blood_group($blood_group); $student->set_email($email); $student->set_contact($contact); $student->set_program_id($program_id); } $this->db->close(); return $student; }
<?php include_once '../config.php'; include_once ROOT_PATH . 'system/models/student.class.php'; include_once ROOT_PATH . 'system/repository/student_repository.class.php'; include_once 'header.php'; if (!isset($_POST['submit'])) { header('location:student.php?error=nopage'); } $student = new Student(); $student->set_first_name($_POST['first_name']); $student->set_last_name($_POST['last_name']); $student->set_dob($_POST['dob']); $student->set_blood_group($_POST['blood_group']); $student->set_email($_POST['email']); $student->set_contact($_POST['contact']); $student->set_program_id($_POST['program_id']); $student_repository = new StudentRepository(); $result_add = 0; $result_edit = 0; if (!isset($_POST['id']) || $_POST['id'] == '') { $result_add = $student_repository->insert($student); } else { $student->set_id($_POST['id']); $result_edit = $student_repository->update($student); } if ($result_add > 0) { header('location:student.php?success=true'); } elseif ($result_edit > 0) { header('location:student.php?update=true'); } elseif ($result_edit == 0) {