首页 > 代码库 > PHP5.4连接sqlserver
PHP5.4连接sqlserver
1.下载微软的php连接驱动:SQLSRV30.EXE(5.4对应,后面的native client要用2012)/SQLSRV20.EXE(5.3对应,native client要用2008)
2.解压SQLSERV30.EXE,拷贝对应extension到php的ext目录
3.配置php.ini
extension=php_sqlsrv_54_ts.dll(54为5.4版本,ts为线程安全,nts为非线程安全)
mssql.secure_connection = Off改为on 很多教程没写这个
4.重启IIS/Apache
5.在sqlserver服务器配置TCP/IP连接
6.在php服务器下载安装sqlserver native client
7.测试代码
<?phpheader("Content-Type: text/html;charset=utf-8");class mssql{ private $host; private $username; private $password; private $database; private $handle; private function __construct (Array $config){ $this -> host = $config[‘host‘]; $this -> username = $config[‘username‘]; $this -> password = $config[‘password‘]; $this -> database = $config[‘database‘]; $this -> init(); } private function init() { $dsn = ‘sqlsrv:server = ‘.$this -> host.‘;database = ‘.$this->database; $this -> handle = new PDO($dsn,$this -> username, $this -> password); } public static function GetInstance(array $config = null) { if (null == $config) { return NULL; } static $db = null; if (null == $db) { $c = __CLASS__; $db = new $c($config); }; return $db -> handle; }}$config = array( ‘host‘ => ‘192.168.0.152,1433‘, ‘database‘ => ‘TimeTracker‘, ‘username‘ => ‘sa‘, ‘password‘ => ‘123‘);$mssql = mssql::GetInstance($config);$result = $mssql->query(‘SELECT * FROM T_Sys_UserInfo‘);foreach($result as $row){ echo $row[2];}?>
PHP5.4连接sqlserver
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。