I am LOST Expiration and AutoUpdate

[orions_empire]

Hi Guys,

I am lost, and pulling off my hair (at least what is left LOL).

Well, I have a small table that has two dates Calibration Date and Calibration Due Date. Also has a status for Expiration. So user will no use equipment. I would like to have this query done when the page is loaded, not by pressing a button.

I need help in sequence and order of coding.

<?php //expiration method
$cal = strtotime($row["eqcaldate"]); 
$cal2 = $row["eqcaldate"]; 
$actual = date("Y-m-d");
$exp1 = strtotime(date("Y-m-d", strtotime("+700 days", $cal)));
$exp2 = date("Y-m-d", $exp1);
$exp3 = strtotime(date("Y-m-d", strtotime("+730 days", $cal)));
$exp4 = date("Y-m-d", $exp3);
$stat = "";
if  ($cal2 = (""))
	{$stat = "NO DATA";}
	elseif
	($exp2 < $actual) 
	{$stat = "Available";} 
	elseif 
		($exp2 <= $actual) 
		{$stat = "30 Days Warning";} 
	elseif 
		($exp3 > $actual) 
		{$stat = "DO NOT USE - Expired";} 
//$row["eqstatus"] = $stat;
if(isset($_POST['hit']))
{
include 'library/config.php';
include 'library/opendb.php';
//$eq_status = $_POST['$stat'];
$query = "INSERT INTO equipment (eqstatus) VALUES ('$stat')";
mysql_query($query) or die('Error, insert query failed');
$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');
include 'library/closedb.php';
echo "Equipment was succesfully added";
}
?>

Also forgot to mention, expiration date is after two years of calibration, but I want a warning before 30days.

thnx!

[Jack_McSlay]

with such an overuse of strtotime, I'm not surprising things are going haywire.

first, what kind of row is "eqcaldate" on the database? if it's not TIMESTAMP, DATETIME, INT nor DATE it's already wrong.

Here's a fix assuming it's a properly formatted date:

if (empty ($row["eqcaldate"]){
	$stat = "NO DATA";
}
else {
	$cal = strtotime ($row["eqcaldate"]);
	$expire = getdate ($cal);
	$expire = mktime(
		$expire['hours'],$expire['minutes'],$expire['seconds'],
		$expire['mon'],$expire['mday'],$expire['year']+2
	);
	$warning = $expire - (30 * 86400);//30 day warning
    $today = time();
    if ($today >= $expire) $stat = 'DO NOT USE - Expired';
    elseif ($today >= $warning) $stat = '30 Days Warning';
    else $stat = 'Available';
}

[orions_empire]

Well, 'eqcaldate', 'eqcalduedate' are Date so they are stored in YYYY-MM-DD format

I need to create a comparison for eqcalduedate to actual Date. and warn me 30days before. eqstatus is a varchar that will store the status string. I dont have a clue on how to do it. This process must be executed at form load.

Thank you for the response!

OE