Simple birthday script using php and mysql

Last updated on January 19th, 2022 at 08:12 am

This is another tutorial which shows how to create a birthday script which automatically send wishes to the person on that particular day using php and mysql.Pretty simple.All you have to do is take care of the DB part and change it according to your convenience.

Assuming that your table name is bday_table and one of the column that has the date is bday_check.

<?php
$date = date("Y/m/d"); //here my date format in my DB is 2010/09/30
$link = mysqli_connect('HOST','USERNAME','PASSWORD','DATABASE');
if($link && mysqli_select_db('DATABASE', $link))
{
    $grabBday = "SELECT * FROM bday_table WHERE bday_check = $date";
	//here it will take the name of the person whose bday is on a particular date
    if($rs = mysqli_query($link, $grabBday))
    {
        while(mysqli_fetch_array($rs))
        {
            mail('TO_EMAIL', 'HAPPY BIRTHDAY', 'MESSAGE');
        }
    }
}  ?>

All you need to create is a DB just similar to the above script structure and run this script as a cron.
You can also run this script in your index page or any other webpages [Make sure that the script is executed only once in a day, you need to configure it accordingly.].

In this script we are using the simple mail() function. But you can refer these tutorials if you would like to send

1] HTML email using PHP

2] Send Email to Multiple Recipients

3] Send HTML email using sendmail