Dear sir,
i want to make a reminder for birthday approximately 2 or 3 days before i should get a reminder.
But the problem is that i downloaded some php birthday reminders from net and they are not working.
Can you tell me all the scripts one by one to make a birthday reminder which will remind me about any birthday.
Thanks and Kind regards,
Matin Modak
Hi Matin,
Creating a birthday reminder program should relatively simple and straigh-forward.
But first you need to decide how your program notifies you – is it thru SMS (using free email to SMS gateway) or by email?
Now, suppose you have a table containing names and their birthdays, you can extract those names with birthdays by simple fetching the current date and then search through the database. Here’s how you’d basically do it:
[php]$date = $today + 3 days /* there’s a function for adding specific number of days to current. Google it*/
$rs=mysql_query(“SELECT name, email, mobile_number FROM tableName WHERE birthday = ‘$date’”) or die(mysql_error());
while($row=mysql_fetch_assoc($rs)){
$name = $row[‘name’];
$email = $row[‘email’];
$mobile_number = $row[‘mobile_number’];
$message = “My greeting message.”;
//send email or sms reminder using mail()
} [/php]
(using free email)
? does something like this exist ?