function addNonAcademicAchievement(Achievement $achievement) { $connectionObject = Connection::getInstance(); $connection = $connectionObject->get_connection(); $student_id = $achievement->getStudentId(); $school_id = $achievement->getSchoolId(); $achievement_case = $achievement->getAchievementCase(); $date = $achievement->getDate(); $case = $achievement->getCase(); $place = $achievement->getPlace(); $stmt = $connection->prepare("INSERT INTO achievement (student_id, school_id, achievement_case) VALUES (?,?,?)"); $stmt->bind_param("iis", $student_id, $school_id, $achievement_case); $result = $stmt->execute(); $stmt->close(); $achievement_id = mysqli_insert_id($connection); $stmt = $connection->prepare("INSERT INTO non_acadamic (achievement_id,ncase,place,date) VALUES (?,?,?,?)"); $stmt->bind_param("isis", $achievement_id, $case, $place, $date); $result = $stmt->execute(); $stmt->close(); return $result; }