php pdo连接mssql server数据库

发布:smiling　来源: PHP粉丝网　添加日期：2014-09-11 10:06:15　浏览: 评论：0　

本文章简单的利用了php的pdo来连接微软的mssql server数据库,下面来看看实例,实例代码如下:

$dsn = 'mssql:dbname=bookStore_demo;host=192.168.1.106';

$user = 'sa';

$password = '123';

    //mssql_connect('192.168.1.106','sa','123');

    //echo 22;//开源代码phpfensi.com

try {

       // echo 11;

    $dbh = new PDO($dsn, $user, $password);

} catch (PDOException $e) {

    echo 'Connection failed: ' . $e->getMessage();

}

//$sql = 'select * from article';

$sth = $dbh->query($sql);

$result = $sth->fetchAll();

var_dump($result);