[SOLVED] Preserve Username formatting

[Bendude14]

What i would like to achieve is that if someone registers on my site with the username Ryan then they will still be able to login even if they try to login with the username RYAN or RaYn etc.

 

I know i could use strtolower, but towards the top of the page where it displays the current user's name i would like it to display in the same format as it was when they registered. so if they registered as ryaN it would always say ryaN even if they logged in using RYAN or Ryan.

 

just a pointer in the right direction would be great

 

Thanks

Ben

 

 

[samshel]

Store the username as it is, just while checking convert it to lowercase

 

"SELECT * from `user` WHERE LOWER(`username`) = '".strtolower($username)."'"

 

 

[Bendude14]

Thanks ill give it a try

[Bendude14]

That does not seem to let people login if you put all capital letters to login or a variant from what was entered into the DB

 

I was using this before

 

<?php

$sql = "SELECT pwd FROM users WHERE username = '$username'";
?>

And i changed it to this after looking at your code

 

<?php
$sql = "SELECT pwd FROM users WHERE LOWER ('username') = '".strtolower($username)."'";
?>

[samshel]

<?php
$sql = "SELECT pwd FROM users WHERE LOWER (`username`) = '".strtolower($username)."'";
?>

 

Field names should not be in single quotes, surroung them with bck ticks..try and let me know

[Wolphie]

I've never had any problem writing and retreiving data from the database in any character case. Have you tried just writing a value to the database using different cases throughout and then tried validating it using lower case / upper case?

 

<?php
$sql = "SELECT pwd FROM users WHERE LOWER (`username`) = '".strtolower($username)."'";
?>

 

Field names should not be in single quotes, surroung them with bck ticks..try and let me know

 

A back tick is just another form of a quote, it doesn't matter what you surround them in, it's strictly for clarity and easy reading.

[MadTechie]

What i would like to achieve is that if someone registers on my site with the username Ryan then they will still be able to login even if they try to login with the username RYAN or RaYn etc.

when they login and you confirm their password also pull back their name.. and use the for formatting from that.. as it sounds like your using the name they entered during login..

 

$username = "RyAn";
$sql = "SELECT username, pwd FROM users WHERE username = '$username'";
$username = $row['username'];

should be fine

[samshel]

m not sure...in a query data surrounded in a single quote would be treated as a string...

 

select 'username' from user;

 

will return the string 'username'

 

where as

 

select `username` from user;

 

will return the actual value of the column

 

Bendude14 , please try query which i posted earlier.

 

hope it is clear...

[MadTechie]

A back tick is just another form of a quote, it doesn't matter what you surround them in, it's strictly for clarity and easy reading.

Wrong...

quotes are for strings, back ticks are for quoting identifiers, ie fields/ tables etc..

 

so samshel is correct.

[Bendude14]

Ok first of all i tried this from samshel but i get the error message that Function LOWER does no exist.

 

<?php
<?php
$sql = "SELECT pwd FROM users WHERE LOWER (`username`) = '".strtolower($username)."'";
?>

?>

 

so i tried

 

<?php
$username = "RyAn";
$sql = "SELECT username, pwd FROM users WHERE username = '$username'";
$username = $row['username'];
?>

 

And what happens here is that you can only login if the username is typed exactly as it was on first login.

 

Thanks for all the help so far

[MadTechie]

erm.. LOWER does exist!

 

try this..

<?php
$username = "RyAn";

$sql = "SELECT username, pwd FROM users WHERE LOWER(username) = LOWER('$username')";
$username = $row['username'];
?>

[Bendude14]

erm.. LOWER does exist!

 

LOL so it does ...

 

Thanks everything works fine now.

 

Great help MadTechie and Samshel