|
|
|
<?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 |
|
| bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Authorize Me! An authentication script.
Categories : MySQL, Databases, Authentication, PHP | | | 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 | | | SQL / PHP based Integrated Authentication
Categories : PHP, Authentication, Databases, MySQL | | | Implementing a "Members ONLY" area
Categories : PHP, MySQL, Databases, Authentication | | | 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 | | | PHP-CSL PHP Code Snippet Library, A very handy application designed to save you many hours by storing all your code snippets, classes and functions.
Categories : PHP, Utilities, MySQL, Databases, To PHP | | | phpMyAdmin is intended to handle the adminstration of MySQL
over the web.
Categories : Databases, MySQL, Complete Programs, PHP | | | Record Set Paging with PHP (RSP)
Categories : PHP, MySQL, Navigation, Databases, HTML and PHP | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | Database resultset navigation
Categories : PHP, HTML and PHP, Databases, MySQL, Navigation | | | Is there some possibility to link a database to an htaccess file, so that instead of having a passwd file you would have a database with DES-crypted password and username fields?
Categories : Authentication, PHP, General SQL, Databases | | | Function to do live population of HTML's <Select> tag from a Table
Categories : PHP, MySQL, HTML and PHP, Databases | | | This program will take data from a user via a web based form, validate it, show it
to the user for re-validation, and finally insert it into the database. Plenty of
sanity checking on the fields in the form.
Categories : MySQL, HTML and PHP, PHP, Complete Programs, Databases | |
| | | | 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.
| |
|
|
