给我所有用户mysql的生日提醒

Question

我想做一个生日提醒，从这里我不知道该做什么。在我的MySQL用户中，DB有月/日/年的生日，并且没有工作，没有错误，我用这一天更新了我的bday，但仍然没有活动。到目前为止，这就是我所拥有的：

<?php
    $conn = new PDO('mysql:host=localhost;dbname=tbl', 'user', 'pass');
    $today = date("m.d.y");    
    $sqlb = "SELECT `birthdate`, `name`, `surename`  FROM `mls_users` WHERE birthdate = '$today'";               
    $userz = $conn->query($sqlb);

    foreach ($userz as $row) {   
        $name = $row['name'];
        $surename = $row['surename'];
        echo 'Todays is'.$name.' '.$surename.' birthday';                 
    }    
?>

Answer 1

我想你想要创建一个电子邮件通知。

$mail_content = '';
foreach ($userz as $row) {   
    $name = $row['name'];
    $surename = $row['surename'];
    $mail_content .= 'Todays is'.$name.' '.$surename.' birthday. <br>';                 
}
// send mail to you
// mail code
if($mail_content){
    $to      = 'nobody@example.com';
    $subject = 'the subject';
    $message = 'hello';
    $headers = 'From: webmaster@example.com' . "\r\n" .
    'Reply-To: webmaster@example.com' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
    mail($to, $subject, $mail_content, $headers);
}

如果您将用户的电子邮件ID保存在数据库中，则可以向他们发送电子邮件。

    foreach ($userz as $row) {   
            $name = $row['name'];
            $surename = $row['surename'];
            //mail code 
            //email message 
            $mail_content = 'Happy birthday '.$name.' '.$surename.' !. <br>';
            $to      = $row['user_email']; //users email field
            $subject = 'the subject';
            $message = 'hello';
            $headers = 'From: webmaster@example.com' . "\r\n" .
            'Reply-To: webmaster@example.com' . "\r\n" .
            'X-Mailer: PHP/' . phpversion();
            mail($to, $subject, $mail_content, $headers);                       
   }

您可以使用CRON作业自动执行脚本进程。