/sysfo/skjdwlujiansk.php
PHP | 663 lines | 621 code | 35 blank | 7 comment | 37 complexity | 5b92532fafdc365b2ca4ac6e37216c6e MD5 | raw file
- <?php
- $a=$_SESSION['level'];
- $b=$_GET['syxec'];
- $c=$_SESSION ['uid'];
-
- echo"level = $a <br>";
-
-
-
- //deskripsi kajur
- $que_jur ="SELECT description FROM kajur WHERE id='$c'";
- $jal_jur = mysql_query($que_jur);
- $hasil = mysql_fetch_array($jal_jur);
-
- $potong = substr($hasil[0],6,30);
-
-
- //kode jurusan
- $per_id_jur = "SELECT kode FROM jurusan WHERE nama_indonesia='$potong'";
- $jalankan = mysql_query($per_id_jur);
- $hasil_id_jur = mysql_fetch_array($jalankan);
-
-
- //kode dosen
- $que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$c'";
- $jal_dosen = mysql_query($que_dosen);
- $hasil_dosen = mysql_fetch_array($jal_dosen);
-
- //kode mahasiswa
- $que_mhs ="SELECT kodejurusan FROM mhsw WHERE id='$c'";
- $jal_mhs = mysql_query($que_mhs);
- $hasil_mhs = mysql_fetch_array($jal_mhs);
-
-
- //nim mhs
- $per_sel_mah = "SELECT nim FROM mhsw WHERE id='$c'";
- $jalan_sel_mah = mysql_query($per_sel_mah);
- $hasil_sel_mah = mysql_fetch_array($jalan_sel_mah);
-
- //kode karyawan jurusan
- $que_karjur ="SELECT Kode FROM karyawan_jurusan WHERE ID='$c'";
- $jal_karjur = mysql_query($que_karjur);
- $hasil_karjur = mysql_fetch_array($jal_karjur);
- echo"kode jurusan karyawan jurusan : $hasil_karjur[0]<br>";
-
-
- switch($_GET['aksi']){
- default:
- if($a=='Kajur'){
- echo "
- <form method='post' name='formdatajadwal' action=''>
- <table border='1' align='center'>
- <tr>
- <td colspan='13' align='left'>
- <input type='button' onclick=window.location.href='?syxec=$b&aksi=tambah' name='tambah' value='Tambah'/>
- </td>
- </tr>
- <tr>
- <th>ID</th>
- <th>NIM</th>
- <th>Nama</th>
- <th>Judul Skripsi</th>
- <th>Hari</th>
- <th>Tanggal</th>
- <th>Jam</th>
- <th>Ruang</th>
- <th>Dosen Penguji 1</th>
- <th>Dosen Penguji 2</th>
- <th>Dosen Penguji 3</th>
- <th>Dosen Penguji 4</th>
- <th>Aksi</th>
- </tr>
- ";
- $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
- FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
- WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_id_jur[0]'
- ORDER BY d.id_jadwal ASC";
- $jalan = mysql_query($perintah);
- while($hasil=mysql_fetch_array($jalan)){
- echo"
- <tr>
- <td>$hasil[0]</td>
- <td>$hasil[1]</td>
- <td>$hasil[2]</td>
- <td>$hasil[3]</td>
- <td>$hasil[4]</td>
- <td>$hasil[5]</td>
- <td>$hasil[6]</td>
- <td>$hasil[7]</td>
- <td>$hasil[8]</td>
- <td>$hasil[9]</td>
- <td>$hasil[10]</td>
- <td>$hasil[11]</td>
- <td><a href='?syxec=$b&aksi=ubah&id=$hasil[0]'>Edit</a> | <a href='?syxec=$b&aksi=hapus&idxx=$hasil[0]'>Hapus</a></td>
- <tr>
- ";
- }
-
- echo"
- </table>
- </form>
- ";
- }
- else if($a=='Dosen'){
- echo "
- <form method='post' name='formdatajadwal' action=''>
- <table border='1' align='center'>
- <tr>
- <th>ID</th>
- <th>NIM</th>
- <th>Nama</th>
- <th>Judul Skripsi</th>
- <th>Hari</th>
- <th>Tanggal</th>
- <th>Jam</th>
- <th>Ruang</th>
- <th>Dosen Penguji 1</th>
- <th>Dosen Penguji 2</th>
- <th>Dosen Penguji 3</th>
- <th>Dosen Penguji 4</th>
-
- </tr>
- ";
- $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
- FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
- WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_dosen[0]'
- ORDER BY d.id_jadwal ASC";
- $jalan = mysql_query($perintah);
- while($hasil=mysql_fetch_array($jalan)){
- echo"
- <tr>
- <td>$hasil[0]</td>
- <td>$hasil[1]</td>
- <td>$hasil[2]</td>
- <td>$hasil[3]</td>
- <td>$hasil[4]</td>
- <td>$hasil[5]</td>
- <td>$hasil[6]</td>
- <td>$hasil[7]</td>
- <td>$hasil[8]</td>
- <td>$hasil[9]</td>
- <td>$hasil[10]</td>
- <td>$hasil[11]</td>
-
- <tr>
- ";
- }
-
- echo"
- </table>
- </form>
- ";
- }
-
- else if($a=='Mahasiswa'){
- echo "
- <form method='post' name='formdatajadwal' action=''>
- <table border='1' align='center'>
- <tr>
- <th>ID</th>
- <th>NIM</th>
- <th>Nama</th>
- <th>Judul Skripsi</th>
- <th>Hari</th>
- <th>Tanggal</th>
- <th>Jam</th>
- <th>Ruang</th>
- <th>Dosen Penguji 1</th>
- <th>Dosen Penguji 2</th>
- <th>Dosen Penguji 3</th>
- <th>Dosen Penguji 4</th>
-
- </tr>
- ";
- $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
- FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
- WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_mhs[0]'
- ORDER BY d.id_jadwal ASC";
- $jalan = mysql_query($perintah);
- while($hasil=mysql_fetch_array($jalan)){
- echo"
- <tr>
- <td>$hasil[0]</td>
- <td>$hasil[1]</td>
- <td>$hasil[2]</td>
- <td>$hasil[3]</td>
- <td>$hasil[4]</td>
- <td>$hasil[5]</td>
- <td>$hasil[6]</td>
- <td>$hasil[7]</td>
- <td>$hasil[8]</td>
- <td>$hasil[9]</td>
- <td>$hasil[10]</td>
- <td>$hasil[11]</td>
-
- <tr>
- ";
- }
-
- echo"
- </table>
- </form>
- ";
- }
-
- else if($a=='Karyawan Jurusan'){
- echo "
- <form method='post' name='formdatajadwal' action=''>
- <table border='1' align='center'>
- <tr>
- <th>ID</th>
- <th>NIM</th>
- <th>Nama</th>
- <th>Judul Skripsi</th>
- <th>Hari</th>
- <th>Tanggal</th>
- <th>Jam</th>
- <th>Ruang</th>
- <th>Dosen Penguji 1</th>
- <th>Dosen Penguji 2</th>
- <th>Dosen Penguji 3</th>
- <th>Dosen Penguji 4</th>
-
- </tr>
- ";
- $perintah = "SELECT d.id_jadwal, d.nim, a.Name, b.judul, d.hari, d.tanggal, d.jam, c.Nama, (SELECT Name FROM dosen WHERE ID=d.penguji1) as Penguji1, (SELECT Name FROM dosen WHERE ID=d.penguji2) as Penguji2, (SELECT Name FROM dosen WHERE ID=d.penguji3) as Penguji3, (SELECT Name FROM dosen WHERE ID=d.penguji4) as Penguji4
- FROM mhsw a, skr_peserta b, ruang c , skr_penjadwalan d
- WHERE a.NIM=d.nim AND b.nim=d.nim AND c.Kode=d.id_ruang AND a.KodeJurusan='$hasil_karjur[0]'
- ORDER BY d.id_jadwal ASC";
- $jalan = mysql_query($perintah);
- while($hasil=mysql_fetch_array($jalan)){
- echo"
- <tr>
- <td>$hasil[0]</td>
- <td>$hasil[1]</td>
- <td>$hasil[2]</td>
- <td>$hasil[3]</td>
- <td>$hasil[4]</td>
- <td>$hasil[5]</td>
- <td>$hasil[6]</td>
- <td>$hasil[7]</td>
- <td>$hasil[8]</td>
- <td>$hasil[9]</td>
- <td>$hasil[10]</td>
- <td>$hasil[11]</td>
-
- <tr>
- ";
- }
-
- echo"
- </table>
- </form>
- ";
- }
- break;
-
- case('tambah'):
- echo "
- <form method='post' name='formskjdwlujiansk' action='?syxec=$b&aksi=insert'>
- <table align='center'>
- <tr>
- <td>
- <input type='hidden' name='id_jadwal' value=''/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Nama</label>
- </td>
- <td>
- :
- <select name='nim'>
- <option value='0'>- Pilih Nama -</option>";
- $perintah_nama = "SELECT a.nim,b.Name FROM skr_peserta a,mhsw b WHERE a.nim=b.NIM AND b.KodeJurusan='$hasil_id_jur[0]'";
- $jalan_nama = mysql_query($perintah_nama);
- while($hasil_nama = mysql_fetch_array($jalan_nama)){
- echo "<option name='nim' value=$hasil_nama[0]>$hasil_nama[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Hari</label>
- </td>
- <td>
- :
- <select name='hari'>
- <option value='0' selected>- Pilih Hari -</option>
- <option name='hari' value='senin'>senin</option>
- <option name='hari' value='selasa'>selasa</option>
- <option name='hari' value='rabu'>rabu</option>
- <option name='hari' value='kamis'>kamis</option>
- <option name='hari' value='jumat'>jumat</option>
- <option name='hari' value='sabtu'>sabtu</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Tanggal</label>
- </td>
- <td>
- : <input type='text' name='tanggal'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Jam</label>
- </td>
- <td>
- : <input type='text' name='jam'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Ruang</label>
- </td>
- <td>
- :
- <select name='id_ruang'>
- <option value='0' selected>- Pilih Ruang -</option>";
- $perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 1</label>
- </td>
- <td>
- :
- <select name='dosen_penguji1'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 2</label>
- </td>
- <td>
- :
- <select name='dosen_penguji2'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 3</label>
- </td>
- <td>
- :
- <select name='dosen_penguji3'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option name='dosen_penguji3' value=$hasil[0]>$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 4</label>
- </td>
- <td>
- :
- <select name='dosen_penguji4'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- echo "<option name='dosen_penguji4' value=$hasil[0]>$hasil[1]</option>";
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td colspan='2' align='center'>
- <input type='reset' name='submit2' value='Reset' />
- <input type='submit' name='submit' value='Simpan' />
- </td>
- </tr>
- </table>
- </form>
- ";
- break;
-
- case('insert'):
- $id_jadwal = $_POST['id_jadwal'];
- $nim = $_POST['nim'];
- $id_ruang = $_POST['id_ruang'];
- $hari = $_POST['hari'];
- $tanggal = $_POST['tanggal'];
- $jam = $_POST['jam'];
- $dp1 = $_POST['dosen_penguji1'];
- $dp2 = $_POST['dosen_penguji2'];
- $dp3 = $_POST['dosen_penguji3'];
- $dp4 = $_POST['dosen_penguji4'];
-
- $Q=mysql_query("SELECT nim FROM skr_penjadwalan");
- $nC = 0;
- while($R=mysql_fetch_array($Q)){
- if($R[0]==$nim){
- $nC = 1;
- break;
- }
- }
- $Q=mysql_query("SELECT hari, tanggal, jam FROM skr_penjadwalan");
- $iC = 0;
- while($R=mysql_fetch_array($Q)){
- if($R[0]==$hari&&$R[1]==$tanggal&&$R[2]==$jam){
- $iC = 1;
- break;
- }
- }
-
- if($iC != 1 && $nC != 1 && $dp1 != $dp2 && $dp1 != $dp3 && $dp1 != $dp4 && $dp2 != $dp3 && $dp2 != $dp4 && $dp3 != $dp4){
- mysql_query("INSERT INTO skr_penjadwalan VALUES ('$id_jadwal','$nim','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$dp4')");
- $q = mysql_query("SELECT id_jadwal FROM skr_penjadwalan WHERE nim=$nim");
- $h = mysql_fetch_array($q);
- mysql_query("INSERT INTO skr_beritaacara VALUES ('null','$h[id_jadwal]','$nim',0,0,0,0,0,'null')");
- echo"<center>Data berhasil disimpan<br>Kembali ke <big><a href='?syxec=skjdwlujiansk'><blink>List Data</blink></a></big></center>";
- }
- else{
- echo("<center>Jadwal <big>Bentrok</big> atau <big>Dosen Penguji ada yang sama</big><br>Kembali ke <big><a href='?syxec=skjdwlujiansk&aksi=tambah'><blink>Form Tambah Jadwal</blink></a></big></center>");
- }
- break;
-
- case('edit'):
- $idxx = $_GET['idxx'];
- $nim = $_POST['nim'];
- $id_ruang = $_POST['id_ruang'];
- $hari = $_POST['hari'];
- $tanggal = $_POST['tanggal'];
- $jam = $_POST['jam'];
- $dp1 = $_POST['dosen_penguji1'];
- $dp2 = $_POST['dosen_penguji2'];
- $dp3 = $_POST['dosen_penguji3'];
- $dp4 = $_POST['dosen_penguji4'];
- //echo"'$nim','$id_ruang','$hari','$tanggal','$jam','$dp1','$dp2','$dp3','$dp4')";
- $perintah = "UPDATE skr_penjadwalan SET id_ruang='$id_ruang',hari='$hari',tanggal='$tanggal',jam='$jam',penguji1='$dp1',penguji2='$dp2',penguji3='$dp3',penguji4='$dp4' WHERE id_jadwal='$idxx'";
- mysql_query($perintah);
- echo"<center>Data berhasil diubah<br>Kembali ke <big><a href='?syxec=skjdwlujiansk'><blink>List Data</blink></a></big></center>";
- break;
- case "ubah";
- $idxx=$_GET['id'];
- echo "
- <form method='post' name='formskjdwlujiansk' action='?syxec=$b&aksi=edit&idxx=$idxx'>
- <table align='center'>
- <tr>
- <td>
- <input type='hidden' name='id_jadwal' value=''/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Nama</label>
- </td>
- <td>
- ";
- $query = "SELECT a.Name FROM mhsw a, skr_penjadwalan b WHERE a.NIM=b.nim AND b.id_jadwal=$idxx";
- $result=mysql_query($query);
- $hasil=mysql_fetch_array($result);
- echo(": ".$hasil[0]);
-
- echo "</td>
- </tr>
- <tr>
- <td>
- <label>Hari</label>
- </td>
- <td>
- :
- ";
-
- $query = "SELECT hari FROM skr_penjadwalan WHERE id_jadwal=$idxx";
- $result=mysql_query($query);
- $hasil=mysql_fetch_array($result);
- echo"
- <select name='hari'>
- <option value='0'"; if($hasil[0]==null){echo(" selected=true ");} echo">- Pilih Hari -</option>
- <option name='hari' value='senin'"; if($hasil[0]=="senin"){echo(" selected=true ");} echo">senin</option>
- <option name='hari' value='selasa'"; if($hasil[0]=="selasa"){echo(" selected=true ");} echo">selasa</option>
- <option name='hari' value='rabu'"; if($hasil[0]=="rabu"){echo(" selected=true ");} echo">rabu</option>
- <option name='hari' value='kamis'"; if($hasil[0]=="kamis"){echo(" selected=true ");} echo">kamis</option>
- <option name='hari' value='jumat'"; if($hasil[0]=="jumat"){echo(" selected=true ");} echo">jumat</option>
- <option name='hari' value='sabtu'"; if($hasil[0]=="sabtu"){echo(" selected=true ");} echo">sabtu</option>
- </select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Tanggal</label>
- </td>
- <td>
- ";
- $query = "SELECT tanggal, jam FROM skr_penjadwalan WHERE id_jadwal=$idxx";
- $result=mysql_query($query);
- $hasil=mysql_fetch_array($result);
- echo"
- : <input type='text' name='tanggal' value='$hasil[0]'/>
- </td>
- </tr>
- <tr>
- <td>
- <label>Jam</label>
- </td>
- <td>
- : <input type='text' name='jam' value='$hasil[1]' />
- </td>
- </tr>
- <tr>
- <td>
- <label>Ruang</label>
- </td>
- <td>
- :
- <select name='id_ruang'>
- <option value='0' selected>- Pilih Ruang -</option>";
- $perintah = "SELECT Kode,Nama FROM ruang ORDER BY Kode";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- $query=mysql_query("SELECT id_ruang FROM skr_penjadwalan WHERE id_jadwal=$idxx");
- $shadow=mysql_fetch_array($query);
- if($shadow[0]==$hasil[0]){
- echo "<option name='id_ruang' value=$hasil[0] selected=true>$hasil[1]</option>";
- }
- else{
- echo "<option name='id_ruang' value=$hasil[0]>$hasil[1]</option>";
- }
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 1</label>
- </td>
- <td>
- :
- <select name='dosen_penguji1'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- $query=mysql_query("SELECT penguji1 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
- $shadow=mysql_fetch_array($query);
- if($shadow[0]==$hasil[0]){
- echo "<option name='dosen_penguji1' value=$hasil[0] selected=true>$hasil[1]</option>";
- }
- else{
- echo "<option name='dosen_penguji1' value=$hasil[0]>$hasil[1]</option>";
- }
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 2</label>
- </td>
- <td>
- :
- <select name='dosen_penguji2'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- $query=mysql_query("SELECT penguji2 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
- $shadow=mysql_fetch_array($query);
- if($shadow[0]==$hasil[0]){
- echo "<option name='dosen_penguji2' value=$hasil[0] selected=true>$hasil[1]</option>";
- }
- else{
- echo "<option name='dosen_penguji2' value=$hasil[0]>$hasil[1]</option>";
- }
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 3</label>
- </td>
- <td>
- :
- <select name='dosen_penguji3'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- $query=mysql_query("SELECT penguji3 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
- $shadow=mysql_fetch_array($query);
- if($shadow[0]==$hasil[0]){
- echo "<option name='dosen_penguji3' value=$hasil[0] selected=true>$hasil[1]</option>";
- }
- else{
- echo "<option name='dosen_penguji3' value=$hasil[0]>$hasil[1]</option>";
- }
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td>
- <label>Dosen Penguji 4</label>
- </td>
- <td>
- :
- <select name='dosen_penguji4'>
- <option value='0' selected>- Pilih Dosen Penguji -</option>";
- $perintah = "SELECT ID,Name FROM dosen WHERE kodejurusan='$hasil_id_jur[0]' ORDER BY ID";
- $jalan = mysql_query($perintah);
- while($hasil = mysql_fetch_array($jalan)){
- $query=mysql_query("SELECT penguji4 FROM skr_penjadwalan WHERE id_jadwal=$idxx");
- $shadow=mysql_fetch_array($query);
- if($shadow[0]==$hasil[0]){
- echo "<option name='dosen_penguji4' value=$hasil[0] selected=true>$hasil[1]</option>";
- }
- else{
- echo "<option name='dosen_penguji4' value=$hasil[0]>$hasil[1]</option>";
- }
- }
- echo "</select>
- </td>
- </tr>
- <tr>
- <td colspan='2' align='center'>
- <input type='submit' name='submit' value='Ubah' />
- </td>
- </tr>
- </table>
- </form>
- ";
-
- break;
- case('hapus'):
- $idxx = $_GET['idxx'];
- mysql_query("DELETE FROM skr_penjadwalan WHERE id_jadwal = '$idxx'");
- mysql_query("DELETE FROM skr_beritaacara WHERE id_jadwal = '$idxx'");
- echo"<center>Data berhasil dihapus<br>Kembali ke <big><a href='?syxec=skjdwlujiansk'><blink>List Data</blink></a></big></center>";
- break;
- }
- ?>