function addTransferredTeacher(Teacher $teacher) { $connectionObject = Connection::getInstance(); $connection = $connectionObject->get_connection(); $teacher_id = $teacher->getTeacherId(); $registered_date = $teacher->getRegisteredDate(); $distance = $teacher->getDistance(); $school_id = $_SESSION['school_id']; $stmt = $connection->prepare("INSERT INTO teacher_school (teacher_id,school_id,start_of_working_date,distance_from_permanent_residence) VALUES (?,?,?,?)"); echo "INSERT INTO teacher_school (teacher_id,school_id,start_of_working_date,distance_from_permanent_residence) VALUES ({$teacher_id},{$school_id},{$registered_date},{$distance})"; $stmt->bind_param("iisi", $teacher_id, $school_id, $registered_date, $distance); $result = $stmt->execute(); $stmt->close(); return $result; }
$address = $_POST['address']; $distance = $_POST['distance']; $contact_number = $_POST['contact_number']; $teacher = new Teacher($address, $distance, $name, $contact_number, $registered_date, $subject); $teacherController = new TeacherController(); $teacherController->addTeacher($teacher); include "add_transferred_student.php"; } elseif (isset($_POST['add_transferred_teacher'])) { $teacher_id = $_POST['teachersforschool']; $name = ""; $registered_date = $_POST['date']; $subject = ""; $address = ""; $contact_number = ""; $distance = $_POST['distance']; $teacher = new Teacher($address, $distance, $name, $contact_number, $registered_date, $subject); $teacher->setTeacherId($teacher_id); $teacherController = new TeacherController(); $teacherController->addTransferredTeacher($teacher); include "add_transferred_teacher.php"; } elseif (isset($_POST['addAcademicAchievement'])) { $student_id = $_POST["student_id"]; $ol = $_POST["ol"]; $al = $_POST["al"]; $school_id = $_SESSION['school_id']; $achievement = new Achievement($student_id, $school_id, "Academic"); $achievement->setOl($ol); $achievement->setAl($al); $achievement_controller = new AchievementController(); $achievement_controller->addAcademicAchievement($achievement); include "add_acadamic_achievement.php";