phpstudy 连接sqlserver数据库
phpstudy 连接sqlserver数据库 参考?http://my.oschina.net/u/733393/blog/110141
第一步:下载sqlsrv扩展打开http://www.microsoft.com/en-us/download/details.aspx?id=20098? ?下载 SQLSRV20.EXE 下载地址:http://pan.baidu.com/s/1eQ7u3kA 解压将三个文件解压后的内容 修改配置文件php.iniphp 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://msdn.microsoft.com/en-us/library/cc296170%28SQL.90%29.aspx?选择 Download the X86 package下载,点击安装即可 下载地址:http://pan.baidu.com/s/1o6kd7To Microsoft SQL Server 2008 R2 Native Client下载http://www.microsoft.com/zh-CN/download/details.aspx?id=27596 云盘下载地址 http://pan.baidu.com/s/10HBCM thinkphp连接代码<?php namespace HomeController; use ThinkController; 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 ); } } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |