/*
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 "";
echo " ";
echo "WARNING:
USER/PASSWORD Failed!
else:
echo "";
echo " ";
echo "Welcome Back $username.
endif;
mysql_close($db);
?>