Check that all items are equal

Question

I am recovering from the database all expired tickets, with the following query

SELECT user,status,hash 
      FROM ticket 
      WHERE datepay < date_add(now(), interval -1 month) AND user = '119'

The result is as expected, as below. It reads status:usuário

0:118 0:119 0:119

However I need to check if all status is 1 (means paid), if there is at least one user with 0:119 already invalid. I tried using array_unique, but it will check all users and I will not know which one did not pay all.

Answer 1

What you need is to deal with for, the logic is simple

Se user.status == 0 então diga "usuário pendente"; 
  parar;
senão
  "o usuário está em dias";

In practice it would look something like this, considering that the variable $ftc is the object of the query (fetchAll):

for($i = 0; $i <= count($ftc); $i++){
  if($ftc[$i]["status"] == "0"){
    echo "O usuário {$ftc[$i]["user"]} ainda tem fatura pendente".PHP_EOL;
    break;
  }else{
    echo "O usuário {$ftc[$i]["user"]} pode ser liberado".PHP_EOL;
  }
}

Since you said that if at least one ticket is pending is no longer valid, then you don’t need to check all the elements, just stop the X user iteration and continue to the next one recursively.

Cons

If there are too many pending users, the application will be slow, taking a high cost in server performance.