本文章简单的利用了php的pdo来连接微软的mssql server数据库,下面来看看实例,实例代码如下:
- $dsn = 'mssql:dbname=bookStore_demo;host=192.168.1.106';
- $user = 'sa';
- $password = '123';
-
-
- try {
-
- $dbh = new PDO($dsn, $user, $password);
-
- } catch (PDOException $e) {
- echo 'Connection failed: ' . $e->getMessage();
- }
-
- $sth = $dbh->query($sql);
- $result = $sth->fetchAll();
-
- var_dump($result);
|