Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $realmd = "realmd"; // DB kde je Tabulka UPTIME
- $ip = "127.0.0.1"; // IP kde je server s mysql
- $port = "3306"; // port mysql
- $user = "root"; // uživatel MySQL
- $pass = "pass"; // heslo k MySQL
- $db_spojeni = mysqli_connect
- ($ip, $user, $pass, $realmd, $port);
- $sql = mysqli_query($db_spojeni, 'SELECT UNIX_TIMESTAMP(NOW())-starttime AS FromLastStart FROM uptime ORDER BY starttime DESC LIMIT 1');
- while ($radek = mysqli_fetch_assoc($sql)){
- $cislo = $radek['FromLastStart']*1;
- $den = floor($cislo/(24*3600));
- $cislo -= $den*24*3600;
- $hodin = floor($cislo/3600);
- $cislo -= $hodin*3600;
- $minut = floor($cislo/60);
- $sekund=$cislo-$minut*60;
- }
- 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>';
- mysqli_free_result($sql);
- if ($db_spojeni)
- mysqli_close($db_spojeni);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement