how can we assign a javascript array from mysql database with the help of php?

Question

I would like to know if we can select data from the database using php and assign it to a javascript array? if so what would be the syntax?

I wrote the code below but it is not working

$js_array = "[";
$result = mysql_query("SELECT item_name FROM tbl_item");
while( $row=mysql_fetch_array($result, MYSQL_NUM) ) {
    $js_array .= $row[0]; 
    $js_array .= ",";
}
$js_array{ strlen($js_array)-1 } = ']';

 ?>

<script>
var cities = <?php echo  $js_array; ?>
for(var i=0; i<4;i++)
alert(cities.length);

</script>

You should manually build JSON. Have a look at the output. You will create something like [name1, name2, name3] which will result in an error because nameX are undefined variables. — Felix Kling
– Felix Kling, Commented Jun 30, 2011 at 8:46
possible duplicate of How can I populate a javascript array with values from a database using PHP? — Felix Kling
– Felix Kling, Commented Jun 30, 2011 at 8:56

Boldewyn · Accepted Answer · 2011-06-30 08:46:08Z

1

The simplest approach is converting to JSON with json_encode:

// with $js_array being a true array
var cities = <?php echo json_encode($js_array)?>;

Note, that there are esoteric cases, where this solution might not work. On the other hand, the advantage is, that json_encode takes over all quoting needs.

answered Jun 30, 2011 at 8:46

Boldewyn

83.1k45 gold badges161 silver badges218 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 20:08:53Z

0

Use json_encode

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered Jun 30, 2011 at 8:43

Peter Kruithof

10.9k6 gold badges32 silver badges42 bronze badges

Comments

Prathab K · Accepted Answer · 2011-06-30 08:46:45Z

0

You should not echo the array object.

Iterate the array and echo the value.

<?php foreach( $js_array as $value) echo "'$value',"; ?>

answered Jun 30, 2011 at 8:46

Prathab K

895 bronze badges

1 Comment

Boldewyn Over a year ago

This doesn't work in IE because of the trailing comma. You will have to work around this complicately or use implode().

Collectives™ on Stack Overflow

how can we assign a javascript array from mysql database with the help of php?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related