login system & higher/lower case letters

[djdaz]

Hey

Making a website that requires people to signup and login to access some of the content. However im having a problem with capital letters.

Imagine someone signs up as DjDaZ

When they come to login they can use djdaz, DjDaZ DJDAz or whatever as there username. How can i get it to make sure the correct case is used?

[cahva]

Check out strcmp(). That should answer to your question..

[djdaz]

had a look at the suggested strcmp() but it only confused me.

😕

Is there a way to do this in the MySQL statement?
I've attached a sample script i threw together to test this.

<?php 
include($_SERVER['DOCUMENT_ROOT'].'/includes/dbconnect.php'); 

$username="djDAZ"; 

$result = mysql_query("SELECT * FROM users WHERE username='$username'"); 

if( mysql_num_rows($result) > 0 ) 
{ 
    $data = mysql_fetch_array($result); 

echo $data['email']; 
} 
?> 

Thanks

[Gornakle]

If you convert both the database row and the input to lowercase, you can compare them. 🙂
Example using your script:

<?php  

include($_SERVER['DOCUMENT_ROOT'].'/includes/dbconnect.php');  

$username = strtolower("djDAZ");  

$result = mysql_query("SELECT * FROM users WHERE LOWER(username)='$username'");  

if( mysql_num_rows($result) > 0 )  

{  

    $data = mysql_fetch_array($result);  

echo $data['email'];  
}  

?>  

[cahva]

Yeah but if he really wants to have option to use lower and uppercase then that wont work 🙂

[cahva]

Oh.. And if you want to compare straight in mysql, use LIKE with BINARY:

$result = mysql_query("SELECT * FROM users WHERE username LIKE BINARY '$username'");  

[onion2k]

Originally posted by cahva
Oh.. And if you want to compare straight in mysql, use LIKE with BINARY:

$result = mysql_query("SELECT * FROM users WHERE username LIKE BINARY '$username'");  

[/B]

Thats a joke, right? I hope thats a joke..

[cahva]

Thats a joke, right? I hope thats a joke..

O_o? Whats wrong with that? If you want case-sensitive search, then thats the correct syntax.

[cahva]

Offcourse you can use it without LIKE:

$result = mysql_query("SELECT * FROM users WHERE BINARY username='$username'");