Matching A Long String With PDO

Forum Moderators: open

Message Too Old, No Replies

Matching A Long String With PDO

match a long string with pdo

typomaniac

1:19 am on Jun 10, 2017 (gmt 0)

I can't get my statement to match a variable that comes through an email link. The same variable goes into a mysql column but I can't get the two of them to match(that is, "Doesn't Exist"). I've searched the internet and forums and have come up with no answers.

$mailcode = $_GET["mailcode"];
$count=$dbo->prepare("select * from table where mysqlcode=:mailcode");
   $count->bindParam(":mailcode",$mailcode,PDO::PARAM_STR,85);
   if($count->execute()){
   $row = $count->fetch(PDO::FETCH_LAZY);
   if($row){
   echo"Exists";
   }else{
   echo"Doesn't Exist";}
   }else{
   print_r($dbo->errorInfo()); 
   }

typomaniac

2:31 am on Jun 10, 2017 (gmt 0)

For what its worth: the reason for the long string is part of a password reset script. It is in the link as well as the database.

typomaniac

3:32 pm on Jun 11, 2017 (gmt 0)

Found the problem. The string was actually made up of 18 separate mini random strings and 17 time codings, it was a very unique code right down to the second. I copied the code out of the database and found a blank space about half way but was not showing in the string on the link in the email. Re-wrote the coding out for the variable and all is fine now though I'm still not sure what caused the gap. I'll look into that another time.