The ways of protecting websites from SQL injection attacks

   $query = $pdo->prepare('SELECT * FROM products WHERE name = :name'); 

   $query->execute(array('name' => $name)); 

   foreach ($query as $result) { // do logic on the data }

$query = $dbConnection->prepare('SELECT * FROM products WHERE name = ?'); 

$query->bind_param('s', $name); 

$query->execute(); 

$result = $stmt->get_result(); 

while ($row = $result->fetch_assoc()) { // do login on data }