create a table for each different array value in specific key

Question

I have the following array:

I am trying to create a loop which will print array data in separate tables, on base on the key SUPPLIER_C

So one table will contain data where the key SUPPLIER_C is 000620, another table for the data where the key SUPPLIER_C is 003053 etc...

My code bellow, does not produce the results that I want:

foreach ($suppliers_invoices['data'] as $key=>$invoice) {
.....table code here...
}

The code above print a table header and only the first row, and then print again new table, even the key SUPPLIER_C is not changed.

Any help will be deeply appreciated.

Split the array to some ones having the only key. and build tables for each array — splash58
– splash58, Commented Oct 31, 2017 at 7:16
Any idea how that can be done? Can you post any code snippet? — user2417624
– user2417624, Commented Oct 31, 2017 at 7:18
Iterate over array and check required key. Add current item to another array defined by the key. — u_mulder
– u_mulder, Commented Oct 31, 2017 at 7:19

bumperbox · Accepted Answer · 2017-10-31 07:24:58Z

1

$invoice_by_supplier = [];
$suppliers = [];

foreach ($suppliers_invoices['data'] as $invoice) {
  $supplier_c = $invoice['SUPPLIER_C'];
  $suppliers[$supplier_c] = $invoice['SUPPLIER_NAME'];
  $invoice_by_supplier[$supplier_c][] = $invoice;
}

foreach ($suppliers as $supplier_c => $supplier_name) {
  ...table head

  foreach ($invoice_by_supplier[$supplier_c] as $invoice) {
    .....table body here...
  }

  .. table foot
}

answered Oct 31, 2017 at 7:24

bumperbox

10.2k6 gold badges46 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create a table for each different array value in specific key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related