move a specific subarray to the top of a multidimensional array

Question

I have an array of rows (from a mysql table)
And need to move to the top a subarray - i.e. a row - having id = $x
Tried a modified solution from here - without success

$st = $db->prepare("select id, nick from presto where id < 4");
$st->execute();
$rows = $st->fetchAll(PDO::FETCH_ASSOC);
print_r($rows);

result

Array ( [0] => Array ( [id] => 52 [nick] => 5fb63a1a8bcbf ) [1] => Array ( [id] => 54 [nick] => 5fb63a1a75171 ) [2] => Array ( [id] => 59 [nick] => 5fb63a1a91e68 ) )

$x = 54;

foreach($rows as $key => $val){
    if($key['id'] == $x){  // line 155
        unset($rows[$key]);
        array_unshift($rows, $val);
    }
}

and getting Warning - Trying to access array offset on value of type int on line 155

please help

Can you please check this url stackoverflow.com/questions/5312879/… — Lokendra Singh Panwar
– Lokendra Singh Panwar, Commented Nov 22, 2022 at 11:44
A query with "where id < 4" can never give a result like you show. If you want to exclude certain id you can already do that with SQL "NOT IN". — jspit
– jspit, Commented Nov 22, 2022 at 11:55
@jspit - are you sure ? I'm getting rows having id as 1, 2, or 3. What's the problem ? — provance
– provance, Commented Nov 22, 2022 at 16:04
And where does the ID 54 that you want to bring to the top come from? Sample data and code are inconsistent. — jspit
– jspit, Commented Nov 22, 2022 at 18:18
@jspit - you're right, that's a mistake, but it's already solved, thanks a lot — provance
– provance, Commented Nov 23, 2022 at 9:36

Richard Leishman · Accepted Answer · 2022-11-22 11:43:07Z

1

$key on line 155 is the index/iteration/position in the array/foreach, which is an integer, not an array. $val is your data array from each iteration.

Try this.

$x = 54;

foreach($rows as $key => $val){
    if($val['id'] === $x){  // line 155
        unset($rows[$key]);
        array_unshift($rows, $val);
    }
}

edited Nov 22, 2022 at 11:43

answered Nov 22, 2022 at 11:36

Richard Leishman

694 bronze badges

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

Collectives™ on Stack Overflow

move a specific subarray to the top of a multidimensional array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related