parse json array which contains sql array

Question

My question: How can I parse a json array?

I send it like this:

$data= mysql_fetch_array($r);
header('Content-type: application/json');

?>              
{
    "check": "<?php echo $check?>",
    "productcode": "<?php echo $code?>",
     "values": [<?php echo $data?>]
}
<?php

on the ajax side I do this on the single values which works fine

success: function(data,textStatus){
    //return values
    identification=data.check;

if I want to access the array I do something like this and I get undefined

value=data.values[1];

What am I doing wrong?

Yeh, I heard that yesterday I really don't want to offend anybody. Sorry, I never payd much attention, to those things on the left sight. I will do that from now on. I really did not know at first why I was offending anyone, because I always say thank you. — Richard
– Richard, Commented Oct 12, 2009 at 12:39

Daff · Accepted Answer · 2009-10-12 12:24:48Z

1

You need to encode your array as JSON, too:

{
    "check": "<?php echo $check?>",
    "productcode": "<?php echo $code?>",
     "values": [<?php echo json_encode($data); ?>]
}

The easiest way is probably to put everything in a PHP array and serialize this as JSON:

$output = array(
    "check" => $check,
    "productcode" => $code,
    "values" => $data
);

echo json_encode($output);

Then you can be sure that it is being encoded properly.

answered Oct 12, 2009 at 12:24

Daff

44.4k9 gold badges108 silver badges122 bronze badges

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

4 Comments

Richard Over a year ago

thanks, could you comment on the mysql_NUM, can I still get the values by name then, in ajax success function.

Daff Over a year ago

You could use mysql_fetch_assoc which returns an associative array. That means, that you then can access the columns in a row by its name in JavaScript (and not by its index). Just check the result and then you'll see what it does.

Richard Over a year ago

With msql_fetch_array, associative is the default, because I get my results by name, or both I get from @RC, s comment below.

Daff Over a year ago

Oh ok sorry. Well the manual said that MYSQL_NUM gives you a non associative array.

Rowan · Accepted Answer · 2009-10-12 12:27:01Z

1

Try this:

$data= mysql_fetch_array($r);
header('Content-type: application/json');

$json = array(
    'check' => $check,
    'productcode' => $code,
    'values' => $data
    );

print json_encode($json);

It's more tidy than printing the json manually. json_encode turns a PHP array into a json string.

answered Oct 12, 2009 at 12:27

Rowan

5,7752 gold badges25 silver badges32 bronze badges

Comments

user180100 · Accepted Answer · 2009-10-12 12:22:41Z

0

$data= mysql_fetch_array($r, MYSQL_NUM);

could correct the problem.

It would be helpful to get the json you get in the ajax part

answered Oct 12, 2009 at 12:22

user180100

2 Comments

Richard Over a year ago

what is it know then, an asociative? is associative bad for parsing?

user180100 Over a year ago

according to the doc, it's both associative and num

Collectives™ on Stack Overflow

parse json array which contains sql array

3 Answers 3

4 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related