SELECT user by Date

Question

I have a Select mysql searching my clients by taking the name, email by date of day...

I need to get the results that are from today (WHERE data_cad='$dataHoje') and I need to select one by one to send an email to him (I will use mail ())

My main question is how to select ONE to ONE and Send One to One. I lacked the logic for this...

Grateful!!

Answer 1

Come on, since you didn’t specify the average amount of emails I’ll create a simple example of how to do this:

I’ll use PDO for the appointments, but you can do as you like

$select = BD::conn()->prepare("SELECT * FROM minhaTabela WHERE DATE(timestamp_field) = CURDATE()");
$select->execute();

$rows = $select->rowCount();

if($rows >= 1){
   while($ftc = $select->fetch()){
      $para = $ftc["email"];
      $assunto = "Assunto do email";
      $msg = "Sua mensagem aqui";
      $headers = "From: [email protected]" . "\r\n" .
                 "CC: [email protected]";

      $enviar = mail($para, $assunto, $msg, $headers);
      if($enviar){
         echo "E-mail enviado com sucesso";
         sleep(5);
      }else{
         echo "Erro";
      }
   }
}