invisio v2.0

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

$sql_mem = "SELECT * FROM tbl_member WHERE register_type = '4'";
    $res_mem = mysqli_query($connection, $sql_mem);

$sql_system = "SELECT * FROM tbl_system_setting WHERE setting_id = '1';";
    $rs_system = mysqli_query($connection, $sql_system);
    $row_system = mysqli_fetch_array($rs_system);

$key = $row_system['secure_text'];
    $pointer = $row_system['secure_pointer'];

while ($row_mem = mysqli_fetch_assoc($res_mem)) {

$sql = "SELECT * FROM tbl_member_detail_worker WHERE member_id = '{$row_mem['member_id']}'";
        $res = mysqli_query($connection, $sql);
        $row = mysqli_fetch_assoc($res);

if (empty($row['birth_date'])) {
            $birthDate = "";
        } else {
            $birthDate = ",birth_date = '{$row['birth_date']}'";
        }

if (empty($row['card_district_id'])) {
            $card_district = "";
        } else {
            $card_district = ",card_district_id = '{$row['card_district_id']}'";
        }

if (empty($row['card_register_date'])) {
            $card_register = "";
        } else {
            $card_register = ",card_register_date = '{$row['card_register_date']}'";
        }

if (empty($row['card_expire_date'])) {
            $card_expire = "";
        } else {
            $card_expire = ",card_expire_date = '{$row['card_expire_date']}'";
        }

if (empty($row['company_district_id'])) {
            $company_district = "";
        } else {
            $company_district = ",company_district_id = '{$row['company_district_id']}'";
        }

if (empty($row['license_expire_date'])) {
            $license_expire = "";
        } else {
            $license_expire = ",license_expire_date = '{$row['license_expire_date']}'";
        }

if (empty($row['work_register_date'])) {
            $work_register = "";
        } else {
            $work_register = ",work_register_date = '{$row['work_register_date']}'";
        }

if (empty($row['work_expire_date'])) {
            $work_expire = "";
        } else {
            $work_expire = ",work_expire_date = '{$row['work_expire_date']}'";
        }

if (empty($row['visa_register_date'])) {
            $visa_register = "";
        } else {
            $visa_register = ",visa_register_date = '{$row['visa_register_date']}'";
        }

if (empty($row['visa_expire_date'])) {
            $visa_expire = "";
        } else {
            $visa_expire = ",visa_expire_date = '{$row['visa_expire_date']}'";
        }

$temp_member_name = bigsara_decode($row['member_name'], $key, $pointer);
        
        if (empty($temp_member_name)) {
            $member_name = "";
        } else {
            $member_name = ",member_name = '$temp_member_name'";
        }
        
        $temp_member_name_en = bigsara_decode($row['member_name_en'], $key, $pointer);

if (empty($temp_member_name_en)) {
            $member_name_en = "";
        } else {
            $member_name_en = ",member_name_en = '$temp_member_name_en'";
        }

$citizen_no = bigsara_decode($row['citizen_no'], $key, $pointer);
        $work_permit = bigsara_decode($row['work_permit'], $key, $pointer);
        $visa_no = bigsara_decode($row['visa_no'], $key, $pointer);

$phone = bigsara_decode($row['phone'], $key, $pointer);
        $fax = bigsara_decode($row['fax'], $key, $pointer);
        $email = bigsara_decode($row['email'], $key, $pointer);

$company_phone = bigsara_decode($row['company_phone'], $key, $pointer);
        $company_email = bigsara_decode($row['company_email'], $key, $pointer);
        $company_line = bigsara_decode($row['company_line'], $key, $pointer);
        $company_web = bigsara_decode($row['company_web'], $key, $pointer);

$insert = "INSERT INTO tbl_member_detail SET
            member_id = '{$row['member_id']}'
            ,title_name = '{$row['title_name']}'
            $member_name
            $member_name_en
            ,race = '{$row['race']}'
            $birthDate
            ,profile_image = '{$row['profile_image']}'
            ,citizen_no = '$citizen_no'
            ,card_address = '{$row['card_address']}'
            $card_district
            $card_register
            $card_expire
            ,phone = '$phone'
            ,email = '$email'
            ,company_name = '{$row['company_name']}'
            ,company_tax_no = '{$row['company_tax_no']}'
            ,position = '{$row['position']}'
            ,company_address = '{$row['company_address']}'
            $company_district
            ,company_phone = '$company_phone'
            ,company_email = '$company_email'
            ,company_line = '$company_line'
            ,company_web = '$company_web'
            ,license_no = '{$row['license_no']}'
            $license_expire
            ,work_permit ='$work_permit'
            $work_register
            $work_expire
            ,visa_no = '$visa_no'
            $visa_register
            $visa_expire
            ,approver = '{$row['approver']}'

$rs_insert = mysqli_query($connection, $insert);

if ($rs_insert) {
            $arr['result'] = 1;
        } else {
            echo $insert;
        }
    }

mysqli_close($connection);