Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. <?php
  2. $servername = "*******";
  3. $username = "********";
  4. $password = "*******";
  5. $dbname = "********";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11. die("Connection failed: " . $conn->connect_error);
  12. }
  13. ?>
  14. <table>
  15.  
  16. <thead>
  17. <tr>
  18. <th data-column-id="name">UKW</th>
  19. <th data-column-id="player" data-type="numeric">Longest Time Online</th>
  20. </tr>
  21. </thead>
  22. <tbody>
  23.  
  24. <?php
  25.  
  26. $sql = "SELECT name FROM stats_player";
  27. $ss = "SELECT online_seconds FROM stats_player";
  28. $result = $conn->query($sql);
  29. $result2 = $conn->query($ss);
  30.  
  31. if ($result->num_rows > 0) {
  32. // output data of each row
  33. while($row = $result->fetch_assoc()) {
  34.  
  35. // echo "Name: " . $row["name"]."<br>";
  36.  
  37. $seconds = $result2; //example
  38.  
  39. $hours = floor($seconds / 3600);
  40. $mins = floor(($seconds - $hours*3600) / 60);
  41. $s = $seconds - ($hours*3600 + $mins*60);
  42.  
  43. $mins = ($mins<10?"0".$mins:"".$mins);
  44. $s = ($s<10?"0".$s:"".$s);
  45.  
  46. $time = ($hours>0?$hours.":":"").$mins.":".$s;
  47.  
  48. echo "<tr><td>".$row["name"]."</td><td>$time</td></tr>";
  49. }
  50. } else {
  51. echo "0 results";
  52. }
  53.  
  54. ?>
  55. </div>
  56.  
  57. <?php
  58. $conn->close();
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement