Php Programming Code Examples

Php > User Management Code Examples

User - Pass System working with MySQL and PHP



User - Pass System working with MySQL and PHP

<? 
/* 
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); 
?>