在mongodb中为php中的用户名发现不区分大小写

Question

I am trying to find a way to query mongodb in a case insensitive way using PHP because currently when checking a user "Username" and "username" can both be diffrent usernames...

$cursor = $collection->findOne(array('username' => /{$_POST['value']}/i));
$lowerInput = strtolower($_POST['value']);
$username = strtolower($cursor['username']);
if($lowerInput == $username){
    echo "That username appears to be in our database!";
}

I tried this but the cursor only looks for a case sensitive match so it will only lowercase the cursor value if it has one.

Answer 1

PHP Mongo driver has an internal Regex Object:

$cursor = $collection->findOne(
  array('username' => new MongoRegex("/$_POST['value']/i")
);

And btw I strongly recommand to check $_POST value and probably transform you regex to get only username (without more before/after => new MongoRegex('/^' . $securevalue . '$/i')

Edit: my answer wasn't precise: starting anchor allow mongo to use index on this query, if available.