Advertisement
Guest User

Untitled

a guest
Jul 29th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.95 KB | None | 0 0
  1. <?php
  2. $realmd = "realmd"; // DB kde je Tabulka UPTIME
  3. $ip = "127.0.0.1"; // IP kde je server s mysql
  4. $port = "3306"; // port mysql
  5. $user = "root"; // uživatel MySQL
  6. $pass = "pass"; // heslo k MySQL
  7.  
  8. $db_spojeni = mysqli_connect
  9. ($ip, $user, $pass, $realmd, $port);
  10.  
  11. $sql = mysqli_query($db_spojeni, 'SELECT UNIX_TIMESTAMP(NOW())-starttime AS FromLastStart FROM uptime ORDER BY starttime DESC LIMIT 1');
  12.  
  13. while ($radek = mysqli_fetch_assoc($sql)){
  14. $cislo = $radek['FromLastStart']*1;
  15. $den = floor($cislo/(24*3600));
  16. $cislo -= $den*24*3600;
  17. $hodin = floor($cislo/3600);
  18. $cislo -= $hodin*3600;
  19. $minut = floor($cislo/60);
  20. $sekund=$cislo-$minut*60;
  21. }
  22. echo ($den>0?$den.' <b><font color="#FFF">dnu</font></b>, ':'').($hodin*1).' <b><font color="#FFF">hod</font></b>, '.($minut*1).' <b><font color="#FFF">min</font></b>, '.($sekund*1).' <b><font color="#FFF">sec</font></b>';
  23.  
  24. mysqli_free_result($sql);
  25.  
  26. if ($db_spojeni)
  27. mysqli_close($db_spojeni);
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement