Displaying Data from MySQL on Flask Python

Question

Does this work? and stored it in a database, now I want to display the same data on my own website, but it doesn't work. Help please!

@auth.route('/')
def home():
    def GetBookLink():
        mydb = mysql.connector.connect(
                    host='localhost',
                    user = 'Salahudheen',
                    passwd = 'Salahudheen1!',
                    database = 'testdatabase'
                    )
        mycursor = mydb.mycursor()

        
        
        mycursor.execute("SELECT * FROM ScrapedBooks") 
        DBData = mycursor.fetchall() 
        mycursor.close()
         

    return render_template("home.html", ScrapedBookData = DBData)

HTML :

{% extends "base.html"%} {% block title %}Home{% endblock %}{% block content %}    
<h1>{{ScrapedBookData}}</h1>
{% endblock %}

Of course this isn't the format I'm going to display it in, but I just want to learn how to display it first

Daweo · Accepted Answer · 2022-02-14 13:41:48Z

1

You defined GetBookLink function inside home function and never calls former. GetBookLink function is also missing return statement. Please try follwing code which is minimal change repair:

@auth.route('/')
def home():
    def GetBookLink():
        mydb = mysql.connector.connect(
                    host='localhost',
                    user = 'Salahudheen',
                    passwd = 'Salahudheen1!',
                    database = 'testdatabase'
                    )
        mycursor = mydb.mycursor()

        
        
        mycursor.execute("SELECT * FROM ScrapedBooks") 
        DBData = mycursor.fetchall() 
        mycursor.close()
        return DBData
         
    DBData = GetBookLink()
    return render_template("home.html", ScrapedBookData = DBData)

answered Feb 14, 2022 at 13:41

Daweo

38.2k3 gold badges17 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Displaying Data from MySQL on Flask Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related