Jump to content

Check MySql Database Hourly and send email ASAP


itwebguy

Recommended Posts

Very limited info, gets very limited help.

 

file.php

$sql = "SELECT * FROM `table` WHERE `timestamp` = NOW()";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {
	while($r = mysql_fetch_assoc($result)) {
	//Select data, then use:
	}
	//then mail.
	mail($to,$subject,$message,$headers);
}

 

crontab quick-reference http://adminschoice.com/crontab-quick-reference

0 * * * * curl --silent --compressed http://mysite.com/file.php

I want code that is running on the server checking the database automatically not in response to a user request.  Would I need a Web Service??  I am on sure that is why I am asking!

 

Very limited info, gets very limited help.

 

file.php

$sql = "SELECT * FROM `table` WHERE `timestamp` = NOW()";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {
	while($r = mysql_fetch_assoc($result)) {
	//Select data, then use:
	}
	//then mail.
	mail($to,$subject,$message,$headers);
}

 

crontab quick-reference http://adminschoice.com/crontab-quick-reference

0 * * * * curl --silent --compressed http://mysite.com/file.php

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.