Here are 3 functions within my functions.php file.
function login_results()
{
// Convert to simple variables
$username = $_POST['username'];
$password = $_POST['password'];
if(($username == "") || ($password == "")){
$txt = "Please enter ALL of the information! <br />";
login_form( $txt, $username, $password );
exit();
}
// check if the user info validates the db
$sql = mysql_query("SELECT * FROM cms_users WHERE username='$username' AND password='$password'");
$login_check = mysql_num_rows($sql);
if($login_check > 0){
while($row = mysql_fetch_array($sql)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
// Register some session variables!
$_SESSION['username'] = $username;
$_SESSION['LoggedIn'] = 1;
mysql_query("UPDATE cms_users SET last_login=now() WHERE user_id='$user_id'");
}
} else {
$txt = "You could not be logged in! The username and password do not match<br />
Please try again!<br />";
login_form( $txt, $username, $password );
exit();
}
}
function number_of_members()
{
// Counting Number of Products Available:
$count = @mysql_query("SELECT * FROM cms_users");
$num_rows = mysql_num_rows($count);
// To display number of products:
echo "<b>Total Members: <font type=\"arial\", color=\"#0000CC\">$num_rows</font></b>";
}
function login_form( $txt= "", $username = "", $password = "" )
{
echo "
<form method=\"post\" action=\"?cmd=results\">\n
<p /><b>Username:</b>\n
<input type=\"text\" name=\"username\" size=\"20\" maxlength=\"20\">\n
<p /><b>Password:</b>\n
<input type=\"password\" name=\"password\" size=\"20\"
maxlength=\"20\"></p>\n
<center><font color=\"red\">$txt</font></center>
<input type=\"hidden\" name=\"cmd\" value=\"login_results\">
<input type=\"submit\" name=\"submit\" value=\"Login\"></p>\n
</form>\n\n";
}