How do get php array in javascript variable

Question

I am using following code .

<?php
    $dbhost = 'localhost';
    $dbuser = '****';
    $dbpass = '******';

    $conn = mysql_connect($dbhost, $dbuser, $dbpass);

    if(! $conn ) {
      die('Could not connect: ' . mysql_error());
    }

    $sql = 'SELECT * FROM mytable';
    mysql_select_db('sujeet_db');
    $retval = mysql_query( $sql, $conn );

    if(! $retval ) {
      die('Could not get data: ' . mysql_error());
    }

     while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
      echo "EMP ID :{$row['firstname']}  <br> ".
         "EMP NAME : {$row['lastname']} <br> ".
         "EMP SALARY : {$row['doj']} <br> ".

         "--------------------------------<br>";

     }

     echo "Fetched data successfully\n";

     mysql_close($conn);
?>

to get data from db . But I want to store these data in JavaScript variable for future use. Like var users=$row; but it is not working.

You need to put javascript code inside script tag.

user4035
– user4035

2018-09-16 07:32:41 +00:00
Commented Sep 16, 2018 at 7:32 — user4035
– user4035, Commented Sep 16, 2018 at 7:32

Coding Master · Accepted Answer · 2018-09-16 07:45:47Z

1

You can do this by putting your mysql result in json format and print it with script tag to use it in javascript like:

<script>
   var result = '<?php echo json_encode($row);?>';
</script>

answered Sep 16, 2018 at 7:45

Coding Master

574 bronze badges

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

Comments

Manikant Gautam · Accepted Answer · 2018-09-16 08:19:12Z

0

you could do this by assigning inside script tag here is how.

 <script>
   var spge = '<?php echo json_encode($row); ?>';
   alert(spge);
  console.log(spge);
</script>

edited Sep 16, 2018 at 8:19

answered Sep 16, 2018 at 7:38

Manikant Gautam

3,5911 gold badge20 silver badges30 bronze badges

Collectives™ on Stack Overflow

How do get php array in javascript variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related