Untitled

<!DOCTYPE html>
<html>
<head>
  <title>AL-WASLIYAH</title>
   <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <link href="css/bootstrap.min.css" rel="stylesheet">
  <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr"
    crossorigin="anonymous">
    <link rel="shortcut icon" href="img/logo2.png">
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE-edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" type="text/css" href="css/lightbox.min.css">
    <!-- Bootstrap CSS -->
</head><body>
<!--baner-->
<div class="container-fluid" style="background: rgba(10,50,10,90.10);">
  <div class="row" >
    <div class="col-md-3">
      <div id="logo" style="margin-bottom:35px; margin-top:15px; margin-right:30px; margin-left:100px;">
        <img src="img/logo2.png">
      </div>
    </div>
    <div class="head-left col-md-8" style="margin-top:50px; margin-left:10px;">
      <div class="text-left" style="color:#FFFFFF;"><h4>SEKOLAH MENENGAH ATAS</h4></div>
        <div class="text-left" style="color:#FFFFFF;"><h1><strong>ALWASLIYAH TANJUNG MORAWA </strong></h1>
          <div class="text-left" style="color:#FFFFFF;"><small>JALAN BANDAR LABUHAN DAGANG KARAWANG TANJUNG MORAWA</small>
          </div>
        </div>
    </div>
  </div>
</div>
<!--tutup-->
<!--bodi 1-->
<div class="container">
</div>
<div class="head-left col-md-12" style="background:#8FBC8F">
<div class="head-right col-md-2 col-md-offset-9" >
<?php
  session_start();
  // cek apakah yang mengakses halaman ini sudah login
  if($_SESSION['level']==""){
    header("location:login.php?pesan=gagal");
  }
  ?>
  <b><p>Nama : <?php echo $_SESSION['username']; ?></p></b>
  <b><p>Kelas : X </p></b>

</div class="" style="background:#8FBC8F">
<div class="head-left col-md-1">
<div>
<div class="dropdown" style="margin-top:10px;">
  <button class="btn btn-success dropdown-toggle" id="dropdownMenu1" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true" >
    <span class="caret"></span>
  </button>
  <ul class="dropdown-menu" aria-labelledby="dropdownMenu1">
    <li><a href="login.php">Log Out</a></li>
  </ul>
</div>
</div>
</div>
</div>
<!--tutup-->
<!--overview-->
<div class="head-left col-md-8 col-md-offset-2">
  <br>
<div class="panel panel-success">
           <ul class="nav nav-tabs">
  <li role="presentation" class="active"  ><a href="#">OverView</a></li>
  <li role="presentation" style="margin-left:500px; bacground:#8FBC8F"><a href="updatepass.php">Ganti Password</a></li>
</ul>
<div class="panel-success">
  <table class="table table-striped">
    <div class="col-md-8 col-md-offset-1">
      <?php
        include 'koneksi.php';
        $username = $_SESSION['username'];
        $sql = mysqli_query($koneksi, "SELECT * from login WHERE username = '" . $username . "' LIMIT 1");
        $kelas="";
        $angkatan="";
        $nip="";
        foreach ($sql as $row){
          echo "
            <tr>
            <td><h3 >nama lengkap = ".$row['username']."</h3></td>
            <tr/><tr>
            <td><h3>kelas =".$row['kelas']."</h3></td>
            </tr><tr>
            <td><h3>angkatan =".$row['angkatan']."</h3></td>
            </tr><tr>
            <td><h3>nip =".$row['nip']."</h3></td>
            </tr>";
        }
      ?>
    </div>
  </table>
</div>
<div class="col-md-12">
  <form action="" method="POST">
    <button type="submit" name="submit" class="btn btn-primary">Nilai</button>
  </form>
</div>
<div class="panel-success">
  <table class="table table-striped">
    <thead>
      <tr>


      </tr>
    </thead>
    <tbody>
    <?php
      $nama_lengkap = $_SESSION['username'];
      if (isset($_POST['submit'])) {

$sql = mysqli_query($koneksi, "SELECT * from dataerapor WHERE nama_lengkap LIKE '%" . $nama_lengkap . "%'");
        foreach ($sql as $row){
          echo "
              <tr>
              <th>Kelas<td><h3>".$row['kls']."</h3></td></th>
              <th>Agama<td><h3>".$row['agama']."</h3></td></th>
              <th>Pendidikan Kewarganegaraan<td><h3>".$row['pkn']."</h3></td></th></tr><tr>
              <th>Bahasa Indonesia<td><h3>".$row['b_ind']."</h3></td></th>
              <th>Bahasa Inggris<td><h3>".$row['b_ing']."</h3></td></th>
              <th>Matematika<td><h3>".$row['mm']."</h3></td></th></tr><tr>
              <th>Fisika<td><h3>".$row['fis']."</h3></td></th>
              <th>Biologi<td><h3>".$row['bio']."</h3></td> </th>
              <th>Kimia <td><h3>".$row['kim']."</h3></td></th></tr><tr>
              <th>Sejarah <td><h3>".$row['sej']."</h3></td></th>
              <th>Geografi<td><h3>".$row['geo']."</h3></td></th>
              <th>Ekonomi<td><h3>".$row['eko']."</h3></td></th></tr><tr>
              <th>Sosiologi<td><h3>".$row['sos']."</h3></td></th>
              <th>Pendidikan Jasmani dan Rohani<td><h3>".$row['penjas']."</h3></td></th>
              <th>Teknologi dan Informasi<td><h3>".$row['ti']."</h3></td></th></tr><tr>
              <th>Bahasa Arab<td><h3>".$row['b_arab']."</h3></td></th>
              <th>Aksara Arab Melayu<td><h3>".$row['aam']."</h3></td></th>
              <th>Sikap<td><h3>".$row['sikap']."</h3></td></th>

              </tr>";

            }
        }
      ?>
    </tbody>
  </table>
</div>
        </div>
      </div>
    </div>
</div>
</div>
<!--tutup-->
<!--link boostrap-->
   <script src="js/fontawesome-all.js" rel="stylesheet"></script>
  <script src="js/jquery-3.2.1.min.js"></script>
  <script src="js/bootstrap.min.js"></script>
  <script src="js/script.js"></script>
</body>
</html>