评论列表显示及排序，个人中心显示

最新推荐文章于 2024-08-12 01:25:53 发布

weixin_30426065

最新推荐文章于 2024-08-12 01:25:53 发布

阅读量59

点赞数

文章标签：前端 ViewUI

原文链接：http://www.cnblogs.com/guomeiting/p/8034493.html

版权

显示所有评论
{% 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.各个页面链接到个人中心

usercenter.html

<!doctype html>
 <html lang="en">
 <head>
 
     <style>
        .nav_ul li{
             float: left;
            list-style: none;
             margin: 10px;
             border-bottom: outset;
        }
     </style>
     <meta charset="UTF-8">
     <meta name="viewport"
           content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
     <meta http-equiv="X-UA-Compatible" content="ie=edge">
     <title>个人中心</title>
 </head>
 <body>
 <ul class="nav_ul">
     <li role="presentation"><a href="#">全部提问</a></li>
     <li role="presentation"><a href="#">全部评论</a></li>
     <li role="presentation"><a href="#">个人信息</a></li>
 
 </ul>
  <div class="col-md-6 column ">
         <div class="page-header">
         {% for foo in wenda %}
             <div class="panel panel-default">
                 <div class="panel-heading">
                     <h3 class="panel-title">
                         <a href="{{ url_for('detail',wenda_id=foo.id) }}">标题:{{ foo.title }}</a><br>
                     </h3>
                     <a href="{{ url_for('usercenter',user_id=foo.author_id) }}">作者：{{ foo.author.username }}</a>
                 </div>
 
                 <div class="panel-body">
                     <a href="#">内容:{{ foo.detail }}</a><br>
                 </div>
                 <div class="panel-footer">
                     <span class="badge" style="margin-left: 60%">{{ foo.creat_time }}发布时间</span>
                 </div>
             </div>
             {% endfor %}
         </div>
     </div>
 
     <div class="col-md-6 column ">
    <div class="page-header">
       {% for foo in comments %}
         <li class="list-group-item">
            <a href="{{ url_for('usercenter',user_id=foo.author_id) }}">{{ foo.author.username }}</a>
             <span class="badge pull-right">{{ foo.create_time }}</span>
             <p>{{ foo.detail }}</p>
             <br>
         </li>
     </div>
         {% endfor %}
 </body>
 </html>

py文件

class Comment(db.Model):
    __tablename__ = 'comment'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    title = db.Column(db.String(100), nullable=False)
    detail = db.Column(db.Text, nullable=False)
    creat_time = db.Column(db.DateTime, default=datetime.now)
    author_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    wenda_id = db.Column(db.Integer,db.ForeignKey('wenda.id'))
    wenda = db.relationship('Wenda', backref=db.backref('comments', order_by=creat_time.desc))
    author = db.relationship('User', backref=db.backref('comments'))

@app.route('/usercenter/<user_id>')
  @loginFirst
  def usercenter(user_id):
      user = User.query.filter(Wenda.id == user_id).first()
      context={
          'username':user.username,
         'wenda':user.wenda,
          'comments':user.comments
      }
     return render_template('usercenter.html',**context)

<a href="{{ url_for('usercenter',user_id=foo.author.id) }}">{{ foo.author.username }} 评论：({{ foo.comments|length }})</a>

转载于:https://www.cnblogs.com/guomeiting/p/8034493.html

weixin_30426065

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
评论列表显示及排序，个人中心显示

显示所有评论{% for foo in ques.comments %}所有评论排序uquestion = db.relationship('Question', backref=db.backref('comments', order_by=creat_time.desc))显示评论条数{{ ques.comments|length }}完成个人中心1.个人中心的页面...
复制链接

扫一扫