Problem with getJSON or PHP

Question

Display.php:

<?php
include 'sql.php';
$dataget = mysql_query("SELECT `user`,`message`,`timestamp` FROM `messages`");
$arr = array();
while ($dataarr = mysql_fetch_assoc($dataget)){
    $arr[] = $dataarr;
}
echo json_encode($arr);
?>

Index.php:

<script type="text/javascript" src="../jquery.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $.getJSON('display.php', function(data) {
            alert(data.0.user);
        });
    });
</script>

Trying to alert data.0.user.

cwallenpoole · Accepted Answer · 2011-09-06 18:19:00Z

4

The problem is that you can't have a . followed by a number (save in the context of a Number). You need to use Array look-up syntax.

var o = {0:"foo"}
o.0 // SyntaxError

On the other hand:

var o = {0:"foo"}
console.log(o[0])//foo

Also, a free-standing digit followed by a . needs to be followed by another digit (or a non-variable character). (eg: a0 can be followed by a ., as can 1, but 1. must be followed by a digit)

edited Sep 6, 2011 at 18:19

answered Sep 6, 2011 at 18:08

cwallenpoole

82.4k26 gold badges132 silver badges174 bronze badges

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

2 Comments

Joe Over a year ago

+1, but I don't understand your last statement. Because 1. as valid as 1.0 or 1.

cwallenpoole Over a year ago

@IAbstractDownvoteFactory I meant contiguous variable character

Cfreak · Accepted Answer · 2011-09-06 18:12:34Z

2

Use data[0].user in your Javascript.

answered Sep 6, 2011 at 18:12

Cfreak

19.4k6 gold badges52 silver badges64 bronze badges

Collectives™ on Stack Overflow

Problem with getJSON or PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related