文章詳情頁

PHP用戶認證及管理完全源碼

瀏覽：2日期：2023-12-31 13:28:20

-- 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') {;;?>;;<HTML><HEAD>;;<TITLE>404 Not Found</TITLE>;;</HEAD><BODY>;;<H1>Not Found</H1>;;The requested URL;;<? echo $REQUEST_URI; ?>;;was not found on this server.;;</BODY></HTML>;;<?php;;exit;;;};;?>;;-- end auth.inc --;;-- begin connect.inc --;;<?php mysql_connect("localhost", "user", ""); ?>;;-- 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 --;;<?php include("auth.inc"); ?>;;<?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<a href="$PHP_SELF">返回</a>n";;;echo "n";;;exit;;;} else {;;echo "n";;;echo "Error: Unknown Errorn";;;echo " n<a href="$PHP_SELF">返回</a>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<a href="$PHP_SELF">返回</a>n";;;echo "n";;;exit;;;} else {;;echo "n";;;echo "Error: Unknown Errorn";;;echo " n<a href="$PHP_SELF">返回</a>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<a href="$PHP_SELF">返回</a>n";;;echo "n";;;exit;;;} else {;;echo "n";;;echo "Error: Unknown Errorn";;;echo " n<a href="$PHP_SELF">返回</a>n";;;echo "n";;;exit;;;};;};;echo "<html>n";;;echo "<head>n";;;echo "<title>用戶管理</title>n";;;echo "</head>n";;;echo "<body>n";;;echo "<form method="post" action="$PHP_SELF">n";;;echo "<table border="1">n";;;echo "<tr><th>Username</th><th>Real Name</th><th>Activated</th></tr>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 "<tr><td>$username</td><td>$lastname, $firstname</td><td>$activated</td><td><a href="$PHP_SELF?deactivate=yes&id=$id&user=$username">Deactivate</a></td><td><a href="$PHP_SELF?delete=yes&id=$id">Delete</a></td></tr>n";;;} elseif ($activated == "no") {;;echo "<tr><td>$username</td><td>$lastname, $firstname</td><td>$activated</td><td><a href="$PHP_SELF?activate=yes&id=$id">Activate</a></td><td><a href="$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 結束--;;

PHP

上一條：用PHP制作的意見反饋表下一條：如何用php作線形圖的函數

排行榜

					
					基于javaweb+jsp實現學生宿舍管理系統
多級聯動下拉選擇框，動態獲取下一級
如何封裝一個Ajax函數
ASP.NET MVC實現樹形導航菜單
PHP擴展之URL編碼、解碼及解析——URLs
Django模板之基本的 for 循環 和 List內容的顯示方式
Laravel Eloquent ORM高級部分解析
jsp response.sendRedirect()用法詳解
Java 接口和抽象類的區別詳解
Spring security 自定義過濾器實現Json參數傳遞并兼容表單參數(實例代碼)
Ajax常用封裝庫——Axios的使用
				