StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTransferring DB data between PHP and Javascript 2D array
text
Body
copied!<p>I am attempting to get all the data from a MySQL db with PHP, initialise a 2D java array and populate it with the PHP data.</p> <p>I am having trouble embedding JS in the PHP. I have marked up what is working and what isn't.</p> <p>As you will see, some of the embedded java works but not all.</p> <p>Any thoughts?</p> <pre><code><body> <?php $con = mysql_connect("XXXXXX.COM","guest","password"); mysql_select_db("HHG", $con); if (!$con) { die('Could not connect: ' . mysql_error()); } else { $result = mysql_query("SELECT * FROM articles", $con); $numrows = mysql_num_rows($result); echo "DB connection OK <br/>"; echo "Found "; echo $numrows; echo " records <br/><br/>"; } // EVERYTHING WORKS UP TO HERE ?> <script type="text/javascript"> document.write("THIS IS THE FISRT JS DOING SOMETHING"); // THIS DOES NOTHING numrows = <?php echo $numrows; ?>; // THIS DOES NOTHING string [][] hhgdata = new string[numrows][4]; // THIS DOES NOTHING document.write("Records = " + numrows + "<br/>"); // THIS DOES NOTHING </script> <? $counter = 1; while ($row = mysql_fetch_assoc($result)) { echo $row["idimg"]; echo "<br/>"; //THIS WORKS $hhgtitle = $row["hhgtitle"]; //THIS WORKS echo $hhgtitle; echo "<br/>"; //THIS WORKS ?> <script type="text/javascript"> //THIS WORKS counter = <?php echo $counter; ?>; //THIS WORKS document.write("counter = " + counter + "<br/><br/>"); //THIS WORKS hhgtitle = <?php echo $hhgtitle; ?>; // THIS DOES NOTHING document.write("Title: "); // THIS DOES NOTHING hhgdata[counter][1]= hhgtitle; // THIS DOES NOTHING document.write(hhgdata[counter][1]); // THIS DOES NOTHING </script> <? $counter++; // THIS WORKS } ?> </body> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload