Breaking News: Grepper is joining You.com. Read the official announcement!

flask connect to mysql

Rey Luar Jr. answered on July 21, 2022 Popularity 10/10 Helpfulness 4/10

answer flask connect to mysql

related flask connect to mssql

flask connect to mysql

Comment

from flask import Flask,render_template, request
from flask_mysqldb import MySQL
 
app = Flask(__name__)
 
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = ''
app.config['MYSQL_DB'] = 'flask'
 
mysql = MySQL(app)
 
@app.route('/form')
def form():
    return render_template('form.html')
 
@app.route('/login', methods = ['POST', 'GET'])
def login():
    if request.method == 'GET':
        return "Login via the login Form"
     
    if request.method == 'POST':
        name = request.form['name']
        age = request.form['age']
        cursor = mysql.connection.cursor()
        cursor.execute(''' INSERT INTO info_table VALUES(%s,%s)''',(name,age))
        mysql.connection.commit()
        cursor.close()
        return f"Done!!"
 
app.run(host='localhost', port=5000)

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.askpython.com

Tags: connect flask mysql sql

Link to this answer
Share Copy Link

Contributed on Jul 21 2022

Rey Luar Jr.

0 Answers Avg Quality 2/10

Closely Related Answers

flask connect to mssql

Comment

# Python 2.x
import urllib
params = urllib.quote_plus("DRIVER={SQL Server Native Client 10.0};SERVER=dagger;DATABASE=test;UID=user;PWD=password")
engine = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)

# Python 3.x
import urllib
params = urllib.parse.quote_plus("DRIVER={SQL Server Native Client 10.0};SERVER=dagger;DATABASE=test;UID=user;PWD=password")
engine = create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)


# using the above logic I just did the following
params = urllib.parse.quote_plus('DRIVER={SQL Server};SERVER=HARRISONS-THINK;DATABASE=LendApp;Trusted_Connection=yes;')
app.config['SQLALCHEMY_DATABASE_URI'] = "mssql+pyodbc:///?odbc_connect=%s" % params

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: connect

Link to this answer
Share Copy Link

Contributed on Nov 14 2022

S3NS4

0 Answers Avg Quality 2/10

flask connect to mysql

Contents

More Related Answers

flask connect to mysql

Closely Related Answers

flask connect to mssql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.