Birthday reminder/alert for members...

Using php & sql on a 2008 x64 R2 windows server.


What's the best way of accomplishing this in my events? :confused:

I need to figure out how to call the alert in php now.. any help would be greatly appreciated..

here is the sql script below.

Code:

---

Select first, last, dob as Birthday
,FLOOR(DATEDIFF(dd,patient_dg.dob,GETDATE()) / 365.25) AS AGE_NOW
,FLOOR(DATEDIFF(dd,patient_dg.dob,GETDATE()+7) / 365.25) AS AGE_ONE_WEEK_FROM_NOW
from event.dbo.patient_dg()
WHERE 1 = (FLOOR(DATEDIFF(dd,patient_dg.dob,GETDATE()+7) / 365.25))
                  -
                  (FLOOR(DATEDIFF(dd,patient_dg.dob,GETDATE()) / 365.25))

---

So i've decided to scratch the sql method of checking the dates and i plan on using the date function in php.

I've created an object: $patient->dob; which displays the patients date of birth.

How do i reference if their date of birth is today and than have a small alert when the patients page is visted??

Any help would be greatly appreciated.

Doing it in SQL is really the best way to get a full list. However I'd do it differently than you did. Something like this:

Code:

---

SELECT * FROM patient WHERE MONTH(dob) = MONTH(NOW()) AND DAY(dob) = DAY(NOW())

---

ok, moving along.. i've written this but i can't seem to get it to work still.. any suggestions from this point???

PHP Code:

---

$bday = new DateTime(strtotime($patient->dob));
$today = new DateTime();
echo $bday->diff($today); 


---

It won't echo anything or print_r any variables when i try...

PHP Code:

---

if (date('m-d') == date('m-d', strtotime($patient->dob)))
{
    echo ('true');
}
    else 
{
    echo ('false');
} 


---

This works fine for me but what if i want to check if there birthday is within a month from todays date and than alert?

I guess i can just drop the day and that would work fine.

Sometimes I post before I think about it.... errrrr