--beginauth.inc--
<?php
$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'){
?>
<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)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--
<?phpinclude("auth.inc");?>
<?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"<fontsize="+1">n";
echo"$useractivatedn";
echo"<br>n<ahref="$PHP_SELF">返回</a>n";
echo"</font>n";
exit;
}else{
echo"<fontsize="+1">n";
echo"Error:UnknownErrorn";
echo"<br>n<ahref="$PHP_SELF">返回</a>n";
echo"</font>n";
exit;
}
}
if($deactivate){
include("connect.inc");
$query2="UPDATEauthSETactive='no'whereid='$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";
echo"Error: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";
echo"Error: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="post"action="$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结束--