How to join two array variables into one in php?

Question

Good afternoon

I have the following code

<?php
include_once("con.php");

$pdo = conectar();

$data = file_get_contents("php://input");
$data = json_decode($data);

$idempresa = $data->idempresa;
$subcategoria = "Recebimento";

$buscaContaEntrada=$pdo->prepare('SELECT * FROM conta WHERE empresa_idempresa=:idempresa AND subcategoria=:subcategoria');
$buscaContaEntrada->bindValue('idempresa', $idempresa);
$buscaContaEntrada->bindValue('subcategoria', $subcategoria);
$buscaContaEntrada->execute();

while ($linha=$buscaContaEntrada->fetch(PDO::FETCH_ASSOC)) {

    $return[] = array(
        'idconta'   => $linha['idconta'],
        'conta' => utf8_encode($linha['conta']),
        'idsubcategoria'    => utf8_encode($linha['subcategoria_idsubcategoria']),
    );
}

echo json_encode($return);
?>

But I need to take the given idsubcategory, do another select, in the database, and the result, play within $Return... How can I do this?

Answer 1

To unite 2 arrays in 1 you can use the function array_merge, example :

<?php
$array1 = array("cor" => "vermelho", 2, 4);
$array2 = array("a", "b", "cor" => "verde", "forma" => "trapezoide", 4);
$result = array_merge($array1, $array2);
echo json_encode($result);
?>
//saida
{"cor":"verde","0":2,"1":4,"2":"a","3":"b","forma":"trapezoide","4":4}

Answer 2

Dude, take off that first bracket

$return[] = array(

Vira

$return = array(

Because this way you are creating 2 levels of array (Return[0][data]) and when you will read in js is giving Object because it is actually Object same.

To simply merge two arrays is array_merge, but my answer there solves what you want

Answer 3

Creates a function that searches the data for the Idcategory and then adds its return to your array.

while ($linha=$buscaContaEntrada->fetch(PDO::FETCH_ASSOC)) {
    $novaVariavelParaInserirNoArray = buscarInformacoesNoBanco($linha['subcategoria_idsubcategoria']);//funcao que realiza sua busca.
    $return[] = array(
        'idconta'   => $linha['idconta'],
        'conta' => utf8_encode($linha['conta']),
        'idsubcategoria'    => utf8_encode($linha['subcategoria_idsubcategoria']),
        'informacoesTrazidasDoBanco' => $novaVariavelParaInserirNoArray
    );
}

I believe that should suffice.