Birhday e-mail scrip to users - help

Anon

I would like to create a php scrip or a cron job that has the following objective and structure:
a) Objective: Check in users database for users that have a birthdate equal to today's date and send them a Happy Birthday e-mail

b) Structure (probably like this)

//Connect to mysql

//Search for users with birthdate equal to today's date

//if found send them a happy birthday e-mail

//and write on the screen how many and who are the users

//else write that there is no user that has is birthday today

//and exit to main admin page

Any help on this would be greatfull

Anon

You'll have a hard time making this all work. PHP, as I'm sure you know, won't run as a timed event. It runs when the user loads the page, and that's that. You could have a cron job reference the page, but you'd either need to have it open lynx and then have lynx open the page, which is roundabout and sloppy, or have it use the CGI version of PHP.

All in all, you'd be better off writing a shell script for it, I'd guess. It's not that hard to learn shell scripting.

maxpup979

well, you have it all properly laid out...ya just need to code it. And assuming you are running a *nix box, you can then add the PHP script to your cron.daily and (with a wee bit of tweaking--really not much at all) then you are set...but I believe Dan is right...you will have to cron it up

Hope this helps
Darren

Anon

Yes, just as I thought, the cron job ws a bit difficult to get done.
We could run the php script on a daily basis, but the problem started with the script that I've built that was checking the date, sending the e-mail but it was just sending the e-mail to the first user and not to all users that would satisfy the defined criteria.
I'm just starting php scripting! 😉

maxpup979

So put up the code to that script, and lets see whats wrong...🙂 Thats what we are here for.

Anon

Thanks for your help.

Here goes the script:

<?
// Include configuration file
require ("config.inc.php");
require ("$lib/lib.php");
{
//Get today date
$tod = date("Y-m-d");

 // Connect database
 dbconnect();

 $sql = "SELECT birthdate FROM $t_users
         WHERE birthdate = ''$birthdate";
 $result = @mysql_query($sql)
           or die ("Can not check status");
 while ($row = mysql_fetch_array($result))
 $birthdate = $row['birthdate'];
 if ($birthdate == $tod) {

 // If confirmation completed, select user info
 $sql = "SELECT email, name, surname, username, password, birthdate FROM $t_users
         WHERE hash = '$hash'";
 $result = @mysql_query($sql)
  or die ("Can not find user info.");
 while ($row = mysql_fetch_array($result))
  {
  $co_email = $row['email'];
  $c_name = $row['name'];
  $c_surname = $row['surname'];
  $c_username = $row['username'];
  $c_password = $row['password'];
  $c_birthdate = $row['birthdate'];
  }
 @mail($co_email, LANG_HAPBTHD,

"".LANG_DEAR." $c_name $c_surname,\n\n

".LANG_MENSPARAB."

\n".LANG_MELCPTOS."
".LANG_EQUIP." $site_name", "From: $admin_mail");

} else {
echo ("No results");
}
}
?