How to add multidimensional array to another array?

PHP
1 
$a1 = mysqli_query($conn, "SELECT Id, Name FROM database");
$a = $a1->fetch_assoc();

$b = array(
    array('cl_name' => 'colorone', 'cl_id' => 'CL1'),
    array('cl_name' => 'colortwo', 'cl_id' => 'CL2'),
    array('cl_name' => 'colorthree', 'cl_id' => 'CL3'),
    array('cl_name' => 'colorfour', 'cl_id' => 'CL4'),
    array('cl_name' => 'colorfive', 'cl_id' => 'CL5'));

The $a array contains :

Array
(
[Id] => 1
[Name] => red
)
Array
(
[Id] => 2
[Name] => white
)
Array
(
[Id] => 3
[Name] => blue
)
Array
(
[Id] => 4
[Name] => black
)
Array
(
[Id] => 5
[Name] => yellow

I want each cl_id value from array $b to add under Id in the array $a, also the same for cl_name to Name

2 
$c = array_replace_recursive($a, $b);

if this is a cosmetic issue then you can ignore it. a string key will get you the correct value no matter which position it has in the hash table.

3

Are you looking for aliases? eg.

mysqli_query($conn, "SELECT Id AS cl_id, Name AS cl_name FROM database")
4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.