WordPress通过AJAX将数据保存到数据库

jQuery(document).ready(function($) {
    $('#my-form').on('submit', function(e) {
        e.preventDefault();
        var formData = $(this).serialize();

        $.ajax({
            url: ajax_object.ajax_url, // WordPress AJAX URL
            type: 'POST',
            data: formData,
            success: function(response) {
                console.log('Data saved successfully:', response);
            },
            error: function(jqXHR, textStatus, errorThrown) {
                console.error('Error saving data:', textStatus, errorThrown);
            }
        });
    });
});

// 在 functions.php 或自定义插件中添加
add_action('wp_ajax_save_my_data', 'save_my_data_callback');
add_action('wp_ajax_nopriv_save_my_data', 'save_my_data_callback');

function save_my_data_callback() {
    // 检查 nonce 安全性
    check_ajax_referer('my_ajax_nonce', 'security');

    // 获取表单数据
    $name = sanitize_text_field($_POST['name']);
    $email = sanitize_email($_POST['email']);

    // 将数据保存到数据库
    global $wpdb;
    $table_name = $wpdb->prefix . 'my_custom_table';
    $wpdb->insert(
        $table_name,
        array(
            'name' => $name,
            'email' => $email,
            'date' => current_time('mysql')
        )
    );

    wp_send_json_success('Data saved successfully.');
}