/sysfo/prjdwlkul.php

<form name="prjdwlmengajardosen" method="post" action='?syxec=prjdwlkul&aksi=cariKaryawan Jurusan'>

			<table align="center" width="400" border="0">

				<tr align="center" bgcolor="#FFCC11">

				<td colspan="4">Jadwal Kuliah</td>

				</tr><tr>

				<td>NIM</td>

				<td width="4">:</td>

				<td width="20"><input type="text" name="nim" size="40"></td>

				</tr><tr>

				<td colspan="2"><input type="submit" name="cari" value="Cari"></td>

				</tr>

			</table></form>

<?php

	$level=$_SESSION ['level'];

	$form=$_GET['syxec'];

	$unip = $_SESSION['unip'];



	if($level=='Karyawan Jurusan'){

	 $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia  FROM karyawan_jurusan a , jurusan b  where a.Kode=b.Kode AND a.ID=$unip");

	}

	else if($level=='Mahasiswa'){

	 $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia  FROM mhsw a , jurusan b  where a.KodeJurusan=b.Kode AND a.nim=$unip");

	}

	else if($level=='Dosen'){

	 $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia  FROM dosen a , jurusan b  where a.KodeJurusan=b.Kode AND a.id=$unip");

	}

	else if($level=='Kajur'){

	$jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia  FROM kajur a , jurusan b  where a.Kode=b.Kode AND a.ID=$unip");

	}

	 $jureks=mysql_fetch_array($jur);

	 $kode=$jureks['Kode'];

	 $jurusan=$jureks['Nama_Indonesia'];



	 

	 echo "

		$level - $unip<br /> $kode - $jurusan<br /> 		

	";

	

if($level=='Mahasiswa'){

   

	 echo"

	 

				

				

					<table border='1' align='center'>

					

					<form method='post' name='formjadwalkul' action=''>

						

						<tr>

				<td>No</td>

				<td>Hari</td>

				<td>Pukul</td>

				<td>Kode Mata Kuliah</td>

				<td>Dosen</td>

				<td>Ruang</td>

				<td>Kelas</td>

				<td>Jumlah Pertemuan</td>

				<td>Mahasiswa Angkatan</td>

				<td>Kapasitas Kelas</td>

						</tr>

						<tr>";

						$que_sel = mysql_query("SELECT * FROM jadwal a, krs b WHERE a.ID = b.IDJadwal AND b.NIM = '$unip'");

						$que_sel1 = mysql_query("SELECT hd_1,hd_2,hd_3,hd_4,hd_5,hd_6,hd_7,hd_8,hd_9,hd_10,hd_11,hd_12,hd_13,hd_14,hd_15,hd_16,hd_17,hd_18,hd_19,hd_20 FROM jadwal");

						$jumlah = mysql_num_fields($que_sel1);

						while($has_sel = mysql_fetch_array($que_sel)){

							$que_sel2 = mysql_query("SELECT Nama FROM hari WHERE ID=$has_sel[Hari]");

							$has_sel2 = mysql_fetch_array($que_sel2);

							$que_sel3 = mysql_query("SELECT Kelas FROM kelas WHERE ID=$has_sel[Kelas]");

							$has_sel3 = mysql_fetch_array($que_sel3);

							$que_sel4 = mysql_query("SELECT Name FROM dosen WHERE ID=$has_sel[IDDosen]");

							$has_sel4 = mysql_fetch_array($que_sel4);

							echo"

							<td>1</td>

								<td>$has_sel2[Nama]</td>

								<td>$has_sel[JamMulai]-$has_sel[JamSelesai]</td>

								<td>$has_sel[KodeMK]</td>

								<td>$has_sel4[Name]</td>

								<td>$has_sel[KodeRuang]</td>

								<td>$has_sel3[Kelas]</td>

								<td>$jumlah</td>

								<td>2009</td>

								<td>$has_sel[KapasitasKelas]</td>

								</ br>

								<tr></tr>

							";

						}

						echo"

						</tr>

						</form>

					</table>

				

			";

			}

			

 else if($level=='Karyawan Jurusan'){

		

		

   echo"

	 

				<form method='post' name='formjadwalkul' action=''>

					<table border='1' align='center'>

						<tr>

				<td>No</td>

				<td>Hari</td>

				<td>Pukul</td>

				<td>Kode Mata Kuliah</td>

				<td>Dosen</td>

				<td>Ruang</td>

				<td>Kelas</td>

				<td>Jumlah Pertemuan</td>

				<td>Mahasiswa Angkatan</td>

				<td>Kapasitas Kelas</td>

						</tr>

						<tr>";

						$que_sel = mysql_query("SELECT * FROM jadwal a, krs b WHERE a.ID = b.IDJadwal AND b.NIM = '$_POST[nim]'");

						//echo $_POST['nim'];

						//echo "SELECT * FROM jadwal a, krs b WHERE a.ID = b.IDJadwal AND b.NIM = '$_POST[nim]'";

						$que_sel1 = mysql_query("SELECT hd_1,hd_2,hd_3,hd_4,hd_5,hd_6,hd_7,hd_8,hd_9,hd_10,hd_11,hd_12,hd_13,hd_14,hd_15,hd_16,hd_17,hd_18,hd_19,hd_20 FROM jadwal");

						$jumlah = mysql_num_fields($que_sel1);

						while($has_sel = mysql_fetch_array($que_sel)){

							$que_sel2 = mysql_query("SELECT Nama FROM hari WHERE ID=$has_sel[Hari]");

							$has_sel2 = mysql_fetch_array($que_sel2);

							$que_sel3 = mysql_query("SELECT Kelas FROM kelas WHERE ID=$has_sel[Kelas]");

							$has_sel3 = mysql_fetch_array($que_sel3);

							$que_sel4 = mysql_query("SELECT Name FROM dosen WHERE ID=$has_sel[IDDosen]");

							$has_sel4 = mysql_fetch_array($que_sel4);

							echo"

							<td>1</td>

								<td>$has_sel2[Nama]</td>

								<td>$has_sel[JamMulai]-$has_sel[JamSelesai]</td>

								<td>$has_sel[KodeMK]</td>

								<td>$has_sel4[Name]</td>

								<td>$has_sel[KodeRuang]</td>

								<td>$has_sel3[Kelas]</td>

								<td>$jumlah</td>

								<td>2009</td>

								<td>$has_sel[KapasitasKelas]</td>

								</ br>

								<tr></tr>

							";

						}

						echo"

						</tr>

					</table>

				</form>

			";

			

}

			 ?>