pdo sqlserver

PHP代码如果想要用以上的方式兼容linux服务器和windows服务器,那么大概的示例代码是这样的。

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 = "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);
上一篇:【问底】徐汉彬:亿级Web系统搭建——单机到分布式集群


下一篇:原生 JavaScript 图片裁剪效果