Detailed explanation of how php7 implements MongoDB fuzzy query

*文
Release: 2023-03-19 07:08:01
Original
2835 people have browsed it

How to implement MongoDB fuzzy query in php7? I believe that the MongoDB fuzzy query statement is familiar to everyone. This article mainly introduces the method of implementing fuzzy query in MongoDB in PHP 7. The article gives a detailed introduction and sample code, which has certain reference and learning value for everyone. I hope to be helpful.

Preface

In actual development, there are many scenarios where fuzzy query needs to be used. MongoDB shell fuzzy query is very simple:

db.collection.find({'_id': /^5101/})
Copy after login

The above sentence is the content of query_id starting with '5101'.

Fuzzy query is quite simple in the old MogoDB. Here is a brief record of the operation method of fuzzy query:

Under the command line:

db.letv_logs.find({"ctime":/uname?/i});
Copy after login

php operation

$query=array("name"=>new MongoRegex("/.*”.$name.".*/i"));
$db->find($query);
Copy after login

The following mainly talks about how to query in the new PHP driver:

$query = new \MongoDB\Driver\Query('_id' => ['$regex' => '^5101']);
$this->getManager()->executeQuery($this->dbname . $this->collection, $query);
Copy after login

The above is the implementation of fuzzy query in the new driver. To be honest, I really complain about this new driver. Compared with the old driver, the function name is too long. . . It’s almost more than Swift’s function names. Moreover, many functions of the old driver have been removed from the new driver. Although a mongodb php library class library is provided for operation, there are more than 60 files in this library, sometimes more than my project files. What's wrong with this. I recommend encapsulating a Driver class yourself for use.

The above complaint is a bit off topic. In addition to direct fuzzy query, when using it with $in or $nin, you need to pay special attention to:

$filter = ['_id' => ['$in' => ['$regex' => '^5101']]];
Copy after login

If you write the filter as above, a fatal error will be thrown during execution:

PHP Fatal error: Uncaught MongoDB\Driver\Exception\ConnectionException: $in needs an array in filename
Copy after login

It says that $in needs to provide a Array, then we change the above $filter and give it an array:

$filter = ['_id' => ['$in' => [['$regex' => '^5101']]];
Copy after login

But unfortunately, we still cannot successfully get the desired result:

PHP Fatal error: Uncaught MongoDB\Driver\Exception\ConnectionException: cannot nest $ under $in in filename
Copy after login

It says $ cannot appear in $in, so what should I do? In fact, to use fuzzy matching in $in or $nin, you need to use an instance of the \MongoDB\BSON\Regex class:

$filter = ['_id' => ['$in' => [new \MongoDB\BSON\Regex('^5101','i')]]];
Copy after login

This time we finally got the results we wanted.

Related recommendations:

php implements Mongodb custom generation of self-increasing ID

MongoDB View execution plan

How to use MongoDB index

The above is the detailed content of Detailed explanation of how php7 implements MongoDB fuzzy query. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template