rugrat - 10:08 pm on Jun 17, 2012 (gmt 0)
I have a situation where a user clicks on a link in an email with an id at the end of the link which is also inserted into a mysql table(tmp). These 2 need to match and an email address in the same row needs to match the same address in table 1 where ultimately user inputed password must match against the password in table 1.
Things seem to be following what they should be doing until it comes to matching the password. If they match perfectly it tells you sometimes it tells you it's a match when not exact but close--I've noticed that when you change the characters at the end of the password string it has a tendency to match but not at the beginning of the string. If it makes any difference the input string is encrypted(perl encryption) in the same manner as the strings in the password field were encrypted before entry.
Here is basically what I have at this point...any ideas. Thank you.
$query="select table1.password,table1.email,tmp.email,tmp.uid from table1,tmp where binary table1.password = '$_' and table1.email = tmp.email and binary tmp.uid like'$_' limit 1";
($_) = $dbh->selectrow_array($query);
$_ represents the password typed in by the user and $_ is an id from a link.
The binary thing comes from Paul DuBois' Mysql book.