Assigning values to a numeric array of values a PHP query

Question

Given the table marcas of the database teste_db (for example)

| id |  marca  |

| 1  | mercedes|
| 2  |   audi  |
| 3  |   fiat  |
| 4  |   alfa  |
| ...|   ...   |
|573 | ferrari |
|574 | bentley |

and given an array with n numerical arguments such as:

$arr = array('3','23','127','574')

and assuming that the array will always contain numerical arguments that can be found in the column id of this table, I would like to include in the array, for each argument of this, the value marca whose id table has the same array value, and the result would be:

$arr = array("3"=>"fiat", "23"=>"rover", "127"=>"tata", "574"=>"bentley");

What code would be required for this task? PHP and mysqli.

Answer 1

If I understand correctly, you can do something like:

if ($result = mysqli_query('SELECT marca FROM marcas'))
{
    $arr = array('1', '2', '3', '4');
    $bancoDeDados = mysqli_fetch_all($result);
    $resultado = array_map(null, $arr, $bancoDeDados);

    print_r($resultado);
}

^{See working on Ideone | Repl.it}

That the result would be something similar to:

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => mercedes
        )

    [1] => Array
        (
            [0] => 2
            [1] => audi
        )

    [2] => Array
        (
            [0] => 3
            [1] => fiat
        )

    [3] => Array
        (
            [0] => 4
            [1] => alfa
        )

)

With the function array_map, passing the first parameter as null, will be returned a pair with the respective values of $arr and $bancoDeDados.