评论列表显示及排序,个人中心显示
- 显示所有评论
{% for foo in ques.comments %} - 所有评论排序
uquestion = db.relationship('Question', backref=db.backref('comments', order_by=creat_time.desc)) - 显示评论条数
{{ ques.comments|length }} - 完成个人中心
1.个人中心的页面布局(html文件及相应的样式文件)
2.定义视图函数def usercenter(user_id):
3.向前端页面传递参数
4.页面显示相应数据
发布的全部问答
发布的全部评论
个人信息
5.各个页面链接到个人中心
{% extends'danghangye.html' %} {% block title %}详情页{% endblock %} {% block head %} <script src="https://cdn.bootcss.com/bootstrap/4.0.0-beta/css/bootstrap.min.css"></script> {% endblock %} {% block main %} <div> <div> <P align="center" style="background-color:rgba(255,255,0,0.25)"></P> <ur class="sss" style="background-color:rgba(255,255,0,0.25)"> <p>发布({{fankui|length}})</p> {% for foo in fankui %} <li class="list"> <span class="glyphicon" aria-hidden="true"></span> <a href="#">{{foo.author.username}}</a> <br> <a href="{{url_for('详情页',fankui_id = foo.id )}}">{{foo.biaoti}}</a> <span class="badge">{{foo.creat_time}} </span> <p>{{foo.questionDetail}}</p> </li> {% endfor %} </ur> </div> <div> <P align="center" style="background-color:rgba(255,255,0,0.25)"></P> <h3><span class="glyphicon glyphicon-user" aria-hidden="true"></span>{{user}}<br><small>全部评论({{comment|length}})<span class="badge"></span></small></h3> <ur class="sss" style="background-color:rgba(255,255,0,0.25)"> {% for foo in comment %} <li class="list"> <span class="glyphicon" aria-hidden="true"></span> <a href="#">{{foo.author.username}}</a> <br> <a href="{{url_for('详情页',fankui_id = foo.id )}}">{{foo.biaoti}}</a> <span class="badge">{{foo.creat_time}} </span> <p>{{foo.detail}}</p> </li> {% endfor %} </ur> </div> <div> <h3><span class="glyphicon glyphicon-user" aria-hidden="true"></span>{{user}}<br><small>个人信息 <span class="badge"></span></small></h3> <ul class="list-group"> <li class="list-group-item">用户:{{username}}</li> <li class="list-group-item">编号:</li> <li class="list-group-item">昵称:</li> </ul> </div> </div> {% endblock %}
@app.route('/person/<user_id>') @loginFirst def person(user_id): user = User.query.filter(User.id ==user_id).first() context = { 'username': user.username, 'fankui':user.fankui, 'comment':user.comment }
<!DOCTYPE html> <html lang="en"> <head> {% block head %}{% endblock %} <meta charset="UTF-8"> <title>{% block title %}{% endblock %}首页</title> <nav style="background-color: slategray"> <img src="http://cdn2.jianshu.io/assets/web/logo-58fd04f6f0de908401aa561cda6a0688.png" width="40px"> <link rel="stylesheet" href="{{url_for('static',filename='css/loginMy.css')}}"> <script type="text/javascript" src="../static/js/switch.js"></script> <img src="{{url_for('static',filename='image/yezi.jpg')}}" alt="wo" width="50px"> {% if username %} <a href="{{url_for('person',user_id = author_id)}}"> {{username}}</a> <a href="{{url_for('logout')}}">注销</a> <a href="{{url_for('edit')}}">编辑</a> {% else %} <a href="{{url_for('login')}}">login</a> <a href="{{url_for('register')}}">register</a> {% endif %} <a href="{{url_for('fankui')}}">fankui</a> <a href="{{url_for('danghangye')}}">首页</a> <img id="myOnOff" onclick="mySwitch()" src="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1509532539555&di=5c7e5df90fa122e5a6dcae2de5fb45d5&imgtype=0&src=http%3A%2F%2Fwww.jbhdq.com%2Fuploadfile%2F2016%2F0617%2F20160617103213932.jpg" width="40px"> <input class="input_control" type="text" placeholder="" name="" size="10" ><button>搜索</button> </nav> <!--<script>--> <!--function mySwitch() {--> <!--var oBody= document.getElementById("myBody");--> <!--var oOnoff=document.getElementById("myOnOff");--> <!--if(oOnoff.src.match("b9999_")){--> <!--oOnoff.src="https://ss0.bdstatic.com/94oJfD_bAAcT8t7mm9GUKT-xh_/timg?image&quality=100&size=b4000_4000&sec=1509520370&di=f7ae57dab90eab30c78e8f4733607b02&src=http://pic29.photophoto.cn/20131121/0017029581107509_b.jpg";--> <!--oBody.style.background="black";--> <!--oBody.style.color="yellow";--> <!--}else{oOnoff.src="https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1509532539555&di=5c7e5df90fa122e5a6dcae2de5fb45d5&imgtype=0&src=http%3A%2F%2Fwww.jbhdq.com%2Fuploadfile%2F2016%2F0617%2F20160617103213932.jpg";--> <!--oBody.style.background="white";--> <!--oBody.style.color="black";--> <!--}--> <!--}--> <!--</script>--> </head> <body id="myBody"> {% block main %} <P align="center" style="background-color:rgba(255,255,0,0.25)">{{username}}请登录</P> <ur class="sss" style="background-color:rgba(255,255,0,0.25)"> {% for foo in fankui %} <li class="list"> <span class="glyphicon" aria-hidden="true"></span> <a href="{{url_for('person',user_id = foo.author_id)}}">{{foo.author.username}}评论({{foo.comment|length}})</a> <br> <a href="{{url_for('详情页',fankui_id = foo.id )}}">{{foo.biaoti}}</a> <span class="badge">{{foo.creat_time}} </span> <p>{{foo.questionDetail}}</p> </li> {% endfor %} </ur> {% endblock %} </body> </html>