<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>Execute a database command</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="mongodb.authenticate.html">MongoDB::authenticate</a></div> <div class="next" style="text-align: right; float: right;"><a href="mongodb.construct.html">MongoDB::__construct</a></div> <div class="up"><a href="class.mongodb.html">MongoDB</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="mongodb.command" class="refentry"> <div class="refnamediv"> <h1 class="refname">MongoDB::command</h1> <p class="verinfo">(PECL mongo >=0.9.2)</p><p class="refpurpose"><span class="refname">MongoDB::command</span> — <span class="dc-title">Execute a database command</span></p> </div> <div class="refsect1 description" id="refsect1-mongodb.command-description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">array</span> <span class="methodname"><strong>MongoDB::command</strong></span> ( <span class="methodparam"><span class="type">array</span> <code class="parameter">$command</code></span> [, <span class="methodparam"><span class="type">array</span> <code class="parameter">$options</code><span class="initializer"> = array()</span></span> ] )</div> <p class="para rdfs-comment"> Almost everything that is not a CRUD operation can be done with a database command. Need to know the database version? There's a command for that. Need to do aggregation? There's a command for that. Need to turn up logging? You get the idea. </p> <p class="para"> This method is identical to: <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br /><br /></span><span style="color: #007700">public function </span><span style="color: #0000BB">command</span><span style="color: #007700">(</span><span style="color: #0000BB">$data</span><span style="color: #007700">) {<br /> return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">selectCollection</span><span style="color: #007700">(</span><span style="color: #DD0000">'$cmd'</span><span style="color: #007700">)-></span><span style="color: #0000BB">findOne</span><span style="color: #007700">(</span><span style="color: #0000BB">$data</span><span style="color: #007700">);<br />}<br /><br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> </p> </div> <div class="refsect1 parameters" id="refsect1-mongodb.command-parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <span class="term"> <em><code class="parameter">command</code></em> </span> <dd> <p class="para"> The query to send. </p> </dd> </dt> <dt> <span class="term"> <em><code class="parameter">options</code></em> </span> <dd> <p class="para"> This parameter is an associative array of the form <em>array("optionname" => <boolean>, ...)</em>. Currently supported options are: <ul class="itemizedlist"> <li class="listitem"><p class="para"><em>"timeout"</em></p><p class="para">Integer, defaults to <em>MongoCursor::$timeout</em>. If acknowledged writes are used, this sets how long (in milliseconds) for the client to wait for a database response. If the database does not respond within the timeout period, a <a href="class.mongocursortimeoutexception.html" class="classname">MongoCursorTimeoutException</a> will be thrown.</p></li> </ul> </p> </dd> </dt> </dl> </p> </div> <div class="refsect1 changelog" id="refsect1-mongodb.command-changelog"> <h3 class="title">Changelog</h3> <p class="para"> <table class="doctable informaltable"> <thead> <tr> <th>Version</th> <th>Description</th> </tr> </thead> <tbody class="tbody"> <tr> <td>1.2.0</td> <td> Added <em>options</em> parameter with a single option: <em>"timeout"</em>. </td> </tr> </tbody> </table> </p> </div> <div class="refsect1 returnvalues" id="refsect1-mongodb.command-returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> Returns database response. Every database response is always maximum one document, which means that the result of a database command can never exceed 16MB. The resulting document's structure depends on the command, but most results will have the <em>ok</em> field to indicate success or failure and <em>results</em> containing an array of each of the resulting documents. </p> </div> <div class="refsect1 examples" id="refsect1-mongodb.command-examples"> <h3 class="title">Examples</h3> <div class="example" id="example-1410"> <p><strong>Example #1 <span class="function"><strong>MongoDB::command()</strong></span> "distinct" example</strong></p> <div class="example-contents"><p> Finding all of the distinct values for a key. </p></div> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br /><br />$people </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">people</span><span style="color: #007700">;<br /><br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Joe"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">4</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Sally"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">22</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Dave"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">22</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Molly"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">87</span><span style="color: #007700">));<br /><br /></span><span style="color: #0000BB">$ages </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">command</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"distinct" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"people"</span><span style="color: #007700">, </span><span style="color: #DD0000">"key" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"age"</span><span style="color: #007700">));<br /><br />foreach (</span><span style="color: #0000BB">$ages</span><span style="color: #007700">[</span><span style="color: #DD0000">'values'</span><span style="color: #007700">] as </span><span style="color: #0000BB">$age</span><span style="color: #007700">) {<br /> echo </span><span style="color: #DD0000">"</span><span style="color: #0000BB">$age</span><span style="color: #DD0000">\n"</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> <div class="example-contents"><p>The above example will output something similar to:</p></div> <div class="example-contents screen"><br /> 4<br /> 22<br /> 87<br /> </div> </div> <div class="example" id="example-1411"> <p><strong>Example #2 <span class="function"><strong>MongoDB::command()</strong></span> "distinct" example</strong></p> <div class="example-contents"><p> Finding all of the distinct values for a key, where the value is larger than or equal to 18. </p></div> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br /><br />$people </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">people</span><span style="color: #007700">;<br /><br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Joe"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">4</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Sally"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">22</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Dave"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">22</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$people</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Molly"</span><span style="color: #007700">, </span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> </span><span style="color: #0000BB">87</span><span style="color: #007700">));<br /><br /></span><span style="color: #0000BB">$ages </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">command</span><span style="color: #007700">(<br /> array(<br /> </span><span style="color: #DD0000">"distinct" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"people"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"key" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"age"</span><span style="color: #007700">, <br /> </span><span style="color: #DD0000">"query" </span><span style="color: #007700">=> array(</span><span style="color: #DD0000">"age" </span><span style="color: #007700">=> array(</span><span style="color: #DD0000">'$gte' </span><span style="color: #007700">=> </span><span style="color: #0000BB">18</span><span style="color: #007700">))<br /> )<br />); <br /><br />foreach (</span><span style="color: #0000BB">$ages</span><span style="color: #007700">[</span><span style="color: #DD0000">'values'</span><span style="color: #007700">] as </span><span style="color: #0000BB">$age</span><span style="color: #007700">) {<br /> echo </span><span style="color: #DD0000">"</span><span style="color: #0000BB">$age</span><span style="color: #DD0000">\n"</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> <div class="example-contents"><p>The above example will output something similar to:</p></div> <div class="example-contents screen"><br /> 22<br /> 87<br /> </div> </div> <div class="example" id="example-1412"> <p><strong>Example #3 <span class="function"><strong>MongoDB::command()</strong></span> MapReduce example</strong></p> <div class="example-contents"><p> Get all users with at least on "sale" event, and how many times each of these users has had a sale. </p></div> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br /><br /></span><span style="color: #FF8000">// sample event document<br /></span><span style="color: #0000BB">$events</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"user_id" </span><span style="color: #007700">=> </span><span style="color: #0000BB">$id</span><span style="color: #007700">, <br /> </span><span style="color: #DD0000">"type" </span><span style="color: #007700">=> </span><span style="color: #0000BB">$type</span><span style="color: #007700">, <br /> </span><span style="color: #DD0000">"time" </span><span style="color: #007700">=> new </span><span style="color: #0000BB">MongoDate</span><span style="color: #007700">(), <br /> </span><span style="color: #DD0000">"desc" </span><span style="color: #007700">=> </span><span style="color: #0000BB">$description</span><span style="color: #007700">));<br /><br /></span><span style="color: #FF8000">// construct map and reduce functions<br /></span><span style="color: #0000BB">$map </span><span style="color: #007700">= new </span><span style="color: #0000BB">MongoCode</span><span style="color: #007700">(</span><span style="color: #DD0000">"function() { emit(this.user_id,1); }"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$reduce </span><span style="color: #007700">= new </span><span style="color: #0000BB">MongoCode</span><span style="color: #007700">(</span><span style="color: #DD0000">"function(k, vals) { "</span><span style="color: #007700">.<br /> </span><span style="color: #DD0000">"var sum = 0;"</span><span style="color: #007700">.<br /> </span><span style="color: #DD0000">"for (var i in vals) {"</span><span style="color: #007700">.<br /> </span><span style="color: #DD0000">"sum += vals[i];"</span><span style="color: #007700">. <br /> </span><span style="color: #DD0000">"}"</span><span style="color: #007700">.<br /> </span><span style="color: #DD0000">"return sum; }"</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$sales </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">command</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">"mapreduce" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"events"</span><span style="color: #007700">, <br /> </span><span style="color: #DD0000">"map" </span><span style="color: #007700">=> </span><span style="color: #0000BB">$map</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"reduce" </span><span style="color: #007700">=> </span><span style="color: #0000BB">$reduce</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"query" </span><span style="color: #007700">=> array(</span><span style="color: #DD0000">"type" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"sale"</span><span style="color: #007700">),<br /> </span><span style="color: #DD0000">"out" </span><span style="color: #007700">=> array(</span><span style="color: #DD0000">"merge" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"eventCounts"</span><span style="color: #007700">)));<br /><br /></span><span style="color: #0000BB">$users </span><span style="color: #007700">= </span><span style="color: #0000BB">$db</span><span style="color: #007700">-></span><span style="color: #0000BB">selectCollection</span><span style="color: #007700">(</span><span style="color: #0000BB">$sales</span><span style="color: #007700">[</span><span style="color: #DD0000">'result'</span><span style="color: #007700">])-></span><span style="color: #0000BB">find</span><span style="color: #007700">();<br /><br />foreach (</span><span style="color: #0000BB">$users </span><span style="color: #007700">as </span><span style="color: #0000BB">$user</span><span style="color: #007700">) {<br /> echo </span><span style="color: #DD0000">"</span><span style="color: #007700">{</span><span style="color: #0000BB">$user</span><span style="color: #007700">[</span><span style="color: #DD0000">'_id'</span><span style="color: #007700">]}</span><span style="color: #DD0000"> had </span><span style="color: #007700">{</span><span style="color: #0000BB">$user</span><span style="color: #007700">[</span><span style="color: #DD0000">'value'</span><span style="color: #007700">]}</span><span style="color: #DD0000"> sale(s).\n"</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> <div class="example-contents"><p>The above example will output something similar to:</p></div> <div class="example-contents screen"><br /> User 47cc67093475061e3d9536d2 had 3 sale(s).<br /> User 49902cde5162504500b45c2c had 14 sale(s).<br /> User 4af467e4fd543cce7b0ea8e2 had 1 sale(s).<br /> </div> <blockquote class="note"><p><strong class="note">Note</strong>: <strong>Using <a href="class.mongocode.html" class="classname">MongoCode</a></strong><br /> <p class="para"> This example uses <a href="class.mongocode.html" class="classname">MongoCode</a>, which can also take a scope argument. However, at the moment, MongoDB does not support using scopes in MapReduce. If you would like to use client-side variables in the MapReduce functions, you can add them to the global scope by using the optional scope field with the database command. See the <a href="http://docs.mongodb.org/manual/core/map-reduce/" class="link external">» MapReduce documentation</a> for more information. </p> </p></blockquote> <blockquote class="note"><p><strong class="note">Note</strong>: <strong>The <em>out</em> argument</strong><br /> <p class="para"> Before 1.8.0, the <em>out</em> argument was optional. If you did not use it, MapReduce results would be written to a temporary collection, which would be deleted when your connection was closed. In 1.8.0+, the <em>out</em> argument is required. See the <a href="http://docs.mongodb.org/manual/core/map-reduce/" class="link external">» MapReduce documentation</a> for more information. </p> </p></blockquote> <div class="example-contents"><p> If you are going to be using MapReduce, Prajwal Tuladhar created an API for Mongo PHP users which provides a nicer interface than the bare command. You can download it from <a href="http://technosophos.com/content/os-x-installing-mongodb-and-php-mongo-driver" class="link external">» Github</a> and there is a <a href="http://prajwal-tuladhar.net.np/2009/11/15/496/mapreduce-api-for-mongodb/" class="link external">» blog post</a> on how to use it. </p></div> </div> <div class="example" id="example-1413"> <p><strong>Example #4 <span class="function"><strong>MongoDB::command()</strong></span> "textSearch" example</strong></p> <div class="example-contents"><p> Do a fulltext search lookup with MongoDB's 2.4 and higher "text search" functionality. </p></div> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br />$m </span><span style="color: #007700">= new </span><span style="color: #0000BB">MongoClient</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">$d </span><span style="color: #007700">= </span><span style="color: #0000BB">$m</span><span style="color: #007700">-></span><span style="color: #0000BB">demo</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$c </span><span style="color: #007700">= </span><span style="color: #0000BB">$d</span><span style="color: #007700">-></span><span style="color: #0000BB">planets</span><span style="color: #007700">;<br /><br /></span><span style="color: #0000BB">$c</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Mercury"</span><span style="color: #007700">, </span><span style="color: #DD0000">"desc" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Mercury is the smallest and closest to the Sun"</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$c</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Venus"</span><span style="color: #007700">, </span><span style="color: #DD0000">"desc" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Venus is the second planet from the Sun, orbiting it every 224.7 Earth days."</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$c</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Earth"</span><span style="color: #007700">, </span><span style="color: #DD0000">"desc" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Earth is the the densest of the eight planets in the Solar System."</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">$c</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Mars"</span><span style="color: #007700">, </span><span style="color: #DD0000">"desc" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Mars is named after the Roman god of war."</span><span style="color: #007700">));<br /><br /></span><span style="color: #0000BB">$c</span><span style="color: #007700">-></span><span style="color: #0000BB">ensureIndex</span><span style="color: #007700">(array(</span><span style="color: #DD0000">'desc' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'text'</span><span style="color: #007700">));<br /><br /></span><span style="color: #0000BB">$r </span><span style="color: #007700">= </span><span style="color: #0000BB">$d</span><span style="color: #007700">-></span><span style="color: #0000BB">command</span><span style="color: #007700">(array(</span><span style="color: #DD0000">"text" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"planets"</span><span style="color: #007700">, </span><span style="color: #DD0000">'search' </span><span style="color: #007700">=> </span><span style="color: #DD0000">"sun" </span><span style="color: #007700">));<br /></span><span style="color: #0000BB">print_r</span><span style="color: #007700">(</span><span style="color: #0000BB">$r</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> <div class="example-contents"><p>The above example will output something similar to:</p></div> <div class="example-contents screen"><br /> Array<br /> (<br /> [queryDebugString] => sun||||||<br /> [language] => english<br /> [results] => Array<br /> (<br /> [0] => Array<br /> (<br /> [score] => 0.625<br /> [obj] => Array<br /> (<br /> [_id] => MongoId Object<br /> (<br /> [$id] => 517549d944670a4a5cb3059a<br /> )<br /> <br /> [name] => Mercury<br /> [desc] => Mercury is the smallest and closest to the Sun<br /> )<br /> <br /> )<br /> <br /> [1] => Array<br /> (<br /> [score] => 0.55<br /> [obj] => Array<br /> (<br /> [_id] => MongoId Object<br /> (<br /> [$id] => 517549d944670a4a5cb3059b<br /> )<br /> <br /> [name] => Venus<br /> [desc] => Venus is the second planet from the Sun, orbiting it every 224.7 Earth days.<br /> )<br /> <br /> )<br /> <br /> )<br /> <br /> [stats] => Array<br /> (<br /> [nscanned] => 2<br /> [nscannedObjects] => 0<br /> [n] => 2<br /> [nfound] => 2<br /> [timeMicros] => 95<br /> )<br /> <br /> [ok] => 1<br /> )<br /> </div> </div> <div class="example" id="example-1414"> <p><strong>Example #5 <span class="function"><strong>MongoDB::command()</strong></span> "geoNear" example</strong></p> <div class="example-contents"><p> This example shows how to use the geoNear command. </p></div> <div class="example-contents"> <div class="phpcode"><code><span style="color: #000000"> <span style="color: #0000BB"><?php<br />$m </span><span style="color: #007700">= new </span><span style="color: #0000BB">MongoClient</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">$d </span><span style="color: #007700">= </span><span style="color: #0000BB">$m</span><span style="color: #007700">-></span><span style="color: #0000BB">demo</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$c </span><span style="color: #007700">= </span><span style="color: #0000BB">$d</span><span style="color: #007700">-></span><span style="color: #0000BB">poiConcat</span><span style="color: #007700">;<br /><br /></span><span style="color: #0000BB">$r </span><span style="color: #007700">= </span><span style="color: #0000BB">$d</span><span style="color: #007700">-></span><span style="color: #0000BB">command</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">'geoNear' </span><span style="color: #007700">=> </span><span style="color: #DD0000">"poiConcat"</span><span style="color: #007700">, </span><span style="color: #FF8000">// Search in the poiConcat collection<br /> </span><span style="color: #DD0000">'near' </span><span style="color: #007700">=> array(-</span><span style="color: #0000BB">0.08</span><span style="color: #007700">, </span><span style="color: #0000BB">51.48</span><span style="color: #007700">), </span><span style="color: #FF8000">// Search near 51.48°N, 0.08°E<br /> </span><span style="color: #DD0000">'spherical' </span><span style="color: #007700">=> </span><span style="color: #0000BB">true</span><span style="color: #007700">, </span><span style="color: #FF8000">// Enable spherical search<br /> </span><span style="color: #DD0000">'num' </span><span style="color: #007700">=> </span><span style="color: #0000BB">5</span><span style="color: #007700">, </span><span style="color: #FF8000">// Maximum 5 returned documents<br /></span><span style="color: #007700">));<br /></span><span style="color: #0000BB">print_r</span><span style="color: #007700">(</span><span style="color: #0000BB">$r</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span> </span> </code></div> </div> </div> </div> <div class="refsect1 seealso" id="refsect1-mongodb.command-seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"> <span class="methodname"><a href="mongocollection.aggregate.html" class="methodname" rel="rdfs-seeAlso">MongoCollection::aggregate()</a> - Perform an aggregation using the aggregation framework</span></li> <li class="member"> <span class="methodname"><a href="mongocollection.findandmodify.html" class="methodname" rel="rdfs-seeAlso">MongoCollection::findAndModify()</a> - Update a document and return it</span></li> <li class="member"> <span class="methodname"><a href="mongocollection.group.html" class="methodname" rel="rdfs-seeAlso">MongoCollection::group()</a> - Performs an operation similar to SQL's GROUP BY command</span></li> </ul> </p> <p class="para"> MongoDB core docs on <a href="http://docs.mongodb.org/manual/reference/command/" class="link external">» database commands</a> and on individual commands: <a href="http://docs.mongodb.org/manual/reference/command/findAndModify/" class="link external">» findAndModify</a>, <a href="docs.mongodb.org/manual/reference/command/getLastError/" class="link external">» getLastError</a>, and <a href="http://docs.mongodb.org/manual/reference/command/repairDatabase/" class="link external">» repairDatabase</a> (dozens more exist, there are merely a few examples). </p> </div> </div><hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="mongodb.authenticate.html">MongoDB::authenticate</a></div> <div class="next" style="text-align: right; float: right;"><a href="mongodb.construct.html">MongoDB::__construct</a></div> <div class="up"><a href="class.mongodb.html">MongoDB</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>