Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db = "realmd"; // DB kde je Tabulka UPTIME
- $ip = "localhost";
- $port = "3306";
- $user = "root"; // uživatel MySQL
- $pass = "password"; // heslo k MySQL
- // Připojení do DB
- $db_spojeni = mysqli_connect
- ($ip, $user, $pass, $db, $port);
- // SQL dotaz
- $sql = mysqli_query($db_spojeni, 'SELECT UNIX_TIMESTAMP(NOW())-starttime AS FromLastStart FROM uptime ORDER BY starttime DESC LIMIT 1');
- if(!$sql){
- echo "Špatně napsaný dotaz do databáze";
- exit();
- }
- // Výpis
- 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="black">dnu</font></b>, ':'').($hodin*1).' <b><font color="black">hod</font></b>, '.($minut*1).' <b><font color="black">min</font></b>, '.($sekund*1).' <b><font color="black">sec</font></b>';
- }
- // Zavření objektu
- mysqli_free_result($sql);
- // Odpojení od Databáze
- if ($db_spojeni)
- mysqli_close($db_spojeni);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement