<?php
$file = "2016/11/2 23:49:34,1,2,3,5 <---Array 0
2016/11/2 23:49:35,2,2,3,9 <---Array 1
2016/11/2 23:49:36,0,2,3,5 <---Array 2
2016/11/2 23:49:37,0,5,3,5 <---Array 3
2016/11/2 23:49:38,0,2,3,5 <---Array 4
2016/11/2 23:49:39,1,2,3,5 <---Array 5
2016/11/2 23:49:40,2,2,3,5 <---Array 6
2016/11/2 23:49:41,3,2,3,5 <---Array 7
2016/11/2 23:49:42,4,2,3,5 <---Array 8
2016/11/2 23:49:43,5,2,7,5 <---Array 9
2016/11/2 23:49:44,0,2,3,5 <---Array 10
2016/11/2 23:49:45,0,2,3,5 <---Array 11
2016/11/2 23:49:46,0,3,5,7 <---Array 12";
// $file = file_get_contents('temp.txt');
$rows = explode("\n", $file);
$i = 0;
$sum = 0;
foreach($rows as $row)
{
//get row data
$row_data = explode(',', $row);
$data = $row_data[1];
if($data == 0){
$sum = $sum + $PrevRow;
}
$PrevRow = $data;
$i++;
}
echo $sum;
- Output for 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.6 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.13
- 7
preferences:
94.3 ms | 408 KiB | 5 Q