Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /* Characters database. */
- $db = "realmd"; // DB kde je Tabulka UPTIME
- /* IP.*/
- $ip = "localhost";
- /* Port. */
- $port = "3306";
- /* Username. */
- $user = "root"; // uživatel MySQL
- /* Password. */
- $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();
- }
- while ($radek = mysqli_fetch_assoc($sql))
- // Výpis
- {
- $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