jQuery $.ajax request of dataType json will not retrieve data from PHP script

by

I think I know this one…

Try sending your JSON as JSON by using PHP’s header() function:

/**
 * Send as JSON
 */
header("Content-Type: application/json", true);

Though you are passing valid JSON, jQuery’s $.ajax doesn’t think so because it’s missing the header.

jQuery used to be fine without the header, but it was changed a few versions back.

ALSO

Be sure that your script is returning valid JSON. Use Firebug or Google Chrome’s Developer Tools to check the request’s response in the console.

UPDATE

You will also want to update your code to sanitize the $_POST to avoid sql injection attacks. As well as provide some error catching.

if (isset($_POST['get_member'])) {

    $member_id = mysql_real_escape_string ($_POST["get_member"]);

    $query = "SELECT * FROM `members` WHERE `id` = '" . $member_id . "';";

    if ($result = mysql_query( $query )) {

       $row = mysql_fetch_array($result);

       $type = $row['type'];
       $name = $row['name'];
       $fname = $row['fname'];
       $lname = $row['lname'];
       $email = $row['email'];
       $phone = $row['phone'];
       $website = $row['website'];
       $image = $row['image'];

       /* JSON Row */
       $json = array( "type" => $type, "name" => $name, "fname" => $fname, "lname" => $lname, "email" => $email, "phone" => $phone, "website" => $website, "image" => $image );

    } else {

        /* Your Query Failed, use mysql_error to report why */
        $json = array('error' => 'MySQL Query Error');

    }

     /* Send as JSON */
     header("Content-Type: application/json", true);

    /* Return JSON */
    echo json_encode($json);

    /* Stop Execution */
    exit;

}

More Related Contents:

  1. PHP display div with select option
  2. Simple jQuery, PHP and JSONP example?
  3. Sending JSON to PHP using ajax
  4. jQuery ajax request with json response, how to?
  5. Submitting JSON data via JQuery ajax.post to PHP
  6. Retrieve JSON POST data in CodeIgniter
  7. How to pass an array using PHP & Ajax to Javascript?
  8. Ajax call with contentType: ‘application/json’ not working
  9. Jquery AJAX post to PHP
  10. json_encode not working with a html string as value
  11. How do I post multiple parameters to a URL
  12. Can anyone help me what is wrong in this code ajax using with php? [closed]
  13. Using Jquery Ajax to retrieve data from Mysql
  14. Update data on a page without refreshing
  15. PHP returning JSON to JQUERY AJAX CALL
  16. Send JSON data from Javascript to PHP?
  17. Send multiple checkbox data to PHP via jQuery ajax()
  18. Update fee dynamically based on radio buttons in Woocommerce checkout
  19. How to load PHP file into DIV by jQuery?
  20. Difference between php echo and return in terms of a jQuery ajax call [closed]
  21. Get variable from PHP file using JQuery/AJAX
  22. PHPExcel download using ajax call
  23. Jquery: Running AJAX locally without a webserver
  24. jQuery AJAX Call to PHP Script with JSON Return
  25. How to populate dependable drop-down using Ajax and php [closed]
  26. How can I pass variables from JavaScript to PHP?
  27. Call PHP function from jQuery?
  28. How to show ajax loading gif animation while the page is loading?
  29. How to remove backslash on json_encode() function?
  30. How to send the values of an array of checkboxes through Ajax using jQuery?

Leave a Comment