1.准备视图函数search()
2.修改base.html 中搜索输入框所在的
<form action="{{ url_for('search') }}" method="get">
<input name="q" type="text" placeholder="请输入关键字">
<div style="padding: 0 500px 50px 450px;" > <form action="{{ url_for('search') }}" method="get" class="bs-example bs-example-form" role="form"> <div class="col-lg-6"> <div class="input-group"> <input name="q" type="text" class="form-control" placeholder="请输入关键字"> <span class="input-group-btn"> <button class="btn btn-default" type="submit"> 搜索 </button> </span> </div><!-- /input-group --> </div><!-- /.col-lg-6 --> </form> </div>
3.完成视图函数search()
- 获取搜索关键字
q = request.args.get('q’) - 条件查询
qu = Question.query.filter(Question.title.contains(q)).order_by('-creat_time’) - 加载查询结果:
return render_template('index.html', question=qu)
@app.route('/search') def search(): qu=request.args.get('q') ques=Question.query.filter(Question.title.contains(qu)).order_by('-creat_time') return render_template('shouye.html',question=ques)
4.组合条件查询
from sqlalchemy import or_, and_
@app.route('/search/') def search(): qu = request.args.get('q') ques = Question.query.filter( or_( Question.title.contains(qu), Question.detail.constraints(qu) ) ).order_by('creat_time') return render_template('shouye.html', question=ques)
运行结果为: