PHP and Javascript Variables

[Anon]

Once I query a database with with php and store the results in a variable is it possible to store those results in a javascript variable? I'm trying to get all the info I need from the database when the page first loads, then place all that info into javascript variables so I can use it on the page without having to refresh anymore.

Thanks, Pahikua

[erokar]

It's possible. You can make PHP print the varibles to a hidden form, which then can be accessed by the JavaScript:

<?php

print "<form name=\"dbForm\">";

print "<input type=\"hidden\" name=\"dbValues\" value=\"$phpDbVariable\">";

print "</form>";

?>

Then you call your JavaScript function:

yourFunction(dbForm.dbValues.value);

[Anon]

Well both JS and PHP can access form variables so that's an option. But I think you can do what you are proposing with PHP.

[pahikua]

I would rather stick to php only if possible. How would you do it with PHP alone?

[pgosse]

Within your javascript code, simply loop through the recordset returned by your database query and output the values to javascript variables, which you'll have to name dynamically somehow (I'm just using "var".$count where count is a number which increments with each loop).

For example,

$count = 1;
while (!$rs->EOF) {
echo "var".$count." = ".$rs->field['name'].";";
$rs->MoveNext();
}

Cheers,
Pablo