Pass PHP array into Javascript array

Question

Referring to the title. I have an array which I coded like this:-

$query = "SELECT * FROM server";
$result = mysql_query($query);
$dServer = array();

while($row = mysql_fetch_assoc($result)) {
    $dServer[] = $row['model'];
}

Now, how do I pass the $dServer array into a Javascript array?

For example, this array:

var a = new Array();

Please use the search function. About 1/4 of the questions in the "Related" sidebar answer your question. — jprofitt, Apr 19 '12 at 02:02
@zerkms If they used quotes it would make `a` a string rather than a variable defined by JSON. — jprofitt, Apr 19 '12 at 02:04
@jprofitt: oops, missed that it is not an ajax response, but inline JS — zerkms, Apr 19 '12 at 02:19

score 15 · Accepted Answer · answered Apr 19 '12 at 02:01

$query = "SELECT * FROM server";
$result = mysql_query($query);
$dServer = array();

while($row = mysql_fetch_assoc($result)){
    $dServer[] = $row['model'];
}    

?>
<script type="text/javascript">
    var a = <?php echo json_encode($dServer); ?>;
</script>

score 3 · Answer 2 · answered Apr 19 '12 at 02:01

3

Encode it as a json object.

<?
    $arr = array('entry' => 'content');
?>

<script>
var data = <?=json_encode($arr);?>;
alert(data['entry']);
</script>

answered Apr 19 '12 at 02:01

Mārtiņš Briedis

17,396
5
54
76

score 1 · Answer 3 · answered Apr 19 '12 at 02:00

Try to get use of ajax request and json_encode.

Second variant

<?php
$query = "SELECT * FROM server";
$result = mysql_query($query);
$dServer = array();

     while($row = mysql_fetch_assoc($result))
      {
              $dServer[] = $row['model'];
      }    
?>
var a = <?php echo json_encode($dServer);?>;

score 1 · Answer 4 · answered Apr 19 '12 at 02:46

In addition to the ajax / json methods mentioned, you can directly print out the values:

<?php
  $query = "SELECT * FROM server";
  $result = mysql_query($query);
?>

<script type="text/javascript">
  var a = new Array();

<?php
  while($row = mysql_fetch_assoc($result)){
    echo "a['model'] = " . $row['model'] . ";"; 
    echo "a['nextField'] = " . $row['nextField'] . ";"; 
  }
?>
</script>

Pass PHP array into Javascript array

4 Answers4

Linked

Related