X RPL | Ulangan Tengah Semester (Praktikum) Semester 2 Test #3

geekdive commented 6 years ago

Buat sebuah database inventori jika sudah ada tampilkan database dan data didalam database Inventori Sisipkan Gambar, pada bagian comment.

Jawab Pertanyaan:

Capture -> kemudian copy dan paste pada comment, secara otomatis gambar akan di upload.

ProgrammerMuda commented 6 years ago

Format

create table inventori(kodeInventori varchar(65) not null, InventoriName varchar(65) not null, Jumlahinventori varchar(65) not null, tanggal varchar(20) not null);
INSERT INTO `inventori` (`kodeInventori`, `InventoriName`, `Jumlahinventori`, `tanggal`) VALUES ('0001', 'laptop', '2', '18 Maret 2018');
INSERT INTO `inventori` (`kodeInventori`, `InventoriName`, `Jumlahinventori`, `tanggal`) VALUES ('0002', 'Handphone','4', '15 Maret 2018');
INSERT INTO `inventori` (`kodeInventori`, `InventoriName`, `Jumlahinventori`, `tanggal`) VALUES ('0003', 'Television','1', '21 Maret 2018');
INSERT INTO `inventori` (`kodeInventori`, `InventoriName`, `Jumlahinventori`, `tanggal`) VALUES ('0004', 'Radio','1', '02 Maret 2018');
INSERT INTO `inventori` (`kodeInventori`, `InventoriName`, `Jumlahinventori`, `tanggal`) VALUES ('0005', 'Infocus','5', '12 Maret 2018');

daffaalam commented 6 years ago

CREATE DATABASE ezyro_21741448_uts_10_2;
USE ezyro_21741448_uts_10_2;
CREATE TABLE inventaris (id TINYINT(3) NOT NULL AUTO_INCREMENT, codename CHAR(10), nama VARCHAR(30), jumlah INT(5), tanggal DATE, keterangan TEXT, PRIMARY KEY (id));
INSERT INTO inventaris VALUES (NULL, 'inv01', 'Komputer', 2, '2018-03-08', '');
INSERT INTO inventaris VALUES (NULL, 'inv02', 'Bola Basket', 5, '2018-03-08', ''), (NULL, 'inv03', 'Bola Volli', 3, '2018-03-08', ''), (NULL, 'inv04', 'Bola Futsal', 5, '2018-03-08', ''), (NULL, 'inv05', 'Infocus', 10, '2018-03-08', '');
SELECT * FROM inventaris;

jepretan layar 2018-03-09 pada 13 19 42

<?php include 'soal2.php'; ?>
<!DOCTYPE html>
<html>
<head>
    <title>UTS Kelas 10 Semester 2 - Test 3</title>
</head>
<body>
    <br><br><br>
    <table width="100%">
        <thead>
            <tr>
                <th>ID</th>
                <th>CodeName</th>
                <th>Nama Barang</th>
                <th>Jumlah</th>
                <th>Tanggal Masuk</th>
                <th>Keterangan</th>
            </tr>
        </thead>
        <tbody align="center">
            <?php
            $pilih = "SELECT * FROM inventaris";
            $kueri = mysqli_query($koneksi, $pilih);
            while ($data = mysqli_fetch_array($kueri)) {
                echo "<tr>";
                echo "<td align=\"center\">" . $data[id] . "</td>";
                echo "<td>" . $data[codename] . "</td>";
                echo "<td>" . $data[nama] . "</td>";
                echo "<td>" . $data[jumlah] . "</td>";
                echo "<td>" . $data[tanggal] . "</td>";
                echo "<td>" . $data[keterangan] . "</td>";
                echo "<td>";
                echo "</tr>";
            }
            ?>
        </tbody>
    </table>
</body>
</html>

http://daffaalam.ezyro.com/UTS-10-2/soal3.php

geekdive / Issue-Configuration

X RPL | Ulangan Tengah Semester (Praktikum) Semester 2 Test #3 #12