connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
$sql = “SELECT * FROM paybandassam”;
$result = $conn->query($sql);
$payband=”;
if ($result->num_rows > 0) {
// output data of each row
$old_id = -100;
while($row = $result->fetch_assoc()) {
/// echo “id: ” . $row[“id”]. ” – Name: ” . $row[“firstname”]. ” ” . $row[“lastname”]. “
“;
$id = trim($row[“id”]);
if( $old_id == -100 || ( $id != $old_id) )
$payband=$payband.’‘;
$old_id = $id;
}
}else {
// echo “0 results”;
}
$result_id = 0;
// print_r( $_POST );
if( isset( $_POST[‘submit’] ) ){
$result_id = 1;
$gradepay = $_POST[‘gradepay’];
$basic = $_POST[‘basic’];
if ( $gradepay != ”)
{
$sql = “SELECT * FROM paybandassam where grade_pay=”.$gradepay.” AND basic_pay >=”.$basic.” ORDER BY basic_pay ASC”;
$result = $conn->query($sql);
$str=”;
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
/// echo “id: ” . $row[“id”]. ” – Name: ” . $row[“firstname”]. ” ” . $row[“lastname”]. “
“;
$new_basic = $row[“new_pay”];
$new_grade = $row[“new_grade”];
$old_pay_band = $row[“pay_band”];
$old_grade = $row[“grade_pay”];
$newgradepay = $row[“new_gradepay”];
$newpayband = $row[“new_payband”];
break;
}
}else
{
$result_id = 0;
}
}
}
?>
Result |
|
|---|---|
| Current Pay band | |
| Current Grade Pay | |
| Current Basic Pay | |
7th Pay Commission – ROP |
|
|---|---|
| Basic Pay | |
| Grade Pay | |
| Pay Band | |
| Pay Band Range | |