PhalApi中常用where、or、and查询组装成数组demo

2021-07-23 46.76w热度

最近用到了PhalApi框架，api开发还是很方便的，这里吧常用的一下where语法列出来，方便使用。

if($this->product_series){$where["c.product_series"] = $this->product_series;}
            if($this->resource){$where["a.resource"] = $this->resource;}
            if($this->reserve_time){
                $arr = explode(",",$this->reserve_time);
                $where["a.reserve_time > ?"]  =$arr[0];
                $where["a.reserve_time < ?"]  =$arr[1];
            }//

// 
            if($this->keyword){
                $where["
                    d.name      like ? or
                    d.network   like ? or
                    d.division  like ? or
                    d.barea     like ? or
                    d.area      like ? 
                "] = [
                    '%'.$this->keyword .'%',
                    '%'.$this->keyword .'%',
                    '%'.$this->keyword .'%',
                    '%'.$this->keyword .'%',
                    '%'.$this->keyword .'%'
                ];
            }
			
			
			
```sql
$where = [
	'project_id'             => $project_id,
	'(pre_start_date != ?  OR pre_end_date != ?)' => ['', ''],
	'deleted_at'             => BaseModel::DELETED_AT_NO,
];
```
[![](https://micuu.com/data/upload/20210723/60fa618a8d1b7.png)](https://micuu.com/data/upload/20210723/60fa618a8d1b7.png)

注:原创不易,转载请注明出处( https://micuu.com/new/1969.html )，本站所有资源来源于网络收集，如有侵权请联系QQ245557979进行清除。

最后修改与 2023-12-08

PhalApi中常用where、or、and查询组装成数组demo

留言反馈