直接上代码:
1.mysql中创建数据表logins(假设在books数据库中创建表logins)
use books;//选择数据库
//创建表结构
create table logins(
id tinyint unsigned not null auto_increment,
username varchar(16) not null,
pswd varchar(32) not null,
primary key(id)
);
//插入记录。后面的md5码时通过对应的用户名值计算的,即:用户名和密码的值相同。
insert into logins(id,username,pswd) values
(1,"wjgilmore","26af87777b830b4f91a55d3d14992ce2"),
(2,"mwade","0e4ab1a5a6d8390f09e9a0f2d45aeb7f"),
(3,"jgennick","e6c0c6b8c7acdf85e36f23a2a068dd1f")
2.php代码
require_once("/usr/share/pear/Auth/HTTP.php");//根据实际的安装地址填写文件路径
$dblogin = array("dsn"=>"mysql://root:19**1*z@localhost/books",//root:mysql用户名 ; 19**1*z:表示mysql密码 ;books数据库名
"table"=>"logins",
"usernamecol"=>"username",
"passwordcol"=>"pswd",
"cryptType"=>"md5",
"db_fields"=>"*"
);
$auth = new Auth_HTTP("DB",$dblogin) or die("Can't connect1");
$auth->start();
$auth->setRealm("ok!");
$auth->setCancelText("Authentication credentials not accepted!");
if($auth->getAuth()){
echo "Welcome to the secret archive!";
}
注:Auth_HTTP类的使用需要安装auth_http组件。由于auth_http的安装依赖auth组建,所以要先安装auth组件,再安装auth_http。指令如下:
[root@meiki ~]# pear install -o auth_http