php mysql用户登录_php mysql简单的用户登录实现代码

$userid=trim($_POST["username"]);

$userpass=trim($_POST["password"]);

$admin_pass=substr(md5($userpass),0,32); //数据库教程密码

echo $userid."
".$admin_pass."
"; //输出用户和密码[post获取];

$mysql=new db_mysql(false);

$query="select * from #@_admin where admin_id like '".$userid."' limit 0,1"; //查询密码是否存在用户名

echo $query."
";

$mysql->SetQuery($query);

$mysql->Execute();

$row=$mysql->GetObject();

echo "数据库密码：".$row->admin_pass." post获取密码：".$admin_pass;

//exit;

if(!isset($row->admin_id)) //用户名错误

{

ShowMsg("用户名错误","../");

$mysql->Close();

return 0;

}

else if($row->admin_pass!=$admin_pass) //密码错误

{

ShowMsg("密码错误","../");

$mysql->Close();

return -1;

}

else

{

ShowMsg("登录成功","../");

$mysql->Close();

return 1;

}