Answers for "how to avoid sql injection"

0

How to prevent sql Injection

// use prepared statement to prevent SQL injection
$preparedStatement = $dbConnection->prepare('SELECT * FROM animals WHERE name = ?');
$preparedStatement->bind_param('s', $name); 
$preparedStatement->execute();
$result = $preparedStatement->get_result();
while ($row = $result->fetch_assoc()) {
// Process $row
}
Posted by: Guest on July-07-2021
0

avoid sql injection in password field

$password = mysqli_real_escape_string($conn,md5($_POST['password']));
Posted by: Guest on February-05-2021

Browse Popular Code Answers by Language