Gestionnaire de fichiers - Editer - /home/kridsana/webapp.cm.in.th/663012801/u66301280015/P003/search_suggestions.php
Arrière
<?php // ตั้งค่าการเชื่อมต่อฐานข้อมูล (ใช้ค่าเดียวกับไฟล์หลัก) $host = 'localhost'; $db = 'u66301280015'; $user = 'u66301280015'; $pass = '@2566'; $conn = new mysqli($host, $user, $pass, $db); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // รับค่าค้นหา $term = isset($_GET['term']) ? $_GET['term'] : ''; if (!empty($term)) { // ค้นหาข้อมูลจากทุกตาราง $query = " SELECT DISTINCT name_in_thai FROM ( SELECT name_in_thai FROM provinces WHERE name_in_thai LIKE ? UNION SELECT name_in_thai FROM districts WHERE name_in_thai LIKE ? UNION SELECT name_in_thai FROM subdistricts WHERE name_in_thai LIKE ? UNION SELECT zip_code FROM subdistricts WHERE zip_code LIKE ? ) AS combined_results LIMIT 10 "; $stmt = $conn->prepare($query); $search_term = "%$term%"; $stmt->bind_param("ssss", $search_term, $search_term, $search_term, $search_term); $stmt->execute(); $result = $stmt->get_result(); $suggestions = []; while ($row = $result->fetch_assoc()) { $suggestions[] = $row['name_in_thai']; } // ส่งผลลัพธ์กลับเป็น JSON header('Content-Type: application/json'); echo json_encode($suggestions); } $conn->close(); ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Génération de la page: 0.55 |
proxy
|
phpinfo
|
Réglages