invisio v2.0

<?php
    session_start();
    include("config/main_function.php");

$secure = "cAh3DrJACzw4RbU";
    $connection = connectDB($secure);

if ($connection) {

$register_no = mysqli_real_escape_string($connection, $_POST['register_no']);
        $member_id = mysqli_real_escape_string($connection, $_POST['member_id']);

if ($register_no != '') {
            $con_chk = "register_no = '$register_no'";
        } else if ($member_id != '') {
            $con_chk = "member_id = '$member_id'";
        }

$sql_chk = "SELECT * FROM tbl_member WHERE $con_chk";
        $res_chk = mysqli_query($connection, $sql_chk) or die($connection->error);
        $row_chk = mysqli_fetch_assoc($res_chk);

$member_id =  $row_chk['member_id'];

$sql_delete_mem = "DELETE FROM tbl_member WHERE member_id = '$member_id'";
        $res_delete_mem = mysqli_query($connection, $sql_delete_mem)  or die($connection->error);
        if ($res_delete_mem) {
            $arr['result1'] = "delete mem success";
        } else {
            $arr['result1'] = 0;
        }

$sql_delete_de = "DELETE FROM tbl_member_detail WHERE member_id = '$member_id'";
        $res_delete_de = mysqli_query($connection, $sql_delete_de)  or die($connection->error);
        if ($res_delete_de) {
            $arr['result2'] = "delete detail success";
        } else {
            $arr['result2'] = 0;
        }

$sql_delete_pay = "DELETE FROM tbl_member_payment WHERE member_id = '$member_id'";
        $res_delete_pay = mysqli_query($connection, $sql_delete_pay)  or die($connection->error);
        if ($res_delete_pay) {
            $arr['result3'] = "delete payment success";
        } else {
            $arr['result3'] = 0;
        }

$sql_delete_doc = "DELETE FROM tbl_member_document WHERE member_id = '$member_id'";
        $res_delete_doc = mysqli_query($connection, $sql_delete_doc)  or die($connection->error);
        if ($res_delete_doc) {
            $arr['result4'] = "delete document success";
        } else {
            $arr['result4'] = 0;
        }
    } else {
        $arr['result'] = 9;
    }

mysqli_close($connection);
    echo json_encode($arr);
    ?>