Mongodb 查询相关操作

1、查询单个文档

2、查询多个文档

##查询单个文档
//        $data = $table->findOne();             //Array
        
        
        
        ##查询多个文档
//        $cursor = $table->find();

        #where 语句
        #分别使用$lt、$lte、$eq、$gte、$gt、$ne表示<、<=、=、>=、>、<>，用于整数字段查询
//        $cursor = $table->find(['quantity_way'=>['$lt'=>'0']]);           //select * from tb where quantity_way<0

        #匹配多个值中任意一个 in 查询 select * from tb where quantity_way in ('-2','-1')
//        $cursor = $table->find(['quantity_way'=>['$in'=>['-1','-2']]]);

        #$all：匹配多个值中所有值（用于数组字段查询）
//        $cursor = $table->find(['quantity_way'=>['$all'=>['-1','-2']]]);

        //并查询
//        $cursor = $table->find(['quantity_way'=>['$in'=>['-1','-2'],'quantity_available'=>0]]);

        //$or：或查询
//        $cursor = $table->find(['$or'=>[['quantity_way'=>'-1'],['quantity_way'=>'-2']]]);

        //$slice：获取数组字段中指定数目的元素，位于find()函数第二个参数中
//        $cursor = $table->find(['quantity_way'=>'-1'],['quantity_available'=>['$slice' => 2]]);     #只返回前两个
//        $cursor = $table->find(['quantity_way'=>'-1'],['quantity_available'=>['$slice' => -2]]);     #只返回最后两个
//        $cursor = $table->find(['quantity_way'=>'-1'],['quantity_available'=>['$slice' => [1,2]]]);     #忽略第一个，返回接下来两个

        //$exists：根据某个字段是否有设置值进行查询
//        $cursor = $table->find(['quantity_way'=>['$exists' => false]]);

        //正则表达式查询
//        $cursor = $table->find(['quantity_way' => new Regex('/^Je/i')]);//查找First Name字段以Je开头的文档，忽略大小写差异


        //排序：1升序，-1降序
//        $cursor = $table->find()->sort(['quantity_way'=>1]);
        //忽略前n个匹配的文档
//        $cursor = $table->find()->skip(10);

        //只返回前n个匹配的文档（limit()与skip()结合使用可实现数据分页功能）
//        $cursor = $table->find()->limit(10);

        //指定查询索引,若索引不存在则会报错
//        $cursor = $table->hint(['Last Name' => -1]);
//
//        while($doc = $cursor->getNext()) {//循环读取每个匹配的文档
//            print_r($doc);
//        }

        //匹配文档的总数
        $count = $table->find()->count();