Untitled

<?php

$dumConn = mysqli_connect("localhost","root","","spm");

// =============================================================
// Default Values
// =============================================================
$totalSalesCalculated = false;

$quantity = 1;

$selectedItem = "";

$totalSales = 0;

$KodJualan = "-";

$tarikhJualan = "mm/dd/yyyy";
// =============================================================
// =============================================================

// if KodJualan is given, then get data from database
if (isset($_GET["KodJualan"])) {

    $KodJualan = $_GET["KodJualan"];
    $q3 = "SELECT * FROM jualan WHERE KodJualan='". $KodJualan ."'";
    $r3 = mysqli_query($dumConn, $q3);
    while ($row = mysqli_fetch_assoc($r3)) {
        $quantity = $row["KuantitiItemDijual"];
        $selectedItem = $row["KodItem"];
        $totalSales = $row["HargaJualan"];
        $tarikhJualan = $row["TarikhJualan"];
    }


}

// Calculate the total sales ONLY WHEN both NamaItem and KuantitiItemDijual is given
// WARNING/NOTE: this will overwrite $quantity and $selectedItem
if (isset($_POST["KID"]) && isset($_POST["NamaItem"])) {
    $totalSalesCalculated = true;
    $quantity = $_POST["KID"];
    $selectedItem = $_POST["NamaItem"];
    $totalSales = mysqli_fetch_assoc(mysqli_query($dumConn, "SELECT HargaPerItem from item WHERE KodItem='".$selectedItem."'"))["HargaPerItem"] * $quantity;
}

?>

<html>
<head>
</head>

<body>
    <form name="thisIsADumDumForm" action="proc-abc2.php" method="POST">
        Kod Jualan:
        <input name="KJ" value="<?php echo $KodJualan; ?>"></input>
        <br>

        TarikhJualan:
        <input name="TJ" value="<?php echo $tarikhJualan; ?>"></input>
        <br>

        Nama Item:
        <select name="NamaItem" class="NamaItem" onChange="reSubmit()">

            <?php
                $q = "SELECT KodItem, NamaItem FROM item";
                $r = mysqli_query($dumConn, $q);
                while ($row = mysqli_fetch_assoc($r)){
                    if ($row["KodItem"] != $selectedItem){
                        echo "<option value=\"" . $row["KodItem"] . "\">" . $row["NamaItem"] . "</option>";
                    } else {
                        echo "<option selected value=\"" . $row["KodItem"] . "\">" . $row["NamaItem"] . "</option>";
                    }
                }
            ?>
        </select>
        <br>

        Kuantiti Item Dijual
        <input name="KID" class="KID" value="<?php echo $quantity; ?>"></input>
        <br>

        Harga Jualan:
        <input class="HJ" value="<?php echo $totalSales; ?>"></input>
    </form>
</body>

<script>
    function reSubmit() {
        document.getElementsByName("thisIsADumDumForm")[0].action = "<?php echo $_SERVER["PHP_SELF"]; if(isset($_GET["KodJualan"])) echo "?KodJualan=" . $_GET["KodJualan"]; ?>";
        document.thisIsADumDumForm.submit();
    }
</script>


</html>