Insert, Update, dan Delete

MEMBUAT MENU KONEKSI PADA PHP
koneksi.php
<?php
$server="localhost";
$username="root";
$password="";
$db="Barang";
$conf = mysql_connect($server, $username, $password) or die ("Ada kesalahan koneksi pada database");
$simpan = mysql_select_db ($db);
?>

MEMBUAT FORM INPUT PADA PHP
FormBarang.php
<div align="center">
<form id="form1" name="form1" method="post" action="Proses.php">
<h2>Form Input Data Barang</h2>
  <table width="454">
    <tr>
      <td width="159">Kode Barang</td>
      <td width="29">:</td>
      <td width="381"><label>
        <input type="text" name="kode" id="kode" />
      </label></td>
    </tr>
    <tr>
      <td>Nama Barang</td>
      <td>:</td>
      <td><label>
        <input name="nama" type="text" id="nama" />
      </label></td>
    </tr>
    <tr>
      <td>Tanggal Masuk</td>
      <td>:</td>
      <td><label>
        <select name="tanggal" id="tanggal">
        <option value="tanggal">Tanggal</option>
        <?php
for ($tanggal = 1; $tanggal <= 31; $tanggal++)
{
echo "<option value=".$tanggal.">".$tanggal."</option>";
}
?>
        </select>
        <select name="bulan" id="bulan">
        <option value="bulan">Bulan</option>
        <?php
for ($bulan = 1; $bulan <= 12; $bulan++)
{
echo "<option value=".$bulan.">".$bulan."</option>";
}
?>
        </select>
        <select name="tahun" id="tahun">
        <option value="tahun">Tahun</option>
        <?php
for ($tahun = 2014; $tahun <= 2020; $tahun++)
{
echo "<option value=".$tahun.">".$tahun."</option>";
}
?>
        </select>
      </label></td>
    </tr>
    <tr>
      <td>Jenis Barang</td>
      <td>:</td>
      <td><label>
        <select name="jenis" id="jenis">
          <option>------</option>
          <option>FOOD</option>
          <option>NON FOOD</option>
          <option>Fresh and Fruit</option>
          <option>DAIRY</option>
        </select>
      </label></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td><label>
        <input type="submit" name="simpan" id="simpan" value="Simpan" />
      </label>
      <label>
      <input type="reset" name="button2" id="button2" value="Reset" />
      </label></td>
    </tr>
  </table>
</form>
</div>

MEMBUAT FORM PROSES SIMPAN PADA PHP
proses.php
<?php
include('koneksi.php');

if($_POST['simpan']=='Simpan')
{
$simpan = "insert into input(`kd_barang`, `nm_barang`, `masuk`, `jenis`) values
('".$_POST['kode']."',
'".$_POST['nama']."',
'".$_POST['tanggal']."-".$_POST['bulan']."-".$_POST['tahun']."',
'".$_POST['jenis']."')";

$success = mysql_query($simpan);
//print_r($success);
if($success)
{
echo '<script>alert("Data Telah Tersimpan!")</script> <a href="FormBarang.php"> <<< Kembali ke halaman Form Peserta</a>';
}
}

?>

MEMBUAT FORM VIEW PADA PHP
view.php
<?php
//koneksi mysql
include('koneksi.php');
$sql="select * from input";
$hasil=mysql_query($sql);
echo "<h2>Data Barang</h2>";
echo "<table border='1' width='700' height='100 align='center'>";
echo "<tr bgcolor='".$warnaHeading."'>
      <td><center><font color='Black'>Kode Barang</td>
      <td><center><font color='Black'>Nama Brang</td>
 <td><center><font color='Black'>Tanggal Masuk</td>
 <td><center><font color='Black'>Jenis Barang</td>
  <td><center><font color='Black'>Action</td>
      </tr>";
