Checking username(upper and lower)

[analyzer]

I was trying to check username in my login form that when someone puts username which is not exactly the same with the registered username, he/she will fail to login. Example. . Registered username is tEst and password is test, when someone tried to log in using "test" as username it will not log in because letter "e" must be "E". So it should be "tEst". How will i'am going to verify that?

[ionutvmi]

check with phpmyadmin if the Collation of your username column is latin1_swedish_ci
alternatively you could use strtolower() on your login page

[analyzer]

The collation is latin1_swedish_ci but still doesn't work. I check it in my sql using, WHERE username='".$username."'

[GumSlone]

The collation is latin1_swedish_ci but still doesn't work. I check it in my sql using, WHERE username='".$username."'

WHERE username LIKE '{$username}' 

[analyzer]

I'll try it bro, thanks!

[CreativityKills]

use character encoding utf8_general_ci, and make sure your username column is a UNIQUE key

[arevel]

try strtolower($username);

[Ghost]

try strtolower($username);

this makes all characters lowercase. but the original poster wants to check for case "insensitive" characters.
so the user is able to use both upper and lower case at same time.

[$XTREME$]

$xtreme = strtolower ( $username );

and get ur sql output with strtolower , then it ll be ,k . Hmm

[Vayne]

WHERE username LIKE '{$username}' 

thats a nice server killer. and what if there`s about 1kk users + every second one of them (or more) tries to login?

[nimeshka]

Hai bro, there is a function in PHP to compare the case of two strings..use strcmp();

$str1 = "TesT";
$str2 = "Test";

$true = strcmp($str1,$str2);

if($true==0){
echo "Two strings are identical";

} else {

echo "Two strings are not identical";

} 

Note : strcmp(); returns 0 if the two are identical in case. if not it will return greater than or less than 0 depending on the condition

hope this will solve your problem.

[nimeshka]

Hmmm I Cant Understand

What you do not understand??

[arnage]

Hai bro, there is a function in PHP to compare the case of two strings..use strcmp();

$str1 = "TesT";
$str2 = "Test";

$true = strcmp($str1,$str2);

if($true==0){
echo "Two strings are identical";

} else {

echo "Two strings are not identical";

} 

Note : strcmp(); returns 0 if the two are identical in case. if not it will return greater than or less than 0 depending on the condition

hope this will solve your problem.

strcmp() is case sensitive, strcasecmp() is case insensitive.

[nimeshka]

strcmp() is case sensitive, strcasecmp() is case insensitive.

So isn't that what he wanted????

[arnage]

Yep, i didn't read it right, i thought that he wants vice versa.

Here is another way.

$query = mysql_query('SELECT * FROM `users` WHERE MATCH(users) AGAINST("'.$login.'" IN BOOLEAN MODE)');