<?php $client = \Doctrine\CouchDB\CouchDBClient::create(array('dbname' => 'doctrine_example')); // Create a database. $client->createDatabase($client->getDatabase()); // Create a new document. list($id, $rev) = $client->postDocument(array('foo' => 'bar')); // Update a existing document. This will increment the revision. list($id, $rev) = $client->putDocument(array('foo' => 'baz'), $id, $rev); // Fetch single document by id. $doc = $client->findDocument($id); // Fetch multiple documents at once. $docs = $client->findDocuments(array($id)); // Return all documents from database (_all_docs?include_docs=true). $allDocs = $client->allDocs(); // Delete a single document. $client->deleteDocument($id, $rev); // Delete a database. $client->deleteDatabase($client->getDatabase()); //Search documents using Mango Query CouchDB v2.x $selector = ['_id'=>['$gt'=>null]]; $options = ['limit'=>1,'skip'=>1,'use_index'=>['_design/doc','index'],'sort'=>[['_id'=>'desc']]]; $query = new \Doctrine\CouchDB\Mango\MangoQuery($selector,$options); $docs = $client->find($query); $query = new \Doctrine\CouchDB\Mango\MangoQuery(); $query->select(['_id', 'name'])->where(['$and'=> [ [ 'name'=> [ '$eq'=> 'Under the Dome', ], 'genres'=> [ '$in'=> ['Drama','Comedy'], ], ], ])->sort([['_id'=>'desc']])->limit(1)->skip(1)->use_index(['_design/doc','index']); $docs = $client->find($query);

<?php class ArticlesDesignDocument implements \Doctrine\CouchDB\View\DesignDocument { public function getData() { return array( 'language' => 'javascript', 'views' => array( 'by_author' => array( 'map' => 'function(doc) {  if(\'article\' == doc.type) {  emit(doc.author, doc._id);  }  }', 'reduce' => '_count' ), ), ); } } $client->createDesignDocument('articles', new ArticlesDesignDocument()); // Fill database with some data. foreach (array('Alice', 'Bob', 'Bob') as $author) { $client->postDocument(array( 'type' => 'article', 'author' => $author, 'content' => 'Lorem ipsum' )); } // Query all articles. $query = $client->createViewQuery('articles', 'by_author'); $query->setReduce(false); $query->setIncludeDocs(true); $result = $query->execute(); foreach ($result as $row) { $doc = $row['doc']; echo 'Article by ', $doc['author'], ': ', $doc['content'], "\n"; } // Article by Alice: Lorem ipsum // Article by Bob: Lorem ipsum // Article by Bob: Lorem ipsum // Query all articles written by bob. $query = $client->createViewQuery('articles', 'by_author'); $query->setKey('Bob'); // ... // Query the _count of articles each author has written. $query = $client->createViewQuery('articles', 'by_author'); $query->setReduce(true); $query->setGroupLevel(1); // group_level=1 means grouping by author. $result = $query->execute(); foreach ($result as $row) { echo 'Author ', $row['key'], ' has written ', $row['value'], ' articles', "\n"; } // Author Alice has written 1 articles // Author Bob has written 2 articles