invisio v2.0

<?php
include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

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

$approve_status = mysqli_real_escape_string($connection, $_POST['approve_status']);
$doc_remark = mysqli_real_escape_string($connection, $_POST['doc_remark']);

$table_detail = "";
if ($register_type == 1) {
    $table_detail = "tbl_member_detail_employer";
} // ทั่วไป 
else if ($register_type == 2) {
    $table_detail = "tbl_member_detail_company";
} // สมาชิกสามัญ
else if ($register_type == 3) {
    $table_detail = "tbl_member_detail_agency";
} // วิสมาชิกสามัญ
else if ($register_type == 4) {
    $table_detail = "tbl_member_detail_worker";
} // กิติมาศักดิ์

if (isset($approve_status)) {
    $approve_status = "document_approve = '$approve_status'";
} else {
    $approve_status = "document_approve = ''";
}

if (isset($doc_remark)) {
    $doc_remark =  ",document_remark = '$doc_remark'";
} else {
    $doc_remark = ",document_remark = ''";
}

$update_status = "UPDATE tbl_member_detail SET $approve_status $doc_remark WHERE member_id = '$member_id'";
$res_update_status = mysqli_query($connection, $update_status);

if ($res_update_status) {
    $arr['result'] = 1;
} else {
    $arr['result'] = 9;
}
echo json_encode($arr);