<?php
session_start ();
include_once'../connect.php';
include_once'header.php';
include_once'sidebar.php';
if(isset($_SESSION['username']) && isset ($_SESSION['nama'])){
    $username = $_SESSION['username'];
    $nama = $_SESSION['nama'];

?>

    <div id="page-wrapper">
        <div class="header">
            <h2 class="page-header">
                <center> Halaman MP</center>
             </h2>
        </div>

        <div id="page-inner">
            <!--Tabel-->
            <div class = "row">
            <div class ="col-md-12">
            <button class = "btn btn-warning pull pull-right" data-toggle="modal" data-target="#tambahMp"><span class ="glyphicon glyphicon-plus-sign"></span> Tambah Data</button>
            </br>
            </br>
                <table  class = "table" id="dataSample">
                    <thead>
                        <tr>
                            <th>id mp</th>
                            <th>nama mp</th>
                        </tr>
                    </thead>
                </table>
            </div>
            </div>

            <!--Modal-->
            <div class="modal fade" tabindex="-1" role="dialog" id="tambahMp">
              <div class="modal-dialog" role="document">
                <div class="modal-content">
                  <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                    <h4 class="modal-title">Tambah Mata Pelajaran</h4>
                  </div>
                  <form class="form-horizontal" action="tambahMp.php" method="POST">
                      <div class="modal-body">
                      <!--Form-->
                          <div class="form-group">
                            <label for="idMp" class="col-sm-2 control-label">Id Mata Pelajaran</label>
                            <div class="col-sm-10">
                              <input type="text" class="form-control" id="idMp" name="idMp" placeholder="Id Mata Pelajaran">
                            </div>
                          </div>
                          <div class="form-group">
                            <label for="namaMp" class="col-sm-2 control-label">Nama Mata Pelajaran</label>
                            <div class="col-sm-10">
                              <input type="text" class="form-control" id="namaMp" name="namaMp" placeholder="Nama Mata Pelajaran">
                            </div>
                          </div>
                        <!--Form-->
                      <div class="modal-footer">
                        <button type="button" class="btn btn-danger" data-dismiss="modal">Batal</button>
                        <button type="submit" class="btn btn-warning">Tambah</button>
                      </div>
                  </form>
                </div>
              </div>
            </div>

        </div>

    </div>
    </div>
<?php
include_once 'footer.php';
}else{
    echo '<script languange="javascript">alert ("Silahkan login terlebih dahulu")</script>';
    echo '<script languange="javascript">window.location="../login.php"</script>';
}
?>

<?php
require_once '../connect.php';

//if form is submitted

if($_POST){
    $idMp = $_POST['idMp'];
    $namaMp = $_POST['namaMp'];

    $sql = "INSERT INTO mata_pelajaran(mp_id, mp_nama) VALUES ('$idMp', '$namaMp')";
    $query = $connect -> query($sql);

    if($query === TRUE){
        echo "Tambah data berhasil";
    }else{
        echo "Error";
    }

    $connect -> close();
}

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$dbname = 'kp';
$connect = mysql_connect($host, $user, $pass) or die (mysql_error());
$dbselect = mysql_select_db($dbname);
?>

$connect = new mysqli($host, $user, $pass, $dbname);