我使用自定义插件在wordpress管理端显示值。。

我的Jquery html文件是

<script type=\'text/javascript\'>
                    jQuery(document).ready(function(){
                    jQuery("#searchsubmit").click( function(e) {
                    e.preventDefault();
                    var data = jQuery("#eventname").val();
                    var city =  jQuery("#city").val();
                    var date =  jQuery("#datepicker").val();

                    jQuery.ajax({
                            type:\'POST\',
                            url: \'./admin-ajax.php\',
                            data:{action:\'my_action\',test:data,test1:city,test2:date},
                            dataType: \'html\',                                   
                            success: function(response) {
                                alert(response);
                            }
                           });
                            });

                    });
                </script>

我的插件文件是

add\\u action（“wp\\u ajax\\u my\\u action”，“my\\u action\\u callback”）；

function my_action_callback(){

        $name = $_POST[\'test\'];
        $city = $_POST[\'test1\'];
        $date = $_POST[\'test2\'];

        if ($date != \'\') {
            $enddate = date("Y-m-t", strtotime($date));
            $dates_sql = " AND start_date <= \'$date\' ";
            }
            if ($city != \'\' && $city != -1) 
            $destination_sql = "AND venue = \'$city\'";
            if ($name != \'\' && $name != -1) 
                $origincity_sql = "AND event_name = \'$name\'";

        $query = " SELECT * FROM <table name> WHERE event_id!=\'\' " . $dates_sql . " " . $destination_sql . " " . $origincity_sql . " ORDER BY start_date DESC ";

        $results = $wpdb->get_results($query) or die(mysql_error());    

        foreach ($results as $row)
        {
            $message  = "<tr><td align=\'center\' id = \'username\'>".$row->username."</td><td align=\'center\' id = \'eventname\'>".$row->event_name."</td><td align=\'center\' id = \'venue\'>". $row->venue."</td><td align=\'center\' id = \'email\'>".$row->email."</td><td align=\'center\' id = \'misseddays\'>".$row->missed_days."</td><td align=\'center\' id = \'paymentstatus\'>".$row->payment_mode."</td><td align=\'center\' id = \'amountpaid\'>".$row->amount_paid."</td><td align=\'center\' id = \'amountbalance\'>".$row->amount_balance."</td><td align=\'center\' id = \'mailsent\'>".$row->mail."</td></tr>";
        }  

        echo $message;
        exit();
    }

尽管jquery html文件返回-1作为响应，但我没有将响应输入到jquery html文件中。要进行任何更改，请帮助。今天在这件事上卡住了。

<?php
add_action( \'wp_ajax_my_action\', \'my_action_callback\' );
//Uncomment next line if you want the ajax action enable in the frontend
//add_action( \'wp_ajax_nopriv_my_action\', \'my_action_callback\' );
function my_action_callback() {
    global $wpdb;
    $name = $_POST[\'test\'];
    $city = $_POST[\'test1\'];
    $date = $_POST[\'test2\'];

    if ($date != \'\') {
        $enddate = date("Y-m-t", strtotime($date));
        $dates_sql = " AND start_date <= \'$date\' ";
    }
   if ($city != \'\' && $city != -1) {
        $destination_sql = "AND venue = \'$city\'";
   }
   if ($name != \'\' && $name != -1) {
            $origincity_sql = "AND event_name = \'$name\'";
   }

   $query = " SELECT * FROM <table name> WHERE event_id!=\'\' " . $dates_sql . " " . $destination_sql . " " . $origincity_sql . " ORDER BY start_date DESC ";

    $results = $wpdb->get_results($query) or die(mysql_error());    

    foreach ($results as $row) {
        $message  = "<tr><td align=\'center\' id = \'username\'>".$row->username."</td><td align=\'center\' id = \'eventname\'>".$row->event_name."</td><td align=\'center\' id = \'venue\'>". $row->venue."</td><td align=\'center\' id = \'email\'>".$row->email."</td><td align=\'center\' id = \'misseddays\'>".$row->missed_days."</td><td align=\'center\' id = \'paymentstatus\'>".$row->payment_mode."</td><td align=\'center\' id = \'amountpaid\'>".$row->amount_paid."</td><td align=\'center\' id = \'amountbalance\'>".$row->amount_balance."</td><td align=\'center\' id = \'mailsent\'>".=$row->mail."</td></tr>";
    }  
    header(\'Content-Type: application/json\');
    echo json_encode($message);
    exit;
}

?>