<?php session_start(); include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); if ($connection) { $certification_lot_id = mysqli_real_escape_string($connection, $_POST['certification_lot_id']); $sql_delete = "DELETE FROM tbl_certification_lot WHERE certification_lot_id = '$certification_lot_id'"; $res_delete = mysqli_query($connection, $sql_delete) or die($connection->error); if ($res_delete) { $sql_delete_mem = "DELETE FROM tbl_certification_lot_member WHERE certification_lot_id = '$certification_lot_id'"; $res_delete_mem = mysqli_query($connection, $sql_delete_mem) or die($connection->error); if ($res_delete_mem) { $arr['result'] = 1; } else { $arr['result'] = 0; } } else { $arr['result'] = 0; } } else { $arr['result'] = 9; } mysqli_close($connection); echo json_encode($arr);