invisio v2.0

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

$postcode = mysqli_real_escape_string($connection , $_GET['postcode']);
$nameform = mysqli_real_escape_string($connection , $_GET['nameform']);
$arr = [];

$province = "";
$amphoe = "";
$district = "";
$sql = "SELECT * FROM tbl_district WHERE district_zipcode = '$postcode';";
$rs = mysqli_query($connection , $sql);
$row = mysqli_fetch_array($rs);
if($row){
    $sql_amphoe = "SELECT * FROM tbl_amphoe WHERE amphoe_id = '".$row['ref_amphoe']."';";
    $rs_amphoe = mysqli_query($connection , $sql_amphoe);
    $row_amphoe = mysqli_fetch_array($rs_amphoe);
    if($row_amphoe){
        $amphoe = $row_amphoe['amphoe_name_th'];

$sql_province = "SELECT * FROM tbl_province WHERE province_id  = '".$row_amphoe['ref_province']."';";
        $rs_province = mysqli_query($connection , $sql_province);
        $row_province = mysqli_fetch_array($rs_province);
        if($row_province){
            $province = $row_province['province_name_th'];
        }
    }

$district.="<select id='".$nameform."' name='".$nameform."' onchange='districtChange()' class='form-control'>";
    foreach ($rs as $key => $rows){
        $district.="<option value='".$rows['district_id']."'>".$rows['district_name_th']."</option>";
    }
    $district.="</select>";

$arr['status'] = 200;
    $arr['message'] = "พบข้อมูล";
    $arr['data'] = [
        'amphoe' => $amphoe,
        'province' => $province,
        'district' => $district,
    ];
}else{
    $arr['status'] = 500;
    $arr['message'] = "เลข ปณ ไม่ถูกต้อง กรุณาตรวจสอบอีกครั้ง";
    $arr['data'] = [
        'amphoe' => "กรุณากรอกรหัส ปณ.",
        'province' => "กรุณากรอกรหัส ปณ.",
        'district' => "กรุณากรอกรหัส ปณ.",
    ];
}

echo json_encode($arr);
?>