PHP實現使用者認證及管理完全源碼_PHP教程

-- begin auth.inc --
$id = "xxxCOM";
if(!isset($PHP_AUTH_USER)) {
Header("WWW-Authenticate: Basic realm="$id"");
Header("HTTP/1.0 401 Unauthorized");
require('error.inc');
exit;
}
$name = $PHP_AUTH_USER;
$pass = $PHP_AUTH_PW;
require("connect.inc");
$query = "select * from auth where username='$name' && realm='$id'";
$result = mysql_db_query("admin", $query);
if(mysql_num_rows($result) == 0) {
Header("WWW-Authenticate: Basic realm="$id"");
Header("HTTP/1.0 401 Unauthorized");
require('error.inc');
exit;
}
$active = mysql_result($result,0,"active");
if($active == 'no') {
?>

404 Not Found

Not Found

The requested URL

was not found on this server.

exit;
}
?>
-- end auth.inc --
-- begin connect.inc --

-- end connect.inc --
-- begin error.inc --
此檔案存放錯誤資訊及返回!
-- end error.inc --
-- 使用者庫結構(自己調整)--
CREATE TABLE auth (
id smallint(6) DEFAULT '0' NOT NULL auto_increment,
username varchar(16) DEFAULT '' NOT NULL,
lastname tinyblob,
firstname tinyblob,
password varchar(16),
realm varchar(16),
active char(3),
PRIMARY KEY (id),
UNIQUE id (id),
UNIQUE username (username)
);
-- 使用者庫結構結束--
-- 添加使用者樣本--
insert into auth (username, lastname, firstname, password, realm, active) values ('admin','my','love','password','xxxCOM','yes');
-- 結束--
--使用者管理程式開始 usermanage.php --

if ($PHP_AUTH_USER != "admin") {
Header("WWW-Authenticate: Basic realm="xxxCOM 客戶認證"");
Header("HTTP/1.0 401 Unauthorized");
echo "Access Denied!n";
exit;
};
if ($PHP_AUTH_PW != "mypassword") {
Header("WWW-Authenticate: Basic realm="xxxCOM 客戶認證"");
Header("HTTP/1.0 401 Unauthorized");
echo "Access Denied!n";
exit;
};
if ($activate) {
include("connect.inc");
$query1 = "UPDATE auth SET active='yes' where id='$id'";
$result1 = mysql_db_query("admin", $query1);
if ($result1) {
echo "n";
echo "$user activatedn";
echo "
n返回\n";
echo "n";
exit;
} else {
echo "n";
echo "Error: Unknown Errorn";
echo "
n返回\n";
echo "n";
exit;
}
}
if ($deactivate) {
include("connect.inc");
$query2 = "UPDATE auth SET active='no' where id='$id'";
$result2 = mysql_db_query("admin", $query2);
if ($result2) {
echo "n";
echo "$user deactivatedn";
echo "
n返回\n";
echo "n";
exit;
} else {
echo "n";
echo "Error: Unknown Errorn";
echo "
n返回\n";
echo "n";
exit;
}
}
if ($delete) {
include("connect.inc");
$query3 = "delete from auth where id='$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: Unknown Errorn";
echo "
n返回\n";
echo "n";
exit;
}
}
echo "n";
echo "n";
echo "使用者管理n";
echo "n";
echo "n";
echo "

\n";
echo "



















n"; echo " n"; include("connect.inc"); $query = "SELECT * FROM auth"; $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 " n"; } elseif ($activated == "no") { echo " n"; } } } mysql_free_result($result); echo "

Username	Real Name	Activated
$username	$lastname, $firstname	$activated	Deactivate	Delete
$username	$lastname, $firstname	$activated	Activate	Delete

\n";
echo "\n";
echo "\n";
?>
-- usermanage.php 結束--

http://www.bkjia.com/PHPjc/318061.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/318061.htmlTechArticle--beginauth.inc-- ?php $id="xxxCOM"; if(!isset($PHP_AUTH_USER)){ Header("WWW-Authenticate:Basicrealm="$id""); Header("HTTP/1.0401Unauthorized"); require('error.inc'); exit; } $name...

