- abs: documentation ( source)
- floor: documentation ( source)
- date: documentation ( source)
- strtotime: documentation ( source)
<?php
require("http://www.receivers.org/ads/db.php");
mysql_connect($DBserver, $DBuser, $DBpass);
mysql_select_db($DBname) or die(mysql_error());
$result = mysql_query("SELECT * FROM CRFAds where AdNumber='4'") or die(mysql_error());
$row = mysql_fetch_array( $result );
If ($row['NewOrRenewal'] == "New") {
$ExpireDate=date("F j, Y", strtotime("$StartDate +92 days"));
}else{
$ExpireDate=date("F j, Y", strtotime("$StartDate +122 days"));
}
$today = date("F j, Y");
$StartDate=date("F j, Y", strtotime("$StartDate"));
$TimeLeft = abs(strtotime($ExpireDate) - strtotime($today));
$daysleft = floor(($TimeLeft - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
$TimePosted = abs(strtotime($today) - strtotime($StartDate));
$daysPosted = floor(($TimePosted - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
echo "Start Date: $StartDate";?><br><?
echo "Days Posted: $daysPosted";?><br><?
echo "Days Left: $daysleft";?><br><?
echo "Today's Date: $today";?><br><?
echo "Expiration Date: $ExpireDate";?><br><?
echo "Ad Number: ".$row['AdNumber'];?><br><?
echo "Submitted by: ".$row['SubmitterName'];
?>