PHP Database Query: How to return the results from a while loop to a Javascript Variable?

Question

I have a php query like so:

<?php
    $query = "SELECT * FROM " . $usertable . " ORDER BY fname;";
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)){
        echo '<option value="' . $row['pkid'] . '">' . $row['fname'] . ' ' . $row['lname'] . '</option>';
    }
?>

Within this same .php file I have some javascript. All I would like to do is return $row['fname'] as a a javascript variable.

Is this possible?

Please, stop using mysql_* functions. They are no longer maintained and are officially deprecated. Learn about prepared statements instead, and use PDO. — Jay Blanchard
– Jay Blanchard, Commented Jan 16, 2015 at 19:00
Just a codebase took over, but I will look into prepared statements and PDO, thanks. — Nubtacular
– Nubtacular, Commented Jan 16, 2015 at 19:02

Jay Blanchard · Accepted Answer · 2015-01-16 19:04:41Z

2

If you want to output the PHP variable in a JavaScript variable you could do something like this -

echo '<script>var name+' . $row['pkid'] . ' = ' .$row['fname'] . ';</script>';

This would give you a uniquely named variable for each row.

answered Jan 16, 2015 at 19:04

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

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

Collectives™ on Stack Overflow

PHP Database Query: How to return the results from a while loop to a Javascript Variable?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related