ThinkPHP5\6 配置mongodb
1、首先使用Composer安装ThinkPHP5\6的MongoDb驱动:
composer require topthink/think-mongo
2、在app下的config文件夹中的 database.php 配置连接信息
代码如下:
'mongo'=>[
'type' => 'mongo',
'hostname' => '127.0.0.1',
'database' => 'database',
'username' => '',
'password' => '',
'hostport' => '27017'
]
3、使用方法
//mock数据
$data=[
'a'=>1,
'b'=>2
];
新增
$res = Db::connect('mongo')->table('news')->insertGetId($data);
查询
$res = Db::connect('mongo')->table('news')->select();
单条件查询
$mangoList = Db::connect('mongo')->table('news')->where('id','76')->select();
模糊查询
$where['name'] = new \MongoDB\BSON\Regex($param['operator'],'i');
$a = new \MongoDB\BSON\Regex($where['pageUrl'],'i');
$model = $model->where('page',$a);
$title = new \MongoDB\BSON\Regex('ddd','i');
$mangoList = Db::connect('mongo')->table('news')->where('title',$title)->select();
多条件查询
$mangoList = Db::connect('mongo')->table('news')
->where('id','76')
->where('city_id','17')
->select();
更新
$mangoList = Db::connect('mongo')->table('news')->where('id','76')->update([
'title'=>'eeeeeeeeeee'
]);
删除
$mangoList = Db::connect('mongo')->table('news')->where('id','75')->delete();
$mangoList = Db::connect('mongo')->table('news')->where('_id','6021506535f34b1ef9497352')->delete();
$res = Db::connect('mongo')->table('news')->select();
dump(json_decode($res,true));
这是我的草稿,需要对接真实数据的,自己得去调试一下。