Authentication

User / Pass System working with MySQL and PHP

Type:	code fragment
Added by:	smog
Entered:	02/03/2000
Last modified:	08/12/1999
Rating:	(54 votes)
Views:	60304

PHP and MySQL running together for username/password check.

<?

                             /* 

                            SQL to build sample database named 'your-database-here' 

                            CREATE TABLE user-password-table (

                              username varchar(12),

                              password varchar(12),

                            );

                            

                            INSERT INTO user-password-table  VALUES ('your-username-here','your-password-here');

                            */

                            

                            
 $username = "your-username-here";
 $password = "your-password-here";
 $database = "your-database-here";

                            
 $db = mysql_connect("localhost", "$username", "$password");
 mysql_select_db("$database",$db);
 $result = mysql_query("select count(username) as Total from user-password-table where username='$username' and password='$password'",$db);
 $row = mysql_fetch_array($result);

                            if ($row["Total"]=="0"):

                                    echo "<BODY bgcolor="#BFBFBF" link="Black" vlink="Black" alink="Black">";

                                    echo "<FONT FACE="Arial" COLOR="#FFFFFF"> ";

                                    echo "<CENTER><H1>WARNING:<P>USER/PASSWORD Failed!</H1></CENTER>";

                            else:

                                    echo "<BODY bgcolor="#BFBFBF" link="Black" vlink="Black" alink="Black">";

                                    echo "<FONT FACE="Arial" COLOR="#FFFFFF"> ";

                                    echo "<CENTER><H1>Welcome Back $username.</H1></CENTER>";

                            endif;
 mysql_close($db);
 ?>

Usage Example

Rate This Script

Zend - The PHP Company

Authentication

Search