如何在php（codeigniter框架）中执行mongodb查询

Question

This is my MongoDB query

db.getCollection('fe_report').aggregate([{
    $match: 
    { date: { $gte: ISODate("2017-07-01T00:00:00.000Z"),
            $lte: ISODate("2017-07-19T00:00:00.000Z")} } },
    {
        $group:
        {
            _id :"$employee_id_fk",

            no_of_kms : {$sum: "$no_of_kms"},
            no_of_orders: {$sum: "$no_of_orders"},
            }
    }
   ]
  )

i need to execute this query from PHP

Answer 1

    config/mongo.php

    $config['mongo_server'] = null;
    $config['mongo_dbname'] = 'mydb';
    libraries/Mongo.php

    class CI_Mongo extends Mongo
    {
        var $db;

        function CI_Mongo()
        {   
            // Fetch CodeIgniter instance
            $ci = get_instance();
            // Load Mongo configuration file
            $ci->load->config('mongo');

            // Fetch Mongo server and database configuration
            $server = $ci->config->item('mongo_server');
            $dbname = $ci->config->item('mongo_dbname');

            // Initialise Mongo
            if ($server)
            {
                parent::__construct($server);
            }
            else
            {
                parent::__construct();
            }
            $this->db = $this->$dbname;
        }
    }
    And a sample controller

    controllers/posts.php

    class Posts extends Controller
    {
        function Posts()
        {
            parent::Controller();
        }

        function index()
        {
            $posts = $this->mongo->db->posts->find();

            foreach ($posts as $id => $post)
            {
                var_dump($id);
                var_dump($post);
            }
        }

        function create()
        {
            $post = array('title' => 'Test post');
            $this->mongo->db->posts->insert($post);
            var_dump($post);
        }
    }

try this it work for u