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?
I managed to figure out the sql query... it is as follows... works a treat..
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.
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
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:
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???
$bday = new DateTime(strtotime($patient->dob));
$today = new DateTime();
It won't echo anything or print_r any variables when i try...
ooopps... i forgot to wrap...
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?
if (date('m-d') == date('m-d', strtotime($patient->dob)))
I guess i can just drop the day and that would work fine.
Sometimes I post before I think about it.... errrrr
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)