Solved

determine all the dates between a start and end date.

Posted on 2003-10-25
4
172 Views
Last Modified: 2013-12-12
I am trying to build a form (using PHP) and would like to have a start date (entered as 3 fields - startMonth, startDay, and startYear) and an end date (entered as 3 fields - endMonth, endDay, endYear).
If they pick the same day for both I am ok, but if the end date is  3 days later I have to figure what dates are in between.

Example 12/20/2003 - 12/23/2003, would have 12/20/2003 and 12/21/2003, and 12/22/2003, and 12/23/2003. (4 dates)

I am pretty new to programming, so an example would be helpful.

Thanks
0
Comment
Question by:James Stone
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
lozloz earned 125 total points
ID: 9622234
<?
if(!checkdate($_POST["startMonth"],$_POST["startDay"],$_POST["startYear"])) {
  die("Start date invalid");
}
if(!checkdate($_POST["endMonth"],$_POST["endDay"],$_POST["endYear"])) {
  die("end date invalid");
}
$startdate = mktime(0,0,0,$_POST["startMonth"],$_POST["startDay"],$_POST["startYear"]);
$enddate = mktime(0,0,0,$_POST["endMonth"],$_POST["endDay"],$_POST["endYear"]);
if($enddate < $startdate) {
  die("End date precedes start date");
}
$distance = $enddate - $startdate;
$distance = $distance / 60 / 60 / 24;
$distance = floor($distance);
?>

$distance should result in the number of days between them, tell me how you get on
0
 

Author Comment

by:James Stone
ID: 9622414
What I was missing was looping it through a mktime statement  x number of  times, finally came to me!

first time I had seen floor function so read up on that.

Thanks for the comment - eventually I will figure this stuff out.

<?

$distance = $distance / 60 / 60 / 24;
$distance = floor($distance);
echo $distance."<p>";

//
// loop through the days
$range = range (0, $distance);

foreach ($range as $value) {
        $Rangetimestamps = mktime(0,0,0,$_POST["Startmonth"],($_POST["Startday"]+$value),$_POST["Startyear"]);
        $RangeDates = date("mdy", $Rangetimestamps);
        //echo $Rangetimestamps. " and ".$value."<p>";
        echo $RangeDates."<p>";

}
?>
0
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 9661074
going with lozloz's initial range checking and assignments using mktime, here's another way to loop through the dates which I think might be a little more readable when you come back to do some debugging:

while ($startdate <= $enddate)
{
    echo date("mdy", $startdate);
    $startdate = strtotime("+1 day", $startdate);
}
0
 

Author Comment

by:James Stone
ID: 9662901
Thanks, I am teaching my self php (I've worked with databases for a few years). The less typing the better! It is much easier to read and probably more efficient too.

Just realized I never gave lozloz his points for helping.

james
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Cookie not unsetting 7 27
How do uses indexes to maximize MySQL Searches 14 54
Creating Functions in phpMyAdmin 8 26
how to access a remote mysql database with xampp 3 23
Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question