Share your experience using PHP7 MongoDB Driver

This article is written by the PHP7 tutorial column to share with you the experience of using the PHP7 MongoDB Driver. I hope it will be helpful to friends in need!

#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 form of mongo: //[host:port,host:port,host:port]/[dbname]?[username=aa&password=bb&replicaSet=cc]
• ##$uriOptions is above? Behind The string of parameters can be written here
• $driverOptions Other options such as the default read and write parameters

MongodbDriver CURD operation

This is where I initially felt that this driver was anti-human. There were no words such as find, update, delete, etc. in the document. There was only a

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 as needed

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

Modify Record

• $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 record,
• 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行
      ]
  ]

Grouping, sorting

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

Reading database status

• $cmd = [
      'replSetGetStatus' => 1,
  ]

Auxiliary class BSON

The most useful ones are of course

MongoDB\BSON\Javascript and MongoDB\BSON\ObjectId , respectively passing in the javascript script function and using the objectid of mongodb.

Exception

All exceptions generated by MongoDBDriver can be captured using

MongoDB\Driver\Exception\Exception

The above is the detailed content of Share your experience using PHP7 MongoDB Driver. For more information, please follow other related articles on the PHP Chinese website!