Passing PHP array to Javascript via GET

Question

I'm trying to pass an array to Javascript after it has sent a GET request to PHP. Sending and retrieving the data works perfectly but I couldn't find anything about passing the data back as an array like this:

<?php

$result = mysql_query('blablabla');

//converting $result to an array?

echo $result_as_javascript_array;

?>

<script>
$('result').innerHTML = httpGet.responseText
</script>

Answer 1

Convert the data you get from MySQL to JSON. First build a "normal" PHP array as you would normally do, then pass it through the json_encode() function and return it.

On the client you have to parse the JSON string into a JS array or object. See this SO question for details: Parse JSON in JavaScript?

And please use something else for accessing MySQL. The extension you are using is basically obsolete: https://www.php.net/manual/en/faq.databases.php#faq.databases.mysql.deprecated

Answer 2

you should use json_encode, which works fine, when directly assigning output to a javascript variable

<?php

$result = mysql_query('blablabla');

//first convert result to an associative array
$myarray = array();
while($fetch = mysql_fetch_assoc($result)){
    $myarray[]=$fetch;
}

//converting $result to an array?
echo "<script>";
echo "var myArray = ".json_encode($myarray).";";
echo "</script>";
?>

<script>
//now you can use myArray global javascript variable
$('result').innerHTML = myArray.join(",");
</script>

Answer 3

You are looking for json_encode.

Answer 4

Use json_encode like this:

<?php

$result = mysql_query('blablabla');

//converting $result to an array?

echo json_encode($result);

?>

You probably won't want to put the response text right into the innerHTML of your element though unless you are wanting to display the json text in the element.

Answer 5

$arr = array();
while ($row = mysql_fetch_array($result)) {
    $arr[] = $row;
}
echo $arr;

However, mysql_ is deprecated, use mysqli instead.

If you want to pass it as JSON, use this:

echo json_encode($arr);