当前位置：网站首页>Connect PHP to MySQL via PDO ODBC

Connect PHP to MySQL via PDO ODBC

2022-04-23 15:26: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://yzsam.com/2022/04/202204231525131224.html