1. Membuat Database seperti berikut :
2. Membuat folder pada direktori htdocs xampp dan buat file index.php yang isinya :
<?php
include_once("koneksi.php");
$tampil = mysqli_query($mysqli, "SELECT * FROM crud");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Belajar CRUD</title>
<center><h1>Belajar CRUD dengan koneksi MYSQLI</h1></center>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
</head>
<body>
<div class="container">
<form method="post" action="./fungsi/tambah.php">
<button type="submit" class="btn btn-primary">Tambah Data</button>
</form>
<br>
<table class="table table-striped">
<thead>
<tr>
<th scope="col">Nama</th>
<th scope="col">Username</th>
<th scope="col">Password</th>
<th scope="col">Email</th>
<th scope="col">Opsi</th>
</tr>
</thead>
<?php
while($data = mysqli_fetch_array($tampil)) {
?>
<tbody>
<tr>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['username']; ?></td>
<td><?php echo $data['password']; ?></td>
<td><?php echo $data['email']; ?></td>
<td>
<a href="fungsi/ubah.php?id=<?php echo $data['id']; ?>" class="btn btn-success">UBAH</a>
<a onclick="return confirm('Apakah Anda Yakin Akan Menghapus Data Ini..???!!!')" href='./fungsi/hapus.php?id=<?php echo $data['id']; ?>' class="btn btn-danger">HAPUS</i></a>
</td>
</tr>
</tbody>
<?php } ?>
</table>
</div>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>
3. Buat file koneksi.php yang isinya :
<html>
<head>
<title>Belajar CRUD</title>
</head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<body>
<center><h2>TAMBAH DATA</h2></center>
<div class="container">
<form action="tambah.php" method="post" name="form">
<div class="form-group">
<input type="hidden" class="form-control" name="id">
</div>
<div class="form-group">
<label for="">Nama</label>
<input type="text" class="form-control" name="nama" pattern="[A-Za-z ]+" required>
</div>
<div class="form-group">
<label for="">Username</label>
<input type="text" class="form-control" name="user" required >
</div>
<div class="form-group">
<label for="">Password</label>
<input type="password" class="form-control" name="pass" required>
</div>
<div class="form-group">
<label for="">Email</label>
<input type="email" class="form-control" name="email" required>
</div>
<div class="form-group">
<div>
<button type="submit" name="submit" class="btn btn-success">Simpan</button>
<a href="../index.php" class="btn btn-danger"> Batal</a>
</div>
</div>
</form>
<?php
if(isset($_POST['submit'])) {
$id = $_POST['id'];
$nama = $_POST['nama'];
$username = $_POST['user'];
$password = $_POST['pass'];
$email = $_POST['email'];
include_once("../koneksi.php");
$sql = mysqli_query($mysqli, "INSERT INTO crud VALUES('$id','$nama','$username','$password','$email')");
if ($sql) {
?>
<script type="text/javascript">
alert("Data Berhasil Disimpan");
window.location.href = "../index.php";
</script>
<?php
}
}
?>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>
5. Pada folder fungsi juga buat file ubah.php yang isinya :
<?php
include_once("../koneksi.php");
$id1 = $_GET['id'];
$sql = mysqli_query($mysqli, "SELECT * FROM crud WHERE id='$id1'");
$tampil = $sql->fetch_assoc();
?>
<!DOCTYPE html>
<html>
<head>
<title>Belajar CRUD</title>
<center><h2>Ubah Data</h2></center>
</head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<body>
<div class="container">
<form action="ubah.php" method="post" name="form1">
<div class="form-group">
<input type="hidden" class="form-control" name="id" value="<?php echo $tampil['id']; ?>">
</div>
<div class="form-group">
<label for="">Nama</label>
<input type="text" class="form-control" name="nama" value="<?php echo $tampil['nama']; ?>" pattern="[A-Za-z ]+" required>
</div>
<div class="form-group">
<label for="">Username</label>
<input type="text" class="form-control" name="user" value="<?php echo $tampil['username']; ?>" required>
</div>
<div class="form-group">
<label for="">Password</label>
<input type="text" class="form-control" name="pass" value="<?php echo $tampil['password']; ?>"required>
</div>
<div class="form-group">
<label for="">Email</label>
<input type="text" class="form-control" name="email" value="<?php echo $tampil['email']; ?>"required>
</div>
<div class="form-group">
<div>
<button type="submit" name="ubah" class="btn btn-success">Ubah</button>
<a href="../index.php" class="btn btn-primary"> Kembali</a>
</div>
</div>
</form>
</div>
<?php
if (isset($_POST['ubah'])) {
$id = $_POST['id'];
$nama = $_POST['nama'];
$username = $_POST['user'];
$password = $_POST['pass'];
$email = $_POST['email'];
$sql1 = mysqli_query($mysqli, "UPDATE data SET id='$id', nama='$nama', username='$username', password='$password', email='$email' WHERE id='$id'");
if($sql1){
?>
<script type="text/javascript">
alert("Data Berhasil Diubah");
window.location.href="../index.php";
</script>
<?php
}
}
?>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>
6. Pada folder fungsi juga buat file ubah.php yang isinya :
