热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

YII2操作mongodb笔记(转)

 componets配置:mongodb>[class>\yii\mongodb\Connection,dsn&

 

componets配置:

'mongodb' => [
    'class' => '\yii\mongodb\Connection',
    'dsn' => 'mongodb://test:123456@127.0.0.1:27017/yiimongodb',
],

  

 

控制器:

mongodb->getCollection ( 'customer' );
        $res = $collection->insert ( [ 
        'name' => 'John Smith22',
        'status' => 2 
        ] );
        var_dump($res);
    }
    public function actionList()
    {
        $query = new Query ();
        $query->select ( [ 
        'name',
        'status' 
        ] )->from ( 'customer' )->offset ( 10 )->limit ( 10 );
        $rows = $query->all ();
        var_dump ( $rows );
    }
    public function actionView()
    {
        $query = new Query ();
        $row = $query->from ( 'customer' )->one ();
        echo Url::toRoute ( [ 
        'item/update',
        'id' => ( string ) $row ['_id'] 
        ] );
        var_dump ( $row ['_id'] );
        var_dump ( ( string ) $row ['_id'] );
    }
    public function actionFind()
    {
        $provider = new ActiveDataProvider ( [ 
        'query' => Customer::find (),
        'pagination' => [ 
        'pageSize' => 10 
        ] 
        ] );
        $models = $provider->getModels ();
        var_dump ( $models );
    }
    public function actionQuery()
    {
        $query = new Query ();
        $query->from ( 'customer' )->where ( [ 
        'status' => 2 
        ] );
        $provider = new ActiveDataProvider ( [ 
        'query' => $query,
        'pagination' => [ 
        'pageSize' => 10 
        ] 
        ] );
        $models = $provider->getModels ();
        var_dump ( $models );
    }
    public function actionSave()
    {
        $res = Customer::saveInfo ();
        var_dump ( $res );
    }
}

  

 

模型:

name = '111';
        $customer->email = '222';
        $customer->insert ();
        return $customer;
    }
    public function attributes()
    {
        return [ 
        '_id',
        'name',
        'email',
        'address',
        'status' 
        ];
    }
}

  

 

YII2的mongodb拓展下载:

https://github.com/yiisoft/yii2-mongodb

 

中文网址:

http://www.runoob.com/

http://www.mongoing.com/

http://www.cnblogs.com/libingql/archive/2011/06/09/2076440.html

常用命令 ,同mysql,eg:

db.createUser({"user":"test","pwd":"123456","roles":["readWrite","dbAdmin"]})

show users;

show dbs;

db.version();

db.stats();

use yiimongodb;

show collections;

  

 


推荐阅读
author-avatar
无视一个水阿哥_470
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有