How to write MongoDB query in core PHP?

Question

I have created query in mongoDB. In MongoChef this query produces more than 10 thousand records in less than 2 seconds. Now I want to execute this query in PHP. So i don't know how to write query in php as I read various documents on internet but confused how to implement it.

 db.PMS.aggregate(
 [
    {$project:
       {EventTS:1,MainsPower:1,PanelID:1}
    },
    {$unwind: 
        {path:"$MainsPower",includeArrayIndex:"arrayIndex",preserveNullAndEmptyArrays:true}
    },
    { $match: { "MainsPower":{$ne:null}}},
    { $match: { "EventTS":{$gt:new Date("2016-01-01")}}},
    {$project:
        {MainsPower:1,
          PanelID:1,
          timestamp:{"$add":
                [{'$subtract' : ["$EventTS",new Date("1970-01-01")]},
                {"$multiply":[60000,"$arrayIndex"]}
                ]}
          }
    }
    ]
);

Which driver are you using? Did you read this? php.net/manual/en/book.mongo.php — m02ph3u5
– m02ph3u5, Commented Jun 18, 2016 at 10:40

Prasheel · Accepted Answer · 2016-06-18 10:49:12Z

1

You can use some resources available on the php official documentation. A mapping of sql queries in php to mongoDB queries in php can be found here. Also I have a demo login and registration script at my github. You can view those in this repo.

answered Jun 18, 2016 at 10:49

Prasheel

1,0207 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lukas Hajdu · Accepted Answer · 2016-06-18 10:55:11Z

0

If you use MongoDB PHP Library you should be able to do something similar to this:

$mongo = new MongoClient();

$database = $mongo->examples;
$collection = $database->PMS;

$pipeline = [
    [
        '$project' => [
            'EventTS' => 1,
            'MainsPower'   => 1,
            'PanelID'   => 1,
        ]
    ],
    [
        '$unwind' => [
            'path' => '$MainsPower',
            'includeArrayIndex' => 'arrayIndex',
            'preserveNullAndEmptyArrays' => true

        ]
    ],
    ...
];

$cursor = $collection->aggregate($pipeline);

answered Jun 18, 2016 at 10:55

Lukas Hajdu

8047 silver badges18 bronze badges

1 Comment

Amit Over a year ago

In $match i have to pass dynamic date so how to pass dynamic date variable in pipeline

Collectives™ on Stack Overflow

How to write MongoDB query in core PHP?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related