Linking html, python and sql

Question

I'm trying to link html form with python and sql. My requirement is that the user gives an input and that input should be sent to some python function block to execute an sql statement on MS SQL Server and return the results back to the user. Please help in linking the below code : order.html

<html>
<form action="/order" method="POST">
<input type="text" name="month">
<input type="number" name="weekno">
<input type="submit">
</form>
The stock for {{weekno}} is xyz
</html>

order.py :

from flask import Flask,render_template
import sys

app = Flask(__name__)

@app.route('/order', method=['POST'])
def orderdb() :
    # using sql server connection statement here
    cursor = connection.cursor ()
    cursor.execute ("select month,stock from salesdb where weeknumbr=?",weekno)
    return render_template('order.html',weekno = weekno)

This is a sample code i'm using here instead of pasting complete code.

Please suggest the syntax to be used so that the query should take the weekno value from the form and execute the query based on weeknumbr condition.

Thanks!!

Aleksandr Kovalev · Accepted Answer · 2015-05-27 14:22:35Z

1

To get value from form, in your case, you should do this:

from Flask import request

...

weekno = int(request.form['weekno'])

I suggest you to read this Flask Quickstart

answered May 27, 2015 at 14:22

Aleksandr Kovalev

3,7794 gold badges37 silver badges36 bronze badges

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

Comments

Jaimin Soni · Accepted Answer · 2015-05-27 16:38:56Z

0

from flask import request
from flask.ext.mysqldb import MySQL

mysql = MySQL(app)
...

month, weekno = request.form['month'], request.form['weekno']
cursor = connection.cursor ()
cursor.execute ("select month,stock from salesdb where weeknumbr=?",weekno)

cursor.execute() will return the number of rows modified or retrieved, just like in PHP.

When performing a SELECT query, each row is represented in Python by an array. For the above SELECT query with columns ‘name’ and ‘phone_number’, you’ll end up with something like:

['Bob', '9123 4567']

cursor.fetchall() will return you an array containing each row in your query results. That is, you get an array of arrays. So the above SELECT query might give you:

[['Bob', '9123 4567'], ['Janet', '8888 8888']]

The easiest thing to do with this is to iterate with something like:

data = cursor.fetchall()
for row in data :
    do stuff

You can also use cursor.fetchone() if you want to retrieve one row at a time. This is handy when you’re doing queries like "SELECT COUNT(*) ..." which only return a single row.

for simple example to use flask-mysql you could read these:

http://ianhowson.com/a-quick-guide-to-using-mysql-in-python.html

or you can read this for reference http://dev.mysql.com/doc/connector-python/en/connector-python-reference.html

edited May 27, 2015 at 16:38

Jaimin Soni

1,0691 gold badge13 silver badges30 bronze badges

answered May 27, 2015 at 15:40

Wendy Huang

12 bronze badges

2 Comments

shashi kanth Over a year ago

Hi! Thanks for a detailed explanation. I tried this but getting the below error: Bad request The browser (or proxy) sent a request that this server could not understand.

Wendy Huang Over a year ago

first import request from flask import Flask ,render_template, requestand modify @app.route('/order', method=['POST'])with@app.route('/order', methods = ['GET', 'POST']) then add ' if request.method == 'POST': or ' if request.method == 'GET': ' for detail please see this link @shashi-kanth

Collectives™ on Stack Overflow

Linking html, python and sql

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related