Khóa học miễn phí PHP & MongoDB – Sorting Records nhận dự án làm có lương

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.

Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc