php 连接sqls,PHP连接SqlServer

PHP连接SqlServer

1、查看phpinfo下载php对应32位或64位版本<?php

echo phpinfo();

?>

2、 sqlserver扩展下载链接:点击这里

如phpinfo中thread为enabled ：添加ts结尾dll文件

3、php.ini中引入extension=php_pdo_sqlsrv_73_ts_x86.dll

extension=php_sqlsrv_73_ts_x86.dll

4、 安装ODBC驱动msodbcsql.msi

注：这个根据操作系统安装

最后连接sqlserver<?php

header("Content-type: text/html; charset=utf-8");

try {

$dbName = "sqlsrv:Server=localhost;Database=demo2";

$dbUser = "sa";

$dbPassword = "hui136366";

$db = new PDO($dbName, $dbUser, $dbPassword);

if($db) {

var_dump($db);

echo "连接成功";

}else{

echo "连接失败";

}

}

catch(PDOException $e) {

$content = $e->getMessage();

echo $content;

}

?>