dashboard.php 967 B

1234567891011121314151617181920212223242526272829303132333435
  1. <div class="dashcollumn">
  2. <h1>Événements par Occurence</h1>
  3. <table class="dashtable">
  4. <tr>
  5. <th>Source</th>
  6. <th>Log</th>
  7. <th>Eventid</th>
  8. <th>Occurence</th>
  9. </tr>
  10. <?php
  11. $getcltqry = mysqli_query($link, "SELECT *,COUNT(*) FROM entries WHERE section = 'eventvwr' GROUP BY data2, data3, data4 ORDER BY COUNT(*) DESC");
  12. while($row = mysqli_fetch_array($getcltqry)){
  13. echo "<tr>";
  14. echo "<th>".$row['data2']."</th>";
  15. echo "<th>".$row['data3']." ".$row['data4']."</th>";
  16. echo "<th>".$row['data1']."</th>";
  17. echo "<th>".$row['COUNT(*)']."</th>";
  18. echo "</tr>";
  19. }
  20. ?>
  21. </table>
  22. </div>
  23. <div class="dashcollumn">
  24. <h1>Éléments à surveiller</h1>
  25. <?php
  26. $getcltqry = mysqli_query($link, "SELECT * FROM checks");
  27. while($row = mysqli_fetch_array($getcltqry)){
  28. echo "<a class='collumnbutton' href='?a=ckvw&chk=".$row['id']."'>".$row['name']."</a><br>";
  29. }
  30. ?>
  31. </div>