Data table python flask

Question

I have a question regarding mysql db python table in Bootstrap.

My question is my data is not shown in the table. I can see it gets data because of when I add row in mysql db with data the table increases.

app.py code:

@app.route('/dashboard')
@is_logged_in
def dashboard():
       #create cursor
    cur = mysql.get_db().cursor()
    #Get data
    result = cur.execute("SELECT * FROM test")
    data=cur.fetchall()
    if result > 0:
        return render_template('dashboard.html', data=data)
    else:
        msg = 'No DOC Found'
        return render_template('dashboard.html', msg=msg)
    #close connection
    cur.close()
    return render_template('dashboard.html' )

.html

  <table class="table table-striped">
              <tr>
                   <th>data1</th>
                   <th>data2</th>
              </tr>
              {% for test in data%}
              <tr>
                   <td>{{test.rdno}}</td>
                   <td>{{test.ipno}}</td>

                {% endfor %}
              </tr>
          </table>

Have you checked this question for a possible solution: stackoverflow.com/questions/9845102/using-mysql-in-flask — Chuck LaPress
– Chuck LaPress, Commented Sep 20, 2018 at 12:31

ABU · Accepted Answer · 2018-09-20 13:56:12Z

1

instead of

<td>{{test.rdno}}</td>
<td>{{test.ipno}}</td>

do this

  <td>{{test[0]}}</td>
  <td>{{test[1]}}</td>

answered Sep 20, 2018 at 13:56

ABU

1072 gold badges4 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data table python flask

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related