php基于PDO连接MSSQL示例DEMO

<?php
try {
  $hostname='117.79.93.222';
  $port=1433;//端口
  $dbname="csdn";//库名
  $username="csdn_admin";//用户
  $pw="123456";//密码
  $dbh= new pdo("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
} catch (pdoexception $e) {
  echo"failed to get db handle: ".$e->getmessage() ."n";
  exit;
}
echo'connent mssql succeed';
$stmt=$dbh->prepare("select * from csdnuser");
$stmt->execute();
while ($row=$stmt->fetch()) {
  print_r($row);
}
unset($dbh);
unset($stmt);