I'm looking to output my db row info though am getting nothing but a blank page instead.
Here is my python code which works:
@app.route("/")
@login_required
def index():
"""Show portfolio of stocks"""
#if(session.get("user_id") > 0):
userRows = db.execute("SELECT * FROM users WHERE id = :id", id=session.get("user_id"))
portfolioRows = db.execute("SELECT * FROM portfolio WHERE userID = :id", id=session.get("user_id"))
stockHeader = "HERE IS YOUR STOCK PORTFOLIO"
return render_template("index.html")
#else:
#return render_template("index.html")
Here is my HTML:
<main class="container p-5">
{% block main %}
<h1>{{ stockHeader }}</h1>
{% for stock in portfolioRows %}
<strong>Name:</strong> {{ stock.stockName }} <br>
<strong>Price:</strong> {{ stock.stockPrice }} <br>
<strong>Symbol:</strong> {{ stock.stockSymbol }} <br>
{% endfor %}
{% endblock %}
</main>