How to relate 2 json tables to php?

Question

Good afternoon, my friends. I’m developing a plan system where I need to link 2 json tables to filter the data.

But I’m not succeeding. I tried to relate them by creating 2 foreachs and trying to create a link between the 2, but I was not successful.

One of my tables is called plans.json and contains data in array

Plans.json

    [
      {
        "codigo": 1,
        "minimo_vidas": 1,
        "faixa1": 10.00,
        "faixa2": 12,
        "faixa3": 15.00
      }
    ]

second table is the.json prices

    [
      {
        "registro": "reg1",
        "nome": "Bitix Customer Plano 1",
        "codigo": 1
      }
    ]

the two the "foreign key" code as referencing, however I am not able to join the two and display them.

Could someone help me find some solution ?

Answer 1

In this case, I suggest using json_decode and turn them into an array, then process these arrays to perform the 'relationship'. Ideally, the API would already be returning this related data within a json object property.

$planos = json_decode($jsonPlanos, true);
$precos = json_decode($jsonPrecos, true);

//indexar array planos:
$idxPlanos = [];
foreach ($planos as $p){
   $idxPlanos[$p['codigo']] = $p;
}

foreach ($precos as $p){
   $idxPlanos[$p['codigo']]['preco'] = $p; 
}

//liberar arrays
unset($precos); unset($planos);
//exibir array pronto
var_dump($idxPlanos);