mastermk.php

<?php
$mysqli = new mysqli("localhost","root","mysql","perwalian");
if (isset($_COOKIE["UsernameAdmin"]))
{
?>
    <H2>Anda berada di halaman Master Matakuliah</H2>
    <a href="homeadmin.php">Beranda<a> |
    <a href="masterperiode.php">Master Periode<a> |
    Master Mata Kuliah |
    <a href="mastermhs.php">Master Mahasiswa<a> |
    <a href="masterkelas.php">Master Kelas<a> |
    <a href="laporan.php">Laporan<a> |
    <a href="loginadmin.php">Logout<a>
    <BR></BR>
<?php

 if (isset($_POST['submitcreate']))
    {
        $kodebuat = $_POST['kodecreate'];
        $namabuat = $_POST['namacreate'];
        $jumsksbuat = $_POST['jumskscreate'];
        $deskripsibuat = $_POST['deskripsicreate'];



        $strsql = "INSERT INTO matakuliah(kode_mk,nama,jumlah_sks,deskripsi,hapuskah)
                    values('$kodebuat','$namabuat','$jumsksbuat','$deskripsi','0')";
        $result = $mysqli -> query($strsql);

        if ($result > 0)
        {
            echo "matakuliah berhasil ditambahkan";
        }


    }

if (isset($_GET['delete']))
    {
        $result = $mysqli -> query("UPDATE matakuliah SET hapuskah = 1 WHERE kode_mk =".$_GET['delete']);
        if ($result > 0)
        {
            echo "Matakuliah berhasil dihapus";
        }
    }

if (isset($_GET['edit']))
    {
        echo"
            <H2> Edit Matakuliah </H2> <BR>
            <FORM method='post' action='mastermk.php'>
            <INPUT type = 'hidden' name='kodeasli' value='".$_GET['edit']."'/>";

        $strsql = "select *from matakuliah where kode_mk=".$_GET['edit'];
        $result = $$mysqli->query($strsql);
        $row = $result->fetch_array();
        $tempkode_mk ="value= '".$row['kode_mk'];
        $tempnamamk ="value= '".$row['nama'];
        $tempjumsks ="value= '".$row['jumlah_sks'];
        $tempdeskripsi ="value= '".$row['deskripsi'];

    }
    else
    {
        echo"
        <H2> Tambah Mahasiswa </H2> <BR>
        <FORM method='post' id='inputmk' action ='mastermhs.php'>";
    }



echo"

        Kode MK : <INPUT type = 'text' name = 'kode' required/>
        Nama MK : <INPUT type = 'text' name = 'nama' required/>
        Deskripsi : <textarea rows ='7' cols='50' name= 'deskripsi' form='inputmk'> </textarea>
        Jumlah SKS : <INPUT type = 'number' name = 'jumsks' required/>";
    if(isset($_GET['edit']))
    {
        echo"
        <INPUT type='submit' name='edit' value='Simpan'/>";

    }
    else
    {
        echo"
        <INPUT type='submit' name'simpan' value='Simpan'/>";
    }
echo"
    <table border='1' width ='500px'>
    <tr>
            <th>Kode MK</th>
            <th>Nama MK</th>
            <th>Edit/Hapus</th>
    </tr>";

 $strsql ="select * from kelas where hapuskah = 0";
        $result = $mysqli->query($strsql);

        while($row = $result->fetch_array())
        {
            echo "<tr>";
            echo "<td>".$row['kode']."</td>";
            echo "<td>".$row['nama']."</td>";
            echo "<td><a href='mastermk.php?edit=".$row['kode']."'>Edit</a><BR>
                <a href='mastermk.php?delete=".$row['kode']."'>Hapus</a></td>";
            echo"</tr>";
        }
}
else
{
    Echo "You're not logged in, please log in first! <a href='loginadmin.php'>Click here to login</a>";
}
$mysqli->close();
?>