sistem informasi

 1. INDEX.PHP


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4"></script>
    <title>Document</title>
</head>
<body>
    <header class="p-5 shadow-md flex items-center">
        <nav class="flex justify-between p-5 w-full">
            <div class="logo">
                <h1>Logo</h1>
            </div>
            <ul class="flex gap-5">
                <li><a href="">Home</a></li>
            </ul>
            <ul class="flex gap-5">
                <li><a href="login.php">Login</a></li>
                <li><a href="register.php">Register</a></li>
            </ul>
        </nav>
    </header>
    <main class="flex flex-col bg-pink-200 items-center">
        <div class=" w-full flex flex-col bg-pink-200 relative"
        style="width: 100%; height: 80vh;justify-content: center; align-items: center;">
    <section class="flex flex-col text-white absolute top-10">
        <h1 class="font-bold text-3xl">
            Sistem Informasi Siswa
        </h1>
    </section>
</main>
</body>
</html>


2. ADMIN.PHP


<?php

session_start();

$koneksi = mysqli_connect("localhost", "root", "", "cemungut_ukk");
$query = mysqli_query($koneksi, "SELECT * FROM euww");

if(isset($_POST['cari'])){
    $cari =$_POST['search'];
    $query =mysqli_query($koneksi, "SELECT * FROM euww WHERE nama LIKE '%$cari%'");
}

?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4"></script>
    <title>Document</title>
</head>
<body>
    <header class="p-5 shadow-md flex items-center">
        <nav class="flex justify-between p-5 w-full">
            <div class="logo">
                <h1>Logo</h1>
            </div>
          <ul class="flex gap-5">
                <li><a href="">Home</a></li>
                <li><a href="">About</a></li>
                <li><a href="">Faq</a></li>
            </ul>
            <ul class="flex gap-5">
                <li><a href="upload.php">upload</a></li>
                <li><a href="register.php">Browser</a></li>
            </ul>
        </nav>
    </header>
    <main class="flex justify-center text-center mt-20 flex-col p-10">
        <h2 class="font-bold text-3xl">HALAMAN ADMIN
            <style>
                h2 {
                    color: pink;
                }
            </style>
        </h2>
        <br>
        <hr class="h-px border">
        <br>
        <form action="" method="post" class="p-5">
            <input type="text" name="search" class="border px-3 py-2 rounded-lg" placeholder="caridata">
            <button type="submit" name="cari" class="cursor-pointer border rounded-lg px-3 py-2">
                cari
            </button>

        </form>
        <table class="border">
        <thead>
            <tr style="color: pink; background-color:pink;">
                <th class="border text-black">no</th>
                <th class="border text-black">nis</th>
                <th class="border text-black">nama</th>
                <th class="border text-black">foto</th>
                <th class="border text-black">kelas</th>
                <th class="border text-black">aksi</th>
            </tr>
        </thead>
        <tbody>
            <?php $no = 1; while($data = mysqli_fetch_assoc($query)): ?>
            <tr>
                <td class="border"><?= $no ?></td>
                <td class="border"><?= $data['nis'] ?></td>
                <td class="border"><?= $data['nama'] ?></td>
                <td class="border p-2 w-35"><img src="ukk/<?= $data['foto'] ?>" alt="foto" class="w-20 h-20 object-cover"></td>
                <td class="border"><?= $data['kelas'] ?></td>
                <td>
                    <a href="update.php?id_siswa=<?= $data['id_siswa'] ?>"
                    class="px-3 py-2 border hover:bg-green-600 rounded-xl hover:text-white"
                    onclick="return confirm('yakin ingin mengupdate data!')">update</a>
                    <a href="hapus.php?id_siswa=<?= $data['id_siswa'] ?>"
                     class="px-3 py-2 border hover:bg-red-600 rounded-xl hover:text-white"
                     onclick="return confirm('yakin ingin menghapus data!')">delete</a>
                     
                </td>
            </tr>
            <?php $no++; endwhile; ?>
        </tbody>
    </table>
    </main>
</body>
</html>


3. UPDATE.PHP


<?php
$koneksi = mysqli_connect("localhost", "root", "", "cemungut_ukk");

