PHP - Getting Dates Using Strtotime Or Other If Possible.

Hi All,

I need to subtract dates and display the number of days left.  I have a 'Start' date and an 'End' date in DATETIME format in the DB.  Not quite sure where to start.  A simply start - end doesn't work  .

Start = 2011-11-01-00:00:00
End = 2011-11-30-23:59:59

Since it is now 2011-11-27, my output should equal 3.  Any help is appreciated.

Hi guys,

I am trying to do a multidates events availability calender. The script below indicates todays date by highlighting an orange colour and also indicates the start and end date of the event highlighting grey colour on the two dates (The colour are link via css classes as shown).
Code: [Select]
//Today's date
$todaysDate = date("d/m/Y");
            $dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
echo "<td align='center' ";
if($todaysDate == $dateToCompare){
echo "class='today'";
}else{
//Compare's the event dates
$sqlcount = "select event_start,event_end from b_calender where event_start ='".$dateToCompare."' AND event_end='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlcount));
if($noOfEvent >= 1){
echo "class='event'";
}
}
It works ok i.e. if start date = 01/01/2012 and end date = 04/01/2012 both date will be highlighted with grey colour. However I want it to also highlight grey on the dates between the 1st and 4th to show that then anydates between the 1st and 4th are not available and this is when I'm stuck.

Please guys I need help.

Thanks

So, my problem is that I need to edit my Xmas calculator to understand when this year's Xmas is over, it will automatically jump to the next one (2011-12-25).

I have no idea how to do this (noob to php...)

Thanks in advance.

Here's my code:
Code: [Select]
<?php
$time=time();
$xmas=strtotime("2010-12-25 00:00:00");
$diff = $xmas - $time;
$days=intval($diff/86400);
$left=$diff%86400;

$hs=intval($left/3600);
$left=$left%3600;

$mins=intval($left/60);
$secs=$left%60;

echo "<font size=12 face=corbel>
Xmas is after:<br>
<strong>$days days</strong><br>
<strong>$hs hours</strong><br>
<strong>$mins mins $secs secs</strong>!
</font>";
?>

I'm trying to add 5 days to $today date:

Code: [Select]
<?php

$exp_date = "2011-09-11";
$todays_date = date("Y-m-d");

$today = strtotime("+5 days", $todays_date);
$expiration_date = strtotime($exp_date);

if ($expiration_date > $today) {
     echo "Valid: Yes";
} else {
     echo "Valid: No";
}

?>
Is +5 days used wrong?

Hello!

A user is going to input a date in the form "mm/dd/yyyy".  I'd like to convert this to a time stamp so that I can store it via MySql.  I've heard about the "strtotime" function in PHP but I'm not sure how it can tell that the user 03/04/2011 represents March,4th 2011 and not, say April,3rd 2011 (European version).  Help with the correct syntax for conversion would be greatly appreciated.

Thank you,

Eric