Membuat Halaman Tambah

Form HTML

<?php include __DIR__ . './../../includes/header.php'; ?>

    <div class="card border-radius p-4">
        <!-- baris judul halaman dan tombol tambah -->
        <div class="row align-items-center">
            <div class="col">
                <h1>Tambah Data Pengguna</h1>
            </div>
            <div class="col text-end">
                <a href="/views/data-pengguna/" class="btn btn-sm btn-outline-secondary"> 
                    Kembali
                </a>
            </div>
        </div>
        <!-- baris untuk tabel -->
        <div class="row mt-4">
            <div class="col">
                <form action="">
                    <div class="mb-3">
                        <label for="inputName" class="form-label">Nama</label>
                        <input type="text" class="form-control" id="inputName" placeholder="Masukkan nama anda" required>
                    </div>
                    <div class="mb-3">
                        <label for="inputEmail" class="form-label">Email</label>
                        <input type="email" class="form-control" id="inputEmail" placeholder="Masukkan email anda" required>
                    </div>
                    <div class="mb-3">
                        <label for="inputPassword" class="form-label">Password</label>
                        <input type="password" class="form-control" id="inputPassword" placeholder="Masukkan password anda" required>
                    </div>
                    <div>
                        <button type="submit" class="btn btn-primary btn-sm">Simpan</button>
                        <button type="reset" class="btn btn-secondary btn-sm">Reset</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

<?php include __DIR__ . './../../includes/footer.php'; ?>

Form HTML + Code Database

<?php require __DIR__ . '/../../includes/config.php'; ?>
<?php include __DIR__ . '/../../includes/header.php'; ?>

    <div class="card p-4">
        <div class="row mb-3">
            <div class="col-md-6">
                <h2>Tambah Data Pengguna</h2>
            </div>
            <div class="col-md-6 text-end">
                <a href="/views/data-pengguna/" class="btn btn-secondary btn-sm">Kembali</a>
            </div>
        </div>

        <div class="row">
            <div class="col-md-12">
                <form action="" method="post">
                    <div class="mb-3">
                        <label for="nama-pengguna" class="form-label">Nama</label>
                        <input type="name" name="name" class="form-control" id="nama-pengguna" placeholder="Masukkan nama anda">
                    </div>
                    <div class="mb-3">
                        <label for="email-pengguna" class="form-label">Email</label>
                        <input type="email" name="email" class="form-control" id="email-pengguna" placeholder="Masukkan email anda">
                    </div>
                    <div class="mb-3">
                        <label for="password-pengguna" class="form-label">password</label>
                        <input type="password" name="password" class="form-control" id="password-pengguna" placeholder="Masukkan password anda">
                    </div>
                    <div class="mb-3">
                        <button type="submit" class="btn btn-primary">Simpan</button>
                        <button type="reset" class="btn btn-secondary">Reset</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <?php

        if ($_SERVER["REQUEST_METHOD"] == "POST") {

            date_default_timezone_set('Asia/Jakarta');

            $name = $_POST['name'];
            $email = $_POST['email'];
            $password = $_POST['password'];
            $created_at = date("Y-m-d H:i:s");

            // Hashing the password
            $hashed_password = password_hash($password, PASSWORD_DEFAULT);

            $sql = "INSERT INTO users (name, email, password, created_at) VALUES (:name, :email, :password, :created_at)";
            $stmt = $pdo->prepare($sql);
            
            $stmt->bindParam(':name', $name);
            $stmt->bindParam(':email', $email);
            $stmt->bindParam(':password', $hashed_password);
            $stmt->bindParam(':created_at', $created_at);
            
            if ($stmt->execute()) {
                echo "<script>alert('Data berhasil ditambah!'); window.location.replace('/views/data-pengguna/index.php');</script>";
            } else {
                echo "Failed to create user.";
            }
        }
    ?>

<?php include __DIR__ . '/../../includes/footer.php'; ?>

Tambah Barang

<?php require __DIR__ . '/../../includes/config.php'; ?>
<?php include __DIR__ . '/../../includes/header.php'; ?>

<?php 

    $query = "SELECT * FROM tbl_barang";
    $stmt = $pdo->query($query);
    $datas = $stmt->fetchAll(PDO::FETCH_ASSOC);

?>

<div class="card p-3">
    <div class="row">
        <div class="col-md-6">
            <h3>Tambah Data Barang</h3>
        </div>
        <div class="col-md-6 text-end">
            <a href="/views/data-barang/index.php" class="btn btn-secondary">
                <i class="fa fa-chevron-left"></i> Kembali
            </a>
        </div>
    </div>
    <div class="row mt-4">
        <div class="col-md-12">
            <form action="" method="post">
                <div class="mb-3">
                    <label for=""><b>Nama barang</b></label>
                    <input type="text" class="form-control" placeholder="Masukkan nama barang" name="nama_barang">
                </div>

                <div class="mb-3">
                    <label for=""><b>Kuantitas</b></label>
                    <input type="number" class="form-control" placeholder="Masukkan kuantitas barang" name="kuantitas">
                </div>

                <div class="mb-3">
                    <label for=""><b>Harga Modal</b></label>
                    <input type="number" class="form-control" placeholder="Masukkan harga modal barang" name="harga_modal">
                </div>

                <div class="mb-3">
                    <label for=""><b>Harga Jual</b></label>
                    <input type="number" class="form-control" placeholder="Masukkan harga jual barang" name="harga_jual">
                </div>

                <div class="mb-3">
                    <label for=""><b>Tanggal</b></label>
                    <input type="date" class="form-control" placeholder="Masukkan tanggal barang" name="tanggal">
                </div>
                <div>
                    <button type="submit" class="btn btn-primary">
                        <i class="fa fa-save"></i> Submit
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php

    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $nama_barang = $_POST['nama_barang'];
        $kuantitas = $_POST['kuantitas'];
        $harga_modal = $_POST['harga_modal'];
        $harga_jual = $_POST['harga_jual'];
        $tanggal = $_POST['tanggal'];

        $sql = "INSERT INTO tbl_barang (nama_barang, kuantitas, harga_modal, harga_jual, tanggal) VALUES (:nama_barang, :kuantitas, :harga_modal, :harga_jual, :tanggal)";
        $stmt = $pdo->prepare($sql);
        
        $stmt->bindParam(':nama_barang', $nama_barang);
        $stmt->bindParam(':kuantitas', $kuantitas);
        $stmt->bindParam(':harga_modal', $harga_modal);
        $stmt->bindParam(':harga_jual', $harga_jual);
        $stmt->bindParam(':tanggal', $tanggal);
        
        if ($stmt->execute()) {
            echo "<script>alert('Data berhasil ditambah!'); window.location.replace('/views/data-barang/index.php');</script>";
        } else {
            echo "Failed to create user.";
        }
    }
?>

<?php require __DIR__ . '/../../includes/footer.php'; ?>