function addStudent(Student $student) { $connectionObject = Connection::getInstance(); $connection = $connectionObject->get_connection(); $number = $student->getNumber(); $name_in_full = $student->getNameInFull(); $address = $student->getAddress(); $registered_date = $student->getRegisterdDate(); $grade = $student->getGrade(); $school_id = $_SESSION['school_id']; $is_old_boy = 0; $stmt = $connection->prepare("INSERT INTO student(name_in_full, address) VALUES (?,?)"); $stmt->bind_param("ss", $name_in_full, $address); $result = $stmt->execute(); $stmt->close(); $student_id = mysqli_insert_id($connection); $stmt = $connection->prepare("INSERT INTO student_school(student_id, school_id, registered_date,is_old_boy, starting_grade, registration_number) VALUES (?,?,?,?,?,?)"); $stmt->bind_param("sssiss", $student_id, $school_id, $registered_date, $is_old_boy, $grade, $number); $result = $stmt->execute(); $stmt->close(); return $result; }