/
home
/
efamember
/
domains
/
efa-member.com
/
public_html
/
efa.or
/
ajax
/
profile
/
up file
home
<?php include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $district_id = mysqli_real_escape_string($connection, $_POST['district_id']); $arr = []; $province = ""; $amphoe = ""; $sql = "SELECT * FROM tbl_district WHERE district_id = '$district_id';"; $rs = mysqli_query($connection, $sql); $row = mysqli_fetch_array($rs); $ref_amphoe = $row['ref_amphoe']; if ($row) { $sql_amp = "SELECT * FROM tbl_amphoe WHERE amphoe_id ='$ref_amphoe'"; $res_amp = mysqli_query($connection, $sql_amp); $row_amp = mysqli_fetch_assoc($res_amp); $amphoe = $row_amp['amphoe_name_th']; if ($row_amp) { $amphoe = $row_amp['amphoe_name_th']; $sql_province = "SELECT * FROM tbl_province WHERE province_id = '" . $row_amp['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']; } } $arr['status'] = 200; $arr['message'] = "พบข้อมูล"; $arr['data'] = [ 'amphoe' => $amphoe, 'province' => $province, ]; } else { $arr['status'] = 500; $arr['message'] = "เลข ปณ ไม่ถูกต้อง กรุณาตรวจสอบอีกครั้ง"; $arr['data'] = [ 'amphoe' => "กรุณากรอกรหัส ปณ.", 'province' => "กรุณากรอกรหัส ปณ.", 'district' => "กรุณากรอกรหัส ปณ.", ]; } echo json_encode($arr);