Text Widget

Disiplin, Jujur, Ilmu, Taqwa, Ulet

24 September 2018

Membuat CRUD PHP Sederhana dengan Database Mysqli

Assalamualaikum wr. wb

Pada kesempatan kali ini kita saya akan memberikan cara membuat CRUD menggunakan PHP Mysqli.




  1. Membuat database.
    2. download database Disini 
  2. Membuat Index.Php
    3. <!DOCTYPE html>
    <html>
    <title>Data Mahasiswa</title>
        <center><h2>Data Mahasiswa</h2></center>
        <table align="center" width="700" cellpadding="3" cellspacing="0" border="1">
    <tr bgcolor="#23BDFF">

    <td>Nama</td>
    <td>Username</td>
    <td>Password</td>
    <td>Email</td>
    <td>Aksi</td>
    </tr>

    <?php
    include "koneksi.php";
    $sql= mysqli_query($koneksi,"SELECT * FROM tbl_data ORDER BY nama");
    while($r= mysqli_fetch_array($sql)){
    ?>
    <tr>

    <td><?php echo $r['nama'];?></td>
    <td><?php echo $r['username'];?></td>
    <td><?php echo $r['password'];?></td>
    <td><?php echo $r['email'];?></td>
    <td><a href="edit.php?id=<?php echo $r['nama']; ?>">Edit</a>&nbsp;|&nbsp;<a href="delete.php?id=<?php echo $r['nama']; ?>">Hapus</a></td>
    </tr>
    <?php
    }
    ?>
    </table>
    <br>
    <center><a href="input.php"> + TAMBAH DATA</a></center>
    </html>
  3. Koneksi.php
    4. <?php
    $koneksi = mysqli_connect("localhost","root","","tugas1");


    if (mysqli_connect_errno()){
    echo "Koneksi database gagal : " . mysqli_connect_error();
    }

    ?>
  4. Tambah Data
    5. <!DOCTYPE html>
    <html>
    <title>Tambah Data Mahasiswa</title>
    <center><h2>Tambah Data Mahasiswa</h2></center>
    <form method="POST" action="simpan.php">
    <table align="center" cellpadding="3" cellspacing="0" border="1" width="600">
    <tr><td>Nama</td> <td>:</td> <td><input type="text" name="nama" size="40"></td></tr>
    <tr><td>Username</td> <td>:</td> <td><input type="text" name="username" size="40"></td></tr>
    <tr><td>Password</td> <td>:</td> <td><input type="password" name="password" size="40"></td></tr>
    <tr><td>Email</td> <td>:</td> <td><input type="email" name="email" size="40"></td></tr>
    <tr><td colspan="3" align="center"><input type="submit" name="kembali" value="Kembali"> <input type="submit" name="submit" value="Simpan"></td></tr>
    </table>
    </form>
    </html>

    simpan.php
    <?php
    include 'koneksi.php';
    if(isset($_POST['kembali'])){
    header("location:index.php");
    }

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

    if($nama == "" | $username=="" | $password=="" | $email==""){
    echo "<script>alert('Gagal di tambahkan! Semua kolom tidak boleh kosong!');history.go(-1);</script>";
    }else{
    if (!preg_match("/^[a-zA-Z .]*$/",$nama)) {
    echo "<center><h1>Terjadi kesalahan Saat Menyimpan Data!</h1></center>";
    echo "<br><center>Hanya huruf , titik dan spasi yang diijinkan</center>";
    echo "<br><center><a href= \"index.php\">Kembali</a></center>";
    }else{
    $sql = mysqli_query($koneksi,"insert into tbl_data(nama, username, password, email) values('$nama','$username','$password','$email')");
    if($sql){
    echo "<center>Data Berhasil Disimpan</center>";
    echo "<br><center><a href= \"index.php\">Kembali</a></center>";
    }else{
    echo "<center>Terjadi kesalahan Saat Menyimpan Data</center>";
    }
    }
    }
    }
    ?>
  5. Edit Data
    6. <?php
    include "koneksi.php";
    $id = $_GET['id'];
    $sql = mysqli_query($koneksi, "SELECT * FROM tbl_data WHERE nama='$id'");
    while($data = mysqli_fetch_array($sql)){
    ?>
        <!DOCTYPE html>
        <html>
        <title>Ubah Data Mahasiswa</title>
        <center><h2>Ubah Data Mahasiswa</h2></center>
    <form method="POST" action="update.php?id=<?php echo $data['nama']; ?>">
            <table align="center" cellpadding="3" cellspacing="0" border="1" width="600">
                <tr><td>Nama</td> <td>:</td> <td><input type="text" name="nama" size="40" value="<?php echo $data['nama']; ?>"></td></tr>
                <tr><td>Username</td> <td>:</td> <td><input type="text" name="username" size="40" value="<?php echo $data['username']; ?>"></td></tr>
                <tr><td>Password</td> <td>:</td> <td><input type="password" name="password" size="40" value="<?php echo $data['password']; ?>"></td></tr>
                <tr><td>Email</td> <td>:</td> <td><input type="email" name="email" size="40" value="<?php echo $data['email']; ?>"></td></tr>
                <tr><td colspan="3" align="center"><input type="submit" name="kembali" value="Kembali"> <input type="submit" name="ubah" value="Ubah"></td></tr>
            </table>
        </form>
        </html>
        <?php
        } 
        ?>
  6. Hapus Data
    7. <?php
    include "koneksi.php";
    $id = $_GET['id'];
    $sql = mysqli_query($koneksi, "delete from tbl_data WHERE nama='$id'");
    if($sql){
        header("location:index.php");
    }else{
        echo "<center><h1>Gagal menghapus data!</h1></center>";
        echo "<br><center><a href= \"index.php\">Kembali</a></center>";
    }
    ?>
  7. Update Data
    8. <?php
    include "koneksi.php";
    if(isset($_POST['kembali'])){
        header("location:index.php");
    }


    $nama = $_POST['nama'];
    $username = $_POST['username'];
    $password = $_POST['password'];
    $email = $_POST['email'];

    if(isset($_POST['ubah'])){
        if (!preg_match("/^[a-zA-Z .]*$/",$nama)) {
            echo "<center><h1>Terjadi kesalahan Saat Menyimpan Data!</h1></center>";
    echo "<br><center>Hanya huruf , titik dan spasi yang diijinkan!</center>";
    echo "<br><center><a href= \"index.php\">Kembali</a></center>";
        }else{
            $sql = mysqli_query($koneksi, "update tbl_data set nama='$nama', username='$username', password='$password', email='$email' where nama='$nama'");
            if($sql){
                echo "<center>Data Berhasil Diubah</center>";
                echo "<br><center><a href= \"index.php\">Kembali</a></center>";
            }else{
                echo "<center>Terjadi kesalahan Saat Mengubah Data!</center>";
                echo "<br><center><a href= \"index.php\">Kembali</a></center>";
        }
        }
       
    }

    ?>
          











di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)