Solved

determine all the dates between a start and end date.

Posted on 2003-10-25
4
167 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:cubbyboy57
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
lozloz earned 125 total points
Comment Utility
<?
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:cubbyboy57
Comment Utility
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
Comment Utility
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:cubbyboy57
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
htacces issue 2 37
Wordpress syntax error 1 27
MYSQL simple update statement 3 32
url rewrites not working in codeigniter 2 8
Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
This article discusses four methods for overlaying images in a container on a web page
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now