How to select id in turn?

Question

PHP

Greetings!

There are several userids, let's say they look like this:

$users = [1,2,3,4,5];
$lastuser = 1;

The task is as follows: I take one id from the $users array and send it some data, then I write this id to $lastuser. Now the question is - how can I select the next id from the array, taking into account $lastuser?

Let's say if $lastuser=3 - then accordingly $users should return 4 to me - and so on. (from 5 to 1).

Answer 1

In general, the literal answer

$next = array_search($lastuser,$users)+1;
$user = $users[$next] ?? $users[0];

But I would choose directly from the database

select manager from users where id > ? order by id limit 1

and if the first one does not find anyone
select manager from users order by id limit 1