<?php session_start(); include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); if ($connection) { $faq_id = mysqli_real_escape_string($connection, $_POST['faq_id']); $sql = "SELECT active_status FROM tbl_faq WHERE faq_id = '$faq_id' ;"; $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 tbl_faq SET active_status = '$new_status' WHERE faq_id = '$faq_id';"; $rs2 = mysqli_query($connection, $sql2) or die($connection->error); if ($rs2) { $arr['status'] = $new_status; $arr['result'] = 1; } else { $arr['result'] = 0; } } else { $arr['result'] = 9; } echo json_encode($arr);