[dsflyerds]

I'm working on a log in page for my website and i was wondering if there Is a way to make the username part work for both upper and lower case, for example if my username were robert if you entered Robert or ROBERT it would work as well?

[Nico]

Yes, there is a way.

But it's hard to tell how without knowing what you're doing. Could you post your code?

[alxkls]

when inserting a user into the database you could do something like

Code:

$sql="insert into my_users_table (user_field, whatever, whatever) values ('".strtolower($_POST['some_user'])."', 'whatever', 'whatever')";

and each time you are making a query-use strtolower.

[Nico]

No, that's actually not necessary.

SELECT queries are case-insensitive, so it doesn't matter if the stored names are in lower or upper case when you fetch the name from the database.

Plus, some users might prefer to have capital letters in their monickers.

I suspect that the OP is actually authenticating their users without MySQL, that's why I asked for the code. The user data could be stored in an array, or in a flat file, etc...

[alxkls]

Incorrect! The queries you use might be case-insensitive but that is not always the case depending on your encoding and alphabet/symbols you are using. Take the cyrillic alphabet for example:

Code:

ч, ш, щ, я, ю

or in queens english-the letters that do not have a latin equivallent. actually the first time i encountered this was last year and it took me quite a while to work it out... And as far as I remember from my days(years rather) in spain-there was a similar problem with letters such as

Code:

á, é, í, ó, ú, ñ

Still-im not sure cause as i said-thats as far as i remember. Still surely thats far not the end of it.

That is of course if he is using any type of database. if he is storing those values in some array-thats a whole different story.

[Host.co.in]

IMO it's all about the data fetched from the log in text-box and while making comparison with the data stored in the database should be kept case sensitive or not. One need to think in that direction only.

[Nico]

Originally Posted by alxkls

Incorrect! The queries you use might be case-insensitive but that is not always the case depending on your encoding and alphabet/symbols you are using.

Well, strtolower() won't convert those either.

[alxkls]

true... forgot about that... my solution in this case was

Code:

function cyrtolower($str) {
	return strtr($str,
	"ABCDEFGHIJKLMNOPQRSTUVWXYZ".
	"АБВГДЕЖЗИЙКЛОМНОПРСТУФХЦЧШЩЬЪЮЯЭЫ",
	"abcdefghijklmnopqrstuvwxyz".
	"абвгдежзийкломнопрстуфхцчшщьъюяэы");
}