I am using the below code :
def static_info(nm):
cursor.execute("SELECT name,age,FROM MyDB where name like ?",(nm) + '%')
for row in cursor:
static={"NAME: ":row[0],"AGE: ":row[1]}
return(static)
@app.route('/submit_form')
def submit_form():
nm = request.form.get('name')
info=static_info(nm)
return render_template('static_display.html',info=info)
I need the desired function output (in the form of dictionary) on my static_display.html page
Any suggestions?
Strange coding.
Your loop in static_info(nm) will only return the last item. You're not appending anything
Your @app.route('/submit_form') does not accepts POSTs. You need:
@app.route('/submit_form', methods = ['GET', 'POST'])
In your template static_display.html, you will want {{ info }}
If you change your code so you can loop over a list in your template, you will want something like:
{% for item in info %}
{% for key, value in item.items() %}
{{ key }} : {{ value }}
{% endfor %}
{% endfor %}
