invisio v2.0

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

$gmail = mysqli_real_escape_string($connection, $_POST['gmail']);
    $name_th = mysqli_real_escape_string($connection, $_POST['name_th']);
    $name_en = mysqli_real_escape_string($connection, $_POST['name_en']);
    $birth_date = mysqli_real_escape_string($connection, $_POST['birth_date']);
    $phone = mysqli_real_escape_string($connection, $_POST['phone']);
    $member_group = mysqli_real_escape_string($connection, $_POST['member_group']);
    $company_name = mysqli_real_escape_string($connection, $_POST['company_name']);

///////////////////////////////////////////////////////////////////

$member_id = randomCode2(10);
    $randomNumber = rand(5, 10);

///////////////////////////////////////////////////////////////////

// เช็คก่อน ID มีซ้ำไหม
    $find_id = "SELECT COUNT(member_id) as duplicate FROM tbl_member WHERE member_id = '$member_id';";
    $rs_find_id = mysqli_query($connection, $find_id) or die($connection->error);
    $row_find_id = mysqli_fetch_array($rs_find_id);
    if ($row_find_id['duplicate'] > 0) {
        $member_id = randomCode2(10);
    } else {
        $insert_user = "INSERT INTO tbl_member SET
            member_id = '$member_id'
            ,name_th = '$name_th'
            ,name_en = '$name_en'
            ,birth_date = '$birth_date'
            ,phone = '$phone'
            ,member_group = '$member_group'
            ,company_name = '$company_name',
            gmail = '$gmail';";
        $rs_insert_user = mysqli_query($connection, $insert_user);
        if ($rs_insert_user) {

$key_login = randomCode(10);
            $pointer_login = rand(0, 9);

$step_1 = bigsara_encode($member_id, $key_login, $pointer_login); //Login Code

// เอา Login Code ต่อคำกับ $step 1 
            $login_code = $step_1 . "." . $key_login;
            $arr['login_code'] = $login_code;
            $arr['member_level'] = 1;
            $arr['register_type'] = 0;
            $arr['register_level'] = '';

$arr['result'] = 1;
        } else {

$arr['result'] = 0;
        }
    }
    mysqli_close($connection);
    echo json_encode($arr);
?>