另外,我死连连都连不上mssqlserver, 我的机子名字叫nec,我连localhost,127.0.0.1都试过了,就是连不上数据库啊,大家帮我看看啊server的名字叫nec db的名字叫njc2 表的名字叫zcyc 表里有两个字段,username,和password <?PHP $conn=mssql_pconnect("nec","sa","1"); mssql_Select_db("njc2",$conn); $str="Select username,password from zcyz"; $result=mssql_query($str,$conn); $row=mssql_num_rows($result); for ($i=1;$i<=$row;$i++) { list($username,$password)=mssql_fetch_row($result);} print("$username,$password");?> 错误代码 Warning: mssql_pconnect(): Unable to connect to server: 127.0.0.1 in g:\program files\apache group\apache\htdocs\5.php on line 9Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 10Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 12Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in g:\program files\apache group\apache\htdocs\5.php on line 13 , 另我,phpinfo()里面sqlserver服务的情况是 MSSQL Support enabled Active Persistent Links 0 Active Links 0 Library version 7.0
路径我都检查过了,不会有错的,是我的路径,不是这里的路径 他启动时候报的错误是:cannt load "G:\PHP4\sapi\php4apache2.dll"into server <126>找不到指定模块
server的名字叫nec db的名字叫njc2 表的名字叫zcyc 表里有两个字段,username,和password <?PHP $conn=mssql_pconnect("nec","sa","1"); mssql_Select_db("njc2",$conn); $str="Select username,password from zcyz"; $result=mssql_query($str,$conn); $row=mssql_num_rows($result); for ($i=1;$i<=$row;$i++) { list($username,$password)=mssql_fetch_row($result);} print("$username,$password");?> 错误代码 Warning: mssql_pconnect(): Unable to connect to server: 127.0.0.1 in g:\program files\apache group\apache\htdocs\5.php on line 9Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 10Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 12Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in g:\program files\apache group\apache\htdocs\5.php on line 13 , 另我,phpinfo()里面sqlserver服务的情况是 MSSQL Support enabled Active Persistent Links 0 Active Links 0 Library version 7.0 这个是症状,大家帮忙看看把!!!
(1) 运行apache_2.0.47-win32-x86-no_ssl.exe,安装apache(2) 选择存放PHP的目录,进行拷贝或解压,例如e:\software\php\php-4.3.4-win32(3) 拷贝PHP目录下的php.ini-dist到windows系统目录下,并改名为php.ini
拷贝PHP目录下的php4ts.dll到windows系统目录下或PHP的sapi子目录下(4) 编辑php.ini
doc_root = "f:\php"
extension_dir = "e:\software\php\php-4.3.4-win32\extensions"
session.save_path = "c:\windows\temp\session"
去掉extension=php_mssql.dll的注释
考虑register_globals = Off的设置(5) 编辑httpd.conf
LoadModule php4_module "e:/software/php/php-4.3.4-win32/sapi/php4apache2.dll"
# AddModule mod_php4.c
AddType application/x-httpd-php .php
DocumentRoot "f:\php"
给AddDefaultCharset ... 加上注释
问下,我照这样做了,他说找不到那个模块咋办捏,当然我的路径是对的,检查过了
他保错的信息是找不到那个模块,不能连接server
LoadModule php4_module "G:\PHP4\sapi\php4apache2.dll"
这句还有错误,我用的apache1.31,是不是这个的问题啊
我的机子名字叫nec,我连localhost,127.0.0.1都试过了,就是连不上数据库啊,大家帮我看看啊server的名字叫nec
db的名字叫njc2
表的名字叫zcyc
表里有两个字段,username,和password
<?PHP
$conn=mssql_pconnect("nec","sa","1");
mssql_Select_db("njc2",$conn);
$str="Select username,password from zcyz";
$result=mssql_query($str,$conn);
$row=mssql_num_rows($result);
for ($i=1;$i<=$row;$i++)
{
list($username,$password)=mssql_fetch_row($result);}
print("$username,$password");?>
错误代码
Warning: mssql_pconnect(): Unable to connect to server: 127.0.0.1 in g:\program files\apache group\apache\htdocs\5.php on line 9Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 10Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 12Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in g:\program files\apache group\apache\htdocs\5.php on line 13
, 另我,phpinfo()里面sqlserver服务的情况是 MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0
他启动时候报的错误是:cannt load "G:\PHP4\sapi\php4apache2.dll"into server <126>找不到指定模块
LoadModule php4_module "C:\Apache\Apache2\php4\sapi\php4apache2.dll"
AddType application/x-httpd-php .php
这个路径C:\Apache\Apache2\php4\要自己改,还有是加在httpd.conf中
db的名字叫njc2
表的名字叫zcyc
表里有两个字段,username,和password
<?PHP
$conn=mssql_pconnect("nec","sa","1");
mssql_Select_db("njc2",$conn);
$str="Select username,password from zcyz";
$result=mssql_query($str,$conn);
$row=mssql_num_rows($result);
for ($i=1;$i<=$row;$i++)
{
list($username,$password)=mssql_fetch_row($result);}
print("$username,$password");?>
错误代码
Warning: mssql_pconnect(): Unable to connect to server: 127.0.0.1 in g:\program files\apache group\apache\htdocs\5.php on line 9Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 10Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in g:\program files\apache group\apache\htdocs\5.php on line 12Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in g:\program files\apache group\apache\htdocs\5.php on line 13
, 另我,phpinfo()里面sqlserver服务的情况是 MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0 这个是症状,大家帮忙看看把!!!
试试!!
<?php
$conn=mssql_pconnect("NEC","sa","1");
mssql_Select_db("njc2",$conn);
$str="Select username from yhzc ";
$res= mssql_query($str,$conn);
$row=mssql_num_rows($res);
for ($i=1;$i=$row;$i++)
{
list($username)=mssql_fetch_row($res);
echo "$username <BR>\n";}