|
|
|
<?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 |
|
| Authorize Me! An authentication script.
Categories : MySQL, Databases, Authentication, PHP | | | Full membership authentication system.
Categories : Authentication, MySQL, PHP, Databases | | | 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 | | | Implementing a "Members ONLY" area
Categories : PHP, MySQL, Databases, Authentication | | | 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 | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Displaying records of database in more than one page (paging)
Categories : Databases, MySQL, PHP | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | Email a user with out exposing email address
Categories : PHP, Databases, MySQL, Email | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | |
| | | | 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.
| |
|
|
|
