<?
require_once("session.php");
$web_root_part = "../";
require_once($web_root_part."lib/db.php");
require_once($web_root_part."lib/function.php");
header('Content-type:text/html;charset=utf-8'); $AdminID = trim($_POST['AdminID']);
$PassWord = trim($_POST['PassWord']);
$Addtime = date("Y-m-d H:i:s");$querySel = "select * from Admin where AdminID='".$AdminID."'";
if( !($result = $db->sql_query($querySel)) )
{
message_die(DB_MESSAGE, 'Could not query Admin');
}else{
$row = $db->sql_fetchrow($result);
//$db->sql_freeresult($result);
if (empty($row['ID'])){
$sql="insert into Admin (AdminID,PassWord,Editer,Addtime) values('".$AdminID."','".md5($PassWord)."','".$_SESSION['AdminID']."','".$Addtime."')";
if( !($result = $db->sql_query($sql)) )
{
//echo $sql;
message_die(DB_MESSAGE, 'Could not query Admin');
}else{
echo "<script>location.replace('admin.php');</script>";
}
}else{
echo "<Script Language='Javascript'>";
echo "alert('提示:管理员ID已存在,请重新输入!');";
echo "history.go(-1);";
echo "</Script>";
}
}
?>这个代码那里有问题呢? 怎么不管理员ID 有没有重复 都提示 管理员ID已存在,请重新输入 呢
require_once("session.php");
$web_root_part = "../";
require_once($web_root_part."lib/db.php");
require_once($web_root_part."lib/function.php");
header('Content-type:text/html;charset=utf-8'); $AdminID = trim($_POST['AdminID']);
$PassWord = trim($_POST['PassWord']);
$Addtime = date("Y-m-d H:i:s");$querySel = "select * from Admin where AdminID='".$AdminID."'";
if( !($result = $db->sql_query($querySel)) )
{
message_die(DB_MESSAGE, 'Could not query Admin');
}else{
$row = $db->sql_fetchrow($result);
//$db->sql_freeresult($result);
if (empty($row['ID'])){
$sql="insert into Admin (AdminID,PassWord,Editer,Addtime) values('".$AdminID."','".md5($PassWord)."','".$_SESSION['AdminID']."','".$Addtime."')";
if( !($result = $db->sql_query($sql)) )
{
//echo $sql;
message_die(DB_MESSAGE, 'Could not query Admin');
}else{
echo "<script>location.replace('admin.php');</script>";
}
}else{
echo "<Script Language='Javascript'>";
echo "alert('提示:管理员ID已存在,请重新输入!');";
echo "history.go(-1);";
echo "</Script>";
}
}
?>这个代码那里有问题呢? 怎么不管理员ID 有没有重复 都提示 管理员ID已存在,请重新输入 呢
//$db->sql_freeresult($result);
if (empty($row['ID'])){
$sql="insert into Admin (AdminID,PassWord,Editer,Addtime) values('".$AdminID."','".md5($PassWord)."','".$_SESSION['AdminID']."','".$Addtime."')";
if( !($result = $db->sql_query($sql)) )
{
//echo $sql;
message_die(DB_MESSAGE, 'Could not query Admin');
}else{
echo "<script>location.replace('admin.php');</script>";
} 换成echo "123"; 就没问题
至于你说的$row['ID']没被清除,应该说不可能
echo "alert('提示:管理员ID已存在,请重新输入!');";
echo "history.go(-1);";
echo "</Script>";
显示 Array ( [ID] => 29 [AdminID] => 999999 [PassWord] => 96e79218965eb72c92a549dd5a330112 [IP] => [LoginTime] => [Editer] => admin [Addtime] => 2012-02-07 09:52:45 ) 数据库中没有 999999 这个用户名 应该是直接插入数据 返回 不应该执行print_r($row);
if(!($result = $db->sql_query($querySel)))
{
//echo $sql;
message_die(DB_MESSAGE, 'Could not query Admin');
}里边 我把这个代码换成 echo "123";就判断正确