php根据第2表排序数据

Question

I have two tables: Table 1 and Table 2

I need to sort the data as shown in Table View.

I have already taken:

foreach($Table1 as $row1 )
{
    foreach($Table2 as $row2 )
    {
          if($row1->id == $row2->selected_id)
          {
                  show??
          }
    }

}

please do not worry about queries: it is taken care of real issue is:

there is only one problem: Table 1 is generated from 20 different function and collects to Table 1. and user selects which they want to view by selecting. so, if there is total of 7 rows and user selects 3, so data will be sorted showing 3 rows selected at first rows and rest after the 3 rows.

is this the right way to do it? or is there much easier way I am using MySQL

please help anyone?

Answer 1

As per your additional question, it seems that you don't want to use MySQL for that, and that your user selection is in fact an array like this one:

$filter = [ 3, 4, 7, 8 ];

Filter the original $Table1 array by using array_reduce. With this method you obtain an array ($filtered) with user selection in element 0 and other values in element 1:

$filtered = array_reduce
(
    $Table1,
    function( $carry, $item ) use( $filter )
    {
        $index = !in_array( $item['id'], $filter );
        $carry[$index][] = $item;
        return $carry;
    },
    [ [], [] ]
);

Then, merge $filtered data with call_user_func_array:

$result = call_user_func_array( 'array_merge', $filtered );

Result:

Array
(
    [0] => Array
        (
            [id] => 3
            [name] => C
        )
    [1] => Array
        (
            [id] => 4
            [name] => D
        )
    [2] => Array
        (
            [id] => 7
            [name] => G
        )
    [3] => Array
        (
            [id] => 8
            [name] => H
        )
    [4] => Array
        (
            [id] => 1
            [name] => A
        )
    [5] => Array
        (
            [id] => 2
            [name] => B
        )
    [6] => Array
        (
            [id] => 5
            [name] => E
        )
    [7] => Array
        (
            [id] => 6
            [name] => F
        )
)