附近小车修理店在哪? (附近小车修理厂电话号码)
武汉夜店
04-12
阅读:52
评论:0
寻找汽车修理厂
输入您的位置,我们将帮助您找到附近的汽车修理厂。您还可以按距离、评分或服务类型进行过滤。
附近汽车修理厂列表
connect_error) {die("连接失败: " .$conn->connect_error);}// 获取表单数据$location = $_GET['location'];$distance = $_GET['distance'];$rating = $_GET['rating'];$services = $_GET['services'];// 创建查询$sql = "SELECT FROM car_repair_shops";// 添加位置过滤器if ($location != "") {$sql .= " WHERE location LIKE '%$location%'";}// 添加距离过滤器if ($distance != "") {$sql .= " AND distance <= $distance";}// 添加评分过滤器if ($rating != "") {$sql .= " AND rating >= $rating";}// 添加服务类型过滤器if (count($services) > 0) {$sql .= " AND services LIKE '%" . implode(",", $services) . "%'";}// 执行查询$result = $conn->query($sql);// 检查结果if ($result->num_rows > 0) {// 输出结果echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";while($row = $result->fetch_assoc()) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";}echo "";echo "名称 | 地址 | 电话 | 距离(公里) | 评分(星级) | 服务类型 |
---|---|---|---|---|---|
" . $row['name'] . " | " . $row['address'] . " | " . $row['phone'] . " | " . $row['distance'] . " | " . $row['rating'] . " | " . $row['services'] . " |
版权声明
本文仅代表作者观点,不代表武汉桑拿立场。
本文系作者授权发表,未经许可,不得转载。