Kuis 1 Php My Sql (Operasi Edit and Delete) ~ EAS Article

Assalamu 'alaikum wr wb
pada postingan kali ini kita akan :
melanjutkan postingan sebelumnya kita akan membuat Operasi Edit and Delete Biasa disebut Crud php
-
postingan pembahasan => KuisPhp
-
Gambar Tampilan Operasi Edit and Delete

Kodingan :

Pada Folder : kuis

Buka Note pad Masukkan dibawah body:

<?php
$conn = mysql_connect("localhost","root","") or die ("koneksi gagal");
mysql_select_db("dbdaftar5d",$conn);
$strSQL = "select * from tbkuis";
$qry = mysql_query($strSQL,$conn) or die ("query salah");

?>

<center>
<table border="1" border="black" bgcolor="white" cellpadding="5" cellspacing="2" width="80%">
<tr>
<th bgcolor="5f9ea0"><b>NIP : </b></th>
<th bgcolor="5f9ea0"><b>Nama : </b></th>
<th bgcolor="5f9ea0"><b>Bagian : </b></th>
<th bgcolor="5f9ea0"><b>Gaji Pokok : </b></th>
<th bgcolor="5f9ea0"><b>Operasi : </b></th>
<th bgcolor="5f9ea0"><b>Operasi : </b></th>
</tr>

<?php
while ($row = mysql_fetch_array($qry))
{
echo "<tr>";
echo "<td>".$row["nip"]."</td>";
echo "<td>".$row["nama"]."</td>";
echo "<td>".$row["bagian"]."</td>";
echo "<td>".$row["gaji_pokok"]."</td>";
echo "<td><a href=edit.php?vnip=".$row["nip"].">Edit</td>";
echo "<td><a href=delete.php?vnip=".$row["nip"].">Delete</td>";
echo "</tr>";
}
?>

</table>
<a href="tambah.php">Input Data</a>
<a href="dbkuis.php">Lihat Database</a>
</center>

-
Save dengan nama : operasi.php

lalu buat file baru di notepad

<?php
$conn = mysql_connect("localhost","root","") or die ("koneksi gagal");
mysql_select_db("dbdaftar5d",$conn);
$strSQL = "select * from tbkuis where nip='$_GET[vnip]' ";
$qry = mysql_query($strSQL,$conn) or die ("query salah");
$row=mysql_fetch_array($qry);
?>

<form action="hedit.php" method="post">
<table border="1" border="black" bgcolor="white" cellpadding="7" cellspacing="5" width="80%">
<tr>
<td>NIP : <input type="text" name="txtnip" value="<?php echo $row['nip'];?>" readonly /></td>
<td>Nama : <input type="text" name="txtnama" value="<?php echo $row['nama'];?>" /></td>
<td>Bagian : <input type="text" name="txtbagian" value="<?php echo $row['bagian'];?>" /></td>
<td>Gaji pokok : <input type="text" name="txtgaji" value="<?php echo $row['gaji_pokok'];?>" /></td>
</tr>
</table>
<input type="submit" value="Update">
</form>

-
Save dengan nama : edit.php

lalu buat file baru di notepad

<?php
$vnip = $_POST ['txtnip'];
$vnama = $_POST ['txtnama'];
$vbagian = $_POST ['txtbagian'];
$vgaji = $_POST ['txtgaji'];

$conn = mysql_connect("localhost","root","") or die ("koneksi gagal");
mysql_select_db("dbdaftar5d",$conn);
$strSQL = "update tbkuis set nama='$vnama',bagian='$vbagian',gaji_pokok='$vgaji' where nip='$vnip'";
$qry = mysql_query($strSQL,$conn) or die ("query salah");
?>
Data sudah di update
<a href="dbkuis.php">Cari Lagi</a>

-
Save dengan nama : hedit.php

lalu buat file baru di notepad

?>

<form action="hdelete.php" method="post">
<table border="1" border="black" bgcolor="white" cellpadding="7" cellspacing="5" width="80%">
<tr>
<td>NIP : <input type="text" name="txtnip" value="<?php echo $row['nip'];?>" readonly /></td>
<td>Nama : <input type="text" name="txtnama" value="<?php echo $row['nama'];?>" readonly /></td>
<td>Bagian : <input type="text" name="txtbagian" value="<?php echo $row['bagian'];?>" readonly /></td>
<td>Gaji Pokok : <input type="text" name="txtgaji" value="<?php echo $row['gaji_pokok'];?>" readonly /></td>
</tr>
</table>
Yakin Hapus Data??
<input type="submit" value="Iyahh Sippp">
</form>

-
Save dengan nama : delete.php

lalu buat file baru di notepad

<?php

$vnip = $_POST ['txtnip']; //variable

$conn = mysql_connect("localhost","root","") or die ("koneksi gagal");
mysql_select_db("dbdaftar5d",$conn);
$strSQL = "delete from tbkuis where nip='$vnip'";
$qry = mysql_query($strSQL,$conn) or die ("query salah");
?>
Data sudah di dihapus
<a href="operasi.php">Kembali Operasi</a>

-
Save dengan nama : hdelete.php

gambar ketika di edit

gambar ketika di delete

Sekian dari saya
Assalamu 'alaikum wr wb