How can i manage a date' sequence in php for showing how many days remaining to the next date?

Question

I have a start date like 07/18/2014, a end date like 07/24/2014, and a period date: every 2 days. So every 2 days starting by 07/18 i warn the user that something have to do, if is not the right day i warn the user about how left days remaining to the next warning. How can i do? And if add also time and a period of every 2 hours?

I thought about store first all the dates warning in an array [07-18/2014, 07-20-2014, 07-22-2014, 07/24/2014]

My code is the following but it does not work. Maybe it is not correct like I use strtotime

$endg = strtotime ( "+". $dataupto . " days", strtotime ( $row['startdate'] ) ) ;     
$endg = date ( 'Y/m/d' , $endg ); 
$endgSTR = strtotime($endg);
$tempg = strtotime($row['startdate']); 

while( $tempg < $endgSTR){ 

        $arraymonitor[] = strtotime(  date($tempgdate )    );

        $tempg = $tempg + (strtotime ( " +1 days", $tempg  ) ); 


        $arraymonitor[] = $tempg; 
        echo "</br> tempg in while:";
        echo $tempg .  " ";

        echo "</br> tempg in while 2:";
        echo  date ( 'Y/m/d' , $tempg ) .  "<br/>";                     


    }

I accept also other suggestions!

UPDATE SOLUTION

                header( "content-type: text-plain" );
                function dayDiff($start, $end){
                    $timeleft = $end - $start;
                    $daysleft = round((($timeleft/24)/60)/60);
                    return $daysleft;
                }

                function testWarning($today, $end, $delay){
                    $endDate     = strtotime($end);
                    $warningDate = $endDate; 
                    $todayDate   = strtotime($today);

                    if( $todayDate == $warningDate ){
                        echo "Oggi c'è un controllo da fare";
                    }elseif( $todayDate < $warningDate ){
                        echo "Miss " . dayDiff($todayDate, $warningDate) . " days";
                    }else{
                        echo "warning was " . abs(dayDiff($todayDate, $warningDate)) . " giorni fa";
                    }

                    echo"\n";
                }

                $ardata =  [07/18/2014, 07/20/2014, 07/22/2014, 07/24/2014];
                $today3 = "07/21/2014"; // the day after warning
                testWarning( $today3, $end, $delay );

                $diffmin = 1000;                                        
                for ($i = 0 ; $i<= count($ardata)-1; $i++){

                    //print_r($ardata);
                    echo "</br> </br> ardata ";
                    echo $ardata[$i];
                    $dataseq = date ( 'm/d/Y' , strtotime($ardata[$i]) );       
                    $diffdata = dayDiff( strtotime($today3), strtotime($dataseq) );
                    echo "</br></br> DIFFDATA: ";
                    echo $diffdata;
                    echo " DIFFMIN ";
                    echo $diffmin;
                    if ($diffdata > 0){  // avoiding days before today
                        if ($diffdata < $diffmin){  
                            $diffmin = $diffdata;
                            $nextdata = $ardata[$i];  
                        }else{
                            if ($diffdata == -1){   
                                echo "error array empty";
                                $nextdata = $today3;
                            }
                        }
                    }else{
                        echo "monitorterminato";
                        $nextdata = -1;
                    }
                }   

                if  ($nextdata != -1){  

                    if ($diffmin == 0){    // giorno di oggi quindi avviso
                        echo "warning    WARNING </br> </br>";
                    }else if ($diffmin > 0 ){

                        echo " oggi ". $today3."  prossimo:". $nextdata. " </br></br>";
                        testWarning( $today3, $nextdata, $delay );   
                    }else{
                        // caso errato
                        echo " </br> </br> ERRORE nel calcolo non può essere negativo";
                    }                       
                }

score 0 · Answer 1 · edited May 23 '17 at 11:50

0

As seen here

$future = strtotime('21 July 2012'); //Future date.
$timefromdb = //source time
$timeleft = $future-$timefromdb;
$daysleft = round((($timeleft/24)/60)/60); 
echo $daysleft;

edited May 23 '17 at 11:50

Community

1
1

answered Jul 19 '14 at 18:50

David Jacquel

51,670
6
121
147

It's really a good solution, but how can i know that 21 july is the next date? In my example, first, i have to generate 4 different "warning" dates and storing them somewhere; then how can i know the future date i have to choose to do what you suggested me? – user3798245 Jul 19 '14 at 20:29

score 0 · Accepted Answer · answered Jul 19 '14 at 22:27

Here is an example on how to calculate your warning dates and days left before warning.

<?php
header( "content-type: text-plain" );

$end   = "09/18/2014";
$delay = "- 2 days"; // warning will be on 16th

$warningDay = date('m-d-Y', strtotime($delay, strtotime($end)));
echo "Warning is on " . $warningDay . "\n";

$today1 = "09/13/2014"; // 3 days before warning
testWarning( $today1, $end, $delay );

$today2 = "09/16/2014"; // warning day
testWarning( $today2, $end, $delay );

$today3 = "09/17/2014"; // the day after warning
testWarning( $today3, $end, $delay );


function testWarning($today, $end, $delay){
    $endDate     = strtotime($end);
    $warningDate = strtotime($delay, $endDate);
    $todayDate   = strtotime($today);

    echo "today : " . date('m-d-Y', $todayDate) . "->";

    if( $todayDate == $warningDate ){
        echo "Warning is today";
    }elseif( $todayDate < $warningDate ){
        echo "Warning in " . dayDiff($todayDate, $warningDate) . " days";
    }else{
        echo "Warning was " . abs(dayDiff($todayDate, $warningDate)) . " days ago";
    }

    echo"\n";
}

// $start and $end are timestamps
function dayDiff($start, $end){
    $timeleft = $end - $start;
    $daysleft = round((($timeleft/24)/60)/60);
    return $daysleft;
}

Sorry, I have not well explained. When the first date ended, in your example: 09/16/2014, today3 does not have to show: "Warning was...". In today 3 there could be a warning for the next day of warning that according to the period: 2 days is 09/18/2014 and so: today 3: "Warning in 1 day today". I have to show this warning for all the dates stored in an array: [07-18/2014, 07-20-2014, 07-22-2014, 07/24/2014] — user3798245, Jul 20 '14 at 00:57
Ok i worked a little bit with your code and i reach my aim. I delete delay variable because is not useful, and i manage the arraysequence with your functions, I update the solution! Thank you! — user3798245, Jul 20 '14 at 14:38

How can i manage a date' sequence in php for showing how many days remaining to the next date?

2 Answers2