PHP实现用户认证及管理完全源码

6年以前  |  阅读数:288 次  |  编程语言:PHP 

-- begin auth.inc --
<?php
$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.

\-- 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 \--** 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 "
UsernameReal NameActivated
$username$lastname, $firstname$activatedDeactivateDelete
$username$lastname, $firstname$activatedActivateDelete
\n"; echo "\n"; echo "\n"; ?> \-- usermanage.php 结束--
 相关文章:
PHP分页显示制作详细讲解
SSH 登录失败:Host key verification failed
将二进制数据转为16进制以便显示
获取IMSI
发送邮件
双位运算符
文件下载
贪吃蛇
年的日历图
获取IMEI
提取后缀名
PHP自定义函数获取搜索引擎来源关键字的方法
Java生成UUID
在Zeus Web Server中安装PHP语言支持
让你成为最历害的git提交人
Yii2汉字转拼音类的实例代码
再谈PHP中单双引号的区别详解
指定应用ID以获取对应的应用名称
php封装的page分页类完整实例
Python 2与Python 3版本和编码的对比