ajax response not recieving

Question

As per jQuery documentation, dataType: 'json' is supported. That is the thing that is being returned and parsed by jQuery to your success function. There is more information needed to resolve your issue.

~~Does pin_shop.ajax_url properly resolve to //site.com/wp-admin/admin-ajax.php? If not, there’s your first problem. (To check this, console.log(ajax_url); just before your $.ajax call.~~ I see your enqueue has this.

(Also, did you notice you’re not returning your result to the AJAX caller? I put a note of it in the code below.)

~~Next, you might not be sending your nonce. Check that $(this).data('nonce') resolves to the nonce? (To check this, console.log(nonce); just before your $.ajax call.)~~

Finally, you may not be resolving your nonce correctly on the server side. To primitively check this, comment out a few lines in your PHP code and see if success/complete is logged to the console, like so:

function pincode_search_field() {
    global $wpdb;
//  if ( wp_verify_nonce( $_REQUEST['nonce'], "pin_shop_nonce") ) {
        $result['database_result'] = $wpdb->get_results("SELECT ID FROM cs_shop_details WHERE pincode="192124"");
        $result = json_encode( $result );
        die();
//  }
}

Lastly, there might be an error in your SQL (as in the tablecs_shop_details does not exist or the pincode field does not exist in that table). To check that, comment out $result['database_result'] = ... and set $result=array() so that an empty result will be returned (and make sure $result is echoed).

(Also, I’m new so if any of this helps, and upvote would be appreciated to help me get my score up so that I can comment.)

EDIT: A little debugging, and the problem was learned to be that the PHP function is not echo-ing the json encoded result: add echo $result; just before die().

EDIT 2: In helping to debug the JSON response. First, note the $wpdb->get_results() will return an array. You put that array into the database_result index of the $results array. So, your structure now looks like this…

Array (
    'database_result' => Array (
        [0] => Array(
            "shop_id" => 1
        )
        ... (other results here, indexed sequentially)
    )
)

So, this array is what is being returned to .done(). Access this array accordingly via the response JSON object passed to the related function. I think something like response.database_result[0]["shop_id"] or response.database_result[0].shop_id.

Related Posts: