标准搜索案例
2023-09-27 14:24:29 时间
html
<div class="alert sb-alert alert-gray margin-left-50">
<div class="row">
<div class="col-lg-2">
<span class="input-group input-group-sm">
<span class="input-group-addon"><b>姓名:</b></span>
<input type="text" class="form-control" id="name" value="{$name}" aria-describedby="base">
</span>
</div>
<div class="col-lg-2">
<span class="input-group input-group-sm">
<span class="input-group-addon"><b>手机号:</b></span>
<input type="text" class="form-control" id="telphone" value="{$telphone}" aria-describedby="base">
</span>
</div>
<div class="col-lg-2">
<span class="input-group input-group-sm">
<span class="input-group-addon"><b>状态:</b></span>
<select id="status" class="form-control" style="position: relative; left:-4px;z-index: 1;" aria-describedby="object">
<option value="0">请选择</option>
<option value="-1" <?php if($status == -1) echo 'selected'; ?>>未处理</option>
<option value="1" <?php if($status == 1) echo 'selected'; ?>>已发货</option>
<option value="2" <?php if($status == 2) echo 'selected'; ?>>已丢弃</option>
</select>
</span>
</div>
<button type="button" class="btn btn-sm btn-primary" style="float: right; margin-right: 15px;" id="search">
<i class="fa fa-search" aria-hidden="true"></i> 搜索
</button>
</div>
</div>
js
$("#search").on('click', function () {
var pathname = window.location.pathname;
var name = $("#name").val();
var telphone = $("#telphone").val();
var status = $("#status").val();
var tail = '?search=1';
if(name){
tail += '&name='+name;
}
if(status){
tail += '&status='+status;
}
if(telphone){
tail += '&telphone='+telphone;
}
window.location.href = "http://" + window.location.host + pathname + tail;
});
php
// search
$where = [];
if ($name = $_GET['name']) {
$where['name'] = ['like',$name.'%'];
$this->assign('name',$name);
}
if ($telphone = $_GET['telphone']) {
$where['telphone'] = ['like',$telphone.'%'];
$this->assign('telphone',$telphone);
}
if ($status = $_GET['status']) {
if ($status == -1) {
$where['status'] = 0;
} else {
$where['status'] = $status;
}
$this->assign('status',$status);
}
$data_list=$women_get->where($where)->order('id desc')->limit($start.','.$step)->select();
干净利落
相关文章
- 华为云助推武水集团项目成功入选住建部“智慧水务”典型案例!
- 从零构建知识图谱(技术、方法与案例)-第一章:知识图谱概览
- MEMS激光雷达监测法兰克福机场客流量应用案例
- 数据分析-day06-pandas-dataFrame案例分析2:统计不同月份的通话次数
- css案例学习之relative与absolute
- css案例学习之class执行的顺序
- 大型网站技术架构:核心原理与案例分析
- 经典网页设计:无缝过渡的响应式设计案例
- 国外经典设计:13个漂亮的插画网站设计案例
- 一文教会你如何进行Rest微服务构建 案例工程模块。教会你如何创建父子工程
- 《Spark SQL大数据实例开发》9.2 综合案例实战——电商网站搜索排名统计
- 【Elasticsearch教程21】分页查询以及Array数组排序 nested排序 详细案例
- Vue基础案例(水果搜索,购物车,todolist,留言板,跑马灯)
- Python+moviepy音视频剪辑:视频帧数据的本质、Clip的fl方法进行变换处理的原理以及滚屏案例
- 遗留代码处理技巧与案例演示
- 服装商品企划实务与案例