--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'){
?>

NotFound

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结束--