Mohon bantuannya saya ingin membuat report dengan php
database yang saya punya:

---

| klp_produk | barcode | jenis | klp_jenis | harga |

---

| Makanan | 1708000000000215410| Bakso | Basah | 10,000 |
| Makanan | 1708000000000215411| Nasi Goreng | Kering | 12,000 |
| Minuman | 1708000000000215412| Es Teh | Dingin | 4,000 |
| Minuman | 1708000000000215413| Teh Hangat | Hangat | 4,000 |
| Cemilan | 1708000000000215414| Keripik Ubi | Kering | 5,000 |

---

dari database diatas saya ingin membuat report tabel di php dengan format yang dihasilkan:

---

| | | Jumlah per Kelompok Produk | |
| | |

---

| Total |
|No. |Kelompok/Jenis| Makanan | Minuman | Cemilan | |
| | |

---

|

---

|
| | | Byk | Harga | Byk | Harga | Byk | Harga | Byk | Harga |

---

| A | Basah |
| |

---

| 1 | Bakso | 1 | 10,000| | | | | 1 | 10,000 |

---

|Sub Total Basah | 1 | 10,000| | | | | 1 | 10,000 |

---

| B | Kering |
| |

---

| 1 | Nasi Goreng | 1 | 12,000| | | | | 1 | 12,000 |
| 2 | Keripik Ubi | | | | | 1 | 5,000 | 1 | 5,000 |

---

| Sub Total Kering | 1 | 12,000| | | 1 | 5,000 | 2 | 17,000 |

---

| C | Dingin |
| |

---

| 1 | Es Teh | | | 1 | 4,000| | | 1 | 4,000 |

---

| Sub Total Dingin | | | 1 | 4,000| | | 1 | 4,000 |

---

| D | Hangat |
| |

---

| 1 | Teh Hangat | | | 1 | 4,000| | | 1 | 4,000 |

---

| Sub Total Hangat | | | 1 | 4,000| | | 1 | 4,000 |

---

| Grand Total | 2 | 22,000| 2 | 8,000| | | 5 | 35,000 |

---

Demikian, tks