How to get a row value from database table to use it in JavaScript / jQuery?

Question

I want to retrieve a row value from database. Since we need serverside to access database we have to use PHP to retrive the value but I am not sure how to use this php in a .js file.

This is what I am trying but it does not work. The reason is simple.. we can not write PHP inside a javascript file.

file.js:

<?php 
$con = mysqli_connect($server, $db_user, $db_pwd, $db_name);
$username = $_SESSION['username'];
$sql = "SELECT * FROM Holders WHERE username='$username'";
$data = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($data);
$address = $row['address'];
?>

$( document ).ready(function() {
    var addressFrmPHP = "<?= $address; ?>";
    var url = "https://api.examlesite.io/api?module=account&action=bal&add=000000000&address="+addressFrmPHP+"&tag=latest&apikey=APIKEY";
});

How can I assign the php $address variable to javascript addressFrmPHP variable?

So what's the solution? I mentioned in my question what you've mentioned @vel is there any way to get a database table row value and use it in jS? — Riffaz Starr
– Riffaz Starr, Commented Jan 4, 2018 at 7:13

Aman Kumar · Accepted Answer · 2018-01-04 07:45:35Z

3

You have to create two files as shown below

getdata.php

<?php 
$con = mysqli_connect($server, $db_user, $db_pwd, $db_name);
$username = $_SESSION['username'];
$sql = "SELECT * FROM Holders WHERE username='$username'";
$data = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($data);
$address = $row['address'];
echo $address;
?>

file.js

$( document ).ready(function() {

    /* AJAX for get data from php page */

    $.post('getdata.php', function(address) {

        var addressFrmPHP = address;
    });

    var url = "https://api.examlesite.io/api?module=account&action=bal&add=000000000&address="+addressFrmPHP+"&tag=latest&apikey=APIKEY";
});

answered Jan 4, 2018 at 7:45

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

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

1 Comment

kscherrer Over a year ago

+1 - Ajax ($.post) is probably what OP was looking for. OP: I would recommend adding some errorhandling (what happens if $_SESSION['username'] is not set? could that potentially happen?)

Vel · Accepted Answer · 2018-01-04 07:27:29Z

1

you have to do like this

test.php

<?php 
$con = mysqli_connect($server, $db_user, $db_pwd, $db_name);
$username = $_SESSION['username'];
$sql = "SELECT * FROM Holders WHERE username='$username'";
$data = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($data);
$address = $row['address'];

echo '<script> var address= '.$address.';</scrpit>';
?>
<script type='text/javascript' src='js/file.js'></script>

file.js

$( document ).ready(function() {
    var addressFrmPHP = address;
    var url = "https://api.examlesite.io/api?module=account&action=bal&add=000000000&address="+addressFrmPHP+"&tag=latest&apikey=APIKEY";
});

edited Jan 4, 2018 at 7:27

answered Jan 4, 2018 at 7:12

Vel

9,4286 gold badges42 silver badges71 bronze badges

1 Comment

Riffaz Starr Over a year ago

so how to include test.php in file.js or file.js in test.php ? then only we can use this right?

Ravi Shrimali · Accepted Answer · 2018-01-04 08:04:07Z

Create One file Getdata.php and write the below code:

<?php 
    $con = mysqli_connect($server, $db_user, $db_pwd, $db_name);
    $username = 'nirav4491';
    $sql = "SELECT * FROM Holders WHERE username='$username'";
    $data = mysqli_query($con, $sql);
    $row = mysqli_fetch_assoc($data);
    $address = $row['address'];

?>
<html>
<head>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <script type="application/javascript">
        $(document).ready(function() {
            var addressFrmPHP = '<?php echo $address; ?>';
            var url = "https://api.examlesite.io/api?module=account&action=bal&add=000000000&address="+addressFrmPHP+"&tag=latest&apikey=APIKEY";
            alert(url);
        });

    </script>
</head>
</html>

Collectives™ on Stack Overflow

How to get a row value from database table to use it in JavaScript / jQuery?

3 Answers 3

You have to create two files as shown below

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

You have to create two files as shown below

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related