首页 > 代码库 > PHP连接SQLServer2012两例

PHP连接SQLServer2012两例

首先放上

PHP连接SQLServer的驱动下载地址

http://php.net/manual/zh/ref.pdo-sqlsrv.php

另外PHP for IIS管理工具 大家可以自己搜索一下 很久以前下的。现在忘记地址了。

PHPManagerForIIS-1.1.2-x64.msi

 

第一个是比较基础的,直接创建conn 连接本机的SQLExpress实例

    $conn = new PDO("sqlsrv:server=.\SQLExpress;Database=thinkphp","admin","pass1234");    //$conn = new PDO("sqlsrv:Server=127.0.0.1/Express; Database=MyeCharts", "admin", "pass1234");     $query = ‘select top 1 * from think_data‘;      $stmt = $conn->query( $query );      while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ) {         //print_r( $row );      }  

第二个是网上搜罗到的创建了类来控制 连接远程服务器。

class mssql{        private $host;        private $username;        private $password;        private $database;        private $handle;        private function __construct (Array $config){            $this -> host = $config[‘DB_HOST‘];            $this -> username = $config[‘DB_USER‘];            $this -> password = $config[‘DB_PWD‘];            $this -> database = $config[‘DB_NAME‘];            $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(        ‘DB_HOST‘ => ‘servername,1800‘,        ‘DB_NAME‘ => formname,        ‘DB_USER‘ => ‘admin‘,        ‘DB_PWD‘ => ‘pass1234‘    );    $mssql = mssql::GetInstance($config);    $result = $mssql->query(‘SELECT MAX(formID) FROM fromname);    foreach($result as  $row){        $id = $row[0];        echo $id;    }