How can I loop through this array?

Question

I have an array from a database that I'd like to loop through and where the item_id is the same, add the qty(quantity) to get a total quantity. I've tried using a while loop to into the inner arrays with a maximum count determined by count(outer array) and this hasn't presented me with a desired outcome.

Here's the array:

Array
(
    [0] => Array
        (
            [id] => 8
            [lpo_id] => 20
            [invoice_no] => 1483958702
            [external_invoice_no] => 1
            [item_id] => 21
            [qty] => 14
            [currency] => USD
            [price] => 1.31
            [date] => 1483909200
            [supplier_id] => 9
        )

    [1] => Array
        (
            [id] => 9
            [lpo_id] => 20
            [invoice_no] => 1483958702
            [external_invoice_no] => 1
            [item_id] => 22
            [qty] => 15
            [currency] => USD
            [price] => 2.52
            [date] => 1483909200
            [supplier_id] => 9
        )

)

Here's the DB query:

public function getSupplierInvoiceByRefNo($ourRef) {
  $sql = "SELECT * FROM `{$this->_table_20}` WHERE `invoice_no` = '$ourRef'";
  return $this->db->fetchAll($sql);
}

public function fetchAll($sql) {
    $result = $this->query($sql);
    $out = array();
    while($row = mysqli_fetch_assoc($result)) {
        $out[] = $row;
    }
    mysqli_free_result($result);
    return $out;
}

DB Table:

id | lpo_id | invoice_no | external_invoice_no | item_id | qty | currency | price | date | supplier_id

Desired output is to have the following table where line items with same item_id have a totaled qty and are displayed only once in the output table

item_id | qty | price | currency

Sorry, but I fail to see your php code you said you tried. How do you expect us to help with it if you do not post it? — arkascha
– arkascha, Commented Jan 9, 2017 at 11:20
And why should list() not be available in php versions lower than 7? — arkascha
– arkascha, Commented Jan 9, 2017 at 11:21
I would say you could do this quicker and more simply by changing the query you run on the database to do this all for you. Post your query. Always try to fix the source of the error, Fiddling rubbish into good data is a bad practice — RiggsFolly
– RiggsFolly, Commented Jan 9, 2017 at 11:21
$final_sum = array(); foreach ($array as $arr){ $final_sum[$arr['item_id']] = $final_sum[$arr['item_id']]+$arr['qty']]; } echo "<pre/>";print_r($final_sum); — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jan 9, 2017 at 11:22

malutki5200 · Accepted Answer · 2017-01-09 11:18:53Z

3

Try the following code:

foreach($arrays as $a) 
{
   foreach ($a as $key => $value) 
       echo $key . '=' . $value;
}

Good luck.

answered Jan 9, 2017 at 11:18

malutki5200

1,1128 silver badges15 bronze badges

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

1 Comment

RiggsFolly Over a year ago

Would be simpler to FIX the query to do the selection correctly

Cepheus · Accepted Answer · 2017-01-09 12:35:23Z

2

This query should produce what you are after

SELECT item_id, SUM(qty) as qty, price, currency 
FROM `{$this->_table_20}` 
WHERE `invoice_no` = '$ourRef'
GROUP BY item_id";

edited Jan 9, 2017 at 12:35

Cepheus

4,9616 gold badges38 silver badges48 bronze badges

answered Jan 9, 2017 at 12:00

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Comments

Passionate Coder · Accepted Answer · 2017-01-09 11:27:42Z

2

You can try something like this

$data = array(
array('id'=>1,'item_id'=>2,'qty'=>13),
array('id'=>2,'item_id'=>3,'qty'=>16),
array('id'=>3,'item_id'=>2,'qty'=>33),
array('id'=>3,'item_id'=>3,'qty'=>43),
array('id'=>3,'item_id'=>4,'qty'=>30));

$new = array();
foreach($data as $value){
if($new[$value['item_id']]){
    $new[$value['item_id']]+= $value[qty];
}else{
  $new[$value['item_id']] = $value['qty'];
}

}echo "<pre>";print_r($new);

Output

Array
(
    [2] => 46
    [3] => 59
    [4] => 30
)

answered Jan 9, 2017 at 11:27

Passionate Coder

7,3042 gold badges24 silver badges50 bronze badges

1 Comment

RiggsFolly Over a year ago

Would be simpler to FIX the query to do the selection correctly

Death-is-the-real-truth · Accepted Answer · 2017-01-09 11:41:32Z

2

I think you want like this:-

$final_sum = array();

foreach ($array as $arr){
  $final_sum[$arr['item_id']] += $arr['qty']];
}

echo "<pre/>";print_r($final_sum); // will give you an array of keys = item_id and values = sum of those id's quantities from original array

Note:- It will be really easy if you do it through query by using SUM() as suggested by @RiggsFolly

edited Jan 9, 2017 at 11:41

answered Jan 9, 2017 at 11:24

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

3 Comments

RiggsFolly Over a year ago

Would be simpler to FIX the query to do the selection correctly

Death-is-the-real-truth Over a year ago

@RiggsFolly aggreed

Cepheus Over a year ago

I would also prefer a query alternative if possible.

Collectives™ on Stack Overflow

How can I loop through this array?

4 Answers 4

1 Comment

Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related