CRUD PHP 2023/2024
index.php
<?php
require "conn.php";
$result=mysqli_query($koneksi,"SELECT * FROM siswa");
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h1>Daftar Siswa SMK Darul Ma'arif</h1>
<a href="tambahdata.php">tambah data siswa</a>
<table border="2" cellpadding="10" cellspacing="0">
<tr>
<th>No.</th>
<th>NIS</th>
<th>Nama</th>
<th>Jenis Kelamin</th>
<th>Jurusan</th>
<th>Kelas</th>
<th>Alamat</th>
<th>Aksi</th>
</tr>
<?php foreach ($result as $baris) {
?>
<tr>
<td><?php echo $baris["id"] ?></td>
<td><?php echo $baris["nis"] ?></td>
<td><?php echo $baris["nama"] ?></td>
<td><?php echo $baris["jeniskelamin"] ?></td>
<td><?php echo $baris["jurusan"] ?></td>
<td><?php echo $baris["kelas"] ?></td>
<td><?php echo $baris["alamat"] ?></td>
<td>
<a href="ubah.php?id=<?php echo $baris["id"] ?>" onclick="return confirm('Yakin ?');">Ubah</a> | <a href="hapus.php?id=<?php echo $baris["id"] ?>" onclick="return confirm('Yakin ?');">Hapus</a>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
conn.php
<?php
$koneksi=mysqli_connect("localhost","root","","rpl");
function query($query) {
global $koneksi;
$result= mysqli_query($koneksi, $query);
$rows= [];
while( $row = mysqli_fetch_assoc($result) ) {
$rows[] =$row;
}
return $rows;
}
function tambah ($data) {
global $koneksi;
$nis = $data["nis"];
$nama = $data["nama"];
$jeniskelamin = $data["jeniskelamin"];
$jurusan = $data["jurusan"];
$kelas = $data["kelas"];
$alamat = $data["alamat"];
//query insert data
$query="INSERT INTO siswa VALUES ('','$nis','$nama','$jeniskelamin','$jurusan','$kelas','$alamat')";
mysqli_query($koneksi, $query);
return mysqli_affected_rows($koneksi);
}
function hapus($id){
global $koneksi;
mysqli_query($koneksi,"DELETE FROM siswa WHERE id = $id ");
return mysqli_affected_rows($koneksi);
}
function ubah ($data) {
global $koneksi;
$id = $data["id"];
$nis = $data["nis"];
$nama = $data["nama"];
$jeniskelamin = $data["jeniskelamin"];
$jurusan = $data["jurusan"];
$kelas = $data["kelas"];
$alamat = $data["alamat"];
//query insert data
$query="UPDATE siswa SET
nis='$nis',
nama='$nama',
jeniskelamin='$jeniskelamin',
jurusan='$jurusan',
kelas='$kelas',
alamat='$alamat' WHERE id=$id ";
mysqli_query($koneksi, $query);
return mysqli_affected_rows($koneksi);
}
?>
tambahdata.php
<?php
//Koneksi ke database dlu
require 'conn.php';
//cek apakah tombol submit sudah d tekan atau belum
if (isset($_POST["submit"])) {
//ambil data dari tiap elemen dalam form
//cek apakah data berhasil ditambahkan atau tdk
if (tambah($_POST)>0) {
echo"
<script>
alert('data berhasil ditambahkan');
document.location.href='database.php';
</script>
";
}else{
echo"gagal";
echo "<br>";
echo mysqli_error($koneksi);
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h1>TAMBAH DATA</h1>
<form action="" method="post">
NIS:
<input type="text" name="nis" required><br>
NAMA SISWA:
<input type="text" name="nama"><br>
JENIS KELAMIN:
<input type="text" name="jeniskelamin"><br>
JURUSAN:
<input type="text" name="jurusan"><br>
KELAS:
<input type="text" name="kelas"><br>
ALAMAT:
<input type="text" name="alamat"><br>
<button type="submit" name="submit">TAMBAH DATA </button>
</form>
</body>
</html>
hapus.php
<?php
require "conn.php";
$id=$_GET["id"];
if (hapus($id)>0) {
echo "
<script>
alert('data berhasil dihapus');
document.location.href='database1.php';
</script>
";
}else{
echo "
alert('data gagal dihapus');
document.location.href='database1.php';
";
}
?>
ubah.php
<?php
//Koneksi ke database dlu
require 'conn.php';
//ambil data dari url ubah
$id=$_GET["id"];
$siswa=query("SELECT * FROM siswa WHERE id=$id")[0];
//cek apakah tombol submit sudah d tekan atau belum
if (isset($_POST["submit"])) {
//ambil data dari tiap elemen dalam form
//cek apakah data berhasil diubahkan atau tdk
if (ubah($_POST)>0) {
echo"
<script>
alert('data berhasil diubahkan');
document.location.href='database.php';
</script>
";
}else{
echo"gagal";
echo "<br>";
echo mysqli_error($koneksi);
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h1>UBAH DATA</h1>
<form action="" method="post">
<input type="hidden" name="id" required value="<?php echo $siswa["id"] ?>"><br>
NIS:
<input type="text" name="nis" required value="<?php echo $siswa["nis"] ?>"><br>
NAMA SISWA:
<input type="text" name="nama" value="<?php echo $siswa["nama"] ?>"><br>
JENIS KELAMIN:
<input type="text" name="jeniskelamin" value="<?php echo $siswa["jeniskelamin"] ?>"><br>
JURUSAN:
<input type="text" name="jurusan" value="<?php echo $siswa["jurusan"] ?>"><br>
KELAS:
<input type="text" name="kelas" value="<?php echo $siswa["kelas"] ?>"><br>
ALAMAT:
<input type="text" name="alamat" value="<?php echo $siswa["alamat"] ?>"><br>
<button type="submit" name="submit">UBAH DATA </button>
</form>
</body>
</html>