Nama : Nurhikmah Septridiani
Nim : 1802046
Kelas : 2 D TI
Berikut ini penjelasannya . .
1. Script "pegawai.php"
<!DOCTYPE html>
<html>
<head>
<title>Pegawai</title>
</head>
<style>
.container{
margin: auto;
width: 900px;
}
</style>
<body>
<div class="container">
<h2>Pegawai</h2>
<a href="insert_data.php">Tambah Data</a><br><br>
<table border="1" cellspacing="0" cellpadding="5">
<tr>
<th>No</th>
<th>Nik</th>
<th>Nama Pegawai</th>
<th>Jenis Kelamin</th>
<th>Alamat</th>
<th>No Hp</th>
<th>Email</th>
<th>Departemen</th>
<th>Jabatan</th>
<th>Gaji Pokok</th>
</tr>
<?php include
'koneksi.php';
$no = 1;
$data = mysqli_query($koneksi,"SELECT * FROM pegawai");
while ($b = mysqli_fetch_array($data)) {
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $b['nik']; ?></td>
<td><?php echo $b['nama_pegawai']; ?></td>
<td><?php echo $b['jenis_kelamin']; ?></td>
<td><?php echo $b['alamat']; ?></td>
<td><?php echo $b['no_hp']; ?></td>
<td><?php echo $b['email']; ?></td>
<td><?php echo $b['departemen']; ?></td>
<td><?php echo $b['jabatan']; ?></td>
<td><?php echo $b['gaji_pokok']; ?></td>
<a href="update_data.php?xid=<?php echo $b['nik']; ?>">Edit</a>
<a href="delete_data.php?xid=<?php echo $b['nik']; ?>">Hapus</a>
</td>
</tr>
<?php
}
?>
</table>
</div>
</body>
</html>
2. Script "koneksi.php"
<?php
$koneksi = mysqli_connect("localhost","root","","1802046_nurhikmah_septridiani");
//Cek koneksi
if (mysqli_connect_errno())
{
echo "koneksi database gagal :". mysqli_connect_error();
}
?>
3. Script "insert_data.php"
<!DOCTYPE html>
<html>
<head>
<title>Tambah Data Pegawai</title>
</head>
<body>
<form action="aksi_simpan.php" method="post">
<table>
<tr>
<td>Nik</td>
<td><input type="text" name="nik">
</td>
</tr>
<tr>
<td>Nama Pegawai</td>
<td><input type="text" name="nama_pegawai">
</td>
</tr>
<td>Jenis Kelamin</td>
<td><input type="text" name="jenis_kelamin">
</td>
<tr>
<td>Alamat</td>
<td><input type="text" name="alamat">
</td>
</tr>
<tr>No Hp</tr>
<td><input type="text" name="no_hp">
</td>
<tr>
<td>Email</td>
<td><input type="text" name="email">
</td>
<tr>
<td>Departemen</td>
<td><input type="text" name="departemen">
</td>
<tr>
<td>Jabatan</td>
<td><input type="text" name="jabatan">
</td>
<tr>
<td>Gaji Pokok</td>
<td><input type="text" name="gaji_pokok"></td>
</tr>
</tr>
</tr>
</tr>
<tr>
<td></td>
<td><input type="submit" name="simpan" values="simpan"></td>
</tr>
</table>
</form>
</body>
</html>
4. Script "aksi_update.php"
<?php
include 'koneksi.php';
$nk = $_POST["nik"];
$np = $_POST["nama_pegawai"];
$jk = $_POST["jenis_kelamin"];
$al = $_POST["alamat"];
$nh = $_POST["no_hp"];
$em = $_POST["email"];
$dp = $_POST["departemen"];
$jb = $_POST["jabatan"];
$gp = $_POST["gaji_pokok"];
mysqli_query(
$koneksi,"UPDATE pegawai SET nik='$nk',
nama_pegawai='$np',
jenis_kelamin='$jk',
alamat='$al',
no_hp='$nh',
email='$em',
departemen='$dp',
jabatan='$jb',
gaji_pokok='gp',
WHERE
id='$id'
"
) ;
header('location:pegawai.php');
?>
5. Script "update_data.php"
<!DOCTYPE html>
<html>
<head>
<title>Ubah Data Pegawai</title>
</head>
<?php
$id = $_GET['xid'];
include 'koneksi.php';
$sql = mysqli_query($koneksi, "SELECT * FROM pegawai WHERE nik='$id'");
$b = mysqli_fetch_array ($sql)
?>
<body>
<form action="aksi_update.php" method="post">
<table>
<tr>
<td>Nik</td>
<td><input type="text" name="nik" value="<?php echo $b['nik']; ?>"></td>
</tr>
<tr>
<td>Nama Pegawai</td>
<td><input type="text" name="nama_pegawai" value="<?php echo $b['nama_pegawai']; ?>"></td>
</tr>
<tr>
<td>Jenis Kelamin</td>
<td><input type="text" name="jenis_kelamin" value="<?php echo $b['jenis_kelamin']; ?>"></td>
</tr>
<tr>
<td>Alamat</td>
<td><input type="text" name="alamat" value="<?php echo $b['alamat']; ?>"></td>
</tr>
<tr>
<td>No Hp</td>
<td><input type="text" name="no_hp" value="<?php echo $b['no_hp']; ?>"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email" value="<?php echo $b['email']; ?>"></td>
</tr>
<tr>
<td>Departemen</td>
<td><input type="text" name="departemen" value="<?php echo $b['departemen']; ?>"></td>
</tr>
<tr>
<td>Jabatan</td>
<td><input type="text" name="jabatan" value="<?php echo $b['jabatan']; ?>"></td>
</tr>
<tr>
<td>Gaji Pokok</td>
<td><input type="text" name="gaji_pokok" value="<?php echo$b['gaji_pokok']; ?>"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="save" value="simpan!"></td>
</tr>
</table>
</form>
</body>
</html>
6. Script "delete_data.php"
<?php
include 'koneksi.php';
$id = $_GET['xid'];
mysqli_query($koneksi, "DELETE FROM pegawai WHERE nik='$id'");
header('location:pegawai.php');
?>
Hasil nya :
1. Buka "pegawai.php" dan klik tambah data
2. Tambahkan data baru lalu klik "Simpan"
3. Kita sudah berhasil menambahkan data baru, lalu klik "edit"
4. Sekarang kita edit datanya, yaitu dengan menambah angka 3 pada setiap inputnya, kecuali Nik, jenis kelamin, dan no hp karena panjang nilai dari Nik hanya saya berikan 6, nilai jenis kelamin 2, dan nilai no hp 12.
5. Dan kita sudah berhasil mengedit data no 1.
Sekian dan Terimakasih, semoga bermanfaat :)
Komentar
Posting Komentar