PHP实现用户认证及管理完全源码
2021-01-23 9:57:19557
--beginauth.inc--
$id="xxxCOM";
if(!isset($PHP_AUTH_USER)){
Header("WWW-Authenticate:Basicrealm="$id"");
Header("HTTP/1.0401Unauthorized");
require('error.inc');
exit;
}
$name=$PHP_AUTH_USER;
$pass=$PHP_AUTH_PW;
require("connect.inc");
$query="select*fromauthwhereusername='$name'&&realm='$id'";
$result=mysql_db_query("admin",$query);
if(mysql_num_rows($result)==0){
Header("WWW-Authenticate:Basicrealm="$id"");
Header("HTTP/1.0401Unauthorized");
require('error.inc');
exit;
}
$active=mysql_result($result,0,"active");
if($active=='no'){
?>
404NotFoundNotFound
TherequestedURL
wasnotfoundonthisserver.
exit;
}
?>
--endauth.inc--
--beginconnect.inc--
--endconnect.inc--
--beginerror.inc--
此文件存放错误信息及返回!
--enderror.inc--
--用户库结构(自己调整)--
CREATETABLEauth(
idsmallint(6)DEFAULT'0'NOTNULLauto_increment,
usernamevarchar(16)DEFAULT''NOTNULL,
lastnametinyblob,
firstnametinyblob,
passwordvarchar(16),
realmvarchar(16),
activechar(3),
PRIMARYKEY(id),
UNIQUEid(id),
UNIQUEusername(username)
);
--用户库结构结束--
--添加用户示例--
insertintoauth(username,lastname,firstname,password,realm,active)values('admin','my','love','password','xxxCOM','yes');
--结束--
--用户管理程序开始usermanage.php--
if($PHP_AUTH_USER!="admin"){
Header("WWW-Authenticate:Basicrealm="xxxCOM客户认证"");
Header("HTTP/1.0401Unauthorized");
echo"AccessDenied!n";
exit;
};
if($PHP_AUTH_PW!="mypassword"){
Header("WWW-Authenticate:Basicrealm="xxxCOM客户认证"");
Header("HTTP/1.0401Unauthorized");
echo"AccessDenied!n";
exit;
};
if($activate){
include("connect.inc");
$query1="UPDATEauthSETactive='yes'whereid='$id'";
$result1=mysql_db_query("admin",$query1);
if($result1){
echo"n";
echo"$useractivatedn";
echo"
n返回\n";
echo"n";
exit;
}else{
echo"n";
echo"Error:UnknownErrorn";
echo"
n返回\n";
echo"n";
exit;
}
}
if($deactivate){
include("connect.inc");
$query2="UPDATEauthSETactive='no'whereid='$id'";
$result2=mysql_db_query("admin",$query2);
if($result2){
echo"n";
echo"$userdeactivatedn";
echo"
n返回\n";
echo"n";
exit;
}else{
echo"n";
echo"Error:UnknownErrorn";
echo"
n返回\n";
echo"n";
exit;
}
}
if($delete){
include("connect.inc");
$query3="deletefromauthwhereid='$id'";
$result3=mysql_db_query("admin",$query3);
if($result3){
echo"n";
echo"$user已删除!n";
echo"
n返回\n";
echo"n";
exit;
}else{
echo"n";
echo"Error:UnknownErrorn";
echo"
n返回\n";
echo"n";
exit;
}
}
echo"n";
echo"
n";echo"
用户管理n";echo"n";
echo"
n";echo"\n";
echo"n";
echo"
UsernameRealNameActivatedn";include("connect.inc");
$query="SELECT*FROMauth";
$result=mysql_db_query("admin",$query);
if($result){
while($r=mysql_fetch_array($result)){
$id=$r["id"];
$username=$r["username"];
$lastname=$r["lastname"];
$firstname=$r["firstname"];
$activated=$r["active"];
if($activated=="yes"){
echo"
$username$lastname,$firstname$activatedDeactivateDeleten";}elseif($activated=="no"){
echo"
$username$lastname,$firstname$activatedActivateDeleten";}
}
}
mysql_free_result($result);
echo"\n";
echo"\n";
echo"\n";
?>
--usermanage.php结束--
点击这里复制本文地址
以上内容由聚米学院网友整理呈现,如对侵犯您的权益,请联系邮箱:fzsbm@qq.com
留言评论