Timothy

1. 安裝 falsk-mysql 套件

2.設定 連線  app\__init__.py

from flaskext.mysql import MySQL
from flask import Flask
app = Flask(__name__)
mysql = MySQL()
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = ''
app.config['MYSQL_DATABASE_DB'] = 'test'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)

3.使用方式 views.py

from app import mysql

@app.route('/MyHtml')
def MyHtml():  
    conn = mysql.connect()
    cursor=conn.cursor()
    cursor.execute('SELECT * FROM test.new_table limit 50')

    return render_template(
       'MyHtml.html',     
        mydata=cursor,         
    )