请输入您的服务类型和位置,我们将为您提供附近选项:
附近 $service 服务:";echo "
";foreach ($results as $result) {echo "
-
" . $result['name'] . " - " . $result['address'] . " - " . $result['phone'] . "
";}echo "
";} else {echo "抱歉,附近没有 $service 服务。";}}// 获取附近服务的函数function get_services($service, $location) {// 连接数据库$conn = mysqli_connect("localhost", "root", "", "services");// 准备查询$stmt = mysqli_prepare($conn, "SELECT FROM services WHERE service=? AND location LIKE ?");// 绑定参数mysqli_stmt_bind_param($stmt, "ss", $service, $location);// 执行查询mysqli_stmt_execute($stmt);// 获取查询结果$result = mysqli_stmt_get_result($stmt);// 存储查询结果$services = array();while ($row = mysqli_fetch_assoc($result)) {$services[] = $row;}// 关闭连接mysqli_close($conn);// 返回查询结果return $services;}?>