实现搜索功能

准备视图函数search()

@app.route('/search/')
def search():
    cha=request.args.get('q')
    chaxun=Wenda.query.filter(
        or_(
            Wenda.title.contains(cha),
            Wenda.detail.contains(cha)
        )).order_by('-creat_time')
    return render_template('moban.html',wenda=chaxun)

修改base.html 中搜索输入框所在的

1. <form action="{{ url_for('search') }}" method="get">

   <input name="q" type="text" placeholder="请输入关键字">

<form action="{{ url_for('search')}}" method="get" class="navbar-form navbar-left" role="search">
                <div class="form-group">
                    <input type="text"  id="q" name="q" autocomplete="off" placeholder="搜索" class="search-input" data-mounted="1">

组合条件查询
from sqlalchemy import or_, and_

from sqlalchemy import or_, and_