数学建模社区-数学中国
标题:
求教连接数据库问题，win8.1(X64)+IIS+php5.5.23+sqlserver2008R2
[打印本页]
作者:
曾经的王者
时间:
2015-4-20 09:59
标题:
求教连接数据库问题，win8.1(X64)+IIS+php5.5.23+sqlserver2008R2
本人新手刚学习PHP，遇到连接SQLSERVER2008R2数据库问题，环境win8.1(X64)+IIS8.5+php5.5.23+sqlserver2008R2(x64)
$ t8 h4 q5 s" ]2 F f
PHP文件能成功执行，但是执行phpinfo()并未发现sqlsrv，执行数据库连接后提示如下：
: ?9 ?5 h" {/ X; Z" D
PHP Fatal error: Call to undefined function sqlsrv_connect() in E:\wwwroot\php.com\test\2.php on line 11
: \% B. q# v! X: E; J
----------------代码如下---------------
/ ^ J* y5 Z2 `9 u0 b
<?php
+ L: R& ~6 h. C: n1 D
$serverName = "(local)";
7 i. j3 J" V! e/ u
$uid ="sa";
8 q+ S: X0 t- u4 z' _- K) h
$pwd = "mypwd123";
5 U2 p8 _ }( D- S" ~
, l6 r2 q ]4 x, c/ ^
$connectionInfo = array("UID"=>$uid,"PWD"=>$pwd,"Database"=>"phpdb");
. ?+ C% t/ ^+ d5 y' h9 O
/ m, B7 W# m! F4 Q' q
$conn = sqlsrv_connect( $serverName,$connectionInfo);
6 I# K0 A- H3 z* T; a
if( $conn == false)
+ k" q( M& a9 k0 ]6 s
{
: u6 X4 Q* U+ s4 y3 i9 j
echo "连接失败！";
2 h9 Y1 h- m- N0 e
die( print_r( sqlsrv_errors(), true));
( z8 f8 w& o" N$ u
}
6 \9 H1 ^+ V n: P4 o
?>
- g) r6 Q, z0 o+ a
-------------------------------------------------------------------------
; W) c7 b v" g8 B
望高手指点迷津
5 X& e Y, b& z4 w9 Q1 {- j
, \2 C, p7 c/ ~1 n! K
php.net里下载php-5.5.24-nts-Win32-VC11-x64.zip
6 o$ w ?# |8 M! H; U
微软官网下载 解压SQLSRV32.EXE后，拷贝php_pdo_sqlsrv_55_nts.dll和php_sqlsrv_55_nts.dll 到PHP安装目录ext
* l6 u4 s' [* \# [- _/ f# W. q
并且修改了php.ini的配置文件extension=php_sqlsrv_55_nts.dll
, ]# F O# D- p5 H) m V
extension=php_pdo_sqlsrv_55_nts.dll
" d3 m+ H L# R9 M
mssql.secure_connection = On
" p2 n$ o, m7 ~
v" W- M3 _' V" ~" f5 D
欢迎光临 数学建模社区-数学中国 (http://www.madio.net/)
Powered by Discuz! X2.5