Flask - best way to include HTML inside a template, where the HTML is a string variable

Question

For this route:

@app.route("/<string:c_id>/br")
def br(c_id):
    mydb = mysql.connector.connect(...)
    mycursor = mydb.cursor()
    mycursor.execute("USE ...)
    mycursor.execute("SELECT * FROM Bank;")
    BR = mycursor.fetchone()
    BR = BR[1]
    mydb.close()
    return render_template('twelve.html',BR=BR,c_id=c_id)

BR is a string, written in HTML, e.g. BR = r'<h1>To sort </h1> <i>to be completed</i>' Which is part of a database. Fetching BR from the database gives: <h1>To sort </h1> <i>to be completed</i>

I would like to include this into my template - twelve.html

twelve.html:

{% extends "layout.html" %}
{% block title %}This Page{% endblock %}
{% block head %}
  {{ super() }}
  <style type="text/css">
    .important { color: #336699; }
  </style>
{% endblock %}
{% block content %}

<h2>This Page</h2>

{{ BR }}

{% endblock %}

Currently the webpage reads,<h1>To sort </h1> <i>to be completed</i>

How do I get it to read the HTML tags, and use them? So it actually looks something like this:

To sort

to be completed

John · Accepted Answer · 2020-05-26 10:42:16Z

1

Try this:

{{ BR|safe }}

This is called a filter. Read more about them here.

answered May 26, 2020 at 10:42

John

922 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Flask - best way to include HTML inside a template, where the HTML is a string variable

To sort

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

To sort

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related