PHP实现用户认证及管理完全源码
2018-09-07 12:13
<?php
$id=xxxCOM;
if(!isset($PHP_AUTH_USER)){
Header(
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){
?>
<HTML><HEAD>
<TITLE>404NotFound</TITLE>
</HEAD><BODY>
<H1>NotFound</H1>
TherequestedURL
<?echo$REQUEST_URI;?>
wasnotfoundonthisserver.<P>
</BODY></HTML>
<?php
exit;
}
?>
--endauth.inc--
--beginconnect.inc--
<?phpmysql_connect(localhost,user,);?>
--endconnect.inc--
--beginerror.inc--
此文件存放错误信息及返回!
--enderror.inc--
--用户库结构(自己调整)--
CREATETABLEauth(
idsmallint(6)DEFAULT0NOTNULLauto_increment,
usernamevarchar(16)DEFAULTNOTNULL,
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--
<?phpinclude(auth.inc);?>
<?php
if($PHP_AUTH_USER!=admin){
Header(WWW-Authenticate:Basicrealm=xxxCOM客户认证);
Header(HTTP/1.0401Unauthorized);
echoAccessDenied!n;
exit;
};
if($PHP_AUTH_PW!=mypassword){
Header(WWW-Authenticate:Basicrealm=xxxCOM客户认证);
Header(HTTP/1.0401Unauthorized);
echoAccessDenied!n;
exit;
};
if($activate){
include(connect.inc);
$query1=UPDATEauthSETactive=yeswhereid=$id;
$result1=mysql_db_query(admin,$query1);
if($result1){
echo<fontsize=+1>n;
echo$useractivatedn;
echo<br>n<ahref=$PHP_SELF>返回</a>\n;
echo</font>n;
exit;
}else{
echo<fontsize=+1>n;
echoError:UnknownErrorn;
echo<br>n<ahref=$PHP_SELF>返回</a>\n;
echo</font>n;
exit;
}
}
if($deactivate){
include(connect.inc);
$query2=UPDATEauthSETactive=nowhereid=$id;
$result2=mysql_db_query(admin,$query2);
if($result2){
echo<fontsize=+1>n;
echo$userdeactivatedn;
echo<br>n<ahref=$PHP_SELF>返回</a>\n;
echo</font>n;
exit;
}else{
echo<fontsize=+1>n;
echoError:UnknownErrorn;
echo<br>n<ahref=$PHP_SELF>返回</a>\n;
echo</font>n;
exit;
}
}
if($delete){
include(connect.inc);
$query3=deletefromauthwhereid=$id;
$result3=mysql_db_query(admin,$query3);
if($result3){
echo<fontsize=+1>n;
echo$user已删除!n;
echo<br>n<ahref=$PHP_SELF>返回</a>\n;
echo</font>n;
exit;
}else{
echo<fontsize=+1>n;
echoError:UnknownErrorn;
echo<br>n<ahref=$PHP_SELF>返回</a>\n;
echo</font>n;
exit;
}
}
echo<html>n;
echo<head>n;
echo<title>用户管理</title>n;
echo</head>n;
echo<body>n;
echo<formmethod=postaction=$PHP_SELF>\n;
echo<tableborder=1>n;
echo<tr><th><fontsize=+1>Username</font></th><th><fontsize=+1>RealName</font></th><th><fontsize=+1>Activated</font></th></tr>n;
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<tr><td><fontsize=+1>$username</font></td><td><fontsize=+1>$lastname,$firstname</font></td><td><fontsize=+1>$activated</font></td><td><ahref=$PHP_SELF?deactivate=yes&id=$id&user=$username>Deactivate</a></td><td><ahref=$PHP_SELF?delete=yes&id=$id>Delete</a></td></tr>n;
}elseif($activated==no){
echo<tr><td><fontsize=+1>$username</font></td><td><fontsize=+1>$lastname,$firstname</font></td><td><fontsize=+1>$activated</font></td><td><ahref=$PHP_SELF?activate=yes&id=$id>Activate</a></td><td><ahref=$PHP_SELF?delete=yes&id=$id>Delete</a></td></tr>n;
}
}
}
mysql_free_result($result);
echo</table>\n;
echo</body>\n;
echo</html>\n;
?>
--usermanage.php结束--
上一篇：f 中文版
下一篇：php 数据结构之链表队列