Repository navigation
Expand file tree
/
Copy pathapp_before.py
More file actions
52 lines (44 loc) · 1.57 KB
/
Copy pathapp_before.py
File metadata and controls
52 lines (44 loc) · 1.57 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
from flask import Flask, request
from flask_sqlalchemy import SQLAlchemy
import pymysql
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:rootpass@localhost/testdb'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
def createQuery(username, password):
# Intentionally vulnerable query (for demonstration only)
# query_text = f"SELECT * FROM users WHERE username = '{username}' AND password = '{password}'"
# use parameterization instead.
query_text = "SELECT * FROM users WHERE username = %s AND password = %s"
parameters = (username, password)
query = query_text, parameters
return query
@app.route("/login", methods=["GET", "POST"])
def login():
if request.method == "POST":
username = request.form['username']
password = request.form['password']
connection = pymysql.connect(
host="localhost",
user="root",
password="rootpass",
database="testdb"
)
cursor = connection.cursor()
query = createQuery(username, password)
# Bug is here:)
cursor.execute(query)
result = cursor.fetchone()
if result:
return "Login successful!"
else:
return "Invalid credentials."
return '''
<form method="post">
Username: <input type="text" name="username"><br>
Password: <input type="password" name="password"><br>
<input type="submit" value="Login">
</form>
'''
if __name__ == "__main__":
app.run(debug=True)