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>
PRAKTIK 2
source code file "koneksi2.php"
<?php
$host = mysqli_connect("localhost","root","","pwdpbpraktik2");
function hapus($data){
global $host;
$id = $_GET['id'];
$tampil = mysqli_query($host,"DELETE FROM projek WHERE id = '$id'");
return mysqli_affected_rows($host);
}
function edit($data){
global $host;
$id = $_POST['id'];
$nama = $_POST['nama'];
$kelas = $_POST['kelas'];
$sql = "UPDATE projek SET
nama='$nama',
kelas='$kelas'
WHERE id = '$id'";
$query = mysqli_query($host, $sql);
return mysqli_affected_rows($host);
}
?>
source code file "hasil2.php"
<?php
require 'koneksi2.php';
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<table border="2">
<thead>
<th>NO</th>
<th>NAMA</th>
<th>KELAS</th>
<th>AKSI</th>
</thead>
<?php
$no = 1;
$sql = mysqli_query($host, "SELECT * FROM projek");
foreach ($sql as $row) {
?>
<tbody>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $row["nama"] ?></td>
<td><?php echo $row["kelas"] ?></td>
<td>
<a href="edit2.php?id=<?php echo $row["id"]; ?>">EDIT</a>
<a href="hapus2.php?id=<?php echo $row["id"]; ?>">HAPUS</a>
</td>
</tr>
</tbody>
<?php } ?>
</table>
</body>
</html>
source code file "edit2.php"
<?php
require 'koneksi2.php';
$id = $_GET['id'];
if (isset($_POST['submit'])) {
if (edit($_POST)>0) {
echo "
<script>
alert('Data Berhasil Diubah');
document.location.href='hasil2.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 projek 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="from-control" name="nama" id="nama" value="<?php echo $row["nama"]; ?>">
<br>
<label for="kelas">Kelas</label>
<select name="kelas">
<option value="<?php echo $row["kelas"]; ?>"><?php echo $row["kelas"]; ?></option>
<option value="XII">XII</option>
<option value="XI">XI</option>
<option value="X">X</option>
</select>
<?php } ?>
<br>
<input type="submit" name="submit" value="Edit Data" class="btn btn-warning mb-3 fw-bold">
</form>
</body>
</html>
source code file "hapus2.php"
<?php
require 'koneksi2.php';
$id = $_GET['id'];
if( hapus($id) > 0 ) {
echo "
<script>
alert('data berhasil dihapus');
document.location.href = 'hasil2.php';
</script>";
} else {
echo "
<script>
alert('data gagal dihapus')
</script>";
}
?>
PRAKTIK 3
source code file "koneksi3.php"
source code file "hasil3.php"
source code file "edit3.php"
source code file "hapus3.php"
PRAKTIK 4
source code file "koneksi4.php"
source code file "hasil4.php"
source code file "edit4.php"
source code file "hapus4.php"
Tidak ada komentar:
Posting Komentar