PRAKTIK 1
source code file "koneksi1.php"
<?php
$host = mysqli_connect("localhost","root","","praktik1");
function hapus($data){
global $host;
$id = $_GET["id"];
$tampil = mysqli_query($host, "DELETE FROM projekk1 WHERE id = '$id'");
return mysqli_affected_rows($host);
}
function edit($data){
global $host;
$id = $_POST['id'];
$nama = $_POST['nama'];
$sql = "UPDATE projekk1 SET
nama = '$nama'
WHERE id = '$id'";
$query = mysqli_query($host,$sql);
return mysqli_affected_rows($host);
}
?>
source code file "hasil1.php"
<?php
require 'koneksi1.php';
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<table border="2">
<thead>
<th>No</th>
<th>Nama</th>
<th>Aksi</th>
</thead>
<?php
$no = 1;
$sql = mysqli_query($host, "SELECT * FROM projekk1");
foreach ($sql as $row) {
?>
<tbody>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $row["nama"]; ?></td>
<td>
<a href="edit1.php?id=<?php echo $row["id"]; ?>">Edit</a>
<a href="hapus1.php?id=<?php echo $row["id"]; ?>">Hapus</a>
</td>
</tr>
</tbody>
<?php } ?>
</table>
</body>
</html>
source code file "hapus1.php"
<?php
require 'koneksi1.php';
$id = $_GET['id'];
if( hapus($id) > 0 ) {
echo "
<script>
alert('data berhasil dihapus');
document.location.href = 'hasil1.php';
</script>";
} else {
echo "
<script>
alert('data gagal dihapus')
</script>";
}
?>
source code file "edit1.php"
<?php
require 'koneksi1.php';
$id = $_GET['id'];
if (isset($_POST['submit'])) {
if (edit($_POST)>0) {
echo "
<script>
alert('Data Berhasil Diubah');
document.location.href='hasil1.php';
</script>
";
}else{
echo "
<script>
alert('Data Gagal Diubah');
</script>
";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method="POST">
<?php
$sql = mysqli_query($host, "SELECT * FROM projekk1 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>
<input type="text" class="from-control" name="nama" id="nama" value="<?php echo $row["nama"]; ?>">
<label for="nama">Nama</label>
<?php } ?>
<input type="submit" name="submit" value="Edit Data" class="btn btn-warning mb-3 fw-bold">
</form>
</body>
</html>
