Update Aplikasi PSB : Penambahan Edit, Update dan Delete Data Siswa

Script edit_siswa.php

<?php
//This code created by root93.co.id
//if you have any question
//contact me : myroot593@gmail.com
include('connect.php');
$idedit=$_GET['idedit'];
$query="select * from daftar where id='$idedit'";
$perintah=@mysql_query ($query,$koneksi) 
or die ("Gagal konek".mysql_error());
$dta_sws=mysql_fetch_array($perintah);
$dta_idsiswa =$dta_sws['id'];
$dta_namasiswa=$dta_sws['nama'];
$dta_alamat=$dta_sws['alamat'];
$dta_ttl=$dta_sws['ttl'];
$dta_asalsekolah=$dta_sws['asal_sekolah'];
$dta_nisn=$dta_sws['nisn'];
$dta_telepon=$dta_sws['telepon'];
?>
<!DOCTYPE HTML>

<html>
 <head>
  <title>Admin Panel</title>
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1" />
  <!--[if lte IE 8]><script src="../assets/js/ie/html5shiv.js"></script><![endif]-->
  <link rel="stylesheet" href="../assets/css/main.css" />
   <!--[if lte IE 8]><link href="../assets/css/ie8.css" type="text/css" rel="stylesheet"><![endif]-->
 </head>
 <body>
<!-- Header -->
   <section id="header">
    <header>
     <span class="image avatar"><img src="../images/avatar.jpg" alt=""></span>
     <h1 id="logo"><a href="#">Admin Panel SMKN 1 Parigi</a></h1>
     <p>Halaman Admin Panel PSB<br />
     SMKN 1 Parigi Kab. Pangandaran</p>
    </header>
    <nav id="nav">
     <ul>
 <li><a href="#home" class="active">Home</a></li>
 <li><a href="lihat_data_siswa.php">Data Siswa</a></li>
 <li><a href="lihat_data_siswa.php?page=input_key">Masukan Key</a></li>
 <li><a href="lihat_data_siswa.php?page=logout">Logout</a></li>
    
     </ul>
    </nav>
    <footer>

    </footer>
   </section>
   
  <!-- Wrapper -->
   <div id="wrapper">

    <!-- Main -->
     <div id="main">

      <!-- One -->
      <section>
        <div class="container">
        <?php
$page=(isset($_GET['page']))?$_GET['page']:"main";
switch($page) {
 
 case'input_key':include"input_key.php";break;
 case'logout':include"logout.php";break;
 case 'main':
 
}
?>
</div>
</section>
</div>
</div>
<section>
   <div class="container">
  <h3 align="center">EDIT SISWA</h3>

<form action="update_siswa.php" method="post" name="form1" target="_self">
<div class="table-wrapper">
<table class="alt">
<tbody>

<tr>
<td>Nama Siswa</td>

<td><input name="namasiswa" type="text" value="<?php echo"$dta_namasiswa";?>"><input name="id" type="hidden" value="<?php echo "$dta_idsiswa";?>"></td>
</tr>
<tr>
<td>Alamat</td>

<td><input name="alamat" type="text" id="alamat" value="<?php echo"$dta_alamat";?>"></td>
</tr>
<tr>
<td>Tempat Tanggal Lahir</td>

<td><input type="text" id="ttl" name="ttl" value="<?php echo "$dta_ttl";?>"></td>
</tr>
<tr>
<td>Asal Sekolah</td>

<td><input type="text" name="asalsekolah" id="asalsekolah" value="<?php echo "$dta_asalsekolah";?>"></td>
</tr>
<tr>
<td>NISN</td>
<td><input type="text" name="nisn" id="nisn" value="<?php echo "$dta_nisn";?>"></td>
</tr>
<tr>
 <td>Telephone</td>
 <td><input type="text" id="telepon" name="telepon" value="<?php echo "$dta_telepon";?>"></td>

</tr>


<tr>
<td></td>
<td><input type="reset" name="batal" value="Batal"> | <input name="update" type="submit" value="Update"></td>
</tr>
</tbody>
</table>
</div>
</form>
</div>
</section>
<!-- Footer -->
     <section id="footer">
      <div class="container">
       <ul class="copyright">
        <li>&copy; ROOT93 School. All rights reserved.</li><li>Design: <a href="http://html5up.net">HTML5 UP</a></li>
       </ul>
      </div>
     </section>

   </div>

  <!-- Scripts -->
 <script src="../assets/js/jquery.min.js"></script>
 <script src="../assets/js/jquery.scrollzer.min.js"></script> 
 <script src="../assets/js/jquery.scrolly.min.js"></script>
 <script src="../assets/js/skel.min.js"></script>
  <script src="../assets/js/util.js"></script>
      

 <!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script><![endif]-->
 <script src="../assets/js/main.js"></script> 
  
  

 </body>
</html>

<?php
//This code created by root93.co.id
//if you have any question
//contact me : myroot593@gmail.com
include('sesi.php');
include('connect.php');

$id =$_POST['id'];
$namasiswa =$_POST['namasiswa'];
$alamat =$_POST['alamat'];
$ttl=$_POST['ttl'];
$aslskl=$_POST['asalsekolah'];
$nisn=$_POST['nisn'];
$tel=$_POST['telepon'];
//Validasi, jika kosong tidak akan diproses
if(empty($id)){
?><script language="JavaScript">alert('Id kosong !');
document.location=('edit_siswa.php')</script>
<?php
}
else if(empty($namasiswa)){
?><script language="JavaScript">alert('Nama Siswa Kosong !');
document.location=('edit_siswa.php')</script>
<?php
}
else if(empty($alamat)){
?><script language="JavaScript">alert('Alamat Siswa kosong !');
document.location=('edit_siswa.php')</script>
<?php
}
else if(empty($ttl)){
 ?><script language="JavaScript">alert('Tempat Tanggal Lahir Kosong');
 document.location=('edit_siswa.php')</script>

<?php
}
else if(empty($aslskl)){
 ?><script language="JavaScript">alert('Asal Sekolah Belum Diisi');
 document.location=('edit_siswa.php')</script>
<?php
}
else if(empty($nisn)){
 ?><script language="JavaScript">alert('Nisn Kosong');
 document.location=('edit_siswa.php')</script>
<?php
}
else if(empty($tel)){
 ?><script language="JavaScript">alert('Telepon Masih Kosong');
 document.location=('edit_siswa.php')</script>
<?php
}

else{
 //Bila semuanya telah di cek maka lanjutkan update
 $sql_ubah="UPDATE daftar SET
    nama='$namasiswa',
    alamat='$alamat',
    ttl='$ttl',
    asal_sekolah='$aslskl',
    nisn='$nisn',
    telepon='$tel'
        
   WHERE id='$id'";
   
  mysql_query($sql_ubah,$koneksi)
      or die ("Perubahan data gagal".mysql_error());
  ?><script language="JavaScript">alert('Data Berhasil diubah !');
document.location=('lihat_data_siswa.php')</script>
<?php
 
  exit;
}
?>

Lihat juga : Script PHP Untuk Menghapus Data Dalam Tabel MySQL

Script delete.php

<?php
extract($_REQUEST);
include('connect.php');

$sql=mysql_query("select * from daftar where id='$del'");
$row=mysql_fetch_array($sql);

unlink($row['name']);
mysql_query("delete from daftar where id='$del'");

header("Location:lihat_data_siswa.php");

?>