yii2.0 中数据查询中 or、in、between 及session的使用
2024-09-06 19:52:16
1 HTML:
2
3 <div>
4 <form class="form-inline " method="get" action="<?=Url::to(['companylist']);?>">
5 <div class="form-group">
6 <input type="text" name="name" style="width: 80%; display:inline;" class="form-control input-sm" placeholder="配电室编号 或 配电室名称" value="<?=$_GET['name'];?>">
7 <button type="submit" style="float: right" class="btn btn-primary btn-sm">查询</button>
8 </div>
9 </form>
10 </div>
11 控制器的查询条件:
12 $data = Concentrator::find()->andWhere(['in', 'id', $cIds]);
13 if ($_GET['name']) {
14 $data->andWhere(['or', ['like', 'number', $_GET['name']], ['like', 'name', $_GET['name']]]);
15 }
16 //in
17 $data->andWhere(['in', 'state', [1, 2, 3]]);
18 //between
19 $data->andFilterWhere(['between', 'create_time', $start_date, $end_date]);
20 $rowset = $data->all();
21 echo $data->createCommand()->getRawSql(); //输出sql语句
1 ['and', 'id=1', 'id=2'] //id=1 AND id=2
2
3 ['and', 'type=1', ['or', 'id=1', 'id=2']] //type=1 AND (id=1 OR id=2)
4
5 ['between', 'id', 1, 10] //id BETWEEN 1 AND 10
6
7 ['not between', 'id', 1, 10] //not id BETWEEN 1 AND 10
8
9 ['in', 'id', [1, 2, 3]] //id IN (1, 2, 3)
10
11 ['not in', 'id', [1, 2, 3]] //not id IN (1, 2, 3)
12
13 ['like', 'name', 'tester'] //name LIKE '%tester%'
14
15 ['like', 'name', ['test', 'sample']] //name LIKE '%test%' AND name LIKE '%sample%'
16
17 ['not like', 'name', ['or', 'test', 'sample']] //not name LIKE '%test%' OR not name LIKE '%sample%'
18
19 ['like', 'name', '%tester', false] // name LIKE '%tester'
20
21 ['exists','id', $userQuery] //EXISTS (sub-query) | not exists
22
23 ['>', 'age', 10] //age>10
24 where(['<>','id',10]) //不等于
session:
$session = Yii::$app->session;
$session['user'] = [
'id' => 1,
'username' => 'yiiuser',
];
echo $session['user']['id'];
echo $session['user']['username'];
最新文章
- css3-columns多列布局
- centos7设置网关
- What is the difference between a binary tree, a binary search tree, a B tree and a B+ tree?
- 给 Xamarin.Form For Windows Phone APP 加个漂亮的 ";头";
- 【JOJO】真男人-坚不可摧
- TinyXml和tinyxml2
- [Redis] windows下安装 Redis
- 一些Android经验
- java.util.Arrays类
- Andrew Ng机器学习课程笔记--week6(精度&;召回率)
- Python并发式编程
- 与postman的第一次亲密接触
- vuex action 与mutations 的区别
- JS膏集02
- POJ 2393 Yogurt factory【贪心】
- Android使得Fragment 切换时不重新实例化
- 【spring mvc】application context的生命周期
- django路由转发
- hidden=";hidden";,display:none, visibility:hidden 三者的区别
- Jquery Datatable添加复选框,实现批量操作。