通过 PDO ODBC 将 PHP 连接到 MySQL

<?php
$hostname = "localhost";
$database = "db";
$username = "root";
$password = "root";

try {
    $pdo = new PDO("odbc:Driver={MySQL ODBC 3.51 Driver};host=$hostname;database=$database", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "SELECT id,name,city FROM mytable";
    $stmt = $pdo->query($sql);
    while ($row = $stmt->fetch()) {
        print( $row[0] . "-" . $row[1] . "-" . $row[2] . "\r\n");
    }
} catch (PDOException $e) {
    echo $e->getMessage();
    exit;
}
# close the connection
$dbh = null;
?>