//=====For MySQL Database=====//
if (isset($_POST['login']))
{
$Link = MySQL_Connect($DBHost, $DBUser, $DBPassword) or die ("Unable to connect to mySQL database");
MySQL_Select_Db($DBName, $Link) or die ("Database ".$DBName." does not exists.");
$Login = $_POST['login'];
$Pass = $_POST['passwd'];
$Repass = $_POST['repasswd'];
$Email = $_POST['email'];
$Login = StrToLower(Trim($Login));
$Pass = StrToLower(Trim($Pass));
$Repass = StrToLower(Trim($Repass));
$Email = Trim($Email);
if (empty($Login) || empty($Pass) || empty($Repass) || empty($Email))
{
echo "All fields are empty.";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Login, $Txt))
{
echo "Username is incorrect.";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Pass, $Txt))
{
echo "Please enter the password.";
}
elseif (ereg("[^0-9a-zA-Z_-]", $Repass, $Txt))
{
echo "Make sure the password is correct.";
}
elseif (StrPos('\'', $Email))
{
echo "Email is incorrect.";
}
else
{
$Result = MySQL_Query("SELECT name FROM users WHERE name='$Login'") or ("Can't execute query.");
if (MySQL_Num_Rows($Result))
{
echo "The username
".$Login." already exists.";
}
elseif ((StrLen($Login) < 4) or (StrLen($Login) > 20))
{
echo "The username must be greater than 4 and less than 20. Please re-enter.";
}
elseif ((StrLen($Pass) < 4) or (StrLen($Pass) > 20))
{
echo "The password must be greater than 4 and less than 20. Please re-enter.";
}
elseif ((StrLen($Repass) < 4) or (StrLen($Repass) > 20))
{
echo "The confirmation password must be greater than 4 and less than 20. Please re-enter.";
}
elseif ((StrLen($Email) < 4) or (StrLen($Email) > 25))
{
echo "The email address must be greater than 4 and less than 25. Please re-enter.";
}
elseif ($Pass != $Repass)
{
echo "Passwords do no match.";
}
else
{
$Salt = $Login.$Pass;
$Salt = md5($Salt);
$Salt = "0x".$Salt;
MySQL_Query("call adduser('$Login', $Salt, '0', '0', '0', '0', '$Email', '0', '0', '0', '0', '0', '0', '0', '', '', $Salt)") or die ("Can't execute query.");
echo "User
".$Login." has registered successfully.";
}
}
}
?>
If you wish to change your password click here.