Birthday reminder

scoppc

I want to have a birthday reminder as one of the feature in my website.
I have users' information (including their DOB, of course) stored in MySQL database.

For this application, the logic that I can think of is that I will have a script that matches todays date and the DOB stored in database. If they match, then I will send Bday reminder to everyone.

The problem is ... can I have a script running every second, every minutes, every hour ... blah ... blah ... on the server without me running it???

Or is there any other way to do that?

thanks in advance.

-scoppc-

zhabala

If it is a Linux Box, then there is a daemon named cron, which allows you to run any program at specified frequency. The smallest interval between is one minute.

Zdenek

scoppc

How about if my operating system is Windows 2000 ??? Is there any applications that work that way?

thanks.

Anon

On my Win2K box at work, I've used the event scheduler to kick off a .bat script which calls the PHP script, since I couldn't call the PHP script directly. The .bat scsript needs only one line containg the absolute path to the PHP.exe (put in double quotes) and the absolute path to your PHP script. Just like running PHP from the command line.

Biggus

Anon

I'm not so sure on how to run PHP from the command line. I'll try it out.
Hope I can get it work without have to ask u guys again. Thanks a lot!

Anon

open a DOS window and enter the following (change for your specific setup/needs):

"e:\PHP\php.exe" e:\Inetpub\wwwroot\test.php

This is all one line, with a single space in between the two items.

To make a .bat script, create a new file in Notepad and enter the same text with the word pause on a second line. The pause keeps the DOS window open. Save it as whatever.bat and doubleclick on it.

HTH,
Biggus