Creating, Reading, Updating, and Deleting MongoDB Documents With PHP

1
<?php
2
3
$client = new MongoDB\Client(
4
   'mongodb+srv://<username>:<password>@<cluster-address>/test?w=majority'
5
);
6
$db = $client->test;

1
MDB_USER="yourusername"
2
MDB_PASS="yourpassword"
3
ATLAS_CLUSTER_SRV="mycluster.zbcul.mongodb.net"

1
$ composer require vlucas/phpdotenv

1
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
2
$dotenv->load();

1
echo $_ENV['MDB_USER'];

1
<?php
2
3
require_once __DIR__ . '/vendor/autoload.php';
4
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
5
$dotenv->load();
6
7
$client = new MongoDB\Client(
8
   'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/test'
9
);
10
11
$collection = $client->test->users;
12
13
$insertOneResult = $collection->insertOne([
14
   'username' => 'admin',
15
   'email' => 'admin@example.com',
16
   'name' => 'Admin User',
17
]);
18
19
printf("Inserted %d document(s)\n", $insertOneResult->getInsertedCount());
20
21
var_dump($insertOneResult->getInsertedId());

1
Inserted 1 document(s)
2
object(MongoDB\BSON\ObjectId)#11 (1) {
3
   ["oid"]=>
4
   string(24) "579a25921f417dd1e5518141"
5
}

1
<?php
2
3
require_once __DIR__ . '/vendor/autoload.php';
4
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
5
$dotenv->load();
6
7
$client = new MongoDB\Client(
8
   'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/test'
9
);
10
11
$collection = $client->test->users;
12
13
$insertManyResult = $collection->insertMany([
14
   [
15
      'username' => 'admin',
16
      'email' => 'admin@example.com',
17
      'name' => 'Admin User',
18
   ],
19
   [
20
      'username' => 'test',
21
      'email' => 'test@example.com',
22
      'name' => 'Test User',
23
   ],
24
]);
25
26
printf("Inserted %d document(s)\n", $insertManyResult->getInsertedCount());
27
28
var_dump($insertManyResult->getInsertedIds());

1
Inserted 2 document(s)
2
array(2) {
3
[0]=>
4
   object(MongoDB\BSON\ObjectId)#18 (1) {
5
      ["oid"]=>
6
      string(24) "6037b861301e1d502750e712"
7
   }
8
   [1]=>
9
   object(MongoDB\BSON\ObjectId)#21 (1) {
10
      ["oid"]=>
11
      string(24) "6037b861301e1d502750e713"
12
   }
13
}

1
function find($filter = [], array $options = []): MongoDB\Driver\Cursor

1
<?php
2
3
//
4
// This example uses data from the Sample Datasets in MongoDB Atlas
5
// To load, and use this sample data, see https://docs.atlas.mongodb.com/sample-data/available-sample-datasets/
6
//
7
8
require_once __DIR__ . '/vendor/autoload.php';
9
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
10
$dotenv->load();
11
12
$client = new MongoDB\Client(
13
   'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/sample_restaurants'
14
);
15
16
$collection = $client->sample_restaurants->restaurants;
17
18
$cursor = $collection->find(
19
   [
20
      'cuisine' => 'Italian',
21
      'borough' => 'Manhattan',
22
   ],
23
   [
24
      'limit' => 5,
25
      'projection' => [
26
            'name' => 1,
27
            'borough' => 1,
28
            'cuisine' => 1,
29
      ],
30
   ]
31
);
32
33
foreach ($cursor as $restaurant) {
34
   var_dump($restaurant);
35
};

1
object(MongoDB\Model\BSONDocument)#20 (1) {
2
["storage":"ArrayObject":private]=>
3
   array(4) {
4
      ["_id"]=>
5
      object(MongoDB\BSON\ObjectId)#26 (1) {
6
         ["oid"]=>
7
         string(24) "5eb3d668b31de5d588f42965"
8
      }
9
      ["borough"]=>
10
      string(9) "Manhattan"
11
      ["cuisine"]=>
12
      string(7) "Italian"
13
      ["name"]=>
14
      string(23) "Isle Of Capri Resturant"
15
   }
16
}
17
object(MongoDB\Model\BSONDocument)#19 (1) {
18
["storage":"ArrayObject":private]=>
19
   array(4) {
20
      ["_id"]=>
21
      object(MongoDB\BSON\ObjectId)#24 (1) {
22
         ["oid"]=>
23
         string(24) "5eb3d668b31de5d588f42974"
24
      }
25
      ["borough"]=>
26
      string(9) "Manhattan"
27
      ["cuisine"]=>
28
      string(7) "Italian"
29
      ["name"]=>
30
      string(18) "Marchis Restaurant"
31
   }
32
}
33
object(MongoDB\Model\BSONDocument)#26 (1) {
34
["storage":"ArrayObject":private]=>
35
   array(4) {
36
      ["_id"]=>
37
      object(MongoDB\BSON\ObjectId)#20 (1) {
38
         ["oid"]=>
39
         string(24) "5eb3d668b31de5d588f42988"
40
      }
41
      ["borough"]=>
42
      string(9) "Manhattan"
43
      ["cuisine"]=>
44
      string(7) "Italian"
45
      ["name"]=>
46
      string(19) "Forlinis Restaurant"
47
   }
48
}
49
object(MongoDB\Model\BSONDocument)#24 (1) {
50
["storage":"ArrayObject":private]=>
51
   array(4) {
52
      ["_id"]=>
53
      object(MongoDB\BSON\ObjectId)#19 (1) {
54
         ["oid"]=>
55
         string(24) "5eb3d668b31de5d588f4298c"
56
      }
57
      ["borough"]=>
58
      string(9) "Manhattan"
59
      ["cuisine"]=>
60
      string(7) "Italian"
61
      ["name"]=>
62
      string(22) "Angelo Of Mulberry St."
63
   }
64
}
65
object(MongoDB\Model\BSONDocument)#20 (1) {
66
["storage":"ArrayObject":private]=>
67
   array(4) {
68
      ["_id"]=>
69
      object(MongoDB\BSON\ObjectId)#26 (1) {
70
         ["oid"]=>
71
         string(24) "5eb3d668b31de5d588f42995"
72
      }
73
      ["borough"]=>
74
      string(9) "Manhattan"
75
      ["cuisine"]=>
76
      string(7) "Italian"
77
      ["name"]=>
78
      string(8) "Arturo'S"
79
   }
80
}

1
<?php
2
3
require_once __DIR__ . '/vendor/autoload.php';
4
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
5
$dotenv->load();
6
7
$client = new MongoDB\Client(
8
   'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/sample_restaurants'
9
);
10
11
$collection = $client->sample_restaurants->restaurants;
12
13
$updateResult = $collection->updateOne(
14
   [ 'restaurant_id' => '40356151' ],
15
   [ '$set' => [ 'name' => 'Brunos on Astoria' ]]
16
);
17
18
printf("Matched %d document(s)\n", $updateResult->getMatchedCount());
19
printf("Modified %d document(s)\n", $updateResult->getModifiedCount());

1
Matched 1 document(s)
2
Modified 1 document(s) 

1
<?php
2
3
require_once __DIR__ . '/vendor/autoload.php';
4
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
5
$dotenv->load();
6
7
$client = new MongoDB\Client(
8
   'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/sample_restaurants'
9
);
10
11
$collection = $client->sample_restaurants->restaurants;
12
13
$updateResult = $collection->updateMany(
14
   [ 'borough' => 'Queens' ],
15
   [ '$set' => [ 'active' => 'True' ]]
16
);
17
18
printf("Matched %d document(s)\n", $updateResult->getMatchedCount());
19
printf("Modified %d document(s)\n", $updateResult->getModifiedCount());

1
Matched 5656 document(s)
2
Modified 5656 document(s)

1
$collection = (new MongoDB\Client)->selectCollection('test', 'users', [
2
   'writeConcern' => new MongoDB\Driver\WriteConcern(1, 0, true),
3
]);
4
5
var_dump($collection->getWriteConcern());

1
<?php
2
3
//
4
// This example uses data from the Sample Datasets in MongoDB Atlas
5
// To load, and use this sample data, see https://docs.atlas.mongodb.com/sample-data/available-sample-datasets/
6
//
7
8
require_once __DIR__ . '/vendor/autoload.php';
9
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
10
$dotenv->load();
11
12
$client = new MongoDB\Client(
13
   'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/sample_restaurants'
14
);
15
16
$collection = $client->sample_restaurants->restaurants;
17
18
$deleteResult = $collection->deleteOne(['cuisine' => 'Hamburgers']); 
19
20
printf("Deleted %d document(s)\n", $deleteResult->getDeletedCount());

1
Deleted 1 document(s)

1
<?php
2
3
   //
4
   // This example uses data from the Sample Datasets in MongoDB Atlas
5
   // To load, and use this sample data, see https://docs.atlas.mongodb.com/sample-data/available-sample-datasets/
6
   //
7
8
   require_once __DIR__ . '/vendor/autoload.php';
9
   $dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
10
   $dotenv->load();
11
12
   $client = new MongoDB\Client(
13
      'mongodb+srv://'.$_ENV['MDB_USER'].':'.$_ENV['MDB_PASS'].'@'.$_ENV['ATLAS_CLUSTER_SRV'].'/sample_restaurants'
14
   );
15
16
   $collection = $client->sample_restaurants->restaurants;
17
   $deleteResult = $collection->deleteMany(['cuisine' => 'Hamburgers']);
18
19
   printf("Deleted %d document(s)\n", $deleteResult->getDeletedCount());