public function get_by_id($id)
{
$this->db->connect();
$sql = "SELECT * FROM teachers WHERE id=?";
$stmt = $this->db->initialize($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->bind_result($id, $first_name, $last_name, $email, $contact_no, $faculty);
$teacher = new Teachers();
while ($row = $stmt->fetch()) {
$teacher->set_id($id);
$teacher->set_first_name($first_name);
$teacher->set_last_name($last_name);
$teacher->set_email($email);
$teacher->set_contact_no($contact_no);
$teacher->set_faculty($faculty);
}
return $teacher;
}
require_once "config.php";
require_once ROOT_PATH . "system/model/teachers.class.php";
require_once ROOT_PATH . "system/repository/teacherrepository.class.php";
require_once ROOT_PATH . "system/dbutil/dbconnection2.class.php";
?>
<?php
include_once ROOT_PATH . "teachers/header.php";
?>
<?php
if (!isset($_POST['submit'])) {
header("Location: index.php");
exit;
}
$teacher = new Teachers();
$teacher->set_first_name($_POST['first_name']);
$teacher->set_last_name($_POST['last_name']);
$teacher->set_email($_POST['email']);
$teacher->set_contact_no($_POST['contact_no']);
$teacher->set_faculty($_POST['faculty']);
$teacherrepository = new TeacherRepository();
if (isset($_POST['id']) && $_POST['id'] == "") {
$result = $teacherrepository->insert($teacher);
} else {
$teacher->set_id($_POST['id']);
$result = $teacherrepository->update($teacher);
}
if ($result > 0) {
header("Location: index.php/?success=true");
}
