Praktikum Web (PHP) Semester 8: Part 4

CREATE TABLE `barang` (
`id` INT NOT NULL AUTO_INCREMENT ,
`idjenisbarang` int(11) NOT NULL,
`namabarang` varchar(200) NOT NULL,
`harga` double NOT NULL,
PRIMARY KEY (`id`)) ENGINE = InnoDB;

INSERT INTO `barang` (`id`, `idjenisbarang`, `namabarang`, `harga`) VALUES
(NULL, 1, 'Celana Kargo', 300000),
(NULL, 1, 'Kemeja Pantai', 250000),
(NULL, 2, 'Blouse Putih', 270000),
(NULL, 2, 'Rok Panjang', 350000)

SELECT B.*, JB.namajenisbarang
FROM barang B
LEFT JOIN jenisbarang JB ON B.idjenisbarang = JB.id

<div class="form-group">
    <label for="namajenisbarang">Jenis Barang</label>
    <select class="form-control" name="idjenisbarang">
        <?php
        include_once "database/database.php";
        $database = new Database();
        $db = $database->getConnection();

        $selectSQL = "SELECT * FROM jenisbarang";
        $stmt = $db->prepare($selectSQL);
        $stmt->execute();

        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            echo "<option value=\"".$row["id"]."\">" . $row["namajenisbarang"] . "</option>";
        }
        ?>
    </select>
</div>

<div class="form-group">
    <label for="namajenisbarang">Nama Jenis Barang</label>
    <select class="form-control" name="idjenisbarang">
        <?php
        include_once "database/database.php";
        $database = new Database();
        $db = $database->getConnection();

        $selectSQL = "SELECT * FROM jenisbarang";
        $stmt = $db->prepare($selectSQL);
        $stmt->execute();

        while ($rowSelect = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $selected = "";
            if($row["idjenisbarang"] == $rowSelect["id"]){
                $selected = " selected";
            }
            echo "<option value=\"" . $rowSelect["id"] . "\"  $selected>" . $rowSelect["namajenisbarang"] . "</option>";
        }
        ?>
    </select>
</div>

CREATE TABLE `pengguna` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `username` varchar(25) NOT NULL,
  `password` varchar(200) NOT NULL,
  `namalengkap` varchar(200) NOT NULL,
  `isadmin` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)) ENGINE = InnoDB;

INSERT INTO `pengguna` (`id`, `username`, `password`, `namalengkap`, `isadmin`) VALUES
(NULL, 'admin', md5("admin"), 'Nama Admin', 1),
(NULL, 'user', md5("user"), 'Nama User', 0);

<div class="form-group">
    <div class="custom-control custom-switch">
        <input type="checkbox" class="custom-control-input" id="isadmin" name="isadmin">
        <label class="custom-control-label" for="isadmin">Admin</label>
    </div>
</div>

<div class="form-group">
    <div class="custom-control custom-switch">
        <?php $checked = $row['isadmin'] == 1 ? " checked" : ""  ?>
        <input type="checkbox" class="custom-control-input" id="isadmin" name="isadmin" <?php echo $checked ?>>
        <label class="custom-control-label" for="isadmin">Admin</label>
    </div>
</div>