How to access a Javascript variable value inside a PHP query?

Question

I have a Javascript variable 'id' which contains a unique network id which I would like access in the PHP code to update my table.

    $("body").on("click", "#" + feature.properties.network_id , function(e) {
    $id = feature.properties.network_id
             layer.setStyle(disable);
             <?php
            $connection = mysqli_connect('localhost', 'root', 'root', 'robsim');
            $sql = mysqli_query($connection,"UPDATE `all_data` SET `Status` = 'Done' WHERE `all_data`.`Network_ID` = id;");
            ?>

    });

Possible duplicate of [Call php function from javascript](https://stackoverflow.com/questions/7165395/call-php-function-from-javascript) — , Jun 17 '17 at 23:44

score 0 · Answer 1 · answered Jun 17 '17 at 22:54

You can't do it like this. PHP is executed server-side while JavaScript is executed client-side. In other words in this example first your PHP is executed then the JavaScript. You need to do this like this:

$("body").on("click", "#"+feature.properties.network_id , function(e) {
    $id = feature.properties.network_id;
    layer.setStyle(disable);
    $.get('script.php', 'iddd=' + $id); 
});

Then you need to create script.php and put inside it:

<?php
$id = $_GET['iddd'];
$connection = mysqli_connect('localhost', 'root', 'root', 'robsim');
$sql = mysqli_query($connection,"UPDATE `all_data` SET `Status` = 'Done' WHERE `all_data`.`Network_ID` = id;");
?>

How to access a Javascript variable value inside a PHP query?

1 Answers1