1,环境是win10+phpstudy+sqlserver2014
2,下载SQL Server驱动
(1)因为php5.3以上版本缺少sqlser的驱动,所以需要去官网下载,下载地址:https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?view=sql-server-2017
有很多版本的驱动,首先确定驱动程序版本支持的操作系统版本
其实phpstudy里面已经有驱动:
3, 在php.ini中开启驱动
添加 extension=下载的驱动的驱动名
例如:
extension=php_sqlsrv_7_nts_x86.dll
extension=php_pdo_sqlsrv_7_nts_x86.dll
4.测试连接:
<?php
/**
* Created by PhpStorm.
* User: alex
* Date: 2019/5/5
* Time: 12:50
*/
echo 'sqlsvr<br/>';
$serverName = "localhost"; //数据库服务器地址
$uid = "sa"; //数据库用户名
$pwd = "pwd!"; //数据库密码
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database" => "test");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if ($conn == false) {
echo "连接失败!";
var_dump(sqlsrv_errors());
exit;
} else {
echo "链接成功<br/>";
}
$sql = "select * from t1";
$stmt = sqlsrv_query($conn, $sql);
echo '<pre>';
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
echo print_r($row,1). "<br/>";
}
用thinkphp连接方式:
config.php里面添加一行:
'sqlsrv_config' => 'sqlsrv://sa:pwd!@localhost:1433/test',
然后代码调用是这样的:
//连接sqlserver数据库
function sqlsrv(){
$t1 = M('t1', '', 'sqlsrv_config');
$row = [];
$row['id'] = 888;
$row['name'] = 'ajfsdk';
$row['val'] = 0894.83;
$t1->add($row);
$data = $t1->limit(2,3)->select();
echo '<pre>';
print_r($data);
}