php连接远程mysql数据库

<?php
$host = '远程MySQL服务器IP地址';
$dbname = '数据库名称';
$username = '数据库用户名';
$password = '数据库密码';

try {
    // 使用MySQLi扩展
    $conn = new mysqli($host, $username, $password, $dbname);

    // 使用PDO扩展
    // $conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);

    if ($conn->connect_error) {
        die("连接失败: " . $conn->connect_error);
    }

    $sql = "SELECT * FROM 表名";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            echo "字段1: " . $row["字段1名称"] . " - 字段2: " . $row["字段2名称"] . "<br>";
        }
    } else {
        echo "0 结果";
    }

    $conn->close();
} catch (Exception $e) {
    echo "连接失败: " . $e->getMessage();
}
?>