How do I do MongoDB console-style queries in PHP?
- by Zoe Boles
I'm trying to get a MongoDB query from the javascript console into my PHP app. What I'm trying to avoid is having to translate the query into the PHP "native driver"'s format... I don't want to hand build arrays and hand-chain functions any more than I want to manually build an array of MySQL's internal query structure just to get data.
I already have a string producing the exact content I want in the Mongo console:
db.intake.find({"processed": {"$exists": "false"}}).sort({"insert_date": "1"}).limit(10);
The question is, is there a way for me to hand this string, as is, to MongoDB and have it return a cursor with the dataset I request?
Right now I'm at the "write your own parser because it's not valid json to kinda turn a subset of valid Mongo queries into the format the PHP native driver wants" state, which isn't very fun.
I don't want an ORM or a massive wrapper library; I just want to give a function my query string as it exists in the console and get an Iterator back that I can work with. I know there are a couple of PHP-based Mongo manager applications that apparently take console-style queries and handle them, but initial browsing through their code, I'm not sure how they handle the translation.
I absolutely love working with mongo in the console, but I'm rapidly starting to loathe the thought of converting every query into the format the native writer wants...
