<?php
/*error_reporting(0);
$baglan=@mysql_connect("localhost","root","");
if(!$baglan) die("mySQL bağlantı Hatası");
mysql_select_db("panel",$baglan) or die("Veritabanı bağlantı hatası");
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8_general_ci");
*/
ob_start();
session_start();
 include("baglan.php");
if(!isset($_SESSION["login"])){
    header("Location:giris.html");
}
else {
?>

<!DOCTYPE html>
<!--
This is a starter template page. Use this page to start your new project from
scratch. This page gets rid of all links and provides the needed markup only.
-->
<html>
<head>
<style type="text/css">
.hepsi{ width:900px; height:700px; margin:10px auto; background:#666}
.ust{ width:890px; height:30px; background:#900; float:left; font:bold 18px Tahoma, Geneva, sans-serif; color:#FFF; padding:10px 0 10px 10px}
.sol{ width:200px; height:650px; background:#000; float:left; opacity:0.5}
.ad{ width:190px; height:20px; float:left; margin:20px 0 0 10px; font:12px Tahoma, Geneva, sans-serif; color:#CCC;; text-decoration:none }
.ad a{ font:12px Tahoma, Geneva, sans-serif; color:#CCC;; text-decoration:none}
.sag{ width:600px; height:650; float:left}
table{
	margin: 20px 0 0 20px;
	font: 15px Tahoma, Geneva, sans-serif;
	
	/* [disabled]color:#999; */
}
td a{font:15px Tahoma, Geneva, sans-serif; color:#999; }
#arka{ background:#F5F5F5; text-align:center; margin:20px auto; opacity:0.9; border-radius:10px; background:#FFf }
#ad{ font:bold 18px Tahoma, Geneva, sans-serif; color:#036}
.anaokul{ width:500px; height:250px; background:#FFf; float:left; margin:20px 0 0 10px; border:1px dashed #ccc; border-radius:10px}
.ilkokul{ width:500px; height:250px; background:#fff; float:left; margin:20px 0 0 10px; border:1px dashed #CCC;border-radius:10px}
.lise{ width:500px; height:250px; background:#fff; float:left; margin:20px 0 0 10px; border:1px dashed #CCC;border-radius:10px}
.ortaokul{ width:500px; height:250px; background:#fff; float:left; margin:20px 0 0 10px; border:1px dashed #CCC;border-radius:10px}

</style>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Yönetim Paneli</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <!-- AdminLTE Skins. We have chosen the skin-blue for this starter
        page. However, you can choose any other skin. Make sure you
        apply the skin class to the body tag so the changes take effect. -->
  <link rel="stylesheet" href="dist/css/skins/skin-blue.min.css">

  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  <!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->

  <!-- Google Font -->
  <link rel="stylesheet"
        href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
</head>
<!--
BODY TAG OPTIONS:
=================
Apply one or more of the following classes to get the
desired effect
|---------------------------------------------------------|
| SKINS         | skin-blue                               |
|               | skin-black                              |
|               | skin-purple                             |
|               | skin-yellow                             |
|               | skin-red                                |
|               | skin-green                              |
|---------------------------------------------------------|
|LAYOUT OPTIONS | fixed                                   |
|               | layout-boxed                            |
|               | layout-top-nav                          |
|               | sidebar-collapse                        |
|               | sidebar-mini                            |
|---------------------------------------------------------|
-->
<body class="hold-transition skin-blue sidebar-mini">
<?php 
 /*
error_reporting(0);
$baglan=@mysql_connect("localhost","root","");
if(!$baglan) die("mySQL bağlantı Hatası");
mysql_select_db("panel",$baglan) or die("Veritabanı bağlantı hatası");
*/


	?>
<div class="wrapper">

  <!-- Main Header -->
  <header class="main-header">

    <!-- Logo -->
    <a href="starter.php" class="logo">
      <!-- mini logo for sidebar mini 50x50 pixels -->
      <span class="logo-mini"><b></b></span>
      <!-- logo for regular state and mobile devices -->
      <span class="logo-lg"><b>Yönetim</b>Paneli</span>
    </a>

    <!-- Header Navbar -->
    <nav class="navbar navbar-static-top" role="navigation">
      <!-- Sidebar toggle button-->
      <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">
        <span class="sr-only">Toggle navigation</span>
      </a>
      <!-- Navbar Right Menu -->
      <div class="navbar-custom-menu">
        <ul class="nav navbar-nav">
          <!-- Messages: style can be found in dropdown.less-->
          <li class="dropdown messages-menu">
            <!-- Menu toggle button -->
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              
            </a>
            <ul class="dropdown-menu">
              
              <li>
                <!-- inner menu: contains the messages -->
                <ul class="menu">
                  <li><!-- start message -->
                    <a href="#">
                      <div class="pull-left">
                        <!-- User Image -->
                        <img src="dist/img/avatar5.png" class="img-circle" alt="User Image">
                      </div>
                      <!-- Message title and timestamp -->
                      
                      <!-- The message -->
                     
                    </a>
                  </li>
                  <!-- end message -->
                </ul>
                <!-- /.menu -->
              </li>
              
            </ul>
          </li>
          <!-- /.messages-menu -->

          <!-- Notifications Menu -->
          <li class="dropdown notifications-menu">
            <!-- Menu toggle button -->
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
             
            </a>
            <ul class="dropdown-menu">
              
              <li>
                <!-- Inner Menu: contains the notifications -->
                <ul class="menu">
                  <li><!-- start notification -->
                    <a href="#">
                      
                    </a>
                  </li>
                  <!-- end notification -->
                </ul>
              </li>
             
            </ul>
          </li>
          <!-- Tasks Menu -->
          <li class="dropdown tasks-menu">
            <!-- Menu Toggle Button -->
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              
              
            </a>
            <ul class="dropdown-menu">
             
                <!-- Inner menu: contains the tasks -->
                <ul class="menu">
                  <li><!-- Task item -->
                    <a href="#">
                      <!-- Task title and progress text -->
                      
                      <!-- The progress bar -->
                      <div class="progress xs">
                        <!-- Change the css width attribute to simulate progress -->
                        <div class="progress-bar progress-bar-aqua" style="width: 20%" role="progressbar"
                             aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                          <span class="sr-only">20% Complete</span>
                        </div>
                      </div>
                    </a>
                  </li>
                  <!-- end task item -->
                </ul>
              </li>
              <li class="footer">
                <a href="#"></a>
              </li>
            </ul>
          </li>
          <!-- User Account Menu -->
          <li class="dropdown user user-menu">
            <!-- Menu Toggle Button -->
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              <!-- The user image in the navbar-->
              <img src="dist/img/avatar5.png" class="user-image" alt="User Image">
              <!-- hidden-xs hides the username on small devices so only the image appears. -->
              <span class="hidden-xs"><?php echo $_SESSION["ad"]; ?></span>
            </a>
            <ul class="dropdown-menu">
              <!-- The user image in the menu -->
              <li class="user-header">
                <img src="dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">

                <p>
                  
                  <small></small>
                </p>
              </li>
              <!-- Menu Body -->
              <li class="user-body">
                <div class="row">
                  <div class="col-xs-4 text-center">
                    <a href="#"></a>
                  </div>
                  <div class="col-xs-4 text-center">
                    <a href="#"></a>
                  </div>
                  <div class="col-xs-4 text-center">
                    <a href="#"></a>
                  </div>
                </div>
                <!-- /.row -->
              </li>
              <!-- Menu Footer-->
              <li class="user-footer">
                <div class="pull-left">
                  <a href="#" class="btn btn-default btn-flat">Profile</a>
                </div>
                <div class="pull-right">
                  <a href="#" class="btn btn-default btn-flat">Sign out</a>
                </div>
              </li>
            </ul>
          </li>
          <!-- Control Sidebar Toggle Button -->
          <li>
            <a href="#" data-toggle="control-sidebar"><i class="fa fa-gears"></i></a>
          </li>
        </ul>
      </div>
    </nav>
  </header>
  <!-- Left side column. contains the logo and sidebar -->
  <aside class="main-sidebar">

    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">

      <!-- Sidebar user panel (optional) -->
      <div class="user-panel">
        <div class="pull-left image">
          <img src="dist/img/avatar5.png" class="img-circle" alt="User Image">
        </div>
        <div class="pull-left info">
          <p><?php echo $_SESSION["ad"]; ?></p>
          <!-- Status -->
          <a href="#"><i class="fa fa-circle text-success"></i> Online</a>
        </div>
      </div>

      <!-- search form (Optional) -->
      <form action="#" method="get" class="sidebar-form">
        <div class="input-group">
          <input type="text" name="q" class="form-control" placeholder="Search...">
          <span class="input-group-btn">
              <button type="submit" name="search" id="search-btn" class="btn btn-flat"><i class="fa fa-search"></i>
              </button>
            </span>
        </div>
      </form>
      <!-- /.search form -->

      <!-- Sidebar Menu -->
      <ul class="sidebar-menu" data-widget="tree">
        <li class="header">Menü</li>
        <!-- Optionally, you can add icons to the links -->
        <li class="active"><a href="#"><i class="fa fa-link"></i> <span>Öğrenci Listele</span></a></li>
        <li><a href="form2a.php"><i class="fa fa-link"></i> <span>Yeni Kayıt</span></a></li>
        <li><a href="giris.html"><i class="fa fa-link"></i> <span>Çıkış Yap</span></a></li>
              </span>
          </a>
          
        </li>
      </ul>
      <!-- /.sidebar-menu -->
    </section>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Kayıtlı Öğrenci Listesi
        
        <small></small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Listele</a></li>
       
      </ol>
      <? /*
error_reporting(0);
$baglan=@mysql_connect("localhost","root","");
if(!$baglan) die("mySQL bağlantı Hatası");

*/
?>

    </section>

    <!-- Main content -->
     <!-- Main content -->
    <section class="content">
      <!-- Small boxes (Stat box) -->
      <div class="row">
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-aqua">
            </div>
            </div>
        <!-- ./col -->
        <div class="col-lg-3 col-xs-6">
          <!-- small box --></div>
          </div>
        <div class="anaokul">
        <form action=""></form>
<table id="arka" width="470" border="0" cellpadding="0" cellspacing="0" >
  <tr>
    <td colspan="4" align="center" id="ad" height="30">Öğrenci Bilgileri</td>
  </tr>
   <tr>
  <td colspan="4" id="ad">Anaokulu</td>
  </tr>
  <?php
  $sorgu="select * from anaokulu where id < '4' ";
$veri=mysqli_query($baglan,$sorgu);
while($oku = mysqli_fetch_assoc($veri))
{
	?>
  <tr>
 
    <td><?php echo $oku["id"];?></td>
    <td><?php echo $oku["ad"];?></td>
    <td><a href="formdetay2.php?id=<?php echo $oku["id"];?>&okulturu=anaokulu">Detaylı Gör</a></td>
    <td><a href="ogrsil.php?id=<?php echo $oku["id"];?>&okulturu=anaokulu">Sil</a></td>
    
  </tr>
  <?php
}
?>
<tr><td colspan="4"><a href="anaokul.php">Devamını Gör</a></td></tr>
</table>
     
        </div>
        
         <div class="ilkokul">
              <form action=""></form>
<table id="arka" width="470" border="0" cellpadding="0" cellspacing="0" >
  <tr>
    <td colspan="4" align="center" id="ad" height="30">Öğrenci Bilgileri</td>
  </tr>
   <tr>
  <td colspan="4" id="ad">İlkokul</td>
  </tr>
  <?php
  $sorgu="select * from ilkokul where id < '4' ";
$veri=mysqli_query($baglan,$sorgu);
while($oku = mysqli_fetch_assoc($veri))
{
  ?>
  <tr>
 
    <td><?php echo $oku["id"];?></td>
    <td><?php echo $oku["ad"];?></td>
    <td><a href="formdetay2.php?id=<?php echo $oku["id"];?>&okulturu=ilkokul">Detaylı Gör</a></td>
    <td><a href="ogrsil.php?id=<?php echo $oku["id"];?>&okulturu=ilkokul">Sil</a></td>
    
  </tr>
  <?php
}
?>
 <tr><td colspan="4"><a href="ilkokul.php">Devamını Gör</a></td></tr>       

</table>

        
         </div>
          <div class="ortaokul">     <form action=""></form>
<table id="arka" width="470" border="0" cellpadding="0" cellspacing="0" >
  <tr>
    <td colspan="4" align="center" id="ad" height="30">Öğrenci Bilgileri</td>
  </tr>
   
  <tr>
  <td colspan="4" id="ad">Ortaokul</td>
  </tr>
  <?php
  $sorgu="select * from ortaokul where id < '4' ";
$veri=mysqli_query($baglan,$sorgu);
while($oku = mysqli_fetch_assoc($veri))
{
  ?>
  <tr>
 
    <td><?php echo $oku["id"];?></td>
    <td><?php echo $oku["ad"];?></td>
    <td><a href="formdetay2.php?id=<?php echo $oku["id"];?>&okulturu=ortaokul">Detaylı Gör</a></td>
    <td><a href="ogrsil.php?id=<?php echo $oku["id"];?>&okulturu=ortaokul">Sil</a></td>
    
  </tr>
  <?php
}
?>
<tr><td colspan="4"><a href="ortaokul.php">Devamını Gör</a></td></tr>
</table>
        </div>
           <div class="lise">     <form action=""></form>
<table id="arka" width="470" border="0" cellpadding="0" cellspacing="0" >
  <tr>
    <td colspan="4" align="center" id="ad" height="30">Öğrenci Bilgileri</td>
  </tr>
   <tr>
  <td colspan="4" id="ad">Lise</td>
  </tr>
  <?php
  $sorgu="select * from lise where id < '4' ";
$veri=mysqli_query($baglan,$sorgu);
while($oku = mysqli_fetch_assoc($veri))
{
  ?>
  <tr>
 
    <td><?php echo $oku["id"];?></td>
    <td><?php echo $oku["ad"];?></td>
    <td><a href="formdetay2.php?id=<?php echo $oku["id"];?>&okulturu=lise">Detaylı Gör</a></td>
    <td><a href="ogrsil.php?id=<?php echo $oku["id"];?>&okulturu=lise">Sil</a></td>
    
  </tr>
  <?php
}
?>
<tr><td colspan="4"><a href="lise.php">Devamını Gör</a></td></tr>
</table>

        </div>

    <section class="content container-fluid">

      <!--------------------------
        | Your Page Content Here |
        -------------------------->

    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->

  <!-- Main Footer -->
  <footer class="main-footer">
    <!-- To the right -->
    <div class="pull-right hidden-xs">
      Bu sitenin yazılımı <strong>Dad&Son Software</strong> tarafından yapılmaktadır.
    </div>
    <!-- Default to the left -->
    <strong>Altın Nesil Okulları</strong>
  </footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Create the tabs -->
    <ul class="nav nav-tabs nav-justified control-sidebar-tabs">
      <li class="active"><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>
      <li><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-gears"></i></a></li>
    </ul>
    <!-- Tab panes -->
    <div class="tab-content">
      <!-- Home tab content -->
      <div class="tab-pane active" id="control-sidebar-home-tab">
        <h3 class="control-sidebar-heading"></h3>
        <ul class="control-sidebar-menu">
          <li>
            <a href="javascript:;">
              <i class="menu-icon fa fa-birthday-cake bg-red"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading"></h4>

                <p></p>
              </div>
            </a>
          </li>
        </ul>
        <!-- /.control-sidebar-menu -->

        <h3 class="control-sidebar-heading"></h3>
        <ul class="control-sidebar-menu">
          <li>
            <a href="javascript:;">
              <h4 class="control-sidebar-subheading">
                
                <span class="pull-right-container">
                    <span class="label label-danger pull-right"></span>
                  </span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-danger" style="width: 70%"></div>
              </div>
            </a>
          </li>
        </ul>
        <!-- /.control-sidebar-menu -->

      </div>
      <!-- /.tab-pane -->
      <!-- Stats tab content -->
      <div class="tab-pane" id="control-sidebar-stats-tab"></div>
      <!-- /.tab-pane -->
      <!-- Settings tab content -->
      <div class="tab-pane" id="control-sidebar-settings-tab">
        <form method="post">
          <h3 class="control-sidebar-heading"></h3>

          <div class="form-group">
            <label class="control-sidebar-subheading">
              
              <input type="checkbox" class="pull-right" checked>
            </label>

            <p>
              
            </p>
          </div>
          <!-- /.form-group -->
        </form>
      </div>
      <!-- /.tab-pane -->
    </div>
  </aside>
  <!-- /.control-sidebar -->
  <!-- Add the sidebar's background. This div must be placed
  immediately after the control sidebar -->
  <div class="control-sidebar-bg"></div>
</div>
<!-- ./wrapper -->

<!-- REQUIRED JS SCRIPTS -->

<!-- jQuery 3 -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.min.js"></script>

<?php

}

?>

<!-- Optionally, you can add Slimscroll and FastClick plugins.
     Both of these plugins are recommended to enhance the
     user experience. -->
</body>
</html>