Интернет технологии -> PHP -> HTTP Установка защиты на страницу используя MySQL и PHP

Вступление

· *nix платформа (Linux, Unix, *BSD) · PHP 3.0.x или PHP 4.x · MySQL (любая версия)

mysql> create database members; 
mysql> create table users ( 
username varchar(25) NOT NULL, 
password varchar(15) NOT NULL, 
primary key (username), 
unique username (username) 
);

mysql> grant select on members.users 
to httpuser@localhost 
identified by 'MyPassword'; 

mysql> insert into users value('john_doe', 'eod_nhoj'); 

 

01 <?php 
02 
03 function access_denied() { 
04 echo "401 Unauthorized: The username / password combination you entered was invalid.n"; 
05 } 
06 
07 function auth_headers($title) { 
08 Header("WWW-Authenticate: Basic realm="$title""); 
09 Header("HTTP/1.0 401 Unauthorized"); 
10 } 
11 
12 if(!isset($PHP_AUTH_USER)) { 
13 auth_headers("My Protected Web Page"); 
14 access_denied(); 
15 exit; 
16 } 
17 else { 
18 
19 $hostname = "localhost"; 
20 $username = "httpuser"; 
21 $password = "MyPassword"; 
22 $database = "members"; 
23 
24 $query = "select username,password from users where username='$PHP_AUTH_USER' 
and password='$PHP_AUTH_PW'"; 
25 $link = mysql_connect($localhost, $username, $password) or die("Unable to connect 
to database server"); 
26 
27 if (mysql_num_rows(mysql_db_query($database, $query)) == 0) { 
28 auth_headers("My Protected Web Page"); 
29 access_denied(); 
30 exit; 
31 } 
32 
33 mysql_close($link); 
34 } 
35 ?> 

<?php require("user_auth.php"); ?> 

Источник: www.webscript.ru