I'm attempting to pass a PHP array so that I can use it in JavaScript.
The PHP code I have written is shown below:
<?php
$link = mysqli_connect("localhost", "root", "password", "database");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "SELECT * FROM Employees";
if ($result = mysqli_query($link, $query)) {
/* fetch associative array */
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
print_r($row);
/* free result set */
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
//convert the PHP array into JSON format, so it works with javascript
$json_array = json_encode($data);
?>
JavaScript:
<script>
var array = <?php echo $data; ?>;
console.log(array);
</script>
Unfortunately, it seems like the data array from PHP is not being successfully transferred to the Javascript variable array. The Firebug console displays the following error messages:
Notice - Array to string conversion.
If anyone has any insights on why this problem is happening, your help would be greatly appreciated.