PROJECT FINAL DENGAN BOOTSTRAP 5

 koneksi.php

<?php 

$db = mysqli_connect("localhost", "root", "", "finale");


function input($data){

    global $db;

    $nama = $_POST['nama'];

    $kelas = $_POST['kelas'];

    $jurusan = $_POST['jurusan'];

    $jeniskelamin = $_POST['jeniskelamin'];

    // buat checkbox

    $hobi = $_POST['hobi'];

    $result = implode(",", $hobi);


    // buat gambar

    $rand = rand();

    $ekstensi = array('png','jpg','jpeg','gif');

    $filename = $_FILES['file']['name'];

    $ukuran = $_FILES['file']['size'];

    $ext = pathinfo($filename, PATHINFO_EXTENSION);


    // aksi input

    if(!in_array($ext, $ekstensi)){

        header('location:index.php');

    }else{

        if ($ukuran < 1044070) {

            $xx = $rand.'_'.$filename;

            move_uploaded_file($_FILES['file']['tmp_name'], 'img/'.$rand.'_'.$filename);

            $sql = mysqli_query($db,"insert into datalengkap values('','$nama','$kelas','$jurusan','$jeniskelamin','$result','$xx')");

        }

    }

    return mysqli_affected_rows($db);

}

function hapus($id){

    global $db;

    $id = $_GET['id'];


    $sql = mysqli_query($db, "delete from datalengkap where id = '$id'");

    return mysqli_affected_rows($db);

}

function edit($data){

    global $db;

    $id = $_GET['id'];

    $nama = $_POST['nama'];

    $kelas = $_POST['kelas'];

    $jurusan = $_POST['jurusan'];

    $jeniskelamin = $_POST['jeniskelamin'];

    // buat checkbox

    $hobi = $_POST['hobi'];

    $result = implode(",",$hobi);

    // buat gambar

    $rand = rand();

    $ekstensi = array('png','jpg','jpeg');

    $filename = $_FILES['file']['name'];

    $ukuran = $_FILES['file']['size'];

    $ext = pathinfo($filename, PATHINFO_EXTENSION);


    // aksi

    $rand = rand();

    $ekstensi = array('png','jpg','jpeg','gif');

    $filename = $_FILES['file']['name'];

    $ukuran = $_FILES['file']['size'];

    $ext =  pathinfo($filename, PATHINFO_EXTENSION);


    if(!in_array($ext,$ekstensi) ) {

        header("location:index.php");

        }else{

        if($ukuran < 1044070){

            $xx = $rand.'_'.$filename;

            move_uploaded_file($_FILES['file']['tmp_name'], 'img/'.$rand.'_'.$filename);

            $sql = "UPDATE datalengkap SET nama = '$nama', kelas='$kelas', jurusan='$jurusan', jeniskelamin='$jeniskelamin', hobi='$result', foto = '$xx' WHERE id = '$id'";

            $query = mysqli_query($db,$sql);

            return mysqli_affected_rows($db);

        }

    }

}

?>

index.php

<?php 

include 'koneksi.php';

$no = 1;

?>


<!doctype html>

<html lang="en">

  <head>

    <!-- Required meta tags -->

    <meta charset="utf-8">

    <meta name="viewport" content="width=device-width, initial-scale=1">

    <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@20..48,100..700,0..1,-50..200" />

    <!-- Bootstrap CSS -->

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">


    <title>Finale</title>

  </head>

  <body>

    <!-- As a heading -->

    <nav class="navbar navbar-dark bg-success p-4">

    <div class="container-fluid">

        <span class="navbar-brand mb-0 h1 fs-1">Data Siswa</span>

    </div>

    </nav>

    <table class="table table-striped mt-5">

        <tr>

            <th>No</th>

            <th>Foto</th>

            <th>Nama</th>

            <th>Kelas</th>

            <th>Jurusan</th>

            <th>Jenis Kelamin</th>

            <th>Hobi</th>

            <th>Aksi</th>

        </tr>

        <?php 

        $sql = mysqli_query($db, "select * from datalengkap");

        foreach ($sql as $key) {

        ?>

        <tr>

            <td><?php echo $no++;?></td>

            <td>

                <img src="img/<?php echo $key['foto'];?>" alt="" width="50" height="50">

            </td>

            <td><?php echo $key['nama'];?></td>

            <td><?php echo $key['kelas'];?></td>

            <td><?php echo $key['jurusan'];?></td>

            <td><?php echo $key['jeniskelamin'];?></td>

            <td><?php echo $key['hobi'];?></td>

            <td>

                <a href="edit.php?id=<?= $key['id'];?>"><span class="material-symbols-outlined text-warning fs-2">edit</span></a>

                <a href="hapus.php?id=<?= $key['id'];?>"><span class="material-symbols-outlined text-danger fs-2">delete</span></a>

            </td>

        </tr>

        <?php }?>

    </table>

    <center>

    <a class="btn btn-outline-success" href="input.php" role="button">Tambah Data</a>

    </center>

    <!-- Optional JavaScript; choose one of the two! -->


    <!-- Option 1: Bootstrap Bundle with Popper -->

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>


    <!-- Option 2: Separate Popper and Bootstrap JS -->

    <!--

    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>

    -->

  </body>

</html>

input.php

<?php 

    include 'koneksi.php';

    if(isset($_POST['submit'])){

        if (input($_POST)>0) {

            echo "<script>alert('data berhasil diinput');

            document.location.href = 'index.php';

            </script>";  

        }else{

            echo "<script>alert('data gagal diedit');

        </script>"; 

        }

    }

?>


<!doctype html>

<html lang="en">

  <head>

    <!-- Required meta tags -->

    <meta charset="utf-8">

    <meta name="viewport" content="width=device-width, initial-scale=1">


    <!-- Bootstrap CSS -->

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">


    <title>Finale</title>

  </head>

  <body>

    <!-- As a heading -->

    <nav class="navbar navbar-dark bg-success p-4">

    <div class="container-fluid">

        <span class="navbar-brand mb-0 h1 fs-1">Data Siswa</span>

    </div>

    </nav>

    <center>

        <form action="" method="post" enctype="multipart/form-data">

            <table cellpadding="15">

                <tr>

                    <td>Nama</td>

                    <td>:</td>

                    <td><input type="text" name="nama" id=""></td>

                </tr>

                <tr>

                    <td>Kelas</td>

                    <td>:</td>

                    <td>

                        <select name="kelas" id="">

                            <option value="X">X</option>

                            <option value="XI">XI</option>

                            <option value="XII">XII</option>

                        </select>

                    </td>

                </tr>

                <tr>

                    <td>Jurusan</td>

                    <td>:</td>

                    <td><input type="text" name="jurusan" id=""></td>

                </tr>

                <tr>

                    <td>Jenis Kelamin</td>

                    <td>:</td>

                    <td>

                        <input type="radio" name="jeniskelamin" id="laki" value="Laki-laki">

                        <label for="laki">Laki-laki</label>

                        <input type="radio" name="jeniskelamin" id="perepmpuan" value="Perepmpuan">

                        <label for="perepmpuan">Perempuan</label>

                    </td>

                </tr>

                <tr>

                    <td>Hobi</td>

                    <td>:</td>

                    <td>

                        <input type="checkbox" name="hobi[]" id="or" value="Olahraga">

                        <label for="or">Olahraga</label>

                        <input type="checkbox" name="hobi[]" id="musik" value="Musik">

                        <label for="musik">Musik</label>

                        <input type="checkbox" name="hobi[]" id="turu" value="Turu">

                        <label for="turu">Turu</label>

                    </td>

                </tr>

                <tr>

                    <td>Foto</td>

                    <td>:</td>

                    <td><input type="file" name="file" id=""></td>

                </tr>

                <tr>

                    <td><button type="submit" name="submit">Tambah</button></td>

                    <td colspan="2"><button><a href="index.php">Kembali</a></button></td>

                </tr>

            </table>

        </form>

    </center>


    <!-- Optional JavaScript; choose one of the two! -->


    <!-- Option 1: Bootstrap Bundle with Popper -->

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>


    <!-- Option 2: Separate Popper and Bootstrap JS -->

    <!--

    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>

    -->

  </body>

</html>


edit.php

<?php 

    include 'koneksi.php';

    if(isset($_POST['submit'])){

        if (edit($_POST)>0) {

            echo "<script>alert('data berhasil diubah');

            document.location.href = 'index.php';

            </script>";  

        }else{

            echo "<script>alert('data gagal diubah');

        </script>"; 

        }

    }

?>


<!doctype html>

