How to insert a PHP 'while loop' into JavaScript code?

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:

Here is the SQL query:

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

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']);?>

Here is where I need to pass the data:

.forEach(function(d){ 
    var     kpi01=<?php echo "var nbcustomers = ". $js_array . ";\n";?>, //  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?

you cannot do in .js file but can be done in .php or .html files — Azad
– Azad, Commented Dec 12, 2016 at 17:57
You'll need to use an AJAX call to a PHP file that handles the server side processing you need. PHP runs server side and runs BEFORE JavaScript, which runs client side. — devlin carnate
– devlin carnate, Commented Dec 12, 2016 at 17:58
Sidenote: your sql query is kind of pseudo to me (missing a quote) and that mysqli_error function requires db connection as an argument. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 12, 2016 at 17:59
ok Samantha, I added the missing quote in an edit since it was throwing off syntax highlighting ;-) details details, eh? lol I'm just a perfectionist that way. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 12, 2016 at 18:00
Yes that would be my solution. But thats not necessarily an easy solution either — RiggsFolly
– RiggsFolly, Commented Dec 12, 2016 at 18:07

Quentin · Accepted Answer · 2016-12-14 19:09:11Z

2

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>

answered Dec 14, 2016 at 19:09

Quentin

948k136 gold badges1.3k silver badges1.4k bronze badges

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

Collectives™ on Stack Overflow

How to insert a PHP 'while loop' into JavaScript code?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related