PHP & MongoDB – Sorting 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 select record(s) in the collection and pass it filters and options to sort the records.
$filter = [];
// Sort in Descending Order, For ascending order pass 1
$options = [''sort'' => [''First_Name'' => -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'' => 3, ''sort'' => [''First_Name'' => -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. First Name: Rachel, Last Name: Christopher. First Name: Fathima, Last Name: Sheik.
