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