Passing value from JS to PHP

Question

Passing a table cell value from javascript variable into php variable.

<script>
  $(document).on('ready',function(){
    $('#business_list_table').on('click','.view_btn',function (){
      $.ajax({
      url: "test.php",
      method: "POST",
      data:{business_id : "6510-1"},
      success: function (data){
        $('#business_permit_table').html(data);
        }
      });
    });
  });

<?php
$business_id = $_GET["business_id"];
echo $business_id;

what do you mean "pass value from JS to PHP"? You can't do that — yqlim
– yqlim, Commented Dec 14, 2018 at 3:42
I don't see any injection vulnerability. Only XSS. The only query I see is a static string: SELECT * FROM business_tb WHERE Business_ID='<script>document.writeln(Business_ID)</script>' — Paul
– Paul, Commented Dec 14, 2018 at 3:50
I think you're mixing up server-side code (PHP) and client side JavaScript which runs in the user's browser only after the PHP code has output the HTML and JavaScript. If you want to send another HTTP request to your server from client side code you should look into ajax. — Paul
– Paul, Commented Dec 14, 2018 at 3:53
Possible duplicate of What is the difference between client-side and server-side programming? — Rotimi
– Rotimi, Commented Dec 14, 2018 at 5:28

ACD · Accepted Answer · 2018-12-14 04:17:25Z

2

You cannot use JS variable directly to PHP like that. use ajax instead:

JS

$("#business_list_table").on('click', '.view_btn', function post() {
    // get the current row
    var currentRow = $(this).closest("tr");
    var Business_id_value= currentRow.find("td:eq(1)").text(); // get current row 2nd T;

    $.post('', {Business_ID: Business_id_value}, function(result){
        $('table tbody').html(result);
    });

});

PHP

if (isset($_POST['Business_ID'])) {
    $Business_ID = $_POST['Business_ID'];

    $conn = mysqli_connect("localhost", "root", "", "bpsystem");
    if ($conn->connect_error) {
        die("Database connection failed:" . $conn->connect_error);
    } else {
        $sql = "SELECT * FROM business_tb WHERE Business_ID='$Business_ID';";
        $result = $conn->query($sql);
        if ($result->num_rows > 0) {
            // output data of each row
            while ($row = $result->fetch_assoc()) {
                echo "<tr >";
                echo "<td>BUSINESS NAME</td>";
                echo "<td>" . $row['Business_Name'] . "</td>";
                echo "</tr>";
                echo "<tr >";
                echo "</tr>";
            }
        }
    }
}

edited Dec 14, 2018 at 4:17

answered Dec 14, 2018 at 4:12

ACD

1,4511 gold badge14 silver badges26 bronze badges

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

1 Comment

Pupil Over a year ago

Appreciate that you have explained the problem instead of just putting code.

Ropali Munshi · Accepted Answer · 2018-12-14 06:11:18Z

0

You can use the query string to pass the variable to PHP. Like this,

$("#business_list_table").on('click', '.view_btn', function post() {
    // get the current row
    var currentRow = $(this).closest("tr");
    var Business_id_value= currentRow.find("td:eq(1)").text(); // get current row 2nd T;
    window.location.href = 'http://your_url?b_id=' + Business_id_value;

});

Now you can access the Business_id_value varible in your PHP script using $_GET['Business_id_value']

answered Dec 14, 2018 at 6:11

Ropali Munshi

3,0365 gold badges27 silver badges49 bronze badges

Collectives™ on Stack Overflow

Passing value from JS to PHP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related