I have a php login page that match the user name and password from a table in mysql table.

user name and password values are in small caps in database table.

But when I try to login with uppercase (capital letters) it aslo allow me to login.

I want to make my login page case sensitive. what should I do ??

Saifi

if you post the bit where you do the checking , someone might be able to help you.

Zerone
www.chatbazaar.com

Hi, if you are only using lower case then it should not be a problem for you. Prepare a function and then just allow only the ASCII values or the alphabets in the lower case only.This would solve your problem.....


Malay
great_mehta85@yahoo.co.in

malay mehta

hi I have the following code........I have tried but failed to make login case sensitive.....( I do not want to use only lower case..I want to make login case sensitive)


<?php
session_start();
$errorMessage = '';
if (isset($_POST['txtUserId']) && isset($_POST['txtPassword'])) {

    $userId = $_POST['txtUserId'];

    $password = ($_POST['txtPassword']);
     require_once("db_fns.php");//mysql db and username info file
    db_connect();

    $sql = "SELECT *
            FROM adminuser
            WHERE username = '$userId' AND password = '$password'";

    $result = mysql_query($sql) or die('Query failed. ' . mysql_error());

    $row=mysql_fetch_array($result);
    $admin=$row['username'];
   // print $admin;
    if (mysql_num_rows($result) == 1) {

           $_SESSION['db_is_logged_in'] = true;

        $_SESSION['admin']=$admin;

        header('Location: main.php');
        exit;
    } else {
        $errorMessage = 'Sorry, wrong user id / password';

    }

}


But this make login without case sensitivity

saifi

Saifi