Untitled

<?php
require 'config.php';
session_start();
?>

<?php
    $conn = new mysqli($db_servername, $db_username, $db_password, $db_name);
    $conn->set_charset("utf8");
////////////////////////////////////////////////////////////////Check connection
if (!$conn) {
	die("Connection failed:".mysqli_connect_error());
}
else{
   // echo "Som v databaze!";
}

$result = $conn->query("SELECT obdobie FROM zaznam WHERE id_uzivatel = 79720 GROUP BY obdobie");


  //echo "Meno: " .$_SESSION['meno']. "<br>";

$result2 = $conn->query("SELECT u.id_uzivatel, u.meno, p.nazov, z.nazov, z.hodnota, z.obdobie, z.id_predmet FROM zaznam z JOIN uzivatel u on z.id_uzivatel = u.id_uzivatel JOIN predmet p on p.id_predmet = z.id_predmet WHERE u.id_uzivatel = 79720");

/*$result2 = $conn->query("SELECT u.id_uzivatel, u.meno, p.nazov, z.nazov, z.hodnota, z.obdobie FROM zaznam z JOIN uzivatel u on z.id_uzivatel = u.id_uzivatel JOIN predmet p on p.id_predmet = z.id_predmet WHERE u.id_uzivatel = '".$_SESSION['meno']."'");*/

$result3 = $conn->query("SELECT * FROM predmet");

$result4 = $conn->query("SELECT * FROM zaznam z JOIN vysledky v ON z.id_predmet = v.id_predmet AND z.id_uzivatel = v.id_uzivatel WHERE z.obdobie = '2015/2016' AND v.id_uzivatel = '79720' AND z.id_predmet = '6'");


//$conn->close();

/*$result3 = $conn->query("SELECT p.nazov FROM predmet p JOIN zaznam z on p.id_predmet = z.id_predmet WHERE z.id_uzivatel ='".$_SESSION['meno']."' GROUP BY p.nazov ");*/

//$result4 = $conn->query("SELECT p.nazov");
?>

<!DOCTYPE html>
<html lang="sk">
     <head>
        <title>Main Page</title>
         <meta charset="utf-8">
         <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
         <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script>
        <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.css">
        <script type="text/javascript" charset="utf-8" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.js"></script>
         <link rel="stylesheet" type="text/css" href="style.css">
        <style>
            .hlavicka{
                width: 100%;
                height: 50px;
                background-color: black;
                font-size: large;
                padding-top: 7px;
            }
         </style>
    </head>
    <body>
        <div class="hlavicka">
        <a href="odhlasenie.php" role="button">Odhlasit</a>
        </div>
            <strong>Vyber si rok studia</strong>
        <form method="post" action="welcomePage.php">
        <select name="roky" id="roky">
        <?php
            while($rows = $result->fetch_assoc()){
                $rok = $rows['obdobie'];
                echo "<option value='$rok'>$rok</option>";

            }
            ?>
        </select>
            <input type="submit" value="Zvol" name="zvol">
        </form>
        <script>
            $(document).ready(function () {
                $('#tabulka').DataTable({
                    "searching":false,
                    "info":false,
                    "bSort":false
                });
            });
        </script>

       <?php

        if (isset($_POST["zvol"])) {
             $rok = htmlspecialchars($_POST["roky"]);

 $result5 = $conn->query("SELECT p.id_predmet,p.nazov FROM zaznam z JOIN predmet p ON z.id_predmet = p.id_predmet WHERE obdobie = '$rok' AND id_uzivatel = '79720' GROUP BY p.id_predmet,p.nazov");


            //echo $rok;
        }
   /* if ($result2->num_rows > 0) {
        while ($row = $result2->fetch_assoc()) {
            echo $row["id_predmet"];
        }
    } else {
        echo "0 results";*/
   // }

              /* if ($result5->num_rows > 0) {
                    while ($row = $result5->fetch_assoc()) {
                        $id = $row["id_predmet"];
                        $predmet = $row["nazov"];
                        echo $id;
                        echo $predmet;
                        }
                    } else {
                        echo "0 results";
                        }*/

            while ($row = $result5->fetch_assoc()) {
                //echo "IDE WHILE3 <br>";
                        $id = $row["id_predmet"];
                        $predmet = $row["nazov"];
                       // echo $id;
                    //    echo $predmet;
 $result4 = $conn->query("SELECT * FROM zaznam z JOIN vysledky v ON z.id_predmet = v.id_predmet AND z.id_uzivatel = v.id_uzivatel WHERE z.obdobie = '$rok' AND v.id_uzivatel = '79720' AND z.id_predmet = '$id'");

                echo "<h2>$predmet</h2>";


                   echo "<table class 'table table-bordered' id='tabulka'>";
                            echo "<tr><th>Nazov</th>";

                        while($rows4 = $result4->fetch_assoc()){

                            //if($rows2['id_predmet'] == $id_predmetu){
                            $id_predmetu_zaznam = $rows4['id_predmet'];

                            if($id == $id_predmetu_zaznam){
                               // echo "id zaznamu $id_predmetu_zaznam <br>";
                                //echo "ID PREDMETU = $id_predmetu";
                                echo "<td>".$rows4['nazov']."</td>";

                            }
                        }

                            echo "</tr><tr><th>Hodnota</th>";
                            while($rows5 = $result4->fetch_assoc()){
                                //echo "ide ";
                                //echo "ID PREDMET: "$row5['id_predmet']";
                                $id_predmetu_zaznam = $rows5['id_predmet'];
                                //echo "ID 1: $id_predmetu_zaznam";
                                //echo "ID 2: $id";
                                if($id == $id_predmetu_zaznam){

                            echo "<td>".$rows5['hodnota']."</td>";
                                      }

               // echo "IDE WHILE2 <br>";
                //$predmet = $rows2['nazov'];
                //echo "$predmet";
           // echo "ID: ".$rows2['id_predmet']."<br>";
                        }
   // echo "ID: ".$rows2['id_predmet']."<br>";

        echo "</tr></table>";
    //echo "$id_predmetu";

            }


        ?>

        <div id="container">
    </div>
    </body>
</html>