Issues importing array from PHP with $.get()

Question

The array values return as 'undefined' when printed, even though by using print_r($items) I can see that the array is not empty. What could be the issue here?

MySQL:

Table called 'nights' with columns called 'name', 'price', 'day', 'queue jump', 'closing' and 'doors'. They are all populated.

eventinfo.php:

<?php

header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');

include('functions.php');
connect();

$night = $_POST['club'];
// this echos fine
$night = mysql_real_escape_string($night);

$query = "SELECT * FROM nights WHERE name = '$night'";

    $result = mysql_query($query);
    $items = array();

    if($result && mysql_num_rows($result) > 0) { 
        while ($row = mysql_fetch_array($result)) { 
        $items[] = array("price"=>$row['price'], "day"=>$row['day'], "queue jump"=>$row['queue jump'], "closing"=>$row['closing'], "doors"=>$row['doors']);
        }
    } 

    mysql_close(); 
    // convert into JSON format and print

    echo json_encode($items);
?>

JS:

<script type="text/javascript">

    $(document).ready(function() {
// for simplicity's sake, but ultimately I'd like to load all the information
            $('#right_inside').html('<h2>' + $('#club').val() + '</h2>');
    });

    $('#club').change(function(event) {
        $.ajax({
            type: "post",
            url: "eventinfo.php",
            data:  $(this).serialize(),
            success: function(data) {
                $('#right_inside').html('<h2>' + $('#club').val() + '</h2><p>Day: ' + data.day + '</p>');
                },
            dataType: "json"
        });
    });

</script>

what is the result of the net request to eventinfo.php in firebug or just going to the site directly? — Ryan
– Ryan, Commented Jun 13, 2012 at 23:09
What does console.log(data) output when you add it to the success callback? Surely there will be a notice about an error... — powtac
– powtac, Commented Jun 13, 2012 at 23:09
try seeing the results of the ajax by JSON.stringify(data) — user1403947
– user1403947, Commented Jun 13, 2012 at 23:12

user1403947 · Accepted Answer · 2012-06-13 23:17:16Z

5

You have got your JSON structure wrong. Data is actually an array:

Try changing data.day to data[0].day

Note: You should use JSON.stringify(data) in your ajax success to see the structure of your JSON.

$.ajax({
  type: "post",
  url: "eventinfo.php",
  data:  $(this).serialize(),
  success: function(data) {
     alert(JSON.stringify(data));
     //or
     console.log(JSON.stringify(data));
  },
   dataType: "json"
 });

answered Jun 13, 2012 at 23:17

user1403947

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

1 Comment

Sebastian Over a year ago

This worked. Thanks very much - will accept as soon as I can.

Collectives™ on Stack Overflow

Issues importing array from PHP with $.get()

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