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