Teknik Kimia FTI ITS
Jadwal Kuliah
JADWAL KULIAH
Lihat Penuh
Lihat Penuh
Lihat Penuh
Lihat Penuh
Lihat Penuh
JADWAL KULIAH
| ".$kolom['kode_ruang']; //$tmpcol= $kolom['nama_ruang']; ?> | |
| ".$baris['nama_jam_kuliah']." ".$baris['deskripsi_jam_kuliah'];?> |
";
$query=mysql_query("select c.id_kuliah_rutin, a.kode_mata_kuliah, a.singkatan_mata_kuliah, c.sks_dipakai, b.nama_ruang, d.inisial_dosen, f.nama_kelas_pararel from mata_kuliah a, ruang b, dosen d, kuliah_rutin c, jam_kuliah e, kelas_pararel f, periode_tahun g, semester h where g.id_aktif=1 and c.id_periode_tahun=g.id_periode_tahun and h.id_aktif=1 and h.id_semester=c.id_semester and a.id_mata_kuliah=c.id_mata_kuliah and b.id_ruang=c.id_ruang and c.id_jam_kuliah=e.id_jam_kuliah and c.id_dosen=d.id_dosen and c.id_kelas_pararel=f.id_kelas_pararel and e.nama_jam_kuliah = '$tmp' AND b.nama_ruang='$tmpcol' AND c.id_hari_kuliah=$hk");
while($row=mysql_fetch_assoc($query)){
//echo $tmp;
echo "".$row['kode_mata_kuliah']."(".$row['nama_kelas_pararel'].") ".$row['singkatan_mata_kuliah']."(".$row['sks_dipakai'].") ".$row['inisial_dosen']; //echo $warna; $idkr=$row['id_kuliah_rutin']; $query2=mysql_query("select b.inisial_dosen as ini from mata_kuliah a, dosen b, kuliah_rutin c where c.id_kuliah_rutin='$idkr' and c.id_dosen2=b.id_dosen and c.id_dosen2!=0 group by id_kuliah_rutin"); while($row2=mysql_fetch_assoc($query2)){ echo "/".$row2['ini']; } }?> |
| ".$kolom['kode_ruang']; //$tmpcol= $kolom['nama_ruang']; ?> | |
| ".$baris['nama_jam_kuliah']." ".$baris['deskripsi_jam_kuliah'];?> |
";
$query=mysql_query("select c.id_kuliah_rutin, a.kode_mata_kuliah, a.singkatan_mata_kuliah, c.sks_dipakai, b.nama_ruang, d.inisial_dosen, f.nama_kelas_pararel, c.keterangan_kuliah_rutin from mata_kuliah a, ruang b, dosen d, kuliah_rutin c, jam_kuliah e, kelas_pararel f, periode_tahun g, semester h where g.id_aktif=1 and c.id_periode_tahun=g.id_periode_tahun and h.id_aktif=1 and h.id_semester=c.id_semester and a.id_mata_kuliah=c.id_mata_kuliah and b.id_ruang=c.id_ruang and c.id_jam_kuliah=e.id_jam_kuliah and c.id_dosen=d.id_dosen and c.id_kelas_pararel=f.id_kelas_pararel and e.nama_jam_kuliah = '$tmp' AND b.nama_ruang='$tmpcol' AND c.id_hari_kuliah=$hk");
while($row=mysql_fetch_assoc($query)){
//echo $tmp;
echo "".$row['keterangan_kuliah_rutin']."".$row['kode_mata_kuliah']."(".$row['nama_kelas_pararel'].") ".$row['singkatan_mata_kuliah']."(".$row['sks_dipakai'].") ".$row['inisial_dosen']; //echo $warna; $idkr=$row['id_kuliah_rutin']; $query2=mysql_query("select b.inisial_dosen as ini from mata_kuliah a, dosen b, kuliah_rutin c where c.id_kuliah_rutin='$idkr' and c.id_dosen2=b.id_dosen and c.id_dosen2!=0 group by id_kuliah_rutin"); while($row2=mysql_fetch_assoc($query2)){ echo "/".$row2['ini']; } }?> |
| ".$kolom['kode_ruang']; //$tmpcol= $kolom['nama_ruang']; ?> | |
| ".$baris['nama_jam_kuliah']." ".$baris['deskripsi_jam_kuliah'];?> |
";
$query=mysql_query("select c.id_kuliah_rutin, a.kode_mata_kuliah, a.singkatan_mata_kuliah, c.sks_dipakai, b.nama_ruang, d.inisial_dosen, f.nama_kelas_pararel, c.keterangan_kuliah_rutin from mata_kuliah a, ruang b, dosen d, kuliah_rutin c, jam_kuliah e, kelas_pararel f, periode_tahun g, semester h where g.id_aktif=1 and c.id_periode_tahun=g.id_periode_tahun and h.id_aktif=1 and h.id_semester=c.id_semester and a.id_mata_kuliah=c.id_mata_kuliah and b.id_ruang=c.id_ruang and c.id_jam_kuliah=e.id_jam_kuliah and c.id_dosen=d.id_dosen and c.id_kelas_pararel=f.id_kelas_pararel and e.nama_jam_kuliah = '$tmp' AND b.nama_ruang='$tmpcol' AND c.id_hari_kuliah=$hk");
while($row=mysql_fetch_assoc($query)){
//echo $tmp;
echo "".$row['keterangan_kuliah_rutin']."".$row['kode_mata_kuliah']."(".$row['nama_kelas_pararel'].") ".$row['singkatan_mata_kuliah']."(".$row['sks_dipakai'].") ".$row['inisial_dosen']; //echo $warna; $idkr=$row['id_kuliah_rutin']; $query2=mysql_query("select b.inisial_dosen as ini from mata_kuliah a, dosen b, kuliah_rutin c where c.id_kuliah_rutin='$idkr' and c.id_dosen2=b.id_dosen and c.id_dosen2!=0 group by id_kuliah_rutin"); while($row2=mysql_fetch_assoc($query2)){ echo "/".$row2['ini']; } }?> |
| ".$kolom['kode_ruang']; //$tmpcol= $kolom['nama_ruang']; ?> | |
| ".$baris['nama_jam_kuliah']." ".$baris['deskripsi_jam_kuliah'];?> |
";
$query=mysql_query("select c.id_kuliah_rutin, a.kode_mata_kuliah, a.singkatan_mata_kuliah, c.sks_dipakai, b.nama_ruang, d.inisial_dosen, f.nama_kelas_pararel, c.keterangan_kuliah_rutin from mata_kuliah a, ruang b, dosen d, kuliah_rutin c, jam_kuliah e, kelas_pararel f, periode_tahun g, semester h where g.id_aktif=1 and c.id_periode_tahun=g.id_periode_tahun and h.id_aktif=1 and h.id_semester=c.id_semester and a.id_mata_kuliah=c.id_mata_kuliah and b.id_ruang=c.id_ruang and c.id_jam_kuliah=e.id_jam_kuliah and c.id_dosen=d.id_dosen and c.id_kelas_pararel=f.id_kelas_pararel and e.nama_jam_kuliah = '$tmp' AND b.nama_ruang='$tmpcol' AND c.id_hari_kuliah=$hk");
while($row=mysql_fetch_assoc($query)){
//echo $tmp;
echo "".$row['keterangan_kuliah_rutin']."".$row['kode_mata_kuliah']."(".$row['nama_kelas_pararel'].") ".$row['singkatan_mata_kuliah']."(".$row['sks_dipakai'].") ".$row['inisial_dosen']; //echo $warna; $idkr=$row['id_kuliah_rutin']; $query2=mysql_query("select b.inisial_dosen as ini from mata_kuliah a, dosen b, kuliah_rutin c where c.id_kuliah_rutin='$idkr' and c.id_dosen2=b.id_dosen and c.id_dosen2!=0 group by id_kuliah_rutin"); while($row2=mysql_fetch_assoc($query2)){ echo "/".$row2['ini']; } }?> |
| ".$kolom['kode_ruang']; //$tmpcol= $kolom['nama_ruang']; ?> | |
| ".$baris['nama_jam_kuliah']." ".$baris['deskripsi_jam_kuliah'];?> |
";
$query=mysql_query("select c.id_kuliah_rutin, a.kode_mata_kuliah, a.singkatan_mata_kuliah, c.sks_dipakai, b.nama_ruang, d.inisial_dosen, f.nama_kelas_pararel, c.keterangan_kuliah_rutin from mata_kuliah a, ruang b, dosen d, kuliah_rutin c, jam_kuliah e, kelas_pararel f, periode_tahun g, semester h where g.id_aktif=1 and c.id_periode_tahun=g.id_periode_tahun and h.id_aktif=1 and h.id_semester=c.id_semester and a.id_mata_kuliah=c.id_mata_kuliah and b.id_ruang=c.id_ruang and c.id_jam_kuliah=e.id_jam_kuliah and c.id_dosen=d.id_dosen and c.id_kelas_pararel=f.id_kelas_pararel and e.nama_jam_kuliah = '$tmp' AND b.nama_ruang='$tmpcol' AND c.id_hari_kuliah=$hk");
while($row=mysql_fetch_assoc($query)){
//echo $tmp;
echo "".$row['keterangan_kuliah_rutin']."".$row['kode_mata_kuliah']."(".$row['nama_kelas_pararel'].") ".$row['singkatan_mata_kuliah']."(".$row['sks_dipakai'].") ".$row['inisial_dosen']; //echo $warna; $idkr=$row['id_kuliah_rutin']; $query2=mysql_query("select b.inisial_dosen as ini from mata_kuliah a, dosen b, kuliah_rutin c where c.id_kuliah_rutin='$idkr' and c.id_dosen2=b.id_dosen and c.id_dosen2!=0 group by id_kuliah_rutin"); while($row2=mysql_fetch_assoc($query2)){ echo "/".$row2['ini']; } }?> |