case sensitive login

Discussion in 'PHP' started by nagar, Jul 13, 2007.

  1. #1
    Hi,

    I would like to put a case sensitive login,please could you help me?

    Thx
     
    nagar, Jul 13, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    Are you using a database?

    If so, compare the pulled username or password with the given one. MySQL searches are case-insensitive by default. You could do something like:

    
    
    $query = mysql_query("
        SELECT *
        FROM users
        WHERE
            username = '". mysql_real_escape_string($_POST['username']) ."' AND
            password = '". mysql_real_escape_string($_POST['password']) ."'
        LIMIT
            1
    ") OR die(mysql_error());
    
    if ($userinfo = mysql_fetch_array($query))
    {
        if ($userinfo['username'] == $_POST['username'] AND
            $userinfo['password'] == $_POST['password']
        )
        {
             // Correct login
        }
    }
    
    // Incorrect login
    
    PHP:
     
    nico_swd, Jul 13, 2007 IP