invisio v2.0

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

if ($connection) {

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

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

$sql_select = "SELECT a.* , (SELECT invoice_number FROM tbl_member_payment WHERE member_id = '$member_id' ) AS invoice_number FROM tbl_member_detail a WHERE member_id = '$member_id' ";
        $res_select = mysqli_query($connection, $sql_select)  or die($connection->error);
        $row = mysqli_fetch_assoc($res_select);

$card_district_id = $row['card_district_id'];
        $sqlAddressCard = "SELECT `tbl_district`.`district_name_th` , `tbl_amphoe`.`amphoe_name_th` , `tbl_province`.`province_name_th` , `tbl_district`.`district_zipcode` FROM `tbl_district` 
        JOIN `tbl_amphoe` ON `tbl_amphoe`.`amphoe_id` = `tbl_district`.`ref_amphoe`
        JOIN `tbl_province` ON `tbl_province`.`province_id` = `tbl_amphoe`.`ref_province`
        WHERE `tbl_district`.`district_id` = '$card_district_id'";
        $rsAddressCard = mysqli_query($connection, $sqlAddressCard);
        $rowAddressCard = mysqli_fetch_array($rsAddressCard);

$full_address = $row['card_address'] . " ตำบล" . $rowAddressCard['district_name_th'] . " อำเภอ" . $rowAddressCard['amphoe_name_th'] . " จังหวัด" . $rowAddressCard['province_name_th'] . " " . $rowAddressCard['district_zipcode'];

if ($row['member_name'] != "") {
            $member_name = $row['member_name'];
        } else {
            $member_name = $row['member_name_en'];
        }

$detail[] = array(
            'member_name'      =>  $row['company_name'],
            'phone'            =>  $row['phone'],
            'card_address'     =>  $full_address,
            'email'            =>  $row['email'],
            'invoice_number'   =>  $row['invoice_number'],
        );
    } else {
        echo "Connection Error";
    }

mysqli_close($connection);

echo json_encode($detail);
    ?>