ThinkPHP用form表单进行搜索

最新推荐文章于 2022-01-10 15:13:07 发布

岐伯漫谈

最新推荐文章于 2022-01-10 15:13:07 发布

阅读量692

点赞数

分类专栏： ThinkPHP应用开发文章标签： php thinkphp

本文链接：https://blog.youkuaiyun.com/programmer54/article/details/110671678

版权

ThinkPHP应用开发专栏收录该内容

2 篇文章

订阅专栏

文章目录

- PHP代码是这样子的
- HTML是这样子的

PHP代码是这样子的

<?php

namespace app\controller;

use app\BaseController;
use app\Request;
use think\facade\Db;

class Member extends BaseController
{
    public function company(Request $request)
    {
        // 1.条件
        $param = $request->param();
        $where = [];
        if (isset($param['name']) && !empty($param['name'])) {
            $where[] = ['name', 'like', '%' . $param['name'] . '%'];
        }
        if (isset($param['city']) && !empty($param['city'])) {
            $where[] = ['city', 'like', '%' . $param['city'] . '%'];
        }

        // 2:列表
        $list = \think\facade\Db::connect('jiaoyu')
            ->table('fa_xiehui_company_member')
            ->order('id', 'desc')
            ->where($where)
            ->paginate(10);

        // 3:获取分页显示
        $page = $list->render();

        return view('', ['list' => $list, 'page' => $page]);

    }

}

HTML是这样子的

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>山西省建设监理协会-单位会员</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="/static/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="/static/css/page.css">
</head>
<body>

<div class="layui-container">
    <fieldset class="layui-elem-field layui-field-title" style="margin-top: 20px;">
        <legend>山西省建设监理协会-单位会员</legend>
    </fieldset>
    <form action="{:url('member/company')}" method='get'>
        <div class="layui-form layui-form-pane" >

            <div class="layui-form-item">
                <div class="layui-inline">
                    <label class="layui-form-label">单位名称</label>
                    <div class="layui-input-block">
                        <input type="text" name="name" placeholder="请输入单位名称" autocomplete="off"
                               class="layui-input" style="width: 400px !important;" value="{$Request.param.name}">
                    </div>
                </div>

                <div class="layui-inline">
                    <label class="layui-form-label">所在城市</label>
                    <div class="layui-input-block">
                        <input type="text" name="city" placeholder="请输入所在城市" autocomplete="off" class="layui-input"
                               value="{$Request.param.city}">
                    </div>
                </div>
                <div class="layui-inline">
                    <button type="submit" class="layui-btn" lay-submit="" lay-filter="demo1">立即提交</button>
                </div>
            </div>

            <table class="layui-table">
                <colgroup>
                    <col width="">
                    <col width="">
                </colgroup>
                <thead>
                <tr>
                    <th>单位名称</th>
                    <th>所在城市</th>
                </tr>
                </thead>
                <tbody>
                {volist name='list' id='company'}
                <tr>
                    <td>{$company.name}</td>
                    <td>{$company.city}</td>
                </tr>
                {/volist}
                </tbody>
            </table>
            {$page|raw}
        </div>
</div>
<script src="/static/layui/layui.js" charset="utf-8"></script>
<script>

</script>
</body>
</html>

最终实现的效果是这样子的

在这里插入图片描述