<?php session_start(); include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); if ($connection) { $member_id = mysqli_real_escape_string($connection, $_POST['member_id']); $sql = "SELECT board_status FROM tbl_member WHERE member_id = '$member_id' ;"; $rs = mysqli_query($connection, $sql) or die($connection->error); $row = mysqli_fetch_array($rs); if ($row['board_status'] == "1") { $new_status = "0"; } else { $new_status = "1"; } $sql2 = "UPDATE tbl_member SET board_status = '$new_status' WHERE member_id = '$member_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);