time value

sandy1028

Hi,

How to decrement the time from current hour of timestamp to last 24hours.
I have to manually get the time of the timestamp for last 24 hours by decrementing from the current hour

I have tried from 0th hour to 24 hours so please help me in reverse
Please help me.


$timeincr=10;
$time_interval = array();
for($i=0;$i<24;$i++){
        if($i<10){
                $hour = "0".$i;
        }
        else{
                $hour = $i;
        }
        for($j=0;$j<60;$j=$j+$timeincr){
                if($j==0){
                        $item = $hour.":00";
                        array_push($time_interval,$item);
                }
                else{
                        $item = $hour.":".$j;
                        array_push($time_interval,$item);
                }
        }
}

choubix

so you need current time - 24h ?

24 hours = 246060

so it would be the current timestamp - 86400 seconds

bogu

e.g. echo [man]strtotime[/man]('-1 day'); if you need to decrement one day and you don't have to think about daylight savings ...

sandy1028

Hi,

I just want the code to check whether the value in database for that timestamp is present or not. If it is present then array_push that value else store 0.

$timeincr=10;
$graphincr = 5;
$time_interval = array();
for($i=0;$i<24;$i++){
        if($i<10){
                $hour = "0".$i;
        }
        else{
                $hour = $i;
        }
        for($j=0;$j<60;$j=$j+$timeincr){
                if($j==0){
                        $item = $hour.":00";
                        array_push($time_interval,$item);
                }
                else{
                        $item = $hour.":".$j;
                        array_push($time_interval,$item);
                }
        }
}


$dbvalue        = getvalue();
array_shift($dbvalue);
$last_date      = $dbvalue[0];
array_shift($dbvalue);
list($dtstr,$last_time)= split(" ",$last_date,2);
$last_time = substr($last_time, 0,5);
list($last_timehr,$last_timemin) = split(":",$last_time,2);
$cnt=0;
$time_val[0]="00:00";
$sublast_date = substr($last_time, 0,4)."0";
while($time_val[$cnt] <= $sublast_date){
        $cnt++;
        $time_val[$cnt] = $time_interval[$cnt];
}

This code is for 0th hour of current day to 24hours.

So Similarly for the last 24hours I need the code like this.
But how to decrement based on the current hour for one day

bradgrafelman

I would say don't bother with some complicated PHP solution, just let the database do the work - look at using the Date and Time Functions if using MySQL, such as DATE_SUB().