|
|
<?php
require ("auth.php");
if(!isset($PHP_AUTH_USER)) {
Header("WWW-Authenticate: Basic realm=\"User Login\"");
Header( "HTTP/1.0 401 Unauthorized");
echo "You failed to provide the correct password....\n";
exit;
}
else {
$con = mysql_pconnect ("$host", "$user", "$pass") or die("Error: " . mysql_error());
mysql_select_db ("$db");
$user_id = strtolower($PHP_AUTH_USER);
$result = mysql_query("SELECT password FROM signup " . "Where username = '$user_id'");
$row = mysql_fetch_array($result);
if ($PHP_AUTH_PW != $row["password"]) {
Header( "WWW-Authenticate: Basic realm=\"Login failed please try again!\"");
Header( "HTTP/1.0 401 Unauthorized");
echo "You failed to provide the correct password....\n";
exit;
}
}
?>
Make a simple php file called auth.php with the variables $host $user $pass $db to connect
to your MySQL server.
The is a table called signup and a field named username & password.
Please comment on this is it helps you.
John |
|
| complete, simple, working example of a login screen/system using php functions, cookies, and a mysql database for begginers. Categories : Authentication, Complete Programs, PHP, MySQL, Databases | | | Full membership authentication system. Categories : Authentication, MySQL, PHP, Databases | | | Authorize Me! An authentication script. Categories : MySQL, Databases, Authentication, PHP | | | Implementing a Members ONLY area Categories : PHP, MySQL, Databases, Authentication | | | SQL / PHP based Integrated Authentication Categories : PHP, Authentication, Databases, MySQL | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | How to thread a list of messages in database
and show it in a treelike structure Categories : PHP, MySQL, Databases | | | Simple function to return the number of days in a time span between 2 given dates. Categories : PHP, Date Time, MySQL, Databases | | | mediaCat-GTK v2.0.0 - an mp3/cd/dvd cataloging utility written in php-gtk which interfaces with mysql and ms access (or db supported by PHP's Unified ODBC Functions) Categories : PHP, MySQL, MS Access, Utilities, Databases | | | Checks Date-Input from HTML-Forms and converts to YYYY-MM-DD Format for MySQL Date-Fields Categories : MySQL, Date Time, PHP, Databases | | | [PHP5] aDB PDO LIKE Database Abstraction. Switch easily from one db server to another, strong errors management, manage transactions, queries preparation and more. Categories : PHP, PHP Classes, Databases, MS SQL Server, MySQL | | | php-gtk mysql querying tool Categories : PHP-GTK, MySQL, PHP, Databases | | | Password reminder Categories : PHP, PHP Classes, Databases, MySQL, Mail | | | MySQL Connection/Query Class Categories : Databases, MySQL, PHP, PHP Classes | |
| |
| | | | | norman volmer wrote : 486
The following case is not handled:
A username is entered, but password field is left blank. The username does not exist in db, so the query is empty, what matches the empty password! $row["pass"] must be checked not to be empty!
| | | | Richard Mike wrote : 561
try this
(($PHP_AUTH_PW != $row["password"]) || (!$PHP_AUTH_PW))
| | | | Artem Polyvianiy wrote :775
This is trivial.
What you can really need is a full session handling class with MySQL table of currently logged people.
| |
|
|