Home  >  Article  >  Backend Development  >  Introduction to the use of MongoDB Driver in PHP7

Introduction to the use of MongoDB Driver in PHP7

不言
不言Original
2018-07-05 14:29:224957browse

This article mainly introduces the use of MongoDB Driver in PHP7. It has certain reference value. Now I share it with you. Friends in need can refer to it.

php7 can only use Mongodb driver to drive mongodb.

Use Mongodb Driver to connect to the database

I refused when I first started using Mongodb Driver. When I looked at the official documentation, I only saw a row of classes and unintelligible member methods. After browsing for a long time, I couldn't find keywords such as find, update, delete, etc., and even slightly more complicated ones such as replica sets and user authentication were not known. How to connect to the database.
Fortunately, the documentation is not completely lacking. Click on Mongodb\Driver\Manger::constructor and see several construction parameters

  • $uri in the shape of mongo://[host:port,host:port,host:port]/[dbname]?[username=aa&password=bb&replicaSet=cc]

  • ## $uriOptions is the string of parameters after ? above, which can be written here

  • $driverOptions Other options such as the default read and write parameters

MongodbDriver CURD operation

This is where I initially thought this driver was anti-human. There are no words like find, update, delete, etc. in the document, only one

Command class and a Query class. The Query class is slightly better and provides some query options.
In fact, all operations on the Mongo database can be performed through the Command class. The PHP driver documentation does not introduce the specific
commandOptions. It is precisely because I am new to mongodb that I feel that this driver is extremely weird and anti-human, and there is no way to start with it.

The key to us using this driver is to use the Command class to construct a commandOption
and this commandOption requires us to obtain it from the official mongodb Learn about MONGODB MANUAL - Database Commands
in the document. All operations, data addition, deletion, modification and query, aggregation sorting, database status, user authentication, etc. can be done through these commands. Here are a few examples

  • Connecting to the database

  • $this->_conn = new MongoDB\Driver\Manager('mongodb://localhost:27017/test');
    $this->_db = 'test';
    // execute command.
    function exec($opts) {
        $cmd = new MongoDB\Driver\Command($opts);
        $res =  $this->_conn->executeCommand($this->_db, $cmd);
        return $res->toArray();
    }
  • Conditional query, return on demand

  • $cmd = [
        'find' => 'table', // collection表名
        'filter' => ['_id' => ['$gte' => 10, '$lt' => 20]],
        'projection' => ['name' => 1, 'email' => 1]
    ];
    $res = $this-exec($cmd);
  • Modify records

  • $cmd = [
        'update' => 'table', // collection 表名
        'updates' => [
            ['q' => [_id => ['$lt' => 10]], 'u' => ['status' => 0], 'upsert'=>0,'multi'=>1],
            ['q' => [_id => ['$gte' => 10]], 'u' => ['status' => 1], 'upsert'=>0,'multi'=>1],
        ],
        'ordered' => 1, // 是否依次执行updates语句,true表示执行失败后继续后面的语句,false 表示一旦失败立即返回
    ]
  • Delete records,

    limit can only be 1 or 0!

  • $cmd = [
        'delete' => 'table', // collection 表名
        'deletes' => [
            ['q' => [_id => ['$lt' => 5]], 'limit' => 0], // 0表示所有,1表示删除1行
        ]
    ]
  • Insert data

  • $cmd = [
        'delete' => 'table', // collection 表名
        'deletes' => [
            ['q' => [_id => ['$lt' => 5]], 'limit' => 0], // 0表示所有,1表示删除1行
        ]
    ]
  • Group, sort

  • $cmd = [
        'aggregate' => 'table', // collection 表名
        'pipeline' => [
            '$group' => 'class',
            '$sort' => 'score'
        ]
    ]
  • Read database status

  • $cmd = [
        'replSetGetStatus' => 1,
    ]
Auxiliary class BSON

The most useful one is of course

MongoDB\BSON\Javascript and MongoDB\BSON\ObjectId respectively pass in the javascript script function and use the objectid of mongodb.

Exception

All exceptions generated by MongoDBDriver can be captured using

MongoDB\Driver\Exception\Exception

The above is the entire content of this article, I hope It will be helpful for everyone’s learning. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

PHP uses Azure Storage Blob to upload files

imagettfbbox and imagettftext text and images in php automatically wrap method

The above is the detailed content of Introduction to the use of MongoDB Driver in PHP7. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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