invisio v2.0

<?php

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

$member_id = mysqli_real_escape_string($connection, $_POST['member_id']);
    $temp_id = explode(".", $member_id);
    $member_id = bigsara_decode($temp_id[0], $temp_id[1]);

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

switch ($register_type) {
        case '1':;
            $table = "tbl_member_detail_employer";
            break;

case '2':
            $table = "tbl_member_detail_company";
            break;

case '3':
            $table = "tbl_member_detail_agency";
            break;

case '4':
            $table = "tbl_member_detail_worker";
            break;

default:
            $level = '-';
            break;
    }

$sql_check_payment = "SELECT * FROM tbl_member_payment WHERE member_id = '$member_id' ";
    $res_check_payment = mysqli_query($connection, $sql_check_payment);
    $row_check_payment = mysqli_fetch_assoc($res_check_payment);

if ($connection) {

if ($row_check_payment['transfer_date'] != "") {
            $arr['result'] = 4;
        } else {
            if ($register_type != 0) {
                $sql_select = "SELECT * FROM tbl_member WHERE member_id = '$member_id' AND register_status = '0'";
                $res_select = mysqli_query($connection, $sql_select)  or die($connection->error);
                $num_row = mysqli_num_rows($res_select);
                if ($num_row < 1) {
                    $arr['result'] = 3;
                } else {
                    $arr['result'] = 2;
                }
            } else {
                $arr['result'] = 1;
            }
        }
    } else {
        $arr['result'] = 9;
    }

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