<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Data Alumni</title>
<style type="text/css">
<!--
.style10 {font-size: small; font-weight: bold; color: #FFFFFF; }
.style11 {font-size: small}
-->
</style>
</head>
<body>
<form method="post" action="alumni.php">
<table width="454">
   <tr>
     <td><select name="seleksi" size="1">
      <option selected value="nim">[View All]</option>
      <option value="nim">NIM</option>
      <option value="angkatan">Angkatan</option>
	  <option value="nm_mhs">Nama</option>
         </select>
       <input type="text" name="src1" size="30">
       <input type="submit" name="tampil" value="Search"></td>
</table>
</form>
<strong>DATA ALUMNI</strong>
<hr>
<table width="1243" border="0">
  <tr bgcolor="#0066CC">
    <td width="55"><div align="center" class="style10">NIM</div></td>
    <td width="215"><div align="center" class="style10">NAMA</div></td>
    <td width="212"><div align="center" class="style10">TTL</div></td>
    <td width="57"><div align="center" class="style10">JENKEL</div></td>
    <td width="114"><div align="center" class="style10">PRODI</div></td>
    <td width="102"><div align="center" class="style10">STATUS</div></td>
    <td width="106"><div align="center" class="style10">TGL. LULUS </div></td>
    <td width="120"><div align="center" class="style10">NO. IJAZAH</div></td>
    <td width="204"><div align="center" class="style10">NO. TRANSKRIP </div></td>
  </tr>
  <?php
    include "connect.php";
	include"indo.php";
 	$seleksi= $_POST['seleksi'];
	$src1 = $_POST['src1'];
		$q="select mhs.nim,mhs.nm_mhs,mhs.kota_lhr,mhs.tgl_lhr,mhs.jenkel,mhs.prog_study,mhs.status,transkrip.tgl_lls,transkrip.no_ijz,transkrip.no_trans from mhs,transkrip
		where mhs.nim=transkrip.nim and mhs.$seleksi like'$src1%'order by nim ASC";
		$sql=mysql_query($q);
		while($hasil=mysql_fetch_array($sql))
		{
		?>
  <tr bgcolor="#99CCFF" align="center">
    <td><span class="style11"><? echo "$hasil[0]"; ?></span></td>
    <td><span class="style11"><? echo "$hasil[1]"; ?></span></td>
				<? $tgl_asli = $hasil[3];
				$ftgl=TanggalIndo($tgl_asli);
				$tgl_lls = $hasil[7];
				$ftgl_lls=TanggalIndo($tgl_lls);
				?>
    <td><span class="style11"><? echo "$hasil[2]"; ?>, <? echo "$ftgl"; ?></span></td>
    <td><span class="style11"><? echo "$hasil[4]"; ?></span></td>
    <td><span class="style11"><? echo "$hasil[5]"; ?></span></td>
    <td><span class="style11"><? echo "$hasil[6]"; ?></span></td>
    <td><span class="style11"><? echo "$ftgl_lls"; ?></span></td>
    <td><span class="style11"><? echo "$hasil[8]"; ?></span></td>
    <td><span class="style11"><? echo "$hasil[9]"; ?></span></td>
	 <?php  } ?>
  </tr>
</table>
<hr>
</body>
</html>
