function ai_survey_save_response($data) { global $wpdb; $table_name = $wpdb->prefix . 'ai_survey_responses'; // Create table if it doesn't exist if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) { $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, full_name varchar(255) NOT NULL, email varchar(255) NOT NULL, mobile varchar(20) NOT NULL, program varchar(255) NOT NULL, state varchar(255) NOT NULL, PRIMARY KEY (id) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } // Insert data into the database $wpdb->insert( $table_name, array( 'full_name' => sanitize_text_field($data['full_name']), 'email' => sanitize_email($data['email']), 'mobile' => sanitize_text_field($data['mobile']), 'program' => sanitize_text_field($data['program']), 'state' => sanitize_text_field($data['state']), ) ); } add_action('wp_ajax_ai_survey_submit', 'ai_survey_handle_submission'); add_action('wp_ajax_nopriv_ai_survey_submit', 'ai_survey_handle_submission'); function ai_survey_handle_submission() { if ($_SERVER['REQUEST_METHOD'] === 'POST') { $data = $_POST; ai_survey_save_response($data); wp_send_json_success('Thank you for completing the survey!'); } wp_send_json_error('An error occurred. Please try again.'); }