是一个通过邮箱登陆的界面,验证输入的用户名和邮箱是否正确,症状是无论输入的正确与否,都不提示。代码如下:
function confirmUserNamePassword($user_name,$user_pass,$in_db_conn=null)
{
if($in_db_conn==null)
$conn=$this->getConnection();
else
$conn=$in_db_conn;
$querystr=<<<EOQUERY
select * from users where mailbox='$user_name'
EOQUERY;
$results=@$conn->query($querystr);
if($results===false)
{
echo"此用户不存在!";
$login_ok=false;
}
while(($row=@$results->fetch_assoc())!==null)
{
if(strcasecmp($row['mailbox'],$user_name)==0)
{
if(md5($user_pass)==$row['password'])
{
$login_ok=true;
$user_id=$row['user_id'];
}
else
$login_ok=false;
break;
}
}
$results->close();
if($in_db_conn==null and isset($conn))
$conn->close();
if($login_ok===false)
{
echo"登陆失败!";
}
return $user_id;
function confirmUserNamePassword($user_name,$user_pass,$in_db_conn=null)
{
if($in_db_conn==null)
$conn=$this->getConnection();
else
$conn=$in_db_conn;
$querystr=<<<EOQUERY
select * from users where mailbox='$user_name'
EOQUERY;
$results=@$conn->query($querystr);
if($results===false)
{
echo"此用户不存在!";
$login_ok=false;
}
while(($row=@$results->fetch_assoc())!==null)
{
if(strcasecmp($row['mailbox'],$user_name)==0)
{
if(md5($user_pass)==$row['password'])
{
$login_ok=true;
$user_id=$row['user_id'];
}
else
$login_ok=false;
break;
}
}
$results->close();
if($in_db_conn==null and isset($conn))
$conn->close();
if($login_ok===false)
{
echo"登陆失败!";
}
return $user_id;