Krs

<?php
// http://phpbego.wordpress.com

// Membuat class KRS
class Krs {

    private $db_connection = null;

    public function __construct($koneksi) {
        $this->db_connection = $koneksi;
    }

    // Method tambah data / CREATE
    function createKrs($kode, $nama, $sks, $dosen) {
        $query = $this->db_connection->query("INSERT INTO krs VALUES ('$kode', '$nama', '$sks', '$dosen')") or die (mysqli_error());

        if ($query) {
            header ('location: index.php');
        } else {
            echo "Data gagal disimpan ke database !";
        }
    }

    // Method tampil data / READ
    function readKrs() {
        $query = $this->db_connection->query("SELECT * FROM krs ORDER BY kode");
        while ($row = mysqli_fetch_array($query)) {
            $data[] = $row;
        }
        return $data;
    }

    // method edit data krs
    function editBacaKrs($field, $kode) {
        $query = $this->db_connection->query("SELECT * FROM krs WHERE kode = '$kode'");
        $data = mysqli_fetch_array($query);
        if ($field == 'kode') {
        return $data['kode'];
        }
        if ($field == 'nama') {
        return $data['nama'];
        }
        if ($field == 'sks') {
        return $data['sks'];
        }
        if ($field == 'dosen') {
        return $data['dosen'];
        }
    }

    // method proses update / UPDATE
    function updateKrs($kode, $nama, $sks, $dosen) {
        $query = $this->db_connection->query("UPDATE krs SET nama='$nama', sks ='$sks', dosen='$dosen' WHERE kode='$kode'");
        header ('location: index.php');
    }

    // method hapus data / DELETE
    function deleteKrs($kode) {
        $query = $this->db_connection->query("DELETE FROM krs WHERE kode='$kode'");
        header ('location: index.php');
    }

}