Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysqli = new mysqli("localhost","root","mysql","perwalian");
- if (isset($_COOKIE["NRPmhs"]))
- {
- $mysqli = new mysqli("localhost","root","mysql","perwalian");
- $strsql ="select * from periode where status = 1";
- $result = $mysqli->query($strsql);
- $row = mysqli_fetch_assoc($result);
- if ($row > 0)
- {
- ?>
- <H2>INPUT PERWALIAN</H2>
- <a>Input Perwalian<a> |
- <a href="matakuliah.php">Mata Kuliah<a> |
- <a href="index.php">Logout<a><BR>
- <?php
- $nrp = $_COOKIE['NRPmhs'];
- if (isset($_GET['delete']))
- {
- $result = $mysqli -> query("DELETE FROM mahasiswa_kelas
- WHERE kode_kelas='".$_GET['delete']."' AND nrp = $nrp;");
- if ($result > 0)
- {
- echo "Matakuliah berhasil dihapus<BR>";
- }
- }
- if (isset($_POST['submit']))
- {
- $strsql = "select * from kelas where kode_mk = '".$_POST['kodemk']."' and nama_kelas='KP ".$_POST['kp']."'";
- $result = $mysqli->query($strsql);
- $row=$result->fetch_array();
- $kodekelas = $row['kode_kelas'];
- $strsql = "select * from kelas where kode_kelas = '$kodekelas'";
- $result = $mysqli->query($strsql);
- $row=$result->fetch_array();
- $strsql2="select * from mahasiswa_kelas where kode_kelas=$kodekelas";
- $result2=$mysqli->query($strsql2);
- $jumlahmhs=0;
- while($row2 = $result2->fetch_array())
- {
- $jumlahmhs+=1;
- }
- if ($jumlahmhs<$row['kapasitas'])
- {
- $strsql = "INSERT INTO mahasiswa_kelas (nrp, kode_kelas)
- values('$nrp','$kodekelas')";
- $result = $mysqli -> query($strsql);
- if ($result > 0)
- {
- echo "Matakuliah berhasil ditambahkan";
- }
- }
- else
- {
- Echo "<H3>Kelas sudah penuh</H3><BR>";
- }
- }
- $strsql = "select * from periode where status = '1'";
- $result = $mysqli->query($strsql);
- $row=$result->fetch_array();
- $strsql2 = "select * from mahasiswa where nrp ='$nrp'";
- $result2 = $mysqli->query($strsql2);
- $infomhs=$result2->fetch_array();
- $strsql3 = "SELECT m.kode_mk
- ,m.nama
- ,k.nama_kelas
- ,m.jumlah_sks
- ,k.kode_kelas
- from matakuliah m
- INNER JOIN kelas k
- ON m.kode_mk = k.kode_mk
- INNER JOIN mahasiswa_kelas mkls
- ON k.kode_kelas = mkls.kode_kelas
- where mkls.nrp=".$infomhs['nrp'];
- $result3 = $mysqli->query($strsql3);
- $tabelmk = "<TR>";
- $jumlahsksdiambil = 0;
- while($daftarmk = $result3->fetch_array())
- {
- $jumlahsksdiambil+=$daftarmk['jumlah_sks'];
- $tabelmk = $tabelmk.'<TD>'.$daftarmk[0].'</TD>';
- $tabelmk = $tabelmk.'<TD>'.$daftarmk[1].'</TD>';
- $tabelmk = $tabelmk.'<TD>'.$daftarmk[2].'</TD>';
- $tabelmk = $tabelmk.'<TD>'.$daftarmk[3].'</TD>';
- $tabelmk = $tabelmk.'<TD> <a href ="inputperwalian.php?delete='.$daftarmk[4].'">Batal</a></TD>';
- $tabelmk = $tabelmk.'</TR>';
- }
- $sisasks=$infomhs['jatah_sks'];
- $sisasks-=$jumlahsksdiambil;
- echo"
- Periode ".$row['nama']."<BR>
- <img src='".$infomhs['foto_profil']."' alt='FOTO PROFIL' height='120' width='120'><BR>
- NRP : ".$infomhs['nrp']."<BR>
- Nama : ".$infomhs['nama']."<BR>
- SKS Maks : ".$infomhs['jatah_sks']."<BR>
- Sisa SKS : $sisasks<BR>
- <H2>TAMBAH MATA KULIAH</H2><BR>
- <FORM method='post' action='inputperwalian.php'>
- Kode MK : <INPUT type = 'text' name='kodemk' required /><BR>
- KP : <INPUT type = 'text' name='kp' required /><BR>
- <INPUT type='submit' name='submit' value='SUBMIT'/><BR>
- </FORM>
- <H2>DAFTAR MATA KULIAH YANG AKAN DIAMBIL</H2><BR>
- <table border='1' width ='500px'>
- <tr>
- <th>KODE MK</th>
- <th>NAMA MK</th>
- <th>Kelas</th>
- <th>SKS</th>
- <th>BATAL</th>
- </tr>
- $tabelmk
- </table>
- ";
- }
- else
- {
- Echo"<H2>Input perwalian belum dapat diakses saat ini</H2>";
- }
- }
- else
- {
- Echo "You're not logged in, please log in first! <a href='loginmhs.php'>Click here to login</a>";
- }
- $mysqli->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement