Struggling to decode JSON in jquery ajax success callback from PHP script

Question

I've been trying to find an answer for this for hours but really struggling.

I have a simple jquery Ajax function which sends data to a PHP script. The data is then used to conduct a MySQL query and the results are included as an array. I'm sending the array back using json_encode but can't work out how to display the array at the other end. I've posted the code below. The console.log is displaying Object {modules: Array[0]}. There should be 3 entries in the array.

The PHP

<?php
 include_once('../../dbconnect.php');

$name = $_POST['uploadname'];

$query = "SELECT * FROM marking_assignments WHERE name = '$name'";
$details = $conn->query($query);
$modules = array();

while ($row = $details->fetch_assoc()){
 $modules[] = $row['unit'];
}

$dataarray = array("modules"=>$modules);
 echo json_encode($dataarray);
?>

The jQuery

  var uploadname;

  $("#uploadname").blur(function(){
   uploadname = $(this).val();
   $.ajax({
            url: "uploadnames.php",
            type: "POST",
            data: {uploadname: uploadname},
            dataType: 'json',
            success: function(data){
            console.log(data);
             }
            });

         });

You're certain everything on the php side is in order, such as $row['unit'] and all of that? — Sturm
– Sturm, Commented Mar 13, 2013 at 19:38
Might have something to do with the echo json_encode($modules); in the while loop. Looks like that shouldn't really be there? — Aydin Hassan
– Aydin Hassan, Commented Mar 13, 2013 at 19:38
If you're returning json to jQuery, you should only have one echo on the page. I'm surprised you're not getting a parseerror — user400654
– user400654, Commented Mar 13, 2013 at 19:42
Oops, hadn't noticed that - I've changed it now but doesn't seem to have resolved the problem — Chris
– Chris, Commented Mar 13, 2013 at 19:53

vovaminiof · Accepted Answer · 2013-03-13 19:57:00Z

1

you should use:

  var parsedData =  jQuery.parseJSON(data);

and then:

  console.log(parsedData)

answered Mar 13, 2013 at 19:57

vovaminiof

5111 gold badge4 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Felix Kling Over a year ago

No, jQuery will parse the JSON automatically in this case. The console wouldn't show Object {modules: Array[0]} if it wasn't parsed.

Collectives™ on Stack Overflow

Struggling to decode JSON in jquery ajax success callback from PHP script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related