public function get_by_id($id) { //connect $this->db->connect(); //query $sql = "SELECT * FROM students WHERE id=?"; //prepare $stmt = $this->db->initialize($sql); //bind $stmt->bind_param("i", $id); //execute $stmt->execute(); //bind result $stmt->bind_result($id, $first_name, $last_name, $email, $contact_no, $course); while ($row = $stmt->fetch()) { $student = new Students(); $student->set_id($id); $student->set_first_name($first_name); $student->set_last_name($last_name); $student->set_email($email); $student->set_contact_no($contact_no); $student->set_course($course); } $this->db->close(); return $student; }
private function map_data() { $student = new Students(); $student->set_first_name($_POST['first_name']); $student->set_last_name($_POST['last_name']); $student->set_email($_POST['email']); $student->set_contact_no($_POST['contact_no']); $student->set_course($_POST['course_id']); return $student; }
private function _map_posted_data() { $students = new Students(); $students->set_first_name($_POST['first_name']); $students->set_last_name($_POST['last_name']); $students->set_email($_POST['email']); $students->set_contact_no($_POST['contact_no']); $students->set_course($_POST['course']); return $students; }
public function get_all() { $student_list = array(); //database connect $this->db->connect(); //query $sql = "SELECT * FROM students"; //execute and fetch data $result = $this->db->fetch_query($sql); while ($row = $result->fetch_assoc()) { //put in object $student = new Students(); $student->set_id($row['id']); $student->set_first_name($row['first_name']); $student->set_last_name($row['last_name']); $student->set_email($row['email']); $student->set_contact_no($row['contact_no']); $student->set_course($row['course']); array_push($student_list, $student); } return $student_list; $this->db->close; }
<?php include_once "config.php"; include_once ROOT_PATH . "students/header.php"; require_once ROOT_PATH . "system/models/students.class.php"; require_once ROOT_PATH . "system/dbutil/dbconnection.class.php"; require_once ROOT_PATH . "system/repository/studentrepository.class.php"; $students = new Students(); $students->set_first_name($_POST['first_name']); $students->set_last_name($_POST['last_name']); $students->set_email($_POST['email']); $students->set_contact_no($_POST['first_name']); $students->set_course($_POST['course']); $studentrepository = new StudentRepository(); $success = false; if (isset($_POST['id']) && $_POST['id'] == '') { $result = $studentrepository->insert($students); } else { $result = $studentrepository->update($students); } if ($result > 0) { header("location:index.php?success=true"); } else { header("location:index.php?error=true"); } exit;
require_once ROOT_PATH . "system/model/students.class.php"; require_once ROOT_PATH . "system/repository/studentrepository.class.php"; ?> <?php include_once "header.php"; ?> <?php if (!isset($_POST['submit'])) { header('Location: index.php'); exit; } $students = new Students(); $students->set_first_name($_POST['first_name']); $students->set_last_name($_POST['last_name']); $students->set_email($_POST['email']); $students->set_contact_no($_POST['contact_no']); $students->set_course($_POST['course']); $studentrepository = new StudentRepository(); $result = 0; if (isset($_POST['id']) && $_POST['id'] == '') { echo "im here"; $result = $studentrepository->insert($students); } else { $students->set_id($_POST['id']); $result = $studentrepository->update($students); } if ($result > 0) { header("Location: index.php?success=true"); }