<!DOCTYPE html>
<html>
<?php
$koneksi = new mysqli (“localhost”,”root”,””,”siswa”);
?>
<head>
<title>APLIKASI CRUD</title>
<link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css”>
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js”></script>
<script src=”https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js”></script>
<script src=”https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js”></script>
</head>
<body>
<div class=”container”>
<div class=”col-lg-12″>
<div class=”page-header”>
<br>
<br>
<h2>CRUD DATA SISWA
<a href=”add.php” class=”btn btn-success”>Tambah Data</a>
</h2>
</div>
<br>
<div>
<table class=”table table-bordered table-striped”>
<thead>
<tr>
<th>NO</th>
<th>NIS</th>
<th>NAMA SISWA</th>
<th>JENIS KELAMIN</th>
<th>JURUSAN</th>
<th>AKSI</th>
</tr>
</thead>
<tbody>
<?php
$sql_tampil = “SELECT * FROM tb_siswa”;
$query_tampil = mysqli_query($koneksi, $sql_tampil);
$no=1;
while ($data = mysqli_fetch_array($query_tampil,MYSQLI_BOTH)) {
?>
<tr>
<td>
<?php echo $no; ?>
</td>
<td>
<?php echo $data[‘nis’]; ?>
</td>
<td>
<?php echo $data[‘nama’]; ?>
</td>
<td>
<?php echo $data[‘jekel’]; ?>
</td>
<td>
<?php echo $data[‘jurusan’]; ?>
</td>
<td>
<a href=”edit.php?kode=<?php echo $data[‘nis’]; ?>” class=’btn btn-warning btn-sm’>Ubah</a>
<a href=”del.php?kode=<?php echo $data[‘nis’]; ?>” onclick=”return confirm(‘Hapus Data Ini ?’)”
class=’btn btn-danger btn-sm’>Hapus</a>
</td>
</tr>
<?php
$no++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>
Buat file dengan nama add.php,
kemudian ketik script dibawah ini.
<!DOCTYPE html>
<html>
<?php
$koneksi = new mysqli (“localhost”,”root”,””,”siswa”);
?>
<head>
<title>APLIKASI CRUD</title>
<link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css”>
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js”></script>
<script src=”https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js”></script>
<script src=”https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js”></script>
</head>
<body>
<div class=”container”>
<div class=”col-lg-8″>
<div class=”page-header”>
<br>
<br>
<h2>TAMBAH DATA SISWA</h2>
</div>
<br>
<form method=”POST” enctype=”multipart/form-data”>
<div class=”form-group”>
<label>NIS</label>
<input type=”text” name=”nis” class=”form-control” required>
</div>
<div class=”form-group”>
<label>NAMA</label>
<input type=”text” name=”nama” class=”form-control” required>
</div>
<div class=”form-group”>
<label>JENIS KELAMIN</label>
<select name=”jekel” class=”form-control”>
<option value=””>- Pilih -</option>
<option>Laki-laki</option>
<option>Perempuan</option>
</select>
</div>
<div class=”form-group”>
<label>JURUSAN</label>
<input type=”text” name=”jurusan” class=”form-control” required>
</div>
<br>
<div class=”form-group”>
<input type=”submit” name=”Simpan” value=”Simpan Data” class=”btn btn-primary”>
<a href=”index.php” class=”btn btn-warning”>Batal</a>
</div>
</form>
</div>
</div>
</body>
<?php
if (isset ($_POST[‘Simpan’])){
$sql_simpan = “INSERT INTO tb_siswa (`nis`, `nama`, `jekel`, `jurusan`) VALUES (
‘”.$_POST[‘nis’].”‘,
‘”.$_POST[‘nama’].”‘,
‘”.$_POST[‘jekel’].”‘,
‘”.$_POST[‘jurusan’].”‘)”;
$query_simpan = mysqli_query($koneksi, $sql_simpan);
if ($query_simpan) {
echo “<script>alert(‘Tambah Data Sukses’)</script>”;
echo “<meta http-equiv=’refresh’ content=’0; url=index.php’>”;
}else{
echo “<script>alert(‘Tambah Data Gagal’)</script>”;
echo “<meta http-equiv=’refresh’ content=’0; url=add.php’>”;
}
}
?>
</html>
5. Buat file dengan nama del.php,
kemudian ketik script dibawah ini.
<?php
$koneksi = new mysqli (“localhost”,”root”,””,”siswa”);
if(isset($_GET[‘kode’])){
$sql_cek = “SELECT * FROM tb_siswa WHERE nis='”.$_GET[‘kode’].”‘”;
$query_cek = mysqli_query($koneksi, $sql_cek);
$data_cek = mysqli_fetch_array($query_cek,MYSQLI_BOTH);
}
?>
<?php
$sql_hapus = “DELETE FROM tb_siswa WHERE nis='”.$_GET[‘kode’].”‘”;
$query_hapus = mysqli_query($koneksi, $sql_hapus);
if ($query_hapus) {
echo “<script>alert(‘Hapus Data Sukses’)</script>”;
echo “<meta http-equiv=’refresh’ content=’0; url=index.php’>”;
}else{
echo “<script>alert(‘Hapus Data Gagal’)</script>”;
echo “<meta http-equiv=’refresh’ content=’0; url=index.php’>”;
}
?>
6. Buat file dengan nama edit.php,
kemudian ketik script dibawah ini.
<!DOCTYPE html>
<html>
<?php
$koneksi = new mysqli (“localhost”,”root”,””,”siswa”);
if(isset($_GET[‘kode’])){
$sql_cek = “SELECT * FROM tb_siswa WHERE nis='”.$_GET[‘kode’].”‘”;
$query_cek = mysqli_query($koneksi, $sql_cek);
$data_cek = mysqli_fetch_array($query_cek,MYSQLI_BOTH);
}
?>
<head>
<title>APLIKASI CRUD</title>
<link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css”>
<script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js”></script>
<script src=”https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js”></script>
<script src=”https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js”></script>
</head>
<body>
<div class=”container”>
<div class=”col-lg-8″>
<div class=”page-header”>
<br>
<br>
<h2>UBAH DATA SISWA</h2>
</div>
<br>
<form method=”POST” enctype=”multipart/form-data”>
<div class=”form-group”>
<label>NIS</label>
<input type=”text” name=”nis” class=”form-control” value=”<?php echo $data_cek[‘nis’]; ?>”
readonly/>
</div>
<div class=”form-group”>
<label>NAMA</label>
<input type=”text” name=”nama” class=”form-control” value=”<?php echo $data_cek[‘nama’]; ?>”
/>
</div>
<div class=”form-group”>
<label>JENIS KELAMIN</label>
<select name=”jekel” id=”jekel” class=”form-control”>
<option value=””>– Pilih jekel –</option>
<?php
if ($data_cek[‘jekel’] == “Laki-laki”) echo “<option value=’Laki-laki’ selected>Laki-laki</option>”;
else echo “<option value=’Laki-laki’>Laki-laki</option>”;
if ($data_cek[‘jekel’] == “Perempuan”) echo “<option value=’Perempuan’ selected>Perempuan</option>”;
else echo “<option value=’Perempuan’>Perempuan</option>”;
?>
</select>
</div>
<div class=”form-group”>
<label>JURUSAN</label>
<input type=”text” name=”jurusan” class=”form-control” value=”<?php echo $data_cek[‘jurusan’]; ?>”
/>
</div>
<br>
<div class=”form-group”>
<input type=”submit” name=”Simpan” value=”Ubah Data” class=”btn btn-primary”>
<a href=”index.php” class=”btn btn-warning”>Batal</a>
</div>
</form>
</div>
</div>
</body>
<?php
if (isset ($_POST[‘Simpan’])){
$sql_ubah = “UPDATE tb_siswa SET
nama='”.$_POST[‘nama’].”‘,
jekel='”.$_POST[‘jekel’].”‘,
jurusan='”.$_POST[‘jurusan’].”‘”;
$query_ubah = mysqli_query($koneksi, $sql_ubah);
$pindah = move_uploaded_file($sumber, ‘foto/’.$nama_file);
}elseif(empty($sumber)){
$sql_ubah = “UPDATE tb_siswa SET
nama='”.$_POST[‘nama’].”‘,
jekel='”.$_POST[‘jekel’].”‘,
jurusan='”.$_POST[‘jurusan’].”‘
WHERE nis='”.$_POST[‘nis’].”‘”;
$query_ubah = mysqli_query($koneksi, $sql_ubah);
}
if ($query_ubah) {
echo “<script>alert(‘Ubah Data Sukses’)</script>”;
echo “<meta http-equiv=’refresh’ content=’0; url=index.php’>”;
}else{
echo “<script>alert(‘Ubah Data Gagal’)</script>”;
echo “<meta http-equiv=’refresh’ content=’0; url=edit.php’>”;
}
?>
</html>