phpstudy sqlsrv v8.1_phpstudy 连接sqlserver数据库

phpstudy 连接sqlserver数据库 参考 http://my.oschina.net/u/733393/blog/110141

第一步：下载sqlsrv扩展

下载地址：http://pan.baidu.com/s/1eQ7u3kA

解压将三个文件解压后的内容

修改配置文件php.ini

php extendsion 为 nts 则将对应的上图中绿框的文件复制到 对应php/ext的目录下

php.ini部分配置

extension=php_pdo_mysql.dll

;extension=php_pdo_oci.dll

extension=php_pdo_odbc.dll

;extension=php_pdo_pgsql.dll

extension=php_pdo_sqlite.dll

;extension=php_pgsql.dll

;extension=php_pspell.dll

;extension=php_shmop.dll

;extension=php_mongo.dl

extension=php_sqlsrv.dll

extension=php_pdo_sqlsrv.dll

mssql.secure_connection = on

sqlsrv扩展、(Microsoft Drivers for PHP for SQL Server)，

依赖Microsoft SQL Server 2008 R2 Native Client 故需要安装

下载地址：http://pan.baidu.com/s/1o6kd7To

Microsoft SQL Server 2008 R2 Native Client下载

thinkphp连接代码

namespace Home\Controller;

use Think\Controller;

class IndexController extends Controller {

public function index() {

$config = array (

'db_type' => 'pdo', //采用pdo方式连接

'db_user' => '***',

'db_pwd' => '***',

'db_charset' => 'utf8',

'DB_DSN' => 'sqlsrv:Server=120.209.149.134;Database=gpsbase',

);

$where ["TerminalID"] = "14100087049";

$m = M ( "Warn", "", $config )->where ( $where )->select ();

dump ( $m );

}

}