以下是筛选数据库中合适的数据并动态显示在网页上的代码
py文件中的部分代码:
sql = "select * from flower where id = %s"
mycursor.execute(sql, [pred_c_mysql, ])
data_list = mycursor.fetchall()
mycursor.close()
mydb.close()
print(data_list)
return render_template('pred.html', data_list=data_list)
HTML文件中的代码:
{% for item in data_list %}
<tr>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
</tr>
{% endfor %}
上面双括号里是item.id等六个属性,为啥能在pycharm中显示data_list,网页上显示不出来呢![](http://static.tieba.baidu.com/tb/editor/images/client/image_emoticon9.png)
py文件中的部分代码:
sql = "select * from flower where id = %s"
mycursor.execute(sql, [pred_c_mysql, ])
data_list = mycursor.fetchall()
mycursor.close()
mydb.close()
print(data_list)
return render_template('pred.html', data_list=data_list)
HTML文件中的代码:
{% for item in data_list %}
<tr>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
<td>{{ }}</td>
</tr>
{% endfor %}
上面双括号里是item.id等六个属性,为啥能在pycharm中显示data_list,网页上显示不出来呢
![](http://static.tieba.baidu.com/tb/editor/images/client/image_emoticon9.png)