MongoDB/PHP.. How to write select queries?

Question

How to write find query in mongo db to select certain values. For example

IN MYSQL - SELECT * from things where id=3;
IN Mongo - thingscollection->find(array("_id" => $id))

suppose if the MYSQL query looks like this,

SELECT name,age from things where id=3;

I am wondering how to write find query in PHP/MongoDB to select specific values?

Answer 1

MySQL: SELECT name,age from things where id=3;  
Mongo: $db->things->find(array("id" => 3), array("name" => 1, "age" => 1));

You may want to use the mongo _id instead of an own created id field.

For more information specifically about the php driver: http://php.net/manual/en/mongo.sqltomongo.php An other good link for just SQL to Mongo is http://rickosborne.org/download/SQL-to-MongoDB.pdf

Answer 2

use SQL to Mongo as a reference when writing queries in Mongo Statements.