<?php
class core {
    public function read(){
        include "config.php";
        $query = "SELECT * FROM mahasiswa";
        $data = $mysqli->query($query);
        if($data->num_rows>0){
            while($row = $data->fetch_array()){
                $tampil[] = $row;
            }
                return $tampil;
        }
    }
    public function create($nim,$nama){
        include "config.php";
        $query = "INSERT INTO mahasiswa VALUES ('','$nim','$nama')";
        $mysqli->query($query);
    }
    public function delete($id){
        include "config.php";
        $query = "DELETE FROM mahasiswa WHERE id = $id";
        $mysqli->query($query);
    }
    public function readUpdate($id){
        include "config.php";
        $query = "SELECT * FROM mahasiswa WHERE id = $id";
        $data = $mysqli->query($query);
        if($data->num_rows>0){
            while($row = $data->fetch_array()){
                $tampil[] = $row;
            }
                return $tampil;
        }
    }
    public function update($id,$nama,$nim){
        include "config.php";
        $query = "UPDATE mahasiswa SET nama='$nama', nim='$nim' WHERE id = $id";
        $data = $mysqli->query($query);
    }
}

 ?>