pdo 链接sqlserver

复制代码
<?php
header("Content-type: text/html; charset=utf-8");
if(PATH_SEPARATOR==':')
    echo '本机操作系统是:Linux<br>';
else
    echo '本机操作系统是:Windows<br>';
 
try {
    //服务器
    $host = "127.0.0.1";
    $port = '1433';
    $dbname = "oblog46";
    $username = "sa";
    $pw = "123456";
    $dbh = null;
 
    if(PATH_SEPARATOR==':'){
        $dbh = new PDO ("dblib:host=$host:$port;dbname=$dbname","$username","$pw");
    }else{
        $dbh = new PDO("sqlsrv:Server=$host,$port;Database=$dbname",$username,$pw);
    }
} catch (PDOException $e) {
    echo "Failed to get DB handle: " . $e->getMessage() . "\n";
    exit;
}
 
$stmt = $dbh->prepare("SELECT top 3 * FROM oblog_log");
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo "<pre>";
    print_r($row);
}
unset($dbh); unset($stmt);
复制代码

 

posted @   愛羅  阅读(140)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· AI技术革命,工作效率10个最佳AI工具
点击右上角即可分享
微信分享提示