<html lang="en">

  <head>

    <!-- Required meta tags -->

    <meta charset="utf-8">

    <meta name="viewport" content="width=device-width, initial-scale=1">


    <!-- Bootstrap CSS -->

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">


    <title>Finale</title>

  </head>

  <body>

    <!-- As a heading -->

    <nav class="navbar navbar-dark bg-success p-4">

    <div class="container-fluid">

        <span class="navbar-brand mb-0 h1 fs-1">Data Siswa</span>

    </div>

    </nav>

    <center>

        <form action="" method="post" enctype="multipart/form-data">

            <table cellpadding="15">

                <?php 

                $id = $_GET['id'];

                $edit = mysqli_query($db, "select * from datalengkap where id='$id'");

                foreach ($edit as $row) {

                ?>

                <tr>

                    <td>Nama</td>

                    <td>:</td>

                    <td><input type="text" name="nama" id="" value="<?php echo $row['nama'];?>"></td>

                </tr>

                <tr>

                    <td>Kelas</td>

                    <td>:</td>

                    <td>

                        <select name="kelas" id="">

                            <option value="<?php echo $row['kelas'];?>" selected><?php echo $row['kelas'];?></option>

                            <option value="X">X</option>

                            <option value="XI">XI</option>

                            <option value="XII">XII</option>

                        </select>

                    </td>

                </tr>

                <tr>

                    <td>Jurusan</td>

                    <td>:</td>

                    <td><input type="text" name="jurusan" id="" value="<?php echo $row['jurusan'];?>"></td>

                </tr>

                <tr>

                    <td>Jenis Kelamin</td>

                    <td>:</td>

                    <td>

                        <?php 

                        $jk = $row['jeniskelamin'];

                            if ($jk=="Laki-laki") {

                                echo '<input type="radio" name="jeniskelamin" id="laki" value="Laki-laki" checked>

                                <label for="laki">Laki-laki</label>

                                <input type="radio" name="jeniskelamin" id="perepmpuan" value="Perepmpuan">

                                <label for="perepmpuan">Perempuan</label>';

                            }else{

                                echo '<input type="radio" name="jeniskelamin" id="laki" value="Laki-laki">

                                <label for="laki">Laki-laki</label>

                                <input type="radio" name="jeniskelamin" id="perepmpuan" value="Perepmpuan" checked>

                                <label for="perepmpuan">Perempuan</label>';

                            }

                        ?>

                    </td>

                </tr>

                <tr>

                    <td>Hobi</td>

                    <?php 

                    $hobi = $row['hobi'];

                    $space = explode(",",$hobi);

                    ?>

                    <td>:</td>

                    <td>

                        <input type="checkbox" name="hobi[]" id="or" value="Olahraga"<?php 

                            if (in_array("Olahraga", $space)) {

                                echo "checked";

                            }

                        ?>>

                        <label for="or">Olahraga</label>

                        <input type="checkbox" name="hobi[]" id="musik" value="Musik"<?php 

                            if (in_array("Musik", $space)) {

                                echo "checked";

                            }

                        ?>>

                        <label for="musik">Musik</label>

                        <input type="checkbox" name="hobi[]" id="turu" value="Turu"<?php 

                            if (in_array("Turu", $space)) {

                                echo "checked";

                            }

                        ?>>

                        <label for="turu">Turu</label>

                    </td>

                </tr>

                <tr>

                    <td>Foto</td>

                    <td>:</td>

                    <td>

                        <input type="file" name="file" id="">

                    </td>

                </tr>

                <tr>

                    <td><button type="submit" name="submit">Tambah</button></td>

                    <td colspan="2"><button><a href="index.php">Kembali</a></button></td>

                </tr>

                <?php }?>

            </table>

        </form>

    </center>


    <!-- Optional JavaScript; choose one of the two! -->


    <!-- Option 1: Bootstrap Bundle with Popper -->

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>


    <!-- Option 2: Separate Popper and Bootstrap JS -->

    <!--

    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js" integrity="sha384-IQsoLXl5PILFhosVNubq5LC7Qb9DXgDA9i+tQ8Zj3iwWAwPtgFTxbJ8NT4GN1R8p" crossorigin="anonymous"></script>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js" integrity="sha384-cVKIPhGWiC2Al4u+LWgxfKTRIcfu0JTxR+EQDz/bgldoEyl4H0zUF0QKbrJ0EcQF" crossorigin="anonymous"></script>

    -->

  </body>

</html>


hapus.php

<?php

    include 'koneksi.php';


    $id = $_GET['id'];


    if (hapus($id)>0) {

        echo "

        <script>alert('data berhasil dihapus');

        document.location.href = 'index.php';

        </script>";

    }else{

        echo "

        <script>alert('data gagal dihapus');

        </script>";

    }

?>


Hasil:


Comments

Post a Comment

Popular posts from this blog

APLIKASI PERPUSTAKAAN DENGAN BOOTSTRAP 5, PHP DAN MYSQL

 koneksi.php <?php  $db = mysqli_connect("localhost","root","","perpus"); function query($query){     global $db;     $result = mysqli_query($db, $query);     $rows = [];     while ($row = mysqli_fetch_assoc($result)) {         $rows[] = $row;     }     return $rows; } function register($nis,$nama,$password){     global $db;     $result = mysqli_query($db, "select nis from user where nis = '$nis'");     if (mysqli_fetch_assoc($result)) {         echo "<script>         alert('NIS sudah terdaftar!')         </script>";         return false;     }     $sql = mysqli_query($db,"insert into user value('$nis','$nama','$password')");     return $sql; } function login($nis,$password){     global $db;     $sql = mysqli_query($db, "selec...
Read more

Aplikasi PKL dengan PHP

PHP koneksi.php <?php       $host = "localhost"; $username = "root"; $password = ""; $database = "pkl"; $koneksi = mysqli_connect($host,$username,$password,$database);       function register($username,$password,$nama) {         global $koneksi; $insert = mysqli_query($koneksi,"insert into user values ('$username','$password','$nama')"); return $insert; }   function login($username,$password,$remember) {         global $koneksi; $query = mysqli_query($koneksi,"select * from user where username='$username'"); $data_user = $query->fetch_array(); if(password_verify($password,$data_user['password'])) { if($remember) { setcookie('username', $username, time() + (60 * 60 * 24 * 5), '/'); setcookie('nama', $data_user['nama'], time() + (60 * 60 * 24 * 5), '/'); } $_SESSION['user...
Read more