using foreach multiple times

Question

How can I use foreach multiple times?

<?php
    $query =  $db->query('SELECT tbl_stok.id_stok,
        tbl_stok.id_provinsi,
        tbl_stok.id_kabupaten,
        tbl_stok.tanggal,
        tbl_stok.mie_instan,
        tbl_stok.beras,
        tbl_stok.telur
        FROM `tbl_stok` INNER JOIN tbl_wilayah ON tbl_stok.id_provinsi = tbl_wilayah.id_user
    ');
    $query->fetchAll;
?>

I want to use the first foreach to show the data tables:

<?php foreach($query as $row){
    echo $row['beras'];
}?>

Then I want to use the second foreach for chart:

<?php foreach($query as $row){
    echo $row['telur'];
}?>

However, this foreach works only once.

You can make script work faster by using only one for instead of two foreach. Please see updated answer for more clarification. — Abhay Maurya
– Abhay Maurya, Commented Nov 11, 2016 at 10:23

Zenel Rrushi · Accepted Answer · 2016-11-11 09:27:37Z

2

You can do this:

1) save your data to an array.

foreach($query as $row){
    $data[]= $row;
}

2) use your array in every loop you want as many time you want

foreach($data as $row){
    echo $row['beras'];
}

foreach($data as $row){
    echo $row['telur'];
}

answered Nov 11, 2016 at 9:27

Zenel Rrushi

2,3861 gold badge21 silver badges35 bronze badges

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

Comments

Abhay Maurya · Accepted Answer · 2016-11-11 10:22:28Z

1

Use foreach only once and store all values you need, like this:

<?php 
   $beras_array = array();
   $telur_array = array();
   foreach($query as $row){
      $beras_array[] = $row['beras'];
      $telur_array[] = $row['telur'];
   }

  //you can use `for` explained later instead of two `foreach`
   foreach($beras_array as $b){
      echo $b;
   }
   foreach($telur_array as $t){
      echo $t;
   }

   //With this method you can also use only one for instead of two foreach
   $limit = count($beras_array);
   for($i=0; $i<$limit; $i++){
      echo $beras_array[$i];
      echo $telur_array[$i];
   }
?>

I hope it helps

edited Nov 11, 2016 at 10:22

answered Nov 11, 2016 at 9:26

Abhay Maurya

12.3k9 gold badges50 silver badges67 bronze badges

Collectives™ on Stack Overflow

using foreach multiple times

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related