
Let’s check your database knowledge.
query = "SELECT * FROM users WHERE id = " + userId
Replace string concatenation with ________ to prevent SQLi
A) query = f"SELECT * FROM users WHERE id = {userId}"
B) query = "SELECT * FROM users WHERE id = " + escape(userId)
C) cursor.execute("SELECT * FROM users WHERE id = %s", (userId,))
D) query = "SELECT * FROM users WHERE id = " + str(int(userId))
Bonus: Why are the others still injectable?
English




