Get values through post method from URL

Question

I am trying some code to get value from URL through post method and search database table for that value and get info from the database and encode it into JSON response.

Here is my code :

<?php
//open connection to mysql db
$connection = mysqli_connect("localhost","root","","json") or die("Error " . mysqli_error($connection));
if (isset($_POST['empid'])) {
    $k = $_POST['empid'];
    //fetch table rows from mysql db
    $sql = "select `salary` from tbl_employee where `employee_id` = $k ";
} else {
    //fetch table rows from mysql db
    $sql = "select `salary` from tbl_employee";
}
//fetch table rows from mysql db
$result = mysqli_query($connection, $sql) or die("Error in Selecting " . mysqli_error($connection));

//create an array
$emparray = array();
while($row =mysqli_fetch_assoc($result))
{
    $emparray[] = $row;
}
echo json_encode($emparray);

//close the db connection
mysqli_close($connection);
?>

I used Postman extension on Chrome and pass the values but it is not returning. Instead it is returning the else part.

Postman Screenshot

Answer 1

Looking at your screen shot, you have not passed body key values, instead you passed params.

Click on Body Tab and then pass key & value pair.