parse json array wich contains sql array

Question

Hello,

I am still searching for an answer but I haven't come up with a solution yet

My question: How can I parse the 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 wich works fine

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

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

value=data.values[1];

What am I doing wrong

thanks, Richard

Answer 1

$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

Answer 2

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.

Answer 3

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.