如何将PHP'while循环'插入JavaScript代码？

Question

I need to display the values of an SQL table in a D3 map for each US state. Below is code excerpts from my file.php:

1. Here is the SQL query:

   $sql = "SELECT COUNT(State) FROM `mytable`";
   $sql_result= mysqli_query($cnx,$sql) or die('Could not execute' . mysqli_error()) ;
   

2. Here is how I pass the result into an array

    <? while($myvar=mysqli_fetch_array($sql_result)) { **need to add both php and javascript below..**  }
   
   <?php $js_array = json_encode($myvar['0']);?>
   

3. Here is where I need to pass the data:

   .forEach(function(d){ 
       var     kpi01=<?php echo "var nbcustomers = ". $js_array . ";
   ";?>, //  No of customers in that state
               kpi02= .....
   
               sampleData[d]={kpi01, kpi02}; 
       });
   

Can anyone help me with suggestions to properly insert the JavaScript code after the while loop within the .forEach?

Answer 1

Don't mess around with trying to generate a bunch of variables with numbers in their names.

Just construct the data structure you need (an array of your SQL query results) in PHP, then use json_encode to convert it to JavaScript.

 <?php
     $my_array = [];
     while($myvar=mysqli_fetch_array($sql_result)) {
         $my_array[] = $myvar;
     }
     $js_array = json_encode($my_array);
 ?>
 <script>
 var javascript_array = <?php echo $js_array; ?>;
 </script>