使用php pdo 连接到mssql sqlsrv

首先到官方http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx 下载相应的驱动。
然后windows为例

extension=php_pdo_odbc.dll
extension=php_pdo_sqlsrv_54_nts.dll
extension=php_sqlsrv_54_nts.dll

查看phpinfo中是否已经开启MsSQL
接下来用代码测试即可

$DSN = "mssql:host=localhost;dbname=testdb";//mssql dsn
$DSN="sybase:host=localhost;dbname=testdb";//sybase dsn
$DSN="dblib:host=localhost;dbname=testdb";//any dsn
$DSN = "sqlsrv:Server=localhost,1521;Database=testdb";//ms sql server
$dbUser = "dbuser";//username
$dbPass = "password";//password
$conn = new PDO($DSN,$dbUser,$dbPass);//connect handle
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);// set some attribute of pdo object
$query = "select * from table where field=:field;"; //T_SQL query
$fieldValue = 'Value';//
$params = array(":field"=>$fieldValue);
$getProducts = $conn->prepare($query);
$getProducts->execute($params);
$products= $getProducts->fetchAll(PDO::FETCH_ASSOC);

未经允许不得转载:SuperMan's blog » 使用php pdo 连接到mssql sqlsrv

评论 0

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址