I found some problem about bindvalue and can't find a solution. this is my code it are work great if in put email like this "abc@aaamail.com" but my problem is when user are input email like "abc.def@aaamail.com" this query it not work. I don't know why and how to fix it anybody can explain to me?
$email = trim($_POST['email']);
$result = $conn->prepare("SELECT * FROM `memberlist` WHERE email = :email");
$result->bindValue(':email', $email);
$result->execute();