function addAcademicAchievement(Achievement $achievement) { $connectionObject = Connection::getInstance(); $connection = $connectionObject->get_connection(); $student_id = $achievement->getStudentId(); $ol = $achievement->getOl(); $al = $achievement->getAl(); $achievement_case = $achievement->getAchievementCase(); $school_id = $achievement->getSchoolId(); $stmt = $connection->prepare("INSERT INTO achievement (student_id, school_id, achievement_case) VALUES (?,?,?)"); $stmt->bind_param("iis", $student_id, $school_id, $achievement_case); echo $student_id . " " . $school_id . " " . $achievement_case; $result = $stmt->execute(); $stmt->close(); $achievement_id = mysqli_insert_id($connection); $stmt = $connection->prepare("INSERT INTO acadamic (achievement_id,ordinary_level,advanced_level) VALUES (?,?,?)"); $stmt->bind_param("iss", $achievement_id, $ol, $al); $result = $stmt->execute(); $stmt->close(); return $result; }
$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"; } elseif (isset($_POST['add_non_academic_achievement'])) { $student_id = $_POST["student_id"]; $date = $_POST["date"]; $case = $_POST["case"]; $place = $_POST["place"]; $school_id = $_SESSION['school_id']; $achievement = new Achievement($student_id, $school_id, "Non_Academic"); $achievement->setDate($date); $achievement->setCase($case); $achievement->setPlace($place); $achievement_controller = new AchievementController(); $achievement_controller->addNonAcademicAchievement($achievement); include "add_non_acadamic_achievement.php"; } elseif (isset($_POST['add_leaving_record'])) { $school_id = $_SESSION["school_id"]; $student_id = $_POST["student_id"]; $date = $_POST["date"]; $studentController = new StudentController(); $studentController->addLeavingRecord($school_id, $student_id, $date); include "./leaving_record.php"; } else { include "school_index.php";