tp6操作mongodb

// 更多的数据库配置信息
'mongo'=>[
    'type'  =>  'mongo',
    'hostname' => '127.0.0.1',
    'database' => '数据库名称',
    'username'        => '',
    'password'        => '',
    'hostport' => '27017'
]

 

创建集合

dadeinsta是集合名，不存在则创建

Db::connect('mongo')->table('dadeinsta')->insert(['name'=>123,'age'=>18,'ss'=>11]);

 

1、查询

查全部
$res = Db::connect('mongo')->table('dade')->select();
        return json($res);

模糊查询
$res = Db::connect('mongo')->table('dade')->whereLike("dade",'666')->select();
        return json($res);


in包含查询
$res = Db::connect('mongo')->table('dade')->whereIn('age',[18,1818])->select();

notin不包含查询
$res = Db::connect('mongo')->table('dade')->whereNotIn('age',[18,1818])->select();


分页
$res = Db::connect('mongo')->table('dade')->limit(0,2)->select();

升序
$res = Db::connect('mongo')->table('dade')->limit(0,2)->order('age','asc')->select();

倒序
$res = Db::connect('mongo')->table('dade')->limit(0,2)->order('age','desc')->select();

查询大于18的
$res = Db::connect('mongo')->table('dade')->where('age','>',18)->select();

只取出age和name字段
$res = Db::connect('mongo')->table('dade')->field('age,name')->select();

获得总条数
$res = Db::connect('mongo')->table('dade')->count();

2、新增

Db::connect('mongodb')->table('dade')->insert(['name'=>123,'age'=>18]);

批量插入
Db::connect('mongo')->table('dade')->limit(100)->insertAll($data);

3、修改

$res = Db::connect('mongo')->table('dade')->where('age','=',185)->update(['name'=>'大得11']);

4、删除

$res = Db::connect('mongo')->table('dade')->where('age','=',186)->delete();

原生篇

mongoDB操作文档（全部）_大得369的博客-CSDN博客