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; }