connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// รับค่าจากตัวเลือกและการค้นหา
$search = isset($_GET['search']) ? $_GET['search'] : '';
$province_id = isset($_GET['province']) ? $_GET['province'] : null;
$district_id = isset($_GET['district']) ? $_GET['district'] : null;
// ดึงข้อมูลจังหวัด
$provinces = $conn->query("SELECT id, name_in_thai FROM provinces ORDER BY name_in_thai");
$provinces_data = [];
while ($row = $provinces->fetch_assoc()) {
$provinces_data[] = $row;
}
// ดึงข้อมูลอำเภอ (ถ้าเลือกจังหวัด)
$districts = null;
if ($province_id) {
$districts = $conn->query("SELECT id, name_in_thai FROM districts WHERE province_id = $province_id ORDER BY name_in_thai");
}
// ดึงข้อมูลตำบลพร้อมจังหวัดและอำเภอ สำหรับทุกจังหวัด
function getSubdistrictsByProvince($conn, $province_id, $search) {
$query = "
SELECT
subdistricts.name_in_thai AS subdistrict_name,
subdistricts.zip_code,
districts.name_in_thai AS district_name,
provinces.name_in_thai AS province_name
FROM subdistricts
JOIN districts ON subdistricts.district_id = districts.id
JOIN provinces ON districts.province_id = provinces.id
WHERE districts.province_id = ?
";
if (!empty($search)) {
$query .= " AND (
subdistricts.name_in_thai LIKE ? OR
districts.name_in_thai LIKE ? OR
provinces.name_in_thai LIKE ? OR
subdistricts.zip_code LIKE ?
)";
}
$query .= " ORDER BY districts.name_in_thai, subdistricts.name_in_thai";
$stmt = $conn->prepare($query);
if (!empty($search)) {
$search_param = "%$search%";
$stmt->bind_param("issss", $province_id, $search_param, $search_param, $search_param, $search_param);
} else {
$stmt->bind_param("i", $province_id);
}
$stmt->execute();
$result = $stmt->get_result();
return $result;
}
function closeConnection($conn) {
$conn->close();
}
?>
จังหวัด อำเภอ ตำบล
num_rows > 0):
?>
| อำเภอ |
ตำบล |
รหัสไปรษณีย์ |
fetch_assoc()): ?>
|
|
|