Spaces:
Runtime error
Runtime error
File size: 615 Bytes
d6a5921 0c2a4c6 1a1368c 0c2a4c6 d6a5921 1a1368c d6a5921 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
from flask import Flask, render_template
import pymysql
app = Flask(__name__)
def get_connection():
return pymysql.connect(
host="bnadwttldj2i5cq9aymp-mysql.services.clever-cloud.com",
user="uvfqvcypihhznd2u",
port=3306,
password="CX6TBadRQYFqprozqDTo",
database="bnadwttldj2i5cq9aymp"
)
@app.route("/")
def index():
db = get_connection()
cursor = db.cursor()
cursor.execute("SELECT * FROM users")
data = cursor.fetchall()
cursor.close()
db.close()
return render_template("index.html", data=data)
if __name__ == "__main__":
app.run(host="0.0.0.0", port=5000) |