Birthday reminder for all my users mysql

Question

I want to make a birthday reminder and from here I don't know what to do. In my MySQL users DB U have birthdate with [month/day/year] And is not working,no error, i updated my bday with this day and still no activity. This is what I have so far:

<?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';                 
    }    
?>

I want to show on my page birthdates reminders for logged users, similar like facebook for example — Demon, Jul 05 '16 at 06:13

score 0 · Accepted Answer · answered Jul 05 '16 at 06:18

0

I suppose you want to create an email notification.

$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);
}

If you have the users email IDs saved in your Db you can send email to them

    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);                       
   }

You can automate the script executing process using CRON Job

answered Jul 05 '16 at 06:18

epynic

1,124
2
14
26

Thank you epynic for your effort i will use the email sender in this script, but i want the reminder to be shown on the page for all the users, i think has some issues because is not working, i updated my birthdate in db with this day and nothing.. – Demon Jul 05 '16 at 06:45
something wrong with the data formats ? could you tell me the date format in DB ? – epynic Jul 05 '16 at 07:01
1

try using $today = date("d/m/y"); – epynic Jul 05 '16 at 07:07
good, now is working, and now how can i calculate between birthdate and $today? from (05/07/1986) and today, and shows me that today is my birthday – Demon Jul 05 '16 at 07:14
if i do : where birthdate < '$today' is ok? – Demon Jul 05 '16 at 07:21
Date >= '2011/02/25' and Date <= '2011/02/27' – epynic Jul 05 '16 at 07:34
1

http://stackoverflow.com/questions/5125076/sql-query-to-select-dates-between-two-dates – epynic Jul 05 '16 at 07:34
Welcome .. Happy coding ! – epynic Jul 20 '16 at 06:25

Birthday reminder for all my users mysql

1 Answers1