from flask import Flask, redirect, render_template, request, session,flash
from mysqlconnection import MySQLConnector
from os import urandom
from binascii import b2a_hex
from md5 import new as md5_new
import re
app = Flask(__name__)
mysql = MySQLConnector(app,"login")
app.secret_key = "LaLlaveSecreta"
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
@app.route('/')
def index():
if "logged_in" not in session:
session["logged_in"] = False
if "current_user" not in session:
session["current_user"] = ""
if session["logged_in"]:
return render_template('user.html')
else:
return render_template('index.html')
@app.route('/login',methods=["GET","POST"])
def login():
if request.method == "GET":
return render_template('login.html')
else:
email = request.form["email"]
password = request.form["password"]
from flask import Flask, render_template, redirect, flash, request as req, session, Blueprint
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app, 'the_wall')
wall = Blueprint('wall',
__name__,
template_folder='../templates',
static_folder='static')
# def format_datetime(value, format='medium'):
# if format == 'full':
# format="EEEE, d. MMMM y 'at' HH:mm"
# elif format == 'medium':
# format="EE dd.MM.y HH:mm"
# return babel.dates.format_datetime(value, format)
#
# jinja_env.filters['datetime'] = format_datetime
def getPostsWithUsers():
post_query = "SELECT posts.*, users.first_name, users.last_name FROM posts \
LEFT JOIN users ON users.id = posts.user_id"
posts = mysql.query_db(post_query)
return posts
def getComments():
comment_query = "SELECT comments.*, users.first_name, users.last_name FROM comments \
from flask import Flask, redirect, render_template, request, flash
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app, 'full_friends')
app.secret_key = "supersecretkey"
@app.route('/')
def index():
query = "SELECT * FROM friend;"
data = mysql.query_db(query)
return render_template('index.html', data=data)
@app.route('/friends', methods=["POST"])
def create():
query = """INSERT INTO friend (first_name, last_name, email, created_at, updated_at)
VALUES (:first_name, :last_name, :email, NOW(), NOW());"""
data = {
'first_name': request.form['fname'],
'last_name': request.form['lname'],
'email': request.form['email']
}
mysql.query_db(query, data)
flash("Saved {} into the database!".format(request.form['fname']))
return redirect('/')
@app.route('/friends/<id>/edit')
def edit(id):
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
import re, md5, os, binascii
app = Flask(__name__)
app.secret_key = 'keepitsecretkeepitsafe'
mysql = MySQLConnector(app, 'usersdb')
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
NAME_REGEX = re.compile(r'^[a-zA-Z]+$')
PASSWORD_REGEX = re.compile(
r"^.*(?=.{8,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[@#$%^&+=]).*$")
@app.route('/')
def index():
if not 'id' in session:
session['id'] = None
query = "SELECT * FROM users"
users = mysql.query_db(query)
return render_template('index.html', users=users)
@app.route('/users')
def users():
# insert code for use on /users
return render_template('users.html')
@app.route('/login', methods=['POST'])
def login():
eMail = request.form['email']
from flask import Flask, render_template, redirect, flash, request, session
import re
import os, binascii
import datetime
from mysqlconnection import MySQLConnector
import md5
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = 'poquitoPOQUITO'
mysql = MySQLConnector(app, 'login_registration')
salt = binascii.b2a_hex(os.urandom(15))
@app.route('/')
def index():
return render_template('index.html')
@app.route('/home')
def home():
return render_template('success.html')
@app.route('/validate', methods=['post'])
def validate():
##REGISTRATION VALIDATION
if request.form['validate'] == 'register':
session['first_valid'] = False
session['last_valid'] = False
session['is_logged_in'] = False
# The Wall - Version 2
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
from hashlib import md5
import re
app = Flask(__name__)
app.secret_key = 'Godzilla'
mysql = MySQLConnector(app, 'TheWall')
# index
@app.route('/', methods=['GET'])
def index():
session['loginid'] = 0
session['registered'] = 0
return redirect('/TheWall')
@app.route('/TheWall', methods=['GET'])
def main():
if 'loginid' not in session:
session['loginid'] = 0
if 'registered' not in session:
session['registered'] = 0
if session['loginid'] > 0:
flash('Logged in')
#return render_template('messages.html', userID = session['loginid'])
return redirect('/Messages')
if session['registered'] > 0:
flash('Registered')
from flask import Flask, render_template, redirect, session, flash, request
from mysqlconnection import MySQLConnector
from flask.ext.bcrypt import Bcrypt
app = Flask(__name__)
bcrypt = Bcrypt(app)
app.secret_key = "secretKey"
mysql = MySQLConnector(app, 'app')
@app.route("/")
def index():
session['logged'] = False
return render_template('index.html')
@app.route("/register")
def reg():
return render_template('registration.html')
@app.route("/login", methods=['POST'])
def login():
email = request.form['email']
pwd = request.form['password']
query = "select * from users where email = :email limit 1"
if mysql.query_db(query, {"email": email}):
data = mysql.query_db(query, {"email": email})
else:
return redirect("/register")
from flask import Flask, request, redirect, render_template, flash, session, url_for, abort
from mysqlconnection import MySQLConnector
from flask_bootstrap import Bootstrap
import os
import re
app = Flask(__name__)
mysql = MySQLConnector(app, 'semidb')
app.secret_key = os.urandom(24)
Bootstrap(app)
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
# /////////////////// Index() = home ///////////////////
@app.route('/') #Takes you to the front(login) page
def index():
if 'logged_id' in session:
return redirect('/users')
users = mysql.query_db('SELECT * FROM users')
print users
return render_template('index.html')
# /////////////////// Logging In ///////////////////
@app.route('/login', methods=['POST']) #Logging in/Session starts
def login():
query = "SELECT * FROM users WHERE email = :email"
data = {'email': request.form['email']}
from flask import Flask, request, redirect, render_template, session, flash, jsonify
from mysqlconnection import MySQLConnector
app = Flask(__name__)
app.secret_key = "ThisIsSecret"
mysql = MySQLConnector(app, 'notes')
@app.route('/')
def index_home():
query = "SELECT * FROM notes"
notes = mysql.query_db(query)
return render_template('index.html', notes=notes)
@app.route('/notes/create', methods=['POST'])
def create():
query = "INSERT INTO notes(title, description, created_at, updated_at) VALUES('{}', '{}', now(), now())".format(
request.form['add_title'], request.form['add_description'])
mysql.query_db(query)
query = "SELECT * FROM notes"
notes = mysql.query_db(query)
return render_template('partials/notes.html', notes=notes)
# import Flask
from flask import Flask, render_template, redirect, request, session, flash
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app, 'Email_Validation')
import re
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = "ThisIsSecret!"
#
# @app.route('/process', methods=['POST'])
# def submit():
@app.route('/', methods=['GET'])
def index():
query = "SELECT * FROM email"
email = mysql.query_db(query)
return render_template('result.html', all_email=email)
# return redirect('/result.html')
@app.route('/email', methods=['POST'])
def create():
if len(request.form['email']) < 1:
flash("Email cannot be blank!")
if not EMAIL_REGEX.match(request.form['email_address']):
from flask import Flask, flash, render_template, request, redirect, session, jsonify
from mysqlconnection import MySQLConnector
import os
import binascii
import md5
import re
# Set the port flask will listen on #
PORT = 5000
app = Flask(__name__)
app.secret_key = "Th!5Is$uPeRSecr37"
mysql = MySQLConnector(app, 'storedb')
stores = [{
'name': 'My Wonderful Store',
'items': [{
'name': 'My Item',
'price': 15.99
}]
}]
@app.route('/')
def index():
return render_template('index.html')
# POST /store data: {name:}
@app.route('/store', methods=['POST'])
from flask import Flask, render_template, request, redirect, session, flash
from mysqlconnection import MySQLConnector
app = Flask(__name__)
app.secret_key = "secret_key"
mysql = MySQLConnector(app, "sakila")
@app.route("/")
def index():
query = "SELECT film_id, title FROM film;"
films = mysql.query_db(query)
return render_template("index.html", films=films)
@app.route("/film/<film_id>")
def show(film_id):
query = "SELECT * FROM film WHERE film_id=:film_id"
data = {"film_id": film_id}
film = mysql.query_db(query, data)[0]
query = """SELECT * FROM actor
LEFT JOIN film_actor ON actor.actor_id=film_actor.actor_id
WHERE film_actor.film_id=:film_id;"""
actors = mysql.query_db(query, data)
return render_template("show.html", film=film, actors=actors)
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
import md5
<<<<<<< HEAD
import re
app = Flask(__name__)
mysql = MySQLConnector(app,'reddit')
app.secret_key = "ThisIsSecret!"
USERNAME_REGEX= re.compile(r'[a-zA-Z0-9.+_-]')
@app.route('/', methods=['GET'])
def index():
if 'user_id' in session and 'username' in session:
return redirect('/user')
=======
app = Flask(__name__)
mysql = MySQLConnector(app,'reddit')
@app.route('/')
def index():
query = "SELECT * FROM users"
users = mysql.query_db(query)
>>>>>>> refs/remotes/origin/master
# -- subreddit posts --
subpost_query="SELECT posts.text, posts.created_at, users.username, subreddits.url FROM posts JOIN users ON posts.user_id=users.id JOIN subreddits ON posts.subreddit_id=subreddit_id LIMIT 0,50"
subposts=mysql.query_db(subpost_query)
<<<<<<< HEAD
from flask import Flask, request, render_template, redirect, jsonify
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app, 'world') #make sure the db name matches your world database
@app.route('/')
def index():
return render_template('index.html')
@app.route('/countries')
def countries():
countries = mysql.query_db("SELECT * FROM countries")
print countries
return jsonify(countries)
@app.route('/countries/<id>/destroy')
def destroy(id):
query = "DELETE FROM countries WHERE id = :id"
data = {'id': id}
mysql.query_db(query, data)
country = mysql.query_db("SELECT * FROM countries WHERE id = "+id)
if country:
return jsonify({'status': False})
else:
return jsonify({'status': True})
app.run(debug=True)
from flask import Flask, request, redirect, render_template, session, flash
# import the Connector function
from mysqlconnection import MySQLConnector
import md5, os, binascii # do this at the top of your file where you import modules
app = Flask(__name__)
# connect and store the connection in "mysql"; note that you pass the database name to the function
mysql = MySQLConnector(app, 'userdemodb')
@app.route('/')
def index():
users_from_db = mysql.query_db('SELECT * FROM users')
print "*" * 80
print 'Here is the query:', users_from_db
return render_template('index.html',
users=users_from_db,
title="User Dashboard")
@app.route('/users/create', methods=['POST'])
def create_user():
name = request.form['name']
email = request.form['email']
password = request.form['password']
errors = False
salt = binascii.b2a_hex(os.urandom(15))
from flask import Flask, render_template, request, redirect, flash, session, url_for
from mysqlconnection import MySQLConnector
from flask_bcrypt import Bcrypt
import re
app = Flask(__name__)
app.secret_key = "W12Zr47j\3yX R~X@Hu0|q\9!jmM]Lwf/,?KTW%"
EMAIL_REGX = re.compile(r'^[a-zA-Z0-9\.\+_-]+@[a-zA-Z0-9\._-]+\.[a-zA-Z]*$')
mysql = MySQLConnector(app, "loginAndRegdb")
bcrypt = Bcrypt(app)
@app.route("/")
def index():
#just render template: the login and the Registration form
return render_template("index.html")
@app.route("/register", methods=["POST"])
def register():
#validation process
if len(request.form["first_name"]) < 1 and len(
request.form["last_name"]) < 1:
flash("name cannot be empty! and name must be at least 2 characters",
"error")
return redirect("/")
if not EMAIL_REGX.match(request.form["email"]):
flash("Invalid email address!", "error")
return redirect("/")
if len(request.form["password"]) < 8:
flash("password must be at leat 8 characters!!!", "error")
from flask import Flask, redirect, request, render_template, session, flash
from mysqlconnection import MySQLConnector
import re
app = Flask(__name__)
app.secret_key = ("secret_key")
mysql = MySQLConnector(app, "mydb")
FIRST_NAME_REGEX = re.compile(r'^[a-zA-Z]+$')
LAST_NAME_REGEX = re.compile(r'^[a-zA-Z]*$')
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
@app.route('/')
def registration_page():
return render_template("registration.html")
@app.route('/wall')
def logged():
query1 = "SELECT users.first_name as first_name, users.last_name as last_name, messages.message as message, messages.id as messages_id, messages.users_id as message_users_id, DATE_FORMAT(messages.created_at, '%M %d %Y %T' ) as created_at FROM users JOIN messages on users.id=messages.users_id order by created_at desc"
messages = mysql.query_db(query1)
query2 = "SELECT users.first_name as first_name, users.last_name as last_name, comments.id as comments_id, comments.messages_id as message_id, comments.comment as comments, DATE_FORMAT(comments.created_at, '%M %d %Y %T') as created_at from users join comments on users.id=comments.users_id"
comments = mysql.query_db(query2)
return render_template("message.html",
all_messages=messages,
all_posts=comments)
@app.route('/login', methods=["POST"])
def user_login():
from flask import Flask, render_template, request, redirect, jsonify # jsonify lets us send JSON back!
# Import MySQLConnector class from mysqlconnection.py
from mysqlconnection import MySQLConnector
app = Flask(__name__)
'''
Set variable 'mysql' to be an instance of the MySQLConnector class,
taking our entire application as the first argument and the database
name as the second argument.
'''
mysql = MySQLConnector(app, 'myownapi')
@app.route('/quotes')
def index():
query = "SELECT * FROM quotes"
quotes = mysql.query_db(query)
return render_template('index.html', quotes=quotes)
@app.route('/quotes/index_json')
def index_json():
query = "SELECT * FROM quotes"
quotes = mysql.query_db(query)
return jsonify(quotes)
@app.route('/quotes/index_html')
def index_partial():
query = "SELECT * FROM quotes"
quotes = mysql.query_db(query)
return render_template('partials/quotes.html', quotes=quotes)
from flask import Flask, redirect, render_template, session, flash, request
from mysqlconnection import MySQLConnector
import re
email_regex = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = 'thisissecret'
mysql = MySQLConnector(app, 'email_val')
@app.route('/')
def index():
query = "SELECT * FROM email_val"
emails = mysql.query_db(query)
return render_template('index.html', all_emails=emails)
@app.route('/process', methods=['POST'])
def process():
is_valid = True
if len(request.form['email']) < 1:
is_valid = False
flash('Email cannot be empty')
elif not email_regex.match(request.form['email']):
flash('Invalid Email Address!')
is_valid = False
if is_valid == False:
return redirect('/')
else:
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
import re
app = Flask(__name__)
mysql = MySQLConnector(app, 'emails')
app.secret_key = 'KeepItSecretKeepItSafe'
email_lst = []
@app.route('/')
def index():
return render_template('index.html')
@app.route('/success')
def success():
query = "SELECT email_list.id AS id, email_list.email AS email, email_list.created_at AS times FROM email_list ORDER BY times DESC"
queries = mysql.query_db(query)
return render_template('success.html', queries=queries)
@app.route('/delete/<id>', methods=['POST'])
def delete(id):
query = "DELETE FROM email_list WHERE id = {}".format(id)
mysql.query_db(query)
session['message'] = "email deleted from list"
return redirect('/success')
from flask import Flask, redirect, request, session, flash, render_template
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app, 'Full Friends')
app.secret_key = 'thisIsSecret'
@app.route('/')
def home():
all_friends = mysql.query_db('select * from friends')
return render_template('index.html', friends=all_friends)
@app.route('/friends', methods=['POST'])
def addFriend():
first = request.form['html_first']
last = request.form['html_last']
email = request.form['html_email']
parameters = {
'first_name': first,
'last_name': last,
'email': email,
}
query = 'INSERT INTO friends(first_name, last_name, email, created_at) VALUES(:first_name, :last_name, :email, NOW())'
mysql.query_db(query, parameters)
return redirect('/')
@app.route('/friends/<ident>/edit', methods=['POST'])
def editFriend(ident):
session['id'] = ident
return render_template('editFriend.html', id=session['id'])
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
import datetime
app = Flask(__name__)
app.secret_key = "ThisIsSecret!"
mysql = MySQLConnector(app,'books')
# route to index
@app.route('/')
def index():
query = "SELECT * FROM books"
book_list = mysql.query_db(query)
return render_template('index.html', books=book_list)
# route to add book
@app.route('/add', methods=['get'])
def add():
return render_template("add.html")
# route to delete book
@app.route('/destroy/<book_id>', methods=['get'])
def destroy(book_id):
query = "SELECT * FROM books WHERE id = :id"
data = {
'id': book_id,
}
book_list = mysql.query_db(query, data)
return render_template("destroy.html", book=book_list)
from flask import Flask, render_template, request, redirect, session, flash
from mysqlconnection import MySQLConnector
import os, binascii # include this at the top of your file
import md5
import re
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = 'key_to_my_heart'
mysql = MySQLConnector(app, 'walldb')
@app.route('/')
def index():
return render_template('login.html')
@app.route('/login', methods=['POST'])
def login():
session['logged_in'] = False
login = request.form['loginId']
salt = binascii.b2a_hex(os.urandom(15))
pWord = request.form['loginPassword']
query = "SELECT * FROM users where email= :email LIMIT 1"
data = {'email': login}
user_query = mysql.query_db(query, data)
if (len(user_query)) > 0:
from flask import Flask, render_template, redirect, request, flash, session
from mysqlconnection import MySQLConnector
import re
# create a regular expression object that we can use run operations on
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = "my super secret key"
mysql = MySQLConnector(app, 'email_validations')
# 1 step render the index page
@app.route('/')
def index():
return render_template('index.html')
@app.route('/email', methods=['POST'])
def create():
# add form validations
print('1')
form_email = request.form['email']
is_valid = True
query = "SELECT * FROM emails WHERE email = :email_from_form"
data = {'email_from_form': form_email}
# check if email already exists in DB
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
import re
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = "ThisIsSecret!"
mysql = MySQLConnector(app, 'emailvalid')
@app.route('/')
def index():
return render_template('index.html')
@app.route('/process', methods=['POST'])
def submit():
if len(request.form['email']) < 1:
flash("Email cannot be blank!")
return redirect('/')
elif not EMAIL_REGEX.match(request.form['email']):
flash("Invalid Email Address!")
return redirect('/')
else:
query = "INSERT INTO emails (email, created_at, updated_at) VALUES (:email, NOW(), NOW())"
data = {
'email': request.form['email'],
}
mysql.query_db(query, data)
flash("Thank you for entering a valid email!")
return redirect('/success')
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app, "friendsdb")
@app.route("/")
def index():
query = "SELECT * FROM friends WHERE id"
friends = mysql.query_db(query)
return render_template("index.html", all_friends=friends)
# @app.route("/friends/<friend_id>")
# def show(friend_id):
# query = "SELECT * FROM friends WHERE id = :specific_id"
# data = {'specific_id': friend_id}
# friends = mysql.query_db(query, data)
# return render_template("index.html", one_friend=friends[0])
@app.route("/friends", methods = ["POST"])
def create():
query = "INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES (:first_name, :last_name, :occupation, now(), now())"
data = {
'first_name': request.form['first_name'],
'last_name': request.form['last_name'],
'occupation': request.form['occupation']
}
mysql.query_db(query, data)
return redirect("/")
@app.route('/update_friend/<friend_id>', methods=['POST'])
from flask import Flask, request, redirect, render_template, session, flash
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app,'friendsdb')
@app.route('/')
def index():
query = "SELECT * FROM friends"
friends = mysql.query_db(query)
return render_template('index.html', all_friends=friends)
@app.route('/friends', methods=['POST'])
def create():
query = "INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES (:first_name, :last_name, :occupation, NOW(), NOW())"
data = {
'first_name': request.form['first_name'],
'last_name': request.form['last_name'],
'occupation': request.form['occupation']
}
mysql.query_db(query, data)
return redirect('/')
@app.route('/friends/<friend_id>')
def show(friend_id):
query = "select * from friends where id = :specific_id"
data = {'specific_id': friend_id}
friends = mysql.query_db(query, data)
print friends[0]
return render_template('index.html', one_friend=friends[0])
app.run(debug=True)
from flask import Flask, render_template, request, redirect, session, flash
from mysqlconnection import MySQLConnector
import random
import datetime
import re
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = 'ThisIsSecret'
mysql = MySQLConnector(app, 'mydb')
@app.route('/')
def main():
query = "SELECT * FROM emails"
tmpEmail = mysql.query_db(query)
return render_template("email_validation.html")
@app.route('/email', methods=['POST'])
def validation():
session['email'] = request.form['email']
if len(request.form['email']) < 1:
flash("Email cannot be blank!")
return redirect('/')
elif not EMAIL_REGEX.match(request.form['email']):
flash("Invalid Email Address!")
return redirect('/')
double = "SELECT email FROM emails WHERE email='{}'".format(
request.form['email'])
check = len(mysql.query_db(double))
from flask import Flask, request, redirect, render_template
from mysqlconnection import MySQLConnector
app = Flask(__name__)
mysql = MySQLConnector(app,'friends_flaskdb')
@app.route('/')
def index():
query = "SELECT * FROM friends"
friends = mysql.query_db(query)
return render_template('index.html', all_friends=friends)
@app.route('/addfriends', methods=['POST'])
def create():
query = "INSERT INTO friends (name, age, friendship_length, created_at, updated_at) VALUES (:name, :age, :friendship_length, NOW(), NOW())"
data = {
'name': request.form['name'],
'age': request.form['age'],
'friendship_length': request.form['length']
}
print mysql.query_db(query, data)
return redirect('/')
app.run(debug=True)
from flask import Flask, redirect, render_template, session, flash, request
from mysqlconnection import MySQLConnector
import re
import os, binascii # include this at the top of your file
import md5 # imports the md5 module to generate a hash
salt = binascii.b2a_hex(os.urandom(15))
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app = Flask(__name__)
app.secret_key = "password"
mysql = MySQLConnector(app, 'registraiondb')
@app.route('/try', methods=["POST"])
def tries():
email = request.form['email']
password = request.form['password']
user_query = "SELECT * FROM users WHERE users.email = :email LIMIT 1"
query_data = {'email': email}
user = mysql.query_db(user_query, query_data)
session["active_user"] = str(user[0]["first_name"] + " " +
user[0]["last_name"])
active = session["active_user"]
if len(user) != 0:
encrypted_password = md5.new(password + user[0]['salt']).hexdigest()
if user[0]['password'] == encrypted_password:
return render_template("wall.html",
active=session["active_user"],
all_users=user)
# this means we have a successful login!
else:
