php-think_php5.1链式查询1

最新推荐文章于 2024-01-05 17:30:37 发布

修罗_

最新推荐文章于 2024-01-05 17:30:37 发布

阅读量307

点赞数

分类专栏： think_php5.1 文章标签： php 开发语言后端

本文链接：https://blog.csdn.net/weixin_45843676/article/details/122896460

版权

think_php5.1 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

链式查询

//关联数组查询
$result = Db::name('user')->where([
          'price' => 555,
          'gender' => '女'
])->select();
$result = Db::name('user')->where([
         'price' => [555, 222, 333],
         'gender' => '男'
])->select();
//索引数组(二维数组)查询
$result = Db::name('user')->where([
         ['price','=',976],
         ['gender','=','男']
])->select();
//指定结果集查询
$result = Db::name('user')->field('id,username,email')->select();
$result = Db::name('user')->field(['id','username','email'])->select();
//给字段设置别名
$result = Db::name('user')->field('id,username as name')->select();
$result = Db::name('user')->field(['id', 'username' => 'name',])->select();
//结果集返回sum
$result = Db::name('user')->field('id,SUM(price)')->select();
//email字段显示5个字符
$result = Db::name('user')->field(['id', 'LEFT(email,5)' => 'left_email'])->select();
//指定字段插入数据
$data = [
      'uuid' => '13813822',
      'user' => '皎月',
      'math' => 88,
      'chinese' => 89,
      'english' => 88,
      'create_time' => date('y-m-d H:i:s')
];
$insert = Db::name('score')->field('uuid,user,math,chinese,create_time')->insert($data);
//指定数据表别名查询返回( SELECT * FROM `tp_user` `user_001` )
$result = Db::name('user')->alias('user_001')->buildSql(true);