如何在PHP中从mysql查询中获取最高和最低纬度和经度

$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

// 使用mysqli扩展连接到MySQL数据库
$conn = new mysqli($servername, $username, $password, $dbname);

// 使用PDO扩展连接到MySQL数据库
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 使用mysqli扩展执行查询语句
$query = "SELECT MAX(latitude) AS max_lat, MIN(latitude) AS min_lat, MAX(longitude) AS max_lng, MIN(longitude) AS min_lng FROM your_table";
$result = $conn->query($query);
$row = $result->fetch_assoc();

// 使用PDO扩展执行查询语句
$query = "SELECT MAX(latitude) AS max_lat, MIN(latitude) AS min_lat, MAX(longitude) AS max_lng, MIN(longitude) AS min_lng FROM your_table";
$result = $conn->query($query);
$row = $result->fetch(PDO::FETCH_ASSOC);

$max_latitude = $row['max_lat'];
$min_latitude = $row['min_lat'];
$max_longitude = $row['max_lng'];
$min_longitude = $row['min_lng'];

// 使用mysqli扩展关闭数据库连接
$conn->close();

// 使用PDO扩展关闭数据库连接
$conn = null;