How to count number of consecutive null values in array

Question

I have an array of customers that has a nested array of payments.

"customer_1" => array:4 [▼
 0 => "211.79"
 1 => "206.20"
 2 => "0.00"
 3 => "0.00"
 4 => "220.90"
]

 "customer_2" => array:4 [▼
 0 => "0.00"
 1 => "0.00"
 2 => "0.00"
 3 => "0.00"
 4 => "220.90"
]

I need to count, for each customer, the amount of consecutive payments, starting from the top of the array that are 0.00.

So I would need it to return something like:

"customer_1" => 0
"customer_2" => 4

I've tried a bunch of while and foreach loops but can't get it to work:

@php($count = 0)

    @foreach($array as $arr)

        @if($arr = "0.00")
            @php($count = $count + 1)
        @else
            @continue
        @endif

    @endforeach

Not really clear, according to your example."customer_1" 's value is 211.79+206.20+220.90? — TsaiKoga
– TsaiKoga, Commented Jan 28, 2020 at 5:33
I need a count of consecutive "0.00" payments, not a sum of payments. Customer 1 has no consecutive "0.00" payments from the top of the array, therefore customer_1 = 0. — Dexx
– Dexx, Commented Jan 28, 2020 at 5:40
But I think customer_1 have two consecutive '0.00',am i wrong? — TsaiKoga
– TsaiKoga, Commented Jan 28, 2020 at 5:46
Correct, however not from the start of the array. Their first payment is 211.79 so therefore count should be 0. — Dexx
– Dexx, Commented Jan 28, 2020 at 5:47

TsaiKoga · Accepted Answer · 2020-01-28 06:01:21Z

1

Check the first element, if it is 0.00, then just calculate the consecutive 0.00, or just break the loop:

$count = 0;
if ($array[0] == "0.00") {
    foreach($array as $item) {
        if($item == "0.00") {
            $count += 1;
        } else {
            break;
        }
    }
}
return $count;

For blade:

@php($count = 0)

@if($arr[0] == "0.00")
@foreach($array as $arr)

   @if($arr == "0.00")
      @php($count += 1)
   @else
      @break
   @endif

@endforeach
@endif

edited Jan 28, 2020 at 6:01

answered Jan 28, 2020 at 5:56

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dexx Over a year ago

Appreciate the blade syntax! Great job.

Neeraj Amoli · Accepted Answer · 2020-01-28 05:28:53Z

0

you are assigning value to variable inside if condition , you need to compare "0.00" inside if condition .

@php($count = 0)

  @foreach($array as $arr)

    @if($arr == "0.00")
        @php($count = $count + 1)
    @else
        @continue
    @endif

 @endforeach

edited Jan 28, 2020 at 5:28

answered Jan 28, 2020 at 5:24

Neeraj Amoli

1,0361 gold badge11 silver badges18 bronze badges

2 Comments

Dexx Over a year ago

Hey still doesn't work, it outputs count as the same amount of payments. customer_1 => 5, customer_2 =>5

Neeraj Amoli Over a year ago

@Dexx please look this refernce geeksforgeeks.org/count-consecutive-pairs-of-same-elements hope this is your requirements :)

Karan Khimani · Accepted Answer · 2020-01-28 05:38:10Z

0

$sum = 0;

foreach($items as $item) {
    $sum += $item;
}

echo $sum;

Try this @dexx

answered Jan 28, 2020 at 5:38

Karan Khimani

454 bronze badges

1 Comment

Dexx Over a year ago

Hey thanks for responding however that is summing the values, I need a count of consecutive "0.00" payments from the beginning of the array.

Collectives™ on Stack Overflow

How to count number of consecutive null values in array

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related