Hi!
Need help with conditional formatting of table rows...
What i need to acheave is to change table row background in red if date_needed is <= than 48 hours than now().
This is what i have now
if (date('d',strtotime($data['date_needed'])) <= 2) $row["rowstyle"]='style="background:red"';
it works in a way... It changes background color for 1. and 2. of the month, but that is not what i need...
Must mark rows where dedline is less or equal to 48 hours.
Thank you!
How are you calculating time to deadline?
I would suggest:
http://php.net/manual/en/datetime.diff.php
BUT if you're on a Windows machine, using VC6, then it won't work as you always get 6015 as the day difference - I wasted a lot of time headscratching over that one - see https://bugs.php.net/bug.php?id=51184 for a workaround.
I put together a working example of using time() to convert datetime's into integar's:
<?php
$now = time();
$testTimes = array('test 1'=>time()+(60*60*16),'test 2'=>time()+(60*60*24*6),'test 3'=>time()-60*30);//test times - array(16 hours,6 days, 30 minutes ago);
//$timetocheck = strtotime('2012-01-18 13:25:12');//to convert a string date or datetime into a time integar
$triggerTime = 60*60*24*2;//seconds * minutes * hours * days(48 hours);
foreach($testTimes as $key=>$value){//$value = time to check
if($now+$triggerTime > $value){
if($now > $value){
echo "{$key} (".date("Y-m-d H:i:s",$value).") Time has already passed<br/>\r\n";
}else{
echo "{$key} (".date("Y-m-d H:i:s",$value).") is in the trigger time band<br/>\r\n";
}
}else{
echo "{$key} (".date("Y-m-d H:i:s",$value).") is later than the trigger time<br/>\r\n";
}
}
?>
time() basically returns the number of seconds that have passed since 1st jan 1970, so you can compare/edit dates in seconds very well, then date() will convert it back into a readable datetime format
http://php.net/manual/en/function.time.php
http://uk1.php.net/manual/en/function.strtotime.php
http://uk1.php.net/manual/en/function.date.php
You may want to test this around leap year days and when daylight saving occurs.
Thank you all! I started to use some program but it has some weird language structure. Anyways, i found the solution to suite my needs.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.