Login php help

[Mancent]

Hello

 

Say i register my username as Dragon123 And password As Fatbuss123

 

How do I make sure the username is spelled perfect and password is perfect before you can enter the new area

because the way it is now you can login with the username dragon123 and password fatbuss123

Or Dragon123 fatbuss123

Or dragon123 Fatbuss123

 

And both is right all is right but it needs to be wrong unless the username is

Dragon123

And the password is

Fatbuss123

 

If it has a cap it must be used.

How do I do that?

<?php
ob_start();
include "connect.php";



// Define $myusername and $mypassword 
$username=$_POST['username']; 
$password=$_POST['password']; 

// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$sql="SELECT * FROM accounts WHERE username='$username' and password='$password'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("username");
session_register("password"); 
echo "&msgText=Entrance Granted!\n";
}
else
{
echo "&msgText=Invalid Login!\n";
}
return false;
ob_end_flush();
?>

 

[Pikachu2000]

Usernames are typically not case-sensitive, just enforced as unique. Passwords should be hashed. Hashing the password forces case-sensitivity, since the hash result will be different.

[Mancent]

ya like encrypted passwords md5?

 

But if I had to check the username to match exactly as it is set in mysql

Dragon123 Fatbuss123

 

if I had to do this how whould I do it?