|
用户认证及管理(完全版)(1)
用户认证及管理(完全版) 用户认证及管理(完全版) 作者:MAX 来源:奥索网 -- 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.<P> </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
|