if(isset($_GET['id_siswa'])){
    $id = $_GET['id_siswa'];
    $query = mysqli_query($koneksi, "SELECT * FROM euww WHERE id_siswa = $id");
    $data = mysqli_fetch_assoc($query);

}
    if(isset($_POST['update'])){
     $id= (int) $_POST['id_siswa'];
     $foto_lama = $_POST['foto_lama'];
     $nis = $_POST['nis'];
     $nama = $_POST['nama'];
     $kelas = $_POST['kelas'];

     if($_FILES['foto']['error'] == 0){
         $foto = $_FILES['foto']['name'];
         $tmp = $_FILES['foto']['tmp_name'];
         $error = $_FILES['foto']['name'];

        $ekstensiFoto = explode('.',$foto);
        $ekstensiFoto = end($ekstensiFoto);
        $namaFoto = uniqid() . '.' . $ekstensiFoto;
        move_uploaded_file($tmp, 'ukk/' . $namaFoto);

        $update = mysqli_query($koneksi, "UPDATE `euww` SET nis = '$nis', nama = '$nama', foto = '$namaFoto',
         kelas = '$kelas' WHERE id_siswa = $id");
         }else{
            $update = mysqli_query($koneksi, "UPDATE `euww` SET nis = '$nis', nama = '$nama', foto = '$foto_lama',
             kelas = '$kelas' WHERE id_siswa = $id");
         }
         
         if($update){
            header ("Location:admin.php");



            exit();
       

     }

    }

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <form action="update.php?id_siswa=<?= $data['id_siswa'] ?>" method="post" enctype="multipart/form-data">
        <h1 class="font-bold text-3xl">FORM UPDATE DATA</h1>
        <label>nis</label>
        <input type="number" name="nis" placeholder="nis" value="<?= $data['nis'] ?>">
        <label>nama</label>
        <input type="text" name="nama" placeholder="nama" value="<?= $data['nama'] ?>">
        <label>foto</label>
        <input type="file" name="foto" placeholder="foto">
        <input type="hidden" name="id_siswa" value="<?= $data['id_siswa'] ?>">
        <input type="hidden" name="foto_lama" value="<?= $data['foto'] ?>">
        <select name="kelas">
            <option selected disabled>pilih kelas</option>
            <option value="X" <?= $data['kelas'] == 'X' ? 'selected' : '' ?>>X</option>
            <option value="XI" <?= $data['kelas'] == 'XI' ? 'selected' : '' ?>>XI</option>
            <option value="XII" <?= $data['kelas'] == 'XII' ? 'selected' : '' ?>>XII</option>
        </select>
        <button type="submit" name="update">update</button>
    </form>  
</body>
</html>

4. HAPUS.PHP


<?php

$koneksi = mysqli_connect("localhost", "root", "", "cemungut_ukk");

if (isset($_GET['id_siswa'])) {
    $id = $_GET['id_siswa'];

    $query = mysqli_query($koneksi, "DELETE FROM `euww` WHERE id_siswa = $id");
    header("Location:admin.php");
}

?>


5. LOGIN.PHP

<?php
session_start();
$koneksi = mysqli_connect("localhost", "root", "", "cemungut_ukk");

if(isset($_POST['login'])){
    $email = $_POST['email'];
    $password = $_POST['password'];

    $query =mysqli_query($koneksi, "SELECT * FROM clear WHERE email = '$email' AND password = '$password'");

    $validasi = mysqli_num_rows($query);

    if($validasi >0){
        $data = mysqli_fetch_assoc($query);

        $_SESSION ['login'] = true;
        $_SESSION ['email'] = $data ['email'];

        echo '<script>
        alert ("anda berhasil login")
        window.location.href="admin.php"
        </script>';
    }else{
        echo '<script>
        alert ("anda gagal login")
        window.location.href="login.php"
        </script>';
    }
   
}

?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <script src="https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4"></script>
</head>
<body>
    <main class="min-h-screen flex items-center justify-center">
        <style>
            main {
                color: pink;
            }
        </style>
        <form action="login.php"
         method="post" class="flex flex-col gap-2 w-100 border p-5">
         <h1 class="text-center text-pink-500">login akun</h1>
            <label>email</label>
            <input type="text" name="email" class="border border-lg p-2" required placeholder="email">
            <label>password</label>
            <input type="text" name="password" class="border border-lg p-2" required placeholder="password">
            <div class="button flex gap-5">
                <button type="submit" name="login" class="bg-blue-600 rounded-lg px-3 py-2 white
                hover:bg-blue-500">Login</button>
                <button type="" name="" class="bg-blue-600 rounded-lg px-3 py-2 white
                hover:bg-blue-500">Batal</button>
                <br>
            </div>
        </form>
    </main>
</body>
</html>


6. REGISTER.PHP

<?php

$koneksi = mysqli_connect("localhost", "root", "", "cemungut_ukk");

if(isset($_POST['register'])){
    $username = $_POST['username'];
    $email = $_POST['email'];
    $password = $_POST['password'];

    $query =mysqli_query($koneksi, "INSERT INTO clear (username,email,password)
    VALUES ('$username','$email','$password')");

    exit();

    $role = $_POST['role'];
}


?>



<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <script src="https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4"></script>
</head>
<body>
    <main class="min-h-screen flex items-center justify-center">
        <form action="register.php"
         method="post" class="flex flex-col gap-2 w-100 border p-5">
         <h1 class="text-center text-pink-500">register akun
            <style>
                main {
                    color: pink;
                }
            </style>
         </h1>
            <label>username</label>
            <input type="text" name="username" class="border border-lg p-2" required placeholder="username">
            <label>email</label>
            <input type="text" name="email" class="border border-lg p-2" required placeholder="email">
            <label>password</label>
            <input type="text" name="password" class="border border-lg p-2" required placeholder="password">
            <div class="button flex gap-5">
                <button type="submit" name="register" class="bg-blue-600 rounded-lg px-3 py-2 white
                hover:bg-blue-500">register</button>
                <button type="" name="" class="bg-blue-600 rounded-lg px-3 py-2 white
                hover:bg-blue-500">Batal</button>
                <br>
    <select name="role" id="" class="border">
        <option value=""disabled>Pilih role</option>
        <option value="user">user</option>
        <option value="admin">admin</option>
    </select>
    <br>
            </div>
        </form>
    </main>
</body>
</html>


7. UPLOAD.PHP

<?php
session_start();
$koneksi = mysqli_connect("localhost", "root", "", "cemungut_ukk");

if(isset($_POST['upload'])){
    $nis = $_POST['nis'];
    $nama = $_POST['nama'];
    $kelas = $_POST['kelas'];

   
    $foto = $_FILES['foto']['name'];
    $tmp = $_FILES['foto']['tmp_name'];
    $error = $_FILES['foto']['name'];
    $ekstensiFoto = explode('.',$foto);
    $ekstensiFoto = end($ekstensiFoto);
    $namaFoto = uniqid() . '.' . $ekstensiFoto;
    move_uploaded_file($tmp, 'ukk/' . $namaFoto);

    $query = mysqli_query($koneksi, "INSERT INTO `euww` (`nis`, `nama`, `foto`, `kelas`) VALUES ('$nis','$nama','$namaFoto','$kelas')");
    exit();
}
?>



<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4"></script>
    <title>Document</title>
</head>
<body>
    <form action="upload.php" method="post" enctype="multipart/form-data">
        <h1 class="font-bold text-3xl">FORM UPLOAD DATA</h1>
        <label>nis</label>
        <input type="number" name="nis" placeholder="nis">
        <label>nama</label>
        <input type="text" name="nama" placeholder="nama">
        <label>foto</label>
        <input type="file" name="foto" placeholder="foto">
        <select name="kelas">
            <option selected disabled>pilih kelas</option>
            <option value="X">X</option>
            <option value="XI">XI</option>
            <option value="XII">XII</option>
        </select>
        <button type="submit" name="upload">upload</button>
    </form>  
</body>
</html>

Komentar

Posting Komentar

Postingan populer dari blog ini

hobiinyaa windaa

Gambar
  nahh ini hobinya Winda windaa sukaa membaca novel(wattpad)              sehari bisa 3/4 cerita yg sya baca klok ngak ada kerjaan,membaca novel adalah kegiatan yang menyenangkan dan bermanfaat, di mana seseorang meresapi berbagai kisah dan karakter yang diciptakan oleh penulis.dengan membaca novel, kita dapat menjelajahi dunia imajinasi yang tak terbatas, mulai dari kisah cinta yang mengharukan hingga petualangan yang mendebarkan.                      ini bukan winda tp poto ini winda gunain                           sebagai contoh ajaa jujur ajaa yaa, dri sya mulai baca wp sya sering ngelamun ngebayangin klok kisah cinta sya sma kyk yg di novel'hehe manfaat membaca novell melatih otak untuk berfikir kreatif dan melihat dunia dari sudut pandang yang berbeda
Baca selengkapnya

10 keinginan yang ingin di raih

 1.ingin sukses dan membahagiakan ortu.  penjelasan: alasan winda ingin sukses dan membahagiakan orang tua itu dari keinginan winda sendiri sebagai rasa cinta dan tanggung jawab winda sebagai anak,karnaa selama ini ortu winda udah berjuang untuk membesarkan winda sampai segede skrng, dan berjuang keras untuk memberikan yang terbaik untuk anak'nya, dan tujuan winda ingin mencapai kesuksesan ini sebagai cara winda untuk membuktikan bahwa usaha mereke tidak sia-sia.selain itu, kebahagiaan orang tua winda bisa menjadi kebahagiaan untuk diri winda sendiri, karena melihat orang yang kita cintai bahagia memberi rasa puas dan kedamaian. 2.membangun resto dan cafe.  penjelasan: karna sekali sebulan keluarga winda yang dari mamak akan ngadain arisan keluarga, dan disitu mereka akan berpergian ke tempat makan yang mereka tau klok makanan di sana enak', jd alasan sy pengen bangun resto/cafe biar klok keluarga winda arisan keluarga mereka tidak pergi k resto'lain tp k resto winda send...
Baca selengkapnya