31 Star 244 Fork 87

店滴云物联网开源框架 / ddiot-茶室民宿酒店棋牌室管理系统

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
pdo.md 1.91 KB
一键复制 编辑 原始数据 按行查看 历史

数据库操作

查询条件

or

    ['or',['mobile'=>123],['id'=>1]]

and

    ['and',['mobile'=>123],['id'=>1]]

复杂查询

    ['or',['username'=>'admin'],['and',['id'=>11],['mobile'=>123]],['store_id'=>111]]

分页查询

    PdoQuery::getInstance()->findPaginated('user',1,11);

查询单个记录

$result = PdoQuery::getInstance()->findOneBy('user',['or',['username'=>'admin'],['and',['id'=>11],['mobile'=>123]],['store_id'=>111]]);

查询所有记录

$result = PdoQuery::getInstance()->findAllBy('user',['or',['username'=>'admin'],['and',['id'=>11],['mobile'=>123],['store_id'=>111]]]);

查询分页

$result = PdoQuery::getInstance()->findAllPaginated('user',1,11);

查询单个字段

$result = PdoQuery::getInstance()->findfield('user','uid',['or',['username'=>'admin'],['and',['id'=>11],['mobile'=>123]],['store_id'=>111]],'id');

查询最后执行的sql

 $sql = PdoQuery::getInstance()->getLastSql();

兼容yii->query语法

查询单个记录

    $PdoQuery = new PdoYii();
    $result = $PdoQuery->table('dd_user')->where(['id'=>232])->orWhere(['mobile'=>12])->orWhere(['store_id'=>2323,'username'=>'admin888'])->one();

查询最后执行的sql

    $sql = $PdoQuery->getLastSql();

查询分页

    $PdoQuery = new PdoYii();
    $result = $PdoQuery->table('dd_user')->where(['id'=>232])->orWhere(['mobile'=>12])->orWhere(['store_id'=>2323,'username'=>'admin888'])->paginate(1,10);

查询所有记录

    $PdoQuery = new PdoYii();
    $result = $PdoQuery->table('dd_user')->where(['id'=>232])->orWhere(['mobile'=>12])->orWhere(['store_id'=>232
3,'username'=>'admin888'])->all();

查询单个字段

    $PdoQuery = new PdoYii();
    $result = $PdoQuery->table('dd_user')->where(['id'=>232])->orWhere(['mobile'=>12])->orWhere(['store_id'=>2323,'username'=>'admin888'])->select('id,username')->one();
PHP
1
https://gitee.com/wayfirer/ddiot.git
git@gitee.com:wayfirer/ddiot.git
wayfirer
ddiot
ddiot-茶室民宿酒店棋牌室管理系统
main

搜索帮助