In flask, how can I modify html with code in python?

Question

This is the "apprunner.py" of my flask

   from flask import *
   from flaskext.mysql import MySQL

   enter code hereapp = Flask(__name__)


   mysql = MySQL()
   app.config['MYSQL_DATABASE_USER'] = 'root'
   app.config['MYSQL_DATABASE_PASSWORD'] = 'myPassword'
   app.config['MYSQL_DATABASE_DB'] = 'myDB'
   app.config['MYSQL_DATABASE_HOST'] = 'localhost'
   mysql.init_app(app)



  conn = mysql.connect()
  cursor =conn.cursor()

  cursor.execute("SELECT * from clients")
  data = cursor.fetchall()



 @app.route("/")
 def index():
   return render_template("index.html")

 if __name__ == "__main__":
   app.run(debug=True)

and this is my index.html file:

 <!DOCTYPE html>
     <head>
         <!-- some code here-->
     </head>
     <body>
         <div id='info_section'>
         </div>
     </body>
 </html>

In the data variable in the "apprunner.py" file, it contains all the entries of the "clients" table as a form of tuples. What I want to do is load the clients info from the clients table into the block in the html file whose id is "info_section". How can achieve it in python?

Refer Jinja templating . You need to pass your data to you template i.e index.html as argument. in this way render_template('index.html',data)...In your html page write templating. — Madhusudan chowdary
– Madhusudan chowdary, Commented Jun 14, 2018 at 18:36

ltd9938 · Accepted Answer · 2018-06-14 18:49:41Z

2

You need to pass the data to the template like so.

return render_template("index.html", data=data)

Then in the HTML file you can loop through the data like this.

<div id='info_section'>
    {% for data in data %}
        <p>{{ data }}</p>
    {% endfor %}
</div>

If you want to access a column of the entry you can do <p>{{ data.whatever_attribute }}</p>

edited Jun 14, 2018 at 18:49

answered Jun 14, 2018 at 18:33

ltd9938

1,4541 gold badge17 silver badges29 bronze badges

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

3 Comments

user9724045 Over a year ago

This is a good start. But, all it does is to load the data sequentially from for loop. However, if I want to enhance the loop. Let's say I want to display this element and the next element in one loop cycle. How am I supposed to do it?

ltd9938 Over a year ago

As in having two different objects or having two different attributes?

user9724045 Over a year ago

For example, the data variable in python is a list. ['apple','banana','cheese']. Now, I want to process 'apple' and 'banana' in the same loop cycle in the html inside the <div>. Am I able to do it?

Collectives™ on Stack Overflow

In flask, how can I modify html with code in python?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related