INFOTECH ACADEMY

Register Now

query("SELECT course_name FROM enrolment_courses WHERE is_active = 1 ORDER BY course_name ASC"); $active_courses = $courses_stmt->fetchAll(PDO::FETCH_COLUMN); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $student_name = trim($_POST['student_name'] ?? ''); $sex = trim($_POST['sex'] ?? ''); $phone = trim($_POST['phone'] ?? ''); $email = trim($_POST['email'] ?? ''); $course_of_interest = trim($_POST['course_of_interest'] ?? ''); $mode = trim($_POST['mode'] ?? ''); $preferred_time = trim($_POST['preferred_time'] ?? ''); $start_date = trim($_POST['start_date'] ?? ''); $payment_plan = trim($_POST['payment_plan'] ?? ''); $home_address = trim($_POST['home_address'] ?? ''); $occupation = trim($_POST['occupation'] ?? ''); $sponsor_name = trim($_POST['sponsor_name'] ?? ''); $sponsor_phone = trim($_POST['sponsor_phone'] ?? ''); if (empty($student_name) || empty($phone) || empty($course_of_interest) || empty($mode) || empty($preferred_time) || empty($start_date) || empty($payment_plan) || empty($home_address) || empty($occupation)) { $error_msg = "Please fill in all required fields marked with *."; } else { $sql = "INSERT INTO student_enrolments (student_name, sex, phone, email, course_of_interest, mode, preferred_time, start_date, payment_plan, home_address, occupation, sponsor_name, sponsor_phone) VALUES (:student_name, :sex, :phone, :email, :course_of_interest, :mode, :preferred_time, :start_date, :payment_plan, :home_address, :occupation, :sponsor_name, :sponsor_phone)"; $stmt = $pdo->prepare($sql); $executed = $stmt->execute([ ':student_name' => htmlspecialchars($student_name), ':sex' => htmlspecialchars($sex), ':phone' => htmlspecialchars($phone), ':email' => !empty($email) ? htmlspecialchars($email) : NULL, ':course_of_interest' => htmlspecialchars($course_of_interest), ':mode' => htmlspecialchars($mode), ':preferred_time' => htmlspecialchars($preferred_time), ':start_date' => htmlspecialchars($start_date), ':payment_plan' => htmlspecialchars($payment_plan), ':home_address' => htmlspecialchars($home_address), ':occupation' => htmlspecialchars($occupation), ':sponsor_name' => !empty($sponsor_name) ? htmlspecialchars($sponsor_name) : NULL, ':sponsor_phone' => !empty($sponsor_phone) ? htmlspecialchars($sponsor_phone) : NULL, ]); if ($executed) { $success_msg = "Enrolment submitted successfully! Our administrative team will reach out to you shortly."; } else { $error_msg = "An error occurred while submitting your enrolment. Please try again."; } } } ?>