实现搜索功能
1 @app.route('/search/') 2 def search(): 3 cha=request.args.get('q') 4 chaxun=Wenda.query.filter( 5 or_( 6 Wenda.title.contains(cha), 7 Wenda.detail.contains(cha) 8 )).order_by('-creat_time') 9 return render_template('moban.html',wenda=chaxun)
1 <form action="{{ url_for('search')}}" method="get" class="navbar-form navbar-left" role="search"> 2 <div class="form-group"> 3 <input type="text" id="q" name="q" autocomplete="off" placeholder="搜索" class="search-input" data-mounted="1">
1 from sqlalchemy import or_, and_