part 3 delete update
Index.php
<?php
require 'connect.php';
?>
<!DOCTYPE html>
<html>
<head>
<title>HALAMAN</title>
</head>
<body>
<h1>DATA SISWA</h1>
<table>
<tr>
<th>No</th>
<th>Nama</th>
<th>Kelas</th>
<th>Aksi</th>
</tr>
<?php
$no = 1;
$sql = mysqli_query($con, "SELECT * FROM sakel");
foreach ($sql as $data) {
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $data["nama"]; ?></td>
<td><?php echo $data["kelas"]; ?></td>
<td>
<a href="hapus.php?id=<?= $data["id"]; ?>"> DELETE </a>
<a href="edit.php?id=<?= $data["id"]; ?>"> EDIT </a>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
Hapus.php
<?php
require 'connect.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>
";
}
?>
Edit.php
<?php
require 'connect.php';
$id = $_GET['id'];
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>
<head>
<title>Edit</title>
<form method="POST">
<?php
$sql = mysqli_query($con, "SELECT * FROM sakel WHERE id = '$id'");
foreach ($sql as $row) {
?>
<h5 class="card-title text-center">EDIT DATA</h5>
<input type="number" name="id" value="<?php echo $id; ?>" hidden>
<label for="nama">Nama</label>
<input type="text" class="form-control" name="nama" id="nama" value="<?php echo $row["nama"]; ?>">
<br>
<br>
<label>Kelas</label>
<select name="Kelas">
<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>
<?php } ?>
<input type="submit" name="submit" value="Edit Data" class="btn btn-warning mb-3 fw-bold">
</div>
</form>
</body>
</html>
Connect.php
<?php
$con = mysqli_connect("localhost", "root", "", "siswa");
if (!$con) {
echo "Koneksi Gagal";
}
function hapus ($data) {
global $con;
$id = $_GET['id'];
$sql = mysqli_query($con, "DELETE FROM sakel WHERE id = '$id'");
return mysqli_affected_rows($con);
}
function edit($data) {
global $con;
$id = $_GET['id'];
$nama = $_POST['nama'];
$kelas = $_POST['Kelas'];
$sql = "UPDATE projectdua SET
nama = '$nama',
kelas = '$kelas'
WHERE id = '$id'";
$query = mysqli_query($con, $sql);
return mysqli_affected_rows($con);
}
?>
Output :
.png)
Komentar
Posting Komentar