TP3.2 where常见的几种条件查询

℡梦醒时分

于 2020-03-24 08:42:19 发布

阅读量2.5k

点赞数

分类专栏： PHP 文章标签： php mysql

本文链接：https://blog.csdn.net/spc007spc/article/details/105063538

版权

PHP 专栏收录该内容

27 篇文章

订阅专栏

$school = M('school');
$name = '张';
$gender = 'men';
$time1 = 1589070134;
$time2 = 1589327933;
$map = [
    'name' => ['like','%'.$name.'%'],//模糊查询
    'nianji' => ['elt', 3],//运算符查询
    'leixing' => ['not in', ['teacher']],//in查询
    'gender' => $gender,//指定条件查询
    'time' => ['between', [$time1, $time2]]//区间查询
];
$user = $school->where($map)->select();