while($data = mysql_fetch_array($hasil))
{
echo "<td>".$data['kd_barang']."</td>";
echo "<td>".$data['nm_barang']."</td>";
echo "<td>".$data['masuk']."</td>";
echo "<td>".$data['jenis']."</td>";
echo  "<td><a href='edit.php?nomor=".$data['kd_barang']."'>edit</a> | <a href='delete.php?nomor=".$data['kd_barang']."'>delete</a></td></tr>";
echo "</tr>";
}
echo "</table>";
?>

MEMBUAT FORM EDIT PADA PHP
edit.php
<?php
//koneksi mysql
include ('koneksi.php');

  $kode = "SELECT `kd_barang`, `nm_barang`, `masuk`, `jenis` FROM input WHERE kd_barang";
  $sql = mysql_query($kode);
  $data = mysql_fetch_array ($sql);
?>

<form id="form" name="form" method="post" action="update.php">
  <h1 align="center">EDIT DATA BARANG</h1>
  <table width="556" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="172">Kode Barang</td>
      <td width="384"><label><input type="text" name="kode" id="kode" value="<?=$data['kd_barang'];?>" />
      </label></td>
    </tr>
    <tr>
      <td>Nama Barang</td>
      <td><label><input type="text" name="nama" id="nama" value="<?=$data['nm_barang'];?>"/>
      </label></td>
    </tr>
    <tr>
      <td>Asal Sekolah</td>
      <td><label><input type="text" name="tanggal" id="tanggal" value="<?=$data['masuk'];?>"/>
   
          <select name="tanggal" id="tanggal">
          <option value="tanggal">Tanggal</option>
        <?php
for ($tanggal = 1; $tanggal <= 31; $tanggal++)
{
echo "<option value=".$tanggal.">".$tanggal."</option>";
}
?>
          </select>
          <select name="bulan" id="bulan">
          <option value="bulan">Bulan</option>
        <?php
for ($bulan = 1; $bulan <= 12; $bulan++)
{
echo "<option value=".$bulan.">".$bulan."</option>";
}
?>
          </select>
          <select name="tahun" id="tahun">
          <option value="tahun">Tahun</option>
        <?php
for ($tahun = 2014; $tahun <= 2020; $tahun++)
{
echo "<option value=".$tahun.">".$tahun."</option>";
}
?>
        </select>
      </label></td>
    </tr>
    <tr>
      <td>Lomba</td>
      <td><label><input type="text" name="jenis" id="jenis" value="<?=$data['jenis'];?>"/>
              <select name="jenis" id="jenis">
 <option>------</option>
          <option>FOOD</option>
          <option>NON FOOD</option>
          <option>Fresh and Fruit</option>
          <option>DAIRY</option>
          </select>
      </label></td>
    </tr>
    </table>
      <p>
    <label>
    <div align="center">
    <input type="submit" name="simpan" id="simpan" value="Update" />
    <input type="reset" name="cancel" id="cancel" value="Cancel" />
    </div>
    </label>
    <label>
  <div align="center"></div>
    </label>
  </p>
</form>

MEMBUAT MENU UPDATE PADA PHP
update.php
<?php
include('koneksi.php');

if($_POST['simpan']=='Update')
{
$simpan = "UPDATE input SET `kd_barang`='".$_POST['kode']."', `nm_barang`='".$_POST['nama']."', `masuk`='".$_POST['tanggal']."-".$_POST['bulan']."-".$_POST['tahun']."',`jenis`='".$_POST['jenis']."' WHERE `kd_barang`='".$_POST['kode']."'";

$success = mysql_query($simpan);
//print_r($success);
if($success)
{
echo '<script>alert("Data Telah TerUPDATE!")</script> <a href="viewPeserta.php"> <<< Kembali ke halaman View Data Peserta</a>';
}
}
?>

MEMBUAT MENU DELETE PADA PHP
delete.php
<?php
//koneksi mysql
include ('koneksi.php');

if (!empty($_GET['kode']))
    {
        $id = $_GET['kode'];
    $result = mysql_query("DELETE FROM input WHERE kd_barang ='$id'") or die(mysql_error());
echo'<script>alert("Data telah terhapus!!")</script> <a href="view.php"> <<< Kembali ke halaman View Data Peserta</a>';
    }
?>