www.webdeveloper.com
Results 1 to 7 of 7

Thread: Birthday reminder/alert for members...

  1. #1
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    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?

  2. #2
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    Lightbulb 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.

    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))

  3. #3
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    Talking

    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.

  4. #4
    Join Date
    Oct 2010
    Location
    Ohio
    Posts
    233
    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())

  5. #5
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    Unhappy

    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...

  6. #6
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    Question ooopps... i forgot to wrap...

    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?

  7. #7
    Join Date
    Jun 2011
    Location
    California
    Posts
    383
    I guess i can just drop the day and that would work fine.

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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles