<?php include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $member_id = mysqli_real_escape_string($connection, $_POST["member_id"]); $countNo = mysqli_real_escape_string($connection, $_POST["countNo"]); $sqlMember = "SELECT * FROM `tbl_member` WHERE `member_id` LIKE '$member_id'"; $resultMember = mysqli_query($connection, $sqlMember); $rowMember = mysqli_fetch_array($resultMember); $storage_no = $rowMember['storage_no']; $sqlUpdateMember = "UPDATE `tbl_member` SET `storage_no` = NULL, `storage_date` = NULL WHERE `tbl_member`.`member_id` = '$member_id'"; $sqlUpdateStorage = "UPDATE `tbl_storage` SET `storage_count` = '$countNo' WHERE `start_no` <= '$storage_no' AND `end_no` >= '$storage_no';"; if (mysqli_query($connection, $sqlUpdateMember) && mysqli_query($connection, $sqlUpdateStorage)) { $status = 1; } else { $status = 0; } $arr['status'] = $status; echo json_encode($arr); ?>