Untitled

    <?php
    session_start();
    require "connection.php";
    $con = connection();
    $imie = $_SESSION['imie'];
    $nazwisko = $_SESSION['nazwisko'];
    if($_SESSION['admin'] == "Yes") {
        $admin = " [Administrator] ";
    } else {
        $admin = "";
        header("Location: //localhost/NewProject/loguj.php");
    }
    if(!isset($_SESSION['sort'])) {
        $_SESSION['sort']  = 1;
    }

    function sortowanie() {
        switch($_SESSION['sort']) {
            case 1:
                return 'SELECT * FROM uzytkownicy';
            case 2:
                return 'SELECT * FROM uzytkownicy ORDER BY punkty DESC';
            case 3:
                return 'SELECT * FROM uzytkownicy ORDER BY punkty';
            case 4:
                return 'SELECT * FROM uzytkownicy ORDER BY imie';
        }
    }
    function select() {
        $_SESSION['sort'] = 3;
        $kwerenda = sortowanie();
    }
    if(isset($_POST['state'])&&$_POST['state'] != 0) {
        $_SESSION['sort'] = $_POST['state'];
    }
    ?>

<!DOCTYPE html>
<html>
<head>
        <title>Punktacja</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta charset="utf-8">
        <?php echo '<link rel="stylesheet" href="http://bootswatch.com/lumen/bootstrap.min.css" crossorigin="anonymous">'; ?>
        <link rel="stylesheet" href="style.css">
        <link rel="stylesheet" href="select.css">
        <script type="text/javascript" src="jquery.js"></script>
        <script src="http://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>
        <script src="jquery.min.js"></script>
        <script src="bootstrap.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.12.2/js/bootstrap-select.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.12.2/js/i18n/defaults-*.min.js"></script>


</head>
<body>
        <nav class="navbar navbar-default">
            <div class="container-fluid">
                <div class="navbar-header">
                    <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                        <span class="sr-only">Toggle navigation</span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                  </button>
                  <a class="navbar-brand" href="index.php">Punktacja</a>
                </div>

                <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                  <ul class="nav navbar-nav">
                    <li><a href="index.php"><i class="glyphicon glyphicon-folder-open"></i> Lista Użytkowników <span class="sr-only">(current)</span></a></li>
                    <li><a href="dodaj.php"><i class="glyphicon glyphicon-cloud-upload"></i> Zgłoś Odpowiedź </a></li>
                  </ul>
                  <ul class="nav navbar-nav navbar-right">
                    <?php
                    if($imie != '')
                    {
                    echo '<li class="active"><a href="user.php"><i class="glyphicon glyphicon-user"></i> Witaj, <b>'.$nazwisko.' '.$imie.$admin.' </a></b></li>';
                    echo '<li><a href="logout.php"><i class="glyphicon glyphicon-log-out"></i> Wyloguj!</a></li>';
                    } else {
                    echo '<li><a href="loguj.php"><i class="glyphicon glyphicon-user"></i> Logowanie</a></li>';
                    }
                    ?>
                    <li><a href="admin.php"><i class="glyphicon glyphicon-wrench"></i> Panel Administratora</a></li>
                  </ul>
                </div>
              </div>
        </nav>
        <?php
        $kwerenda = sortowanie();
        $rezultat = mysqli_query($con, $kwerenda);
        $row = mysqli_fetch_assoc($rezultat);
        $punkty = $row['punkty'];
        $ADDdate = $row['ADDdate'];
        $CHdate = $row['CHdate'];
        $stat = $row['status'];
        $LABoczekujacy = '<span class="label label-default">Oczekuje na ocene</span>';
        $LABadmin = '<span class="label label-warning">Administrator</span>';
        $LABoceniony = '<span class="label label-success">Oceniony!</span>';

        if($stat == 'oczekujacy') {
            $CHdate = $LABoczekujacy;
            $stat = $LABoczekujacy;
        } else {

        }

        ?>

    <div id="container">

        <div class="col-sm-6">
                <div class="form-group">
                    <h3><label class="control-label"><font color="black">Witaj, <b><?php echo $nazwisko.' '.$imie; ?> [Administrator]</b></font></label><br></h3>
                    <h4><label class="control-label"><font color="black">Panel Administratora</font></label></h4>
                </div>

            <div id="menu">

            <?php
                 require_once 'connection.php';
                $con = connection();

                $kwerenda = sortowanie();

                $rezultat = mysqli_query($con, $kwerenda);
                $ile = mysqli_num_rows($rezultat);


                echo '<div id="sorting">';
                echo '<form name="sorts" action="admin.php?id='.$id.'" method="post">';
                echo '<select name="state" onchange="this.form.submit();" class="selectpicker" data-width="fit">';
                echo '<option>Sortowanie</option>';
                echo '<optgroup label="[SORT] Opcje">';
                echo '<option value="1">Wylacz</option>';
                echo '</optgroup><optgroup label="[SORT] Punkty">';
                echo '<option value="2">Malejaco</option>';
                echo '<option value="3">Rosnaco</option>';
                echo '</optgroup><optgroup label="[SORT] Imie">';
                echo '<option value="4">Alfabetycznie</option>';
                echo '</optgroup>';
                echo '</select>';
                echo '</form>';
                echo '</div>';

            ?>
            </div>

            <table id="pag" class='table table-striped table-hover'>
            <tr><th>#</th><th>Nazwisko</th><th>Imię</th><th>Wynik</th><th>Status Oceny</th><th>Akcje</th></tr>
            <?php
            for($i = 1; $i <= $ile; $i++) {
                    $row = mysqli_fetch_assoc($rezultat);
                    $imie = $row['imie'];
                    $punkty = $row['punkty'];
                    $nazwisko = $row['nazwisko'];
                    $status = $row['status'];
                    $idoceny = $row['id'];
                    if($status == 'oczekujacy') {
                        $status = $LABoczekujacy;
                    } else if($status == 'admin'){
                        $status = $LABadmin;
                    } else if($status == 'oceniony') {
                        $status = $LABoceniony;
                    }
                    if(!empty($imie)) {
                        echo "<tr><td>$i</td><td>$nazwisko</td><td>$imie</td><td>$punkty</td><td>$status</td><td><a href='ocena.php?ocen=$idoceny' class='btn btn-default btn-xs'>Ocen</a>&nbsp;<a href='edytuj.php?ocen=$idoceny' class='btn btn-default btn-xs'>Edytuj</a></td></tr>";
                   }
                }
            ?>
            </table>
            <script>
            $('#pag').DataTable();


            </script>
            </div>
        </div>
    </div>
</body>
</html>