PHP & MongoDB – Limit Records
First step to do any operation is to create a Manager instance.
// Connect to MongoDB using Manager Instance $manager = new MongoDBDriverManager("mongodb://localhost:27017");
Second step is to prepare and execute a Query object to record(s) in the collection and pass it filters and options to limit search results.
$filter = []; $options = [''limit'' => 1]; // Create a Query Object $query = new MongoDBDriverQuery($filter, $options); // Execute the query $rows = $manager->executeQuery("testdb.sampleCollection", $query);
Example
Try the following example to limit search results in MongoDB server −
Copy and paste the following example as mongodb_example.php −
<?php try { // connect to mongodb $manager = new MongoDBDriverManager("mongodb://localhost:27017"); $filter = []; $options = [''limit'' => 1]; // Create a Query Object $query = new MongoDBDriverQuery($filter, $options); // Execute the query $rows = $manager->executeQuery("myDb.sampleCollection", $query); foreach ($rows as $row) { printf("First Name: %s, Last Name: %s.<br/>", $row->First_Name, $row->Last_Name); } } catch (MongoDBDriverExceptionException $e) { echo "Exception:", $e->getMessage(), "n"; } ?>
Output
Access the mongodb_example.php deployed on apache web server and verify the output.
First Name: Radhika, Last Name: Sharma.