0) {echo "
";foreach ($errors as $error) {echo "
-
$error
";}echo "
";} else {// 连接到数据库$servername = "localhost";$username = "root";$password = "password";$dbname = "private_guides";$conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) {die("连接数据库失败：" . $conn->connect_error);}// 准备查询语句$stmt = $conn->prepare("SELECT FROM guides WHERE location = ?");$stmt->bind_param("s", $_GET['location']);// 执行查询$stmt->execute();// 获取查询结果$result = $stmt->get_result();// 关闭 prepared statement$stmt->close();// 关闭数据库连接$conn->close();// 显示查询结果if ($result->num_rows >0) {echo "";echo "";while ($row = $result->fetch_assoc()) {echo "";}echo "
|
姓名
|
邮箱
|
电话
|
地点
|
" . $row['name'] . "
|
" . $row['email'] . "
|
" . $row['phone'] . "
|
" . $row['location'] . "
|
";} else {echo "没有找到符合条件的私人导游。";}}?>
