13 UPDATE Verkrijg aangepaste rijen

$stmt = $mysqli -> prepare('UPDATE users SET email = ? WHERE name = ? LIMIT 1');

$email = ‘nieuwemail@mail.com’;
$name = ‘willem’;

$stmt -> bind_param(‘ss’, $email, $name);
$stmt -> execute();

// 1
echo $stmt -> affected_rows;