当前位置：网站首页>通过 PDO ODBC 将 PHP 连接到 MySQL

通过 PDO ODBC 将 PHP 连接到 MySQL

2022-04-23 15:25:00 【allway2】 

<?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;
?>

版权声明
本文为[allway2]所创，转载请带上原文链接，感谢
https://blog.csdn.net/allway2/article/details/124361655

边栏推荐

猜你喜欢

随机推荐