Pass PHP array values to JavaScript variable

Question

I am trying to get the values of PHP Array in JavaScript variable. Here is my code:

    $qry="select * from optin";
    $rlt1=mysql_query($qry);
    $em_ary=array();
    while($row= mysql_fetch_array($rlt1)){
        $em_ary=$row;
        echo $em_ary['timer'];}// this echo show all records that I have in data base and I want to get all the values in Javascript


<script>
    var tmr=[];
    tmr='<?php echo json_encode($em_ary['timer']); ?>';
    alert(tmr);// this alert only shows the last record in the database 
<?script>

Where I am going wrong or is there any other way to accomplish this? Thanks in advance!

If I had a penny for each time someone asked how to pass a PHP variable’s value to JavaScript, I’d be a millionaire. — Martin Bean, Jul 15 '15 at 07:24
possible duplicate of [Pass a PHP array to a JavaScript function](http://stackoverflow.com/questions/4885737/pass-a-php-array-to-a-javascript-function) — Martin Bean, Jul 15 '15 at 07:25
wow. but starter will always get struggle them. teach them with smile. — Raghavendra, Jul 15 '15 at 07:25
Also, don't use `mysql_*` functions. They're deprecated and will be **removed** in a future version of PHP, at which point your code **won't work**. — Martin Bean, Jul 15 '15 at 07:26

Narendrasingh Sisodia · Answer 1 · 2015-07-15T10:13:05.380

0

You are overwriting values within your $em_ary array in order to make an array of values you need to place [] after $em_ary which will result you an array

$em_ary[]=$row;

You need to update this also from

tmr='<?php echo json_encode($em_ary['timer']); ?>';

into

tmr="<?php echo json_encode({$em_ary['timer']}); ?>";

edited Jul 15 '15 at 10:13

answered Jul 15 '15 at 07:19

Narendrasingh Sisodia

21,247
6
47
54

still i am not getting values in javascript variable! – Rajeet Jul 15 '15 at 10:11

score 0 · Accepted Answer · answered Jul 15 '15 at 10:35

0

You need to update this line:

$em_ary = $row;

and change it to:

$em_ary[] = $row;

You are overwriting the array each time you want to add a new element to it.

Then, in the JS part, update this line:

tmr = '<?php echo json_encode($em_ary['timer']); ?>';

to:

tmr = JSON.parse('<?php echo json_encode($em_ary); ?>');

Hope this helps! Cheers!

answered Jul 15 '15 at 10:35

Romi Halasz

1,949
1
13
23

I'm glad my suggestion was useful. Kudos! – Romi Halasz Jul 15 '15 at 13:35

Pass PHP array values to JavaScript variable

2 Answers2