get_charset_collate(); // Table: Applications $table_apps = $wpdb->prefix . 'ihm_applications'; $sql_apps = "CREATE TABLE $table_apps ( id mediumint(9) NOT NULL AUTO_INCREMENT, application_no varchar(50) UNIQUE, academic_year varchar(20) NOT NULL, course_name varchar(100) NOT NULL, center_name varchar(100) NOT NULL, first_name varchar(100) NOT NULL, last_name varchar(100) NOT NULL, dob date NOT NULL, email varchar(150) NOT NULL, phone_mobile varchar(20) NOT NULL, status varchar(20) DEFAULT 'submitted', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql_apps); } // 2. SHORTCODE FOR FRONTEND FORM [ihm_apply_form] add_shortcode('ihm_apply_form', 'ihm_render_application_form'); function ihm_render_application_form() { // Check if form was just submitted if (isset($_GET['ihm_success']) && $_GET['ihm_success'] == '1') { return '

Application Submitted Successfully!

Your Application Number is: ' . esc_html($_GET['app_no']) . '

Please save this number for future reference.

'; } ob_start(); ?>

Step 1: Course Selection

Step 2: Personal Details

sanitize_text_field($_POST['academic_year']), 'course_name' => sanitize_text_field($_POST['course_name']), 'center_name' => sanitize_text_field($_POST['center_name']), 'first_name' => sanitize_text_field($_POST['first_name']), 'last_name' => sanitize_text_field($_POST['last_name']), 'dob' => sanitize_text_field($_POST['dob']), 'phone_mobile' => sanitize_text_field($_POST['phone_mobile']), 'email' => sanitize_email($_POST['email']), 'status' => 'submitted' ); $table_name = $wpdb->prefix . 'ihm_applications'; // Insert Data $wpdb->insert($table_name, $data); // Generate Application ID (IHMA + Year + ID) $insert_id = $wpdb->insert_id; $year = date('Y'); $app_no = "IHMA" . $year . str_pad($insert_id, 4, '0', STR_PAD_LEFT); // Update with Application No $wpdb->update( $table_name, array('application_no' => $app_no), array('id' => $insert_id) ); // Redirect back to page with success message $redirect_url = add_query_arg(array('ihm_success' => '1', 'app_no' => $app_no), wp_get_referer()); wp_redirect($redirect_url); exit; } // 4. ADD ADMIN MENU add_action('admin_menu', 'ihm_admission_menu'); function ihm_admission_menu() { add_menu_page( 'IHM Admissions', // Page Title 'Admissions', // Menu Title 'manage_options', // Capability 'ihm-admissions', // Menu Slug 'ihm_admin_dashboard', // Function 'dashicons-welcome-learn-more', // Icon 6 ); } // 5. RENDER ADMIN DASHBOARD (LIST APPLICATIONS) function ihm_admin_dashboard() { global $wpdb; $table_name = $wpdb->prefix . 'ihm_applications'; $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY id DESC"); ?>

IHM Admission Applications

App No Name Course Mobile Email Status Date
application_no); ?> first_name . ' ' . $row->last_name); ?> course_name); ?> phone_mobile); ?> email); ?> status); ?> created_at)); ?>
No applications received yet.