Couchbase Playground

Key Value Get
Query Rows
Query w/ Named Param
Query w/ Positional Param
Sub-Document Lookup
Sub-Document Mutate
Upsert
Search Query String
Next Steps

PHP - Query Rows

Basic N1QL query, with looping through each returned row.

Visit the docs to learn more about Handling Query Results in PHP.

To run this example, click the button in the top right corner of the code editor.

Code Editor

<?php
  $connectionString = "couchbase://127.0.0.1";
  $options = new \Couchbase\ClusterOptions();
  $options->credentials("username", "password");
  $cluster = new \Couchbase\Cluster($connectionString, $options);

  $bucket = $cluster->bucket("travel-sample");
  try {
    $result = $cluster->query('SELECT x.* FROM `travel-sample` x
                              WHERE x.`type`="hotel" AND x.name LIKE "%hotel%" LIMIT 10');

    foreach($result->rows() as $row) {
        print_r($row);
    }
  } catch (\Couchbase\BaseException $ex) {
      print("Exception $ex\n");
  }
?>

PHP - Query Rows

Code Editor

Output