app8.py

#!/usr/bin/python
from flask import Flask, request, redirect, render_template
from flask_mysqldb import MySQL
app = Flask(__name__)

## Configure DB
app.config['MYSQL_HOST'] = '127.0.0.1'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = 'root123'
app.config['MYSQL_DB'] = 'flaskapp'

mysql = MySQL(app)

@app.route('/')
def index():
        return render_template('methods.html')


@app.route('/update/<serial1>/<name1>', methods=['GET', 'POST'])
def update(serial1,name1):
        cur = mysql.connection.cursor()
	cur.execute("SELECT * from users where serial ='" + serial1 + "' and name ='" + name1 + "'")
	data = cur.fetchone()
	if data is None:
		return "Authentication Failure"
	else:
        	if request.method == 'POST':
                	userDetails = request.form
                	serial = userDetails['serial']
                	name = userDetails['name']
                	email = userDetails['email']
                	cur.execute("INSERT INTO users(serial,name, email) VALUES(%s,%s, %s)",(int(serial),name, email))
                	mysql.connection.commit()
	                cur.close()
#	                return redirect('/users/<serial1>/<name1>', serial1=serial1, name1=name1)
			url = "/users/" + serial1 + "/" + name1
	                return redirect(url)
        	return render_template('index.html')
#                cur = mysql.connection.cursor()
#		cur.execute("SELECT * from users where serial ='" + serial1 + "' and name ='" + name1 + "'")
#		data = cur.fetchone()
#		if data is None:
#			return "Authentication Failure"
#		else:	
#                	cur.execute("INSERT INTO users(serial,name, email) VALUES(%s,%s, %s)",(int(serial),name, email))
#                	mysql.connection.commit()
#                cur.close()
#                return redirect('/users')
#        return render_template('index.html')

@app.route('/users/<serial1>/<name1>')
def users(serial1,name1):
        cur = mysql.connection.cursor()
	cur.execute("SELECT * from users where serial ='" + serial1 + "' and name ='" + name1 + "'")
	data = cur.fetchone()
	if data is None:
		return "Authentication Failure"
	else:
        	resultValue = cur.execute("SELECT * from users")
        	if resultValue > 0:
                	userDetails = cur.fetchall()
                	return render_template('users.html', userDetails=userDetails)
	cur.close()

@app.route('/Authenticate', methods=['GET','POST'])
def Authenticate():
        if request.method == 'POST':
                userDetails = request.form
                serial = userDetails['serial']
                name = userDetails['name']
                cursor = mysql.connection.cursor()
                cursor.execute("SELECT * from users where serial ='" + serial + "' and name ='" + name + "'")
                data = cursor.fetchone()
                if data is None:
                        return index()
                else:
                        return "Logged in successfully"
        return render_template('index1.html')


if __name__ == '__main__':
        app.run(debug=True,host='0.0.0.0',port='5000')