view.php

<html>
<head>
   <title>Tampil Data Mahasiswa Baru</title>
      <script language="JavaScript">
      function konfirmasi(kode) {
        tanya = confirm('Anda yakin ingin menghapus data mahasiswa ini ?');
        if (tanya == true) return true;
        else return false;
      }
   </script>
</head>
<body>
<body bgcolor="chartreuse">
<?php
include "koneksi.php";
$koneksi=mysql_connect("localhost","root","");
$perintah_sql = "SELECT * FROM `admin` WHERE 1";

mysql_select_db("ta", $koneksi) or die("Gagal memilih database!");
$hasil_query = mysql_query($perintah_sql, $koneksi) or die ("Gagal memproses query!");

$jumlah_data = mysql_num_rows($hasil_query);

echo "<H3><center>DATA MAHASISWA</center></H3>";

echo "<table border=1 align=center cellpadding=2 cellspacing=0>";
echo "<tr bgcolor=Lightgreen align=center>";
echo "<td>KODE</td>";
echo "<td>NISN</td>";
echo "<td>Nama Mahasiswa</td>";
echo "<td>Tanggal Lahir</td>";
echo "<td>Tempat Lahir</td>";
echo "<td>Jenis Kelamin</td>";
echo "<td>Kewarganegaraan</td>";
echo "<td>Agama</td>";
echo "<td>Status</td>";
echo "<td>Alamat Rumah </td>";
echo "<td>Alamat Semarang</td>";
echo "<td>Telepon</td>";
echo "<td>Asal Sekolah</td>";
echo "<td>Jenis Ijazah</td>";
echo "<td>Status Ijazah</td>";
echo "<td>Jurusan Ijazah</td>";
echo "<td>Tahun Ijazah</td>";
echo "<td>Jurusan Pilihan</td>";
echo "<td>Status Mahasiswa</td>";
echo "<td>Pilihan Kuliah</td>";
echo "<td>Nama Ayah</td>";
echo "<td>Nama Ibu</td>";
echo "<td>Alamat</td>";
echo "<td>Pendidikan Ayah</td>";
echo "<td>Pendidikan Ibu</td>";
echo "<td>Pekerjaan Ayah</td>";
echo "<td>Pekerjaan Ibu</td>";

echo "<td colspan=2>AKSI</td>";
echo "</tr>";

while ($row=mysql_fetch_array($hasil_query))
{
   echo "<tr>";
   echo "<td>$row[0]</td>";
   echo "<td>$row[1]</td>";
   echo "<td>$row[2]</td>";
   echo "<td>$row[3]</td>";
   echo "<td>$row[4]</td>";
   echo "<td>$row[5]</td>";
   echo "<td>$row[6]</td>";
   echo "<td>$row[7]</td>";
   echo "<td>$row[8]</td>";
   echo "<td>$row[9]</td>";
   echo "<td>$row[10]</td>";
   echo "<td>$row[11]</td>";
   echo "<td>$row[12]</td>";
   echo "<td>$row[13]</td>";
   echo "<td>$row[14]</td>";
   echo "<td>$row[15]</td>";
   echo "<td>$row[16]</td>";
   echo "<td>$row[17]</td>";
   echo "<td>$row[18]</td>";
   echo "<td>$row[19]</td>";
   echo "<td>$row[20]</td>";
   echo "<td>$row[21]</td>";
   echo "<td>$row[22]</td>";
   echo "<td>$row[23]</td>";
   echo "<td>$row[24]</td>";
      echo "<td>$row[25]</td>";
   echo "<td>$row[26]</td>";

   echo "<td><a href=\"edit.php?kode=$row[0]\">Ubah</a></td>";
   echo "<td><a href=\"delete.php?kode=$row[0]\" onclick=\"return konfirmasi('".$row[0]."')\">Hapus</a>";
   echo "</tr>";
}
echo "</table>";
echo "Jumlah data : $jumlah_data \t [<a href=add.php>Tambah Data</a>]";
?>

</body>
</html>