Alfyan Sore

1. index.php
2. insert.php
3. update.php
4. delete.php

CREATE DATABASE db_mahasiswa;

CREATE TABLE mahasiswa (
   id INT(6) AUTO_INCREMENT NOT NULL,
   nim VARCHAR(10) NOT NULL,
   nama VARCHAR(30) NOT NULL,
   jk VARCHAR(1) NOT NULL,
   alamat TEXT,
   PRIMARY KEY(id)
);

<?php
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

?>

<h2>Tambah Data Mahasiswa</h2>
<form action="insert.php" method="post" name="insertform">
<table>
 <tr> 
  <td>NIM</td>
  <td>:</td>
  <td><input type="number" name="nim" required placeholder="NIM"></td>
 </tr>
 <tr> 
  <td>Nama</td>
  <td>:</td>
  <td><input type="text" name="nama" required placeholder="Nama"></td>
 </tr>
  <tr> 
  <td>L/P</td>
  <td>:</td>
  <td>
   <input type="radio" name="jk" value="L">L
    <input type="radio" name="jk" value="P">P
   </td>
 </tr>
 <tr> 
  <td>Alamat</td>
  <td>:</td>
  <td><input type="text" name="alamat" required placeholder="Alamat"></td>
 </tr>
</table>
  <input type="submit" name="send" value="Submit"/>
</p>
</form>

<?php 
if ($data = $mysqli->query("SELECT * FROM mahasiswa")) {
  echo "<table border=1>";
     echo "<tr>";
     echo "<td>Nim</td>";
     echo "<td>Nama</td>";
     echo "<td>L/P</td>";
     echo "<td>Alamat</td>";
     echo "<td colspan=2>Aksi</td>";
     echo "</tr>";

 foreach ($data as $hasil) {
  echo "<tr>";
  echo "<td>".$hasil['nim']."</td>";
  echo "<td>".$hasil['nama']."</td>";
  echo "<td>".$hasil['jk']."</td>";
  echo "<td>".$hasil['alamat']."</td>";
  echo "<td><a href='update.php?id=".$hasil['id']."'>Edit</a></td>";
  echo "<td><a href='delete.php?id=".$hasil['id']."'>Hapus</a></td>";
  echo "</tr>";
 }
 echo "</table>";

    /* free result set */
    $data->close();
}

$mysqli->close();
?>

<?php
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if(isset($_POST['send'])!="")
  {
  $nim=$_POST['nim'];
  $nama=$_POST['nama'];
  $jk=$_POST['jk'];
  $alamat=$_POST['alamat'];
  $insert= $mysqli->query("INSERT INTO mahasiswa (nim,nama,jk,alamat)VALUES ('$nim','$nama','$jk','$alamat') ");
  
  if($insert)
  {
      $msg="Tambah Data Berhasil";
      echo "<script type='text/javascript'>alert('$msg');</script>";
      header('Location:index.php');
  }
  }
  else
  {
     $errormsg="Tambah Data Gagal !!! Coba Lagi !!";
      echo "<script type='text/javascript'>alert('$errormsg');</script>";
      header('Location:index.php');
  }

$mysqli->close();
?>

<?php 
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");
if(isset($_GET['id']))
{
  $id=$_GET['id'];
  if(isset($_POST['update']))
  {
  $nim=$_POST['nim'];
  $nama=$_POST['nama'];
  $jk=$_POST['jk'];
  $alamat=$_POST['alamat'];
  $update= $mysqli->query("UPDATE mahasiswa SET nim='$nim', nama='$nama', jk='$jk', alamat='$alamat' WHERE id='$id'");
  if($update)
  {
  $msg="Berhasil Di Update";
  header('Location:index.php');
  }
}
}
?>
<?php 
  if(isset($_GET['id']))
  {
  $id=$_GET['id'];
  $ambildata = $mysqli->query("SELECT * from mahasiswa WHERE id='$id'");
  while($data=$ambildata->fetch_array(MYSQLI_BOTH))
  {
    $nim=$data['nim'];
    $nama=$data['nama'];
    $jk=$data['jk'];
    $alamat=$data['alamat'];
?>
<h2>Edit Data Mahasiswa</h2>
<form action="" method="post" name="insertform">
<table>
 <tr> 
  <td>NIM</td>
  <td>:</td>
  <td><input type="number" name="nim" required placeholder="NIM" value="<?php echo $nim;?>"></td>
 </tr>
 <tr> 
  <td>Nama</td>
  <td>:</td>
  <td><input type="text" name="nama" required placeholder="Nama" value="<?php echo $nama;?>"></td>
 </tr>
  <tr> 
  <td>L/P</td>
  <td>:</td>
  <td>
   <input type="radio" name="jk" value="L">L
    <input type="radio" name="jk" value="P">P
   </td>
 </tr>
 <tr> 
  <td>Alamat</td>
  <td>:</td>
  <td><input type="text" name="alamat" required placeholder="Alamat" value="<?php echo $alamat;?>"></td>
 </tr>
</table>
  <input type="submit" name="update" value="Simpan Update"/>
</p>
</form>
<?php } } ?> 

<?php
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if(isset($_GET['id'])!="")
  {
   $id=$_GET['id'];
   $hapus=$mysqli->query("DELETE FROM mahasiswa WHERE id='$id'");
   if($hapus)
   {
       header("Location:index.php");
   }
   else
   {
       echo mysql_error();
   }
}

$mysqli->close();
?>

1. Ranking Otomatis Calon Siswa
2. Pilihan Program Studi Yang Bisa Diubah
3. Mata Pelajaran Untuk Input Nilai Bisa Diubah
4. Setting Web
5. Tampilan Antar Muka Yang Efisien

1. Isi Biodata
2. Pilih Program Studi
3. Input Nilai Siswa
4. Kirim Verifikasi
5. Cetak Bukti Pendaftaran Dan Diserahkan Ke Panitia PSB Online Untuk Diverifikasi
6. Setelah berhasil diverifikasi . Data pendaftar akan otomatis di ranking.