CURD (UPDATE) master_mahasiswa3.php

<?php
$a = !empty($_GET['a']) ? $_GET['a'] : "reset";
$idmahasiswa = !empty($_GET['id']) ? $_GET['id'] : " ";
$kdb = koneksidatabase();
$a = @$_GET["a"];
$sql = @$_POST["sql"];
switch ($sql) {
    case "insert": sql_insert(); break;
    case 'update': sql_update(); break;
    case 'delete': sql_delete(); break;
}

switch ($a) {
    case "reset" :  curd_read();   break;
    case "tambah":  curd_create(); break;
    case "edit"  :  curd_update($idmahasiswa); break;
    case "hapus" : curd_delete($idmahasiswa); break;
    default : curd_read(); break;
}
  mysqli_close($kdb);

function curd_read()
{
  $hasil = sql_select();
  $i=1;
  ?>
  <H3> MASTER DATA MAHASISWA  </H3>
  <a href="master_mahasiswa3.php?a=tambah" >CREATE</a>
  <table border="1" cellpadding="10" cellspacing="0" >
  <tr>
  <td>No</td>
  <td>ID Mahasiswa</td>
  <td>NPM</td>
  <td>Nama Mahasiswa</td>
  <td> Jenis Kelamin</td>
  <td>Tempat Lahir</td>
  <td>Tanggal Lahir</td>
  <td>ID Agama</td>
  <td>ID Tahun</td>
  <td>ID Jalur Masuk</td>
  <td>Alamat</td>
  <td>Kecamatan</td>
  <td>Kabupaten</td>
  <td>Provinsi</td>
  <td>Kode Pos</td>
  <td>No HP</td>
  <td>Email</td>
  <td>gambar</td>
  <td>Publish</td>
  <td>Aksi</td>
  </tr>
  <?php
  while($baris = mysqli_fetch_array($hasil))
  {
  ?>
  <tr>
  <td><?= $i; ?></td>
  <td><?= $baris['idmahasiswa']; ?></td>
  <td><?= $baris['npm']; ?></td>
  <td><?= $baris['nama']; ?></td>
  <td><?= $baris['sex']; ?></td>
  <td><?= $baris['tmp_lahir']; ?></td>
  <td><?= $baris['tgl_lahir']; ?></td>
  <td><?= $baris['idagama']; ?></td>
  <td><?= $baris['idtahun']; ?></td>
  <td><?= $baris['idjalurmasuk']; ?></td>
  <td><?= $baris['alamat_jln']; ?></td>
  <td><?= $baris['alamat_kecamatan']; ?></td>
  <td><?= $baris['alamat_kabupatenkota']; ?></td>
  <td><?= $baris['alamat_provinsi']; ?></td>
  <td><?= $baris['kodepos']; ?></td>
  <td><?= $baris['nohp']; ?></td>
  <td><?= $baris['email']; ?></td>
  <td><?= $baris['gambar']; ?></td>
  <td><?= $baris['publish']; ?></td>
  <td>
  <a href="master_mahasiswa3.php?a=edit&id=<?= $baris['idmahasiswa']; ?>">UPDATE</a>
  <a href="master_mahasiswa3.php?a=hapus&id=<?= $baris['idmahasiswa']; ?>">DELETE</a>
  </td>
  </tr>
  <?php
   $i++;
  }
  ?>
  </table>
   <?php
  mysqli_free_result($hasil);
}
 ?>


<?php
function formeditor($row)
  {
?>
<table>
<tr>
<td width="200px">NPM</td>
<td><input type="text" name="npm" id="npm" maxlength="25" size="25" value="<?= trim($row["npm"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Nama Mahasiswa</td>
<td><input type="text" name="nama" id="nama" maxlength="25" size="25" value="<?= trim($row["nama"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Jenis Kelamin</td>
<td >
<?php  $sex = str_replace('"', '"', trim($row["sex"])); ?>
<input type="radio" name="sex" id="sex" value="L" <?php  if($sex=='L' || $sex=='') {echo "checked=\"checked\""; } else {echo ""; }  ?> />
<label>Laki-Laki</label><br>
<input type="radio" name="sex" id="sex" value="P" <?php  if($sex=='P') {echo "checked=\"checked\""; } else {echo ""; } ?> />
<label>Perempuan</label>
</td>

<tr>
<td width="200px">Tempat Lahir</td>
<td><input type="text" name="tmp_lahir" id="tmp_lahir" maxlength="25" size="25" value="<?= trim($row["tmp_lahir"]) ?>" ></td>
</tr>
<tr>

<tr>
<td width="200px">Tanggal Lahir</td>
<td><input type="date" name="tgl_lahir" id="tgl_lahir" maxlength="25" size="25" value="<?= trim($row["tgl_lahir"]) ?>" ></td>
</tr>

<tr>
<td width="200px">ID Agama</td>
<td><input type="text" name="idagama" id="idagama" maxlength="25" size="25" value="<?= trim($row["idagama"]) ?>" ></td>
</tr>

<tr>
<td width="200px">ID Tahun</td>
<td><input type="text" name="idtahun" id="idtahun" maxlength="25" size="25" value="<?= trim($row["idtahun"]) ?>" ></td>
</tr>

<tr>
<td width="200px">ID Jalur Masuk</td>
<td><input type="text" name="idjalurmasuk" id="idjalurmasuk" maxlength="25" size="25" value="<?= trim($row["idjalurmasuk"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Alamat</td>
<td><input type="text" name="alamat_jln" id="alamat_jln" maxlength="25" size="25" value="<?= trim($row["alamat_jln"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Kecamatan</td>
<td><input type="text" name="alamat_kecamatan" id="alamat_kecamatan" maxlength="25" size="25" value="<?= trim($row["alamat_kecamatan"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Kabupaten</td>
<td><input type="text" name="alamat_kabupatenkota" id="alamat_kabupatenkota" maxlength="25" size="25" value="<?= trim($row["alamat_kabupatenkota"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Provinsi</td>
<td><input type="text" name="alamat_provinsi" id="alamat_provinsi" maxlength="25" size="25" value="<?= trim($row["alamat_provinsi"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Kode Pos</td>
<td><input type="text" name="kodepos" id="kodepos" maxlength="25" size="25" value="<?= trim($row["kodepos"]) ?>" ></td>
</tr>

<tr>
<td width="200px">No HP</td>
<td><input type="text" name="nohp" id="nohp" maxlength="25" size="25" value="<?= trim($row["nohp"]) ?>" ></td>
</tr>

<tr>
<td width="200px">Email</td>
<td><input type="text" name="email" id="email" maxlength="25" size="25" value="<?= trim($row["email"]) ?>" ></td>
</tr>

<tr>
<td width="200px">gambar</td>
<td><input type="text" name="gambar" id="gambar" maxlength="25" size="25" value="<?= trim($row["gambar"]) ?>" ></td>
</tr>

<tr>
<td >PUBLIKASI</td>
<td >
<?php  $publish = str_replace('"', '"', trim($row["publish"])); ?>
<input type="radio" name="publish" id="publish" value="T" <?php  if($publish=='T' || $publish=='') {echo "checked=\"checked\""; } else {echo ""; }  ?> />
<label>Dipublikasikan</label><br>
<input type="radio" name="publish" id="publish" value="F" <?php  if($publish=='F') {echo "checked=\"checked\""; } else {echo ""; } ?> />
<label>Tidak dipublikasikan</label>
</td>
</tr>
</table>
<?php  }?>

<?php
function curd_create()
{
?>
<h3>Penambahan Data mahasiswa</h3><br>
<a href="master_mahasiswa3.php?a=reset">Batal</a>
<br>
<form action="master_mahasiswa3.php?a=reset" method="post">
<input type="hidden" name="sql" value="insert" >
<?php
$row = array(
  "npm" => "",
  "nama" => "",
  "sex" => "-",
  "tmp_lahir" => "",
  "tgl_lahir" => "",
  "idagama" => "",
  "idtahun" => "",
  "idjalurmasuk" => "",
  "alamat_jln" => "",
  "alamat_kecamatan" => "",
  "alamat_kabupatenkota" => "",
  "alamat_provinsi" => "",
  "kodepos" => "",
  "nohp" => "",
  "email" => "",
  "gambar" => "",
  "publish" => "T");
formeditor($row)
?>
<p><input type="submit" name="action" value="Simpan" ></p>
</form>
<?php } ?>

<?php
function curd_update($idmahasiswa)
{
global $kdb;
$hasil2 = sql_select_byid($idmahasiswa);
$row = mysqli_fetch_array($hasil2);
?>
<h3>Pengubahan Data Mahasiswa</h3><br>
<a href="master_mahasiswa3.php?a=reset">Batal</a>
<br>
<form action="master_mahasiswa3.php?a=reset" method="post">
<input type="hidden" name="sql" value="update" >
<input type="hidden" name="idmahasiswax" value="<?php  echo $idmahasiswa; ?>" >
<?php
formeditor($row)
?>
<p><input type="submit" name="action" value="Update" ></p>
</form>
<?php } ?>


<?php
function koneksidatabase()
{
    include('../koneksi/koneksi.php');
  return $kdb;
}

function sql_select()
{
  global $kdb;
  $sql = " select * from mahasiswa ";
  $hasil = mysqli_query($kdb, $sql) or die(mysql_error());
  return $hasil;
}

function sql_insert()
{
  global $kdb;
  global $_POST;
  echo $_POST["nama"];
  $sql  = " insert into `mahasiswa` (`npm`, `nama`, `sex`, `tmp_lahir`, `tgl_lahir`, `idagama`, `idtahun`, `idjalurmasuk`, `alamat_jln`, `alamat_kecamatan`, `alamat_kabupatenkota`, `alamat_provinsi`, `kodepos`, `nohp`, `email`, `gambar`, `publish`) values ( '".$_POST["npm"]."', '".$_POST["nama"]."', '".$_POST["sex"]."', '".$_POST["tmp_lahir"]."', '".$_POST["tgl_lahir"]."', '".$_POST["idagama"]."', '".$_POST["idtahun"]."', '".$_POST["idjalurmasuk"]."', '".$_POST["alamat_jln"]."', '".$_POST["alamat_kecamatan"]."', '".$_POST["alamat_kabupatenkota"]."', '".$_POST["alamat_provinsi"]."', '".$_POST["kodepos"]."', '".$_POST["nohp"]."', '".$_POST["email"]."', '".$_POST["gambar"]."', '".$_POST["publish"]."' )";
  mysqli_query($kdb, $sql) or die( mysql_error());
}

function sql_select_byid($idmahasiswa)
{
  global $kdb;
  $sql = " select * from mahasiswa where idmahasiswa = ".$idmahasiswa;
  $hasil2 = mysqli_query($kdb, $sql) or die(mysql_error());
  return $hasil2;
}

function sql_update()
{
  global $kdb;
  global $_POST;
  $sql  = " update  `mahasiswa` set `nama` = '".$_POST["nama"]."', publish = '".$_POST["publish"]."' where idmahasiswa = ".$_POST["idmahasiswax"];
  mysqli_query($kdb, $sql) or die( mysql_error());
}
?>