Advertisement
Guest User

Untitled

a guest
Aug 6th, 2016
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head lang="en">
  4. <meta charset="UTF-8">
  5. <title></title>
  6. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  7. <script src="ajaxTest.js"></script>
  8. </head>
  9. <body>
  10. <div class="repeatTimers">
  11. <style type="text/css">
  12. .tg {border-collapse:collapse;border-spacing:0;}
  13. .tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
  14. .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
  15. .tg .tg-egay{font-weight:bold;font-size:26px;font-family:Impact, Charcoal, sans-serif !important;;background-color:#9a0000;text-align:center;vertical-align:top}
  16. .tg .tg-yw4l{vertical-align:top}
  17. </style>
  18. <table class="tg">
  19. <tr>
  20. <th class="tg-egay" colspan="4"> Cooldowns </th>
  21. </tr>
  22. <?php
  23. $dbhost = 'rdbms.strato.de';
  24. $dbuser = 'U2658295';
  25. $dbpass = 'ABC123456789';
  26. $dbname = 'DB2658295';
  27.  
  28. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  29.  
  30. mysql_select_db($dbname, $conn);
  31. $result = mysql_query("SELECT * FROM Timer", $conn);
  32.  
  33. date_default_timezone_set("Europe/Berlin");
  34. $timestamp = date('Y-m-d G:i:s');
  35.  
  36. while ($row = mysql_fetch_array($result)) {
  37. $Ready = date(htmlspecialchars($row['Clear']));
  38. echo '<tr align="center"><td class="tg-yw4l"> ' . htmlspecialchars($row['Name']) . ' </td>';
  39. if ($timestamp > strtotime("+45 minutes",$Ready)) {
  40. echo '<td class="tg-yw4l">Ready on -> '. $timestamp .'</td>';
  41. } else {
  42. echo '<td class="tg-yw4l">Ready - '. $Ready .'</td>';
  43. }
  44. echo '</td><td class="tg-yw4l"> Got it!</td></tr>';
  45.  
  46. #<td class="tg-yw4l"> ' . htmlspecialchars($row['Cooldown']) . ' </td><td class="tg-yw4l"> ' . htmlspecialchars($row['Clear']) .
  47.  
  48. }
  49. ?>
  50. </table>
  51. </div>
  52. <br \>
  53. <a class="timer" timerid="1">atrgha</a>
  54. <a class="timer" timerid="2">athrsa</a>
  55. <a class="timer" timerid="3">aetrha</a>
  56. </body>
  57. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement