脚本向php中的注册用户发送自动生日愿望时出错

Question

I have written the script of sending automatic e-mail for a given date. I have already set up the cron job to execute this once a day for a given time. But it is not working. Can anyone show me the error here. I'm really new to this. What I'm really supposed to do is to send an automatic email to a user on their birthday

   <?php
    $host="mysql117.000webhost.com/";//hostname
    $username="abc";//mysql_username
    $password="123";//mysql_password
    $dbname="abc";//Database name
    $tbl_name="customer_info";//table name

    $date = date("2005-09-23"); //here my date format in my DB is 2010-09-30
    $link = mysqli_connect('$host','$username','$password','$dbname');
    if($link && mysqli_select_db('$dbname', $link))
    {
  $grabBday = "SELECT b_day,DATE_FORMAT(b_day,'2015-%m-%d') FROM customer_info where b_day = '2002-09-24'";
        //here it will take the name of the person whose bday is on a particular date,I just hard coded this date to check  if this is working
        if($rs = mysqli_query($link, $grabBday))
        {
            while(mysqli_fetch_array($rs))
            {
                mail('[e-mail]', 'HAPPY BIRTHDAY', 'Many Happy Returns of the day');
            }
        }
    }  ?>

Answer 1

I am seeing logical difference as you are searching where b_day=$date where $date='2015-09-23' but dob can be '2002-09-23' or '1997-09-23' etc. so you will not get desired output, so you can change your query as per below if everything other than it is fine.

SELECT * FROM 
tbl_name 
WHERE CONCAT(YEAR(CURDATE()),DATE_FORMAT(b_day,'-%m-%d')) = $date