Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db['host'] = 'localhost';
- $db['name'] = 'dbname';
- $db['user'] = 'dbuser';
- $db['pass'] = 'dbpass';
- try
- {
- $connection = new PDO('mysql:host='. $db['host'] .';dbname='. $db['name'], $db['user'], $db['pass']);
- }
- catch(PDOException $error)
- {
- echo 'Error: ' . $error -> getMessage();
- }
- try
- {
- $connection = new PDO('mysql:host='. $db['host'] .';dbname='. $db['name'], $db['user'], $db['pass']);
- }
- catch(PDOException $error)
- {
- echo 'Error: ' . $error -> getMessage();
- }
- $wynik = $connection -> prepare('SELECT * FROM Punishments');
- $wynik -> execute();
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <meta name="description" content="">
- <meta name="author" content="JustWrite - Szczur">
- <title> </title>
- <!-- ========= CSS ========= -->
- <link href="css/bootstrap.css" rel="stylesheet" media="all">
- <link href="css/font-awesome.min.css" rel="stylesheet" media="all">
- <link href="css/style.css" rel="stylesheet" media="all">
- <!-- ============ LOAD JAVASCRIPTS =========== -->
- <script src="js/jquery.min.js"></script>
- <script src="js/bootstrap.min.js"></script>
- <script src="js/style.js"></script>
- </head>
- <body>
- <div class="container">
- <div align="center">
- <?php
- if ($wynik -> rowCount() > 0)
- {
- echo '<table border="2" width="500" height="50">';
- ?>
- <tr>
- <td>Zbanowany</td>
- <td>Administrator</td>
- <td>Powód</td>
- <td>Data Zakończenia</td>
- </tr>
- <?php
- foreach ($wynik as $var)
- {
- echo "<tr>";
- echo "<td>";
- echo '<img src="https://minotar.net/avatar/'.$var['name'].'/30.png" alt=""> '.$var['name'];
- echo "</td>";
- echo "<td>";
- echo $var['operator'];
- echo "</td>";
- echo "<td>";
- echo $var['reason'];
- echo "</td>";
- echo "<td>";
- if($var['end'] == '-1') {
- echo 'NIGDY';
- } else {
- echo date('d M Y H:i:s', $var['end']/1000);
- }
- echo "</td>";
- echo "</tr>";
- }
- echo '</table>';
- }
- ?>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment