Guest User

Banlista

a guest
Oct 17th, 2017
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.22 KB | None | 0 0
  1. <?php
  2. $db['host'] = 'localhost';
  3. $db['name'] = 'dbname';
  4.  
  5. $db['user'] = 'dbuser';
  6. $db['pass'] = 'dbpass';
  7.  
  8. try
  9. {
  10. $connection = new PDO('mysql:host='. $db['host'] .';dbname='. $db['name'], $db['user'], $db['pass']);
  11. }
  12. catch(PDOException $error)
  13. {
  14. echo 'Error: ' . $error -> getMessage();
  15. }
  16.  
  17. try
  18. {
  19. $connection = new PDO('mysql:host='. $db['host'] .';dbname='. $db['name'], $db['user'], $db['pass']);
  20. }
  21. catch(PDOException $error)
  22. {
  23. echo 'Error: ' . $error -> getMessage();
  24. }
  25.  
  26. $wynik = $connection -> prepare('SELECT * FROM Punishments');
  27.  
  28. $wynik -> execute();
  29.  
  30. ?>
  31. <!DOCTYPE html>
  32. <html>
  33. <head>
  34. <meta charset="utf-8">
  35. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  36. <meta name="viewport" content="width=device-width, initial-scale=1">
  37. <meta name="description" content="">
  38. <meta name="author" content="JustWrite - Szczur">
  39.  
  40. <title> </title>
  41.  
  42. <!-- ========= CSS ========= -->
  43. <link href="css/bootstrap.css" rel="stylesheet" media="all">
  44. <link href="css/font-awesome.min.css" rel="stylesheet" media="all">
  45. <link href="css/style.css" rel="stylesheet" media="all">
  46.  
  47. <!-- ============ LOAD JAVASCRIPTS =========== -->
  48. <script src="js/jquery.min.js"></script>
  49. <script src="js/bootstrap.min.js"></script>
  50. <script src="js/style.js"></script>
  51.  
  52. </head>
  53. <body>
  54. <div class="container">
  55. <div align="center">
  56. <?php
  57.  
  58. if ($wynik -> rowCount() > 0)
  59. {
  60.  
  61. echo '<table border="2" width="500" height="50">';
  62. ?>
  63. <tr>
  64. <td>Zbanowany</td>
  65. <td>Administrator</td>
  66. <td>Powód</td>
  67. <td>Data Zakończenia</td>
  68. </tr>
  69. <?php
  70. foreach ($wynik as $var)
  71. {
  72. echo "<tr>";
  73. echo "<td>";
  74. echo '<img src="https://minotar.net/avatar/'.$var['name'].'/30.png" alt=""> '.$var['name'];
  75. echo "</td>";
  76. echo "<td>";
  77. echo $var['operator'];
  78. echo "</td>";
  79. echo "<td>";
  80. echo $var['reason'];
  81. echo "</td>";
  82. echo "<td>";
  83. if($var['end'] == '-1') {
  84. echo 'NIGDY';
  85. } else {
  86. echo date('d M Y H:i:s', $var['end']/1000);
  87. }
  88. echo "</td>";
  89. echo "</tr>";
  90.  
  91. }
  92.  
  93. echo '</table>';
  94. }
  95. ?>
  96. </div>
  97. </div>
  98. </body>
  99. </html>
Advertisement
Add Comment
Please, Sign In to add comment