I have the following array:
$grupo_empresas = [
['id_empresa' => 1, 'id_proveedor' => 101, 'proveedor' => 'Proveedor 101', 'compra' => 40],
['id_empresa' => 1, 'id_proveedor' => 102, 'proveedor' => 'Proveedor 102', 'compra' => 10],
['id_empresa' => 2, 'id_proveedor' => 101, 'proveedor' => 'Proveedor 102', 'compra' => 20],
['id_empresa' => 2, 'id_proveedor' => 102, 'proveedor' => 'Proveedor 102', 'compra' => 30],
['id_empresa' => 3, 'id_proveedor' => 103, 'proveedor' => 'Proveedor 103', 'compra' => 50]
];
Going through it with a foreach I get:
<?php foreach ($grupo_empresas as $cia) : ?>
<tr>
<td><?php echo $cia['id_empresa'] ?> </td>
<td><?php echo $cia['id_proveedor'] ?></td>
<td><?php echo $cia['proveedor'] ?></td>
<td><?php echo $cia['compra'] ?></td>
</tr>
<?php endforeach; ?>
Will it be possible to get the following report?
Or because of the type of array that I have it will not be possible?
You're doing well, he
foreach()
's a good start. Continue with this code:In any case, except for very specific cases, do not torture yourself with arrays and resort to databases, which allow you to reach these same results with simple queries.