How to get JavaScript variable through PHP post request?

Question

I am posting the PHP file (post.php) through jquery ajax. And I want to get the data from it in the form of a javascript variable. I successfully get the data in my console. But I don't know how can I use this variable. You can see my code below.

$.post(
    "post.php",
    {
      region: region,
      district: district
    },
    function(data) {
      console.log(data);
    }
  );

my post.php page looks like this

    @include('../../_partials/_dbConnect.php');
    $region = $_POST['region'];
    $district = $_POST['district'];
    $sql = "SELECT * FROM table1 WHERE name_rg= '".$region."'";
    $result = pg_query($db_connection, $sql);
        while ($row = pg_fetch_row($result)) {
            $cols = array($row[0],$row[1],$row[2],$row[3],$row[4],$row[5],$row[6],$row[7],$row[8],$row[9],$row[10],$row[11],$row[12],$row[13],$row[14],$row[15],$row[16],$row[17],$row[18],$row[19],$row[20],$row[21]);
        }
<script>
  var cols = [<?php echo '"'.implode('","', $cols).'"' ?>];
</script>

And the console.log(data) output like this,

<script>
  var cols = ["94","32","361","0","118","159","0","243","702","1775","8","0","2","0","150","135","381","2","0","0","0","0"];
</script>

Your help is highly appreciated.

I mean, I want to use the cols as a javascript variable. Inside the function(data) {var cols=$getThisColsValueFromPhpPost} — Tek Kshetri
– Tek Kshetri, Commented Mar 5, 2020 at 3:27

Thum Choon Tat · Accepted Answer · 2020-03-05 03:43:21Z

2

In your post.php, you can simply echo the array and jQuery should automatically convert it to an array as the response

// post.php
<?php
    @include('../../_partials/_dbConnect.php');
    $region = $_POST['region'];
    $district = $_POST['district'];
    $sql = "SELECT * FROM table1 WHERE name_rg= '".$region."'";
    $result = pg_query($db_connection, $sql);

    while ($row = pg_fetch_row($result)) {
        $cols = array($row[0],$row[1],$row[2],$row[3],$row[4],$row[5],$row[6],$row[7],$row[8],$row[9],$row[10],$row[11],$row[12],$row[13],$row[14],$row[15],$row[16],$row[17],$row[18],$row[19],$row[20],$row[21]);
    }

    echo json_encode($cols);
?>

// Somewhere in your js
$.post(
    "post.php",
    {
      region: region,
      district: district
    },
    function(data) {
      console.log(data[0]);
    }
);

answered Mar 5, 2020 at 3:43

Thum Choon Tat

3,0901 gold badge24 silver badges26 bronze badges

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

2 Comments

Tek Kshetri Over a year ago

It gives the value in the string, How can I change string to numeric?

Tek Kshetri Over a year ago

Thank you, I got my solution, I need to write console.log(parseJSON(data)) instate of console.log(data).

Sadak · Accepted Answer · 2020-03-05 04:28:38Z

2

in javascript use JSON.parse()

$.post(
    "post.php",
    {
      region: region,
      district: district
    },
    function(data) {
      data=JSON.parse(data);
    }
);```

And here you go, u can play with it as you need
Happy learning!

answered Mar 5, 2020 at 4:28

Sadak

9418 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to get JavaScript variable through PHP post request?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related