fork download
copy 
  1. <?php
  2. $data = 
  3.             array(
  4.                 array('time' => '2014-12-01T00:00:00', 'value' => 0.0107),
  5.                 array('time' => '2014-12-01T00:05:35', 'value' => 0.0321),
  6.                 array('time' => '2014-12-01T00:05:35', 'value' => 0.0107),
  7.                 array('time' => '2014-12-01T00:06:41', 'value' => 0.0119),
  8.                 array('time' => '2014-12-01T00:06:41', 'value' => 0.0109),
  9.                 array('time' => '2014-12-01T00:06:41', 'value' => 0.0108),
  10.                 array('time' => '2014-12-01T00:06:41', 'value' => 0.0109),
  11.                 array('time' => '2014-12-01T00:06:41', 'value' => 0.0108),
  12.                 array('time' => '2014-12-02T00:06:41', 'value' => 0.0108)
  13.             );
  14.  
  15.         $sortedData = array();
  16.         $index = 0;
  17.         foreach ($data as $element) {
  18.             $timestamp = strtotime($element['time']);
  19.             $date = date("d.m.Y", $timestamp); 
  20.             if ( ! isset($sortedData[$date][$element['time']]) ) { 
  21.                 $sortedData[$date][$element['time']] = $element;
  22. $sortedData[$date][$element['time']]['lowest_value'] = $element['value'];
  23.             }
  24.                 if ($sortedData[$date][$element['time']]['lowest_value'] >  $element['value']) {
  25.                     $sortedData[$date][$element['time']] = $element;
  26.                     $sortedData[$date][$element['time']]['lowest_value'] =  $element['value'];
  27.                 }
  28.         }
  29.  
  30. var_dump($sortedData);
Success #stdin #stdout 0.02s 24448KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
array(2) {
  ["01.12.2014"]=>
  array(3) {
    ["2014-12-01T00:00:00"]=>
    array(3) {
      ["time"]=>
      string(19) "2014-12-01T00:00:00"
      ["value"]=>
      float(0.0107)
      ["lowest_value"]=>
      float(0.0107)
    }
    ["2014-12-01T00:05:35"]=>
    array(3) {
      ["time"]=>
      string(19) "2014-12-01T00:05:35"
      ["value"]=>
      float(0.0107)
      ["lowest_value"]=>
      float(0.0107)
    }
    ["2014-12-01T00:06:41"]=>
    array(3) {
      ["time"]=>
      string(19) "2014-12-01T00:06:41"
      ["value"]=>
      float(0.0108)
      ["lowest_value"]=>
      float(0.0108)
    }
  }
  ["02.12.2014"]=>
  array(1) {
    ["2014-12-02T00:06:41"]=>
    array(3) {
      ["time"]=>
      string(19) "2014-12-02T00:06:41"
      ["value"]=>
      float(0.0108)
      ["lowest_value"]=>
      float(0.0108)
    }
  }
}
https://ideone.com/9W5lbZ
language:
PHP (php 7.3.5)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!