Perhatikan Script codingan Berikut:

Perhatikan Script codingan Berikut: 

<?php

include "koneksi.php";

?>

<h1 class="mt-4">TRANSAKSI</h1>

    <form action="" method="POST">

    <div class="mb-3">

    Jenis Laundry  <select class="form-select" name="id_jenislaundry" id="">

            <?php

            $query = mysqli_query($koneksi, "select * from jenis_laundry");

            while ($data = mysqli_fetch_array($query)) {

                ?>

                <option value="<?php echo $data['id_jenislaundry']; ?>"><?php echo $data['nama_jenislaundry'] ?></option>

            <?php

            }

            ?>

        </select>

    </div>

    <div class="mb-3">

    <label class="form-label">Qty</label>

    <input type="text" class="form-control" name="qty">

    </div>

    <button class="btn btn-primary" name="simpan" type="submit">Simpan</button>

    </form>

    <form action="" method="POST">

    Nama  Konsumen:<div class="mb-3">

     <select class="form-select" name="kode_konsumen" id="">

            <?php

            $query = mysqli_query($koneksi, "select * from konsumen");

            while ($data = mysqli_fetch_array($query)) {

                ?>

                <option value="<?php echo $data['kode_konsumen']; ?>"><?php echo $data['nama_konsumen'] ?></option>

            <?php

            }

            ?>

        </select>

    </div>

<br>

        <button class="btn btn-danger" name="selesai" type="submit">Selesai</button>

    </form>

<?php

if (isset($_POST['simpan'])) {

    //menyimpan ke tabel

    $id_jenislaundry = $_POST['id_jenislaundry'];

    $qty = $_POST['qty'];

    $query = mysqli_query($koneksi, "insert into transaksi (id_jenislaundry,qty) values ('$id_jenislaundry','$qty')");

}

if (isset($_POST['selesai'])) {

    //membuat nota

    // $kode_konsumen=$_POST['kode_konsumen'];

    // $query=mysqli_query($koneksi,"select max(nota) as nota from transaksi");

    // $data=mysqli_fetch_array($query);

    // $nota=$data ['nota']+1;

    // $user=$_SESSION['username'];  

    // $query=mysqli_query($koneksi,"update transaksi set nota='$nota', status='1', username='$user' where status='0'");

    $query=mysqli_query($koneksi,"update transaksi set status='1' where status='0'");

}

?>

<hr>

<table class="table table-striped">

    <tr>

        <th>No</th>

        <th>Jenis Laundry</th>

        <th>Harga</th>

        <th>Qty</th>

        <th>Jumlah</th>

        <th>Aksi</th>

     </tr>

    <?php

    $query=mysqli_query($koneksi,"SELECT jenis_laundry.nama_jenislaundry, jenis_laundry.tarif, transaksi.id, transaksi.qty

    FROM jenis_laundry

    JOIN transaksi ON transaksi.id_jenislaundry = jenis_laundry.id_jenislaundry

    WHERE

    transaksi.status = 0");

    $total=0;

    $i = 1;

    while($data = mysqli_fetch_array($query)) {

    ?>

    <tr>

        <td><?php  echo  $i++ ?></td>

        <td><?php  echo  $data['nama_jenislaundry']  ?></td>

        <td><?php  echo  $data['tarif']  ?></td>

        <td><?php  echo  $data['qty']  ?></td>

        <td><?php  echo  $data['tarif']* $data['qty']  ?></td>

        <td><button class="btn btn-warning"><a style="color: white; text-decoration: none;" href="?page=transaksi/hapus&id=<?php echo $data['id']?>">Hapus</a></button></td>

    </tr>

<?php

    $total=$total + ($data['tarif']*$data['qty']);

    }

?>

<tr>

    <th colspan="4">Total</th>

    <th><?php echo $total; ?></th>

    <td></td>

</tr>

</table>

Tugas:

Salin dibuku tugas kalian script diatas!

Apa fungsi file index tersebut diatas!

Gambarkan ERD dari project web laundry yang kalian buat!

Diskusikan dengan teman sebangku kalian untuk membuat 5 pertanyaan terkait codingan diatas beserta jawabannya!