<?php include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $table_name = $_POST['table_name']; $key_name1 = $_POST['key_name']; $key_value1 = $_POST['key_value']; $sql = "SELECT active_status FROM $table_name WHERE $key_name1 = '$key_value1' ;"; $rs = mysqli_query($connection, $sql) or die($connection->error); $row = mysqli_fetch_array($rs); if ($row['active_status'] == "1") { $new_status = "0"; } else { $new_status = "1"; } $sql2 = "UPDATE $table_name SET active_status = '$new_status' WHERE $key_name1 = '$key_value1';"; $rs2 = mysqli_query($connection, $sql2) or die($connection->error); if ($rs2) { $arr['result'] = 1; } else { $arr['result'] = 0; } echo json_encode($arr);