Untitled

<?php
ini_set('display_errors', 1);
//var_dump($_GET['input']);
$Fields = array();
$conn =  new mysqli("jestrab.kolej.mff.cuni.cz", "martin", "Kos", "martin_skola");
$select = "select * from Report join Senzor on Senzor.id=Report.Senzor_id;";
$selectResoult = mysqli_query($conn, $select);
$get_info = mysqli_fetch_assoc($selectResoult);

//var_dump($selectResoult);
foreach (array_keys($get_info) as $columnName) {
  array_push($Fields, $columnName);
}
$FilterSetted=true;
$selectResoult = mysqli_query($conn, $select);
if(isset($_GET['input'])&&is_array($_GET['input'])){
  $FilterFields=$_GET['input'];
}else{
  $FilterFields=array();
  $FilterSetted=false;
}
if (isset($_GET['onlyData']) && $_GET['onlyData'] == "true") {
  echo '<div class="datagrid" id="datagrid">
    <table>
        <tr>';
  if (!$FilterSetted) {
    foreach ($Fields as $field) {
      printf("<th>%s</th>", $field);
    }
    echo '</tr>';
    while ($row = mysqli_fetch_array($selectResoult)) {
      echo '<tr>';
      foreach ($Fields as $collom) {
        printf("<th>%s</th>", $row[$collom]);
      }
      echo '</tr>';
    }
    echo '</table></div>';
  } else {
    for ($i = 0; $i < count($FilterFields); $i++) {
      printf("<th>%s</th>", $FilterFields[$i]);
    }
    echo '</tr>';
    while ($row = mysqli_fetch_array($selectResoult)) {
      echo '<tr>';
      for ($i = 0; $i < count($FilterFields); $i++) {
        printf("<th>%s</th>", $row[$FilterFields[$i]]);
      }
      echo '</tr>';
    }
    echo '</table></div>';
  }
  exit();
}
?>
<html>

<head>
  <title>Data log</title>
  <link rel="stylesheet" type="text/css" href="style.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
  <script src="./p5.min.js"></script>
  <script src="script.js" charset="utf-8"></script>
</head>

<body>
  <?php
  echo '<div class="dropdown">
  <button onclick="toggleDropDown()" class="dropbtn">Filter</button>
  <div id="myDropdown" class="dropdown-content">
    <form action="index.php">';
    foreach ($Fields as $fieldName) {
      if (in_array($fieldName, $FilterFields)) {
        printf('<label class="myInput"><input type="checkbox" name="input[]" value="%s" checked/>%s</label><br/>', $fieldName, $fieldName);
      } else {
        printf('<label class="myInput"><input type="checkbox" name="input[]" value="%s" />%s</label><br/>', $fieldName, $fieldName);
      }
    }
  echo ' <input type="submit" value="Submit" class="submit"/>
</form>
<button onclick="resetInputs()" class="submit">Reset Input</button>
</div>
</div>
<div class="datagrid" id="datagrid">
  <table>
      <tr>';
  if (count($FilterFields) == 0) {
    foreach ($Fields as $field) {
      printf("<th>%s</th>", $field);
    }
    echo '</tr>';
    while ($row = mysqli_fetch_array($selectResoult)) {
      echo '<tr>';
      foreach ($Fields as $collom) {
        printf("<th>%s</th>", $row[$collom]);
      }
      echo '</tr>';
    }
    echo '</table></div>';
  } else {
    for ($i = 0; $i < count($FilterFields); $i++) {
      printf("<th>%s</th>", $FilterFields[$i]);
    }
    echo '</tr>';
    while ($row = mysqli_fetch_array($selectResoult)) {
      echo '<tr>';
      for ($i = 0; $i < count($FilterFields); $i++) {
        printf("<th>%s</th>", $row[$FilterFields[$i]]);
      }
      echo '</tr>';
    }
    echo '</table></div>';
  }
  echo '<button onclick="togleGraphView()" class="dropbtn">Togle Graph</button>';
  echo '<button onclick="togleRefrash()" class="dropbtn red">Auto refrash</button>';
  ?>
</body>

</html>