Jump to content


Photo

How do I make an authentication not case sensitive?


  • Please log in to reply
1 reply to this topic

#1 Infected-Waffle

Infected-Waffle
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 17 August 2006 - 04:33 AM

okay so I've got this login, but it requires me to put my username in exactly as it is in the database. This gets kind of tedious. How could I make it so that it will accept both upper and lower case?

Here's the code if it helps...

if($mode == 'login') {
			//login
			$username = $_POST['username'];
			$password = md5($_POST['password']);
			
			$query = 'SELECT name, password FROM users WHERE name = "'.$username.'"';
			$result = mysql_query($query);
			$row = @mysql_fetch_array($result, MYSQL_ASSOC);
			
			if($username == $row['name'] && $password == $row['password']) {
				$_SESSION['logged_in'] = $row['name'];
				header('location: index.php');
			} else {
				$content = 'Invalid Login credentials';
			}
			mysql_free_result($result);


#2 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 17 August 2006 - 04:35 AM

this would require some work but couldnt u just change all the letters to lower case b4 goin into db and then just change all letters to lower case when tring to match?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users