<?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 = "databasename";
$username = "sa";
$pw = "xxxwtxxx";
$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 1 * FROM tablename");
$stmt->execute();
while ($row = $stmt->fetch()) {
var_dump($row);
}
unset($dbh); unset($stmt);
pdosqlsrv 连接sqlserver数据库
最新推荐文章于 2023-12-21 14:07:41 发布