作者roger70349 (roger70349)
看板PHP
标题[请益] php程式码问题
时间Mon Jan 29 15:12:31 2007
请各位大大能否帮我看一下下面的两只程式的程式码那里有问题
分别为login_chk.php及admin_chk.php
公用程式
my_msg.php
<?
Function my_header($redirect){
echo "<script language=\"javascript\">";
echo "location.href='".$redirect."'";
echo "</script>";
return;
}
Function my_msg($msg,$redirect){
echo "<SCRIPT Language=javascript>";
echo "window.alert('".$msg."')";
echo "</SCRIPT>";
echo "<script language=\"javascript\">";
echo "location.href='".$redirect."'";
echo "</script>";
return;
}
?>
另一只共用程式 sql_connect.php
<?
/* Connecting, selecting database */
$link = mysql_connect('localhost', 'root', 'roger')
or die("Could not connect : " . mysql_error());
//echo "Connected successfully";
mysql_select_db("danshui") or die("Could not select database");
mysql_query("SET NAMES 'big5'"); //显示中国伟大的文学
?>
两只程式
login_chk.php
<?
include_once("sql_connect.php");
include_once("my_msg.php");
?>
<?
//检核资料
if($_POST['id']=='' or $_POST['password']==''){
my_msg("栏位不可空白","login.html");
}
$sqlstr="select * from member where id ='".$_POST['id']."' and password =
'".$_POST['password']."' and status = 1";
$result = mysql_query($sqlstr,$link);
$row = mysql_fetch_array($result, MYSQL_BOTH);
if(mysql_num_rows ($result)==1 && $row["rank"]==100){
setcookie("cookie_chk", "adm_logined");
setcookie("cookie_id", $_POST['id']);
my_header("adm.php");// 管理者登入
}elseif(mysql_num_rows ($result)==1 && $row["rank"]==1){
setcookie("cookie_chk", "logined");
setcookie("cookie_id", $_POST['id']);
my_header("main.php");// 会员登入
}else{
my_msg("登入失败，请重新登入","login.html");
}
mysql_free_result($result);
mysql_close($link);
?>
还有另一只程式是 admin_chk.php
<?
$link = mysql_connect("localhost","root","roger");
mysql_query("danshui");
$sqlstr="select * from user where id ='".$_POST['id']."' and passwd =
'".$_POST['passwd']."'";
$result = mysql_query($sqlstr,$link);
if(mysql_num_rows ($result)){
echo "<center>管理者登入成功</center>";
}else{
echo "<center>管理者登入失败</center>";
}
?>
但在执行後出现
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in D:\AppServ\www\danshui\member\admin_chk.php on line 17
请问各位大大，以上两只程式的问题出在那里，谢谢。
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 163.21.79.80
1F：→ antontw:admin_chk.php 第十七行 01/29 15:36
2F：推 yanli2:你的Querry没东西所以出错 01/29 17:50