timestamp

[sandy1028]

Hi,

In the code below when status changes from 0 to 1 the difference is calculated.

When status is 0 the difference of timestamp is not calculated.
Please tell me how to do it.
i.e,

In one row I want the difference like $tdiff = 2008-06-13 00:30:00-2008-06-13 00:10:00

<?php
$values=array(
   "0#2008-06-13 00:10:00#master",
   "0#2008-06-13 00:20:00#master",
   "0#2008-06-13 00:30:00#master",
   "1#2008-06-13 00:40:00#stud",
   "0#2008-06-13 00:50:00#stud",
   "1#2008-06-13 01:10:00#stud"
   );

$i=0;
$outset = array();
$status = array();
$aset   = 0;

foreach($values as $v) //For each element in the values array
  {
  // Split the value by hash
  $vals = explode('#', $v);
  // If this is the first loop, set the previous status
  if($i == 0) {$previous_value = $vals[0]; $i=1; $starttime = $vals[1];}

  // If the previous =0 and the current is 1, store the values in a new array for output
  if($previous_value == 0 && $vals[0] == 1)
    {
    $aset             = 1;
    $tdiff             = date('h:i:s', strtotime($vals[1]) - strtotime($starttime));
    $outset[]          = $starttime.' '.$vals[1].' '.$tdiff.' '.$vals[2];

[sandy1028]

Sorry for the previous mail.

I have to find the difference when status is 0 through out the day.

<?php
$values=array(
   "0#2008-06-13 00:10:00#master",
   "0#2008-06-13 00:20:00#master",
   "0#2008-06-13 00:30:00#master",
   "1#2008-06-13 00:40:00#stud",
   "0#2008-06-13 00:50:00#stud",
   "1#2008-06-13 01:10:00#stud"
   );

$i=0;
$outset = array();
$status = array();
$aset   = 0;

foreach($values as $v) //For each element in the values array
  {
  // Split the value by hash
  $vals = explode('#', $v);
  // If this is the first loop, set the previous status
  if($i == 0) {$previous_value = $vals[0]; $i=1; $starttime = $vals[1];}
 // If the previous =0 and the current is 1, store the values in a new array for output
  if($previous_value == 0 && $vals[0] == 1)
    {
    $aset             = 1;
    $tdiff             = date('h:i:s', strtotime($vals[1]) - strtotime($starttime));
    $outset[]          = $starttime.' '.$vals[1].' '.$tdiff.' '.$vals[2];
    }

  if($vals[0] == 0 && $previous_value == 1)
    {
    $starttime         = $vals[1];
    }

  // Store the current, for the next loop it is previous value
  $previous_value     = $vals[0];
  $lasttime           = $vals[1];
  }

if($aset == 0)
  {
    $tdiff             = strtotime($vals[1])-strtotime($starttime);
    $outset[]          = $starttime.' '.$lasttime.' '.$tdiff.' '.$vals[2];
  }

echo"<pre>";
print_r($outset);
echo"</pre>";

[sandy1028]

hi,

Please anyone tell me why the timestamp difference is not showing based on the name.

While calculating the timestamp for master and stud the names are not displaying properly.

[leatherback]

Sandy,

As before: You need to be clear in your questions. What are you trying to ask us? A question asking 'why the timestamp difference is not showing based on the name' does not make any sense.

[sandy1028]

The output of above code shows
<pre>Array
(
[0] => 2008-06-13 00:10:00 2008-06-13 00:40:00 06:00:00 stud
[1] => 2008-06-13 00:50:00 2008-06-13 01:10:00 05:50:00 stud
)

[0] => 2008-06-13 00:10:00 2008-06-13 00:40:00 06:00:00 stud 

should be master. but it is showing as stud.

[leatherback]

It is showing stud because the records that have the 1 as status have the 'name' stud. If you want to know what the previous 'name' was (So the 'name' linked to the last record with a 0) you will need to store the last name, similar to:

$lasttime = $vals[1];

and use that to display the name.