Question: Review the code and determine is SQL Injection is a problem. Describe specifically how you would test to see if SQL injection was a problem.

Review the code and determine is SQL Injection is a problem. Describe specifically how you
would test to see if SQL injection was a problem. For example, show exactly what you would
input into the form fields to determine if SQL injection was a problem. Discuss the code issues
pointing to where the SQL injection could happen. (30 points)
$conn = getDB();
$sql = "SELECT id, firstname, lastname, salary, birth, ssn,
phonenumber, address, email, nickname, Password
FROM data
WHERE id='$input_id' and password='$input_pwd'";
$result = $conn->query($sql))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!