首页 文章

AJAX从Wordpress插件调用的脚本没有得到$ wpdb

提问于
浏览
2

我正在编写一个Wordpress插件,并希望使用ajax来提交数据 . 使用ajax在管理面板中提交表单时,我收到此错误:

致命错误:在第13行的/home1/crave/public_html/wp-content/plugins/MiniCMS/add_contenttype.php中的非对象上调用成员函数insert()

这是被调用的脚本 . 错误行已注释 .

<?php
global $wpdb;

$name = $_POST["name"];
$id = '1';
$text_inputs = $_POST["text_inputs"];
$paragraph_inputs = $_POST["paragraph_inputs"];
$map_inputs = $_POST["map_inputs"];
$file_inputs = $_POST["file_inputs"];

$contentTypeTable = $wpdb->prefix . "minicms_content_type";

//This is line 13, the problem child:
$wpdb->insert( $contentTypeTable, array(
    'name' => $name,
    'id' => $id,
    'text_inputs' => $text_inputs,
    'paragraph_inputs' => $paragraph_inputs,
    'map_inputs' => $map_inputs,
    'file_inputs' => $file_inputs
));
?>

Does anyone know why I'm not getting $wpdb to work?

1 回答

  • 3

    你需要在WordPress方式中使用ajax .

    From WordPress Doc:

    首先添加一些将触发AJAX请求的javascript:

    <?php
    add_action( 'admin_footer', 'my_action_javascript' );
    
    function my_action_javascript() {
    ?>
    <script type="text/javascript" >
    jQuery(document).ready(function($) {
    
        var data = {
            action: 'my_action',
            whatever: 1234
        };
    
        // since 2.8 ajaxurl is always defined in the admin header and points to admin-ajax.php
        $.post(ajaxurl, data, function(response) {
            alert('Got this from the server: ' + response);
        });
    });
    </script>
    <?php
    }
    

    然后,设置一个将处理该请求的PHP函数:

    add_action('wp_ajax_my_action', 'my_action_callback');
    
    function my_action_callback() {
        global $wpdb; // this is how you get access to the database
    
        $whatever = intval( $_POST['whatever'] );
    
        $whatever += 10;
    
            echo $whatever;
    
        die(); // this is required to return a proper result
    }
    

    参考:

    1. http://codex.wordpress.org/AJAX_in_Plugins
    2. http://wp.tutsplus.com/articles/getting-started-with-ajax-wordpress-pagination/

相关问题