php 跳板机连接mysql

<?php
try {
    // 跳板机的 SSH 配置
    $sshUser = 'ssh_user';
    $sshPass = 'ssh_password';
    $sshHost = '192.168.1.1';
    $sshPort = 22;

    // MySQL 数据库配置
    $dbHost = '192.168.2.1';
    $dbPort = 3306;
    $dbName = 'db_name';
    $dbUser = 'db_user';
    $dbPass = 'db_password';

    // 使用 SSH 隧道连接跳板机
    $ssh = new \phpseclib\Net\SSH2($sshHost, $sshPort);
    if (!$ssh->login($sshUser, $sshPass)) {
        throw new Exception("SSH login failed");
    }

    // 创建本地端口转发
    $localPort = 3307;
    $ssh->forwardLocal($localPort, $dbHost, $dbPort);

    // 使用 PDO 连接 MySQL 数据库
    $dsn = "mysql:host=127.0.0.1;port=$localPort;dbname=$dbName";
    $pdo = new PDO($dsn, $dbUser, $dbPass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 执行查询
    $stmt = $pdo->query("SELECT * FROM your_table");
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

    print_r($result);
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>