Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connect = mysqli_connect("localhost", "root", "Mania211", "akserver");
- $query ="SELECT * FROM player LEFT JOIN combat ON player.unique_id = combat.uid ORDER BY unique_id DESC";
- //SELECT * FROM player LEFT JOIN combat ON player.unique_id = combat.unique_id ORDER BY unique_id DESC";
- $result = mysqli_query($connect, $query);
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Player Data</title>
- <link rel="stylesheet" // 1
- href="stats.css" // 2
- type="text/css" /> // 3
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
- <script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
- <script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>
- <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
- </head>
- <body>
- <body background="https://images4.alphacoders.com/584/thumb-1920-584348.jpg">...</body>
- <br /><br />
- <div class="container">
- <div class="napis">
- <h3 align="center">Mount & Blade With Fire and Sword Player Data </h3>
- <h3><font size="3">Supported Servers</font></h3>
- </br>
- <img src="https://cdn.countryflags.com/thumbs/poland/flag-400.png" align="center" width="35" height="25" /> <font size="3">ð€ð«ð¦ð¢ðš_ðŠð¨ð«ð¨ð§ð§ðš_ð’ðžð«ð¯ðžð«</font>
- </div>
- <br />
- <div class="table-responsive">
- <table id="employee_data" class="table table-striped table-bordered">
- <thead>
- <tr>
- <td>username</td>
- <td>unique_id</td>
- <td>kills</td>
- <td>deaths</td>
- </tr>
- </thead>
- <?php
- while($row = mysqli_fetch_array($result))
- {
- echo '
- <tr>
- <td>'.$row["username"].'</td>
- <td>'.$row["unique_id"].'</td>
- <td>'.$row["kills"].'</td>
- <td>'.$row["deaths"].'</td>
- </tr>
- ';
- }
- ?>
- </table>
- </div>
- </div>
- <br />
- <br />
- <br />
- <br />
- <div id="stopka"><b> Copyright © 2018 by Pitch | All rights reserved</b></div>
- <div id="stopka"><b> Images from Teleworlds.com</b></div>
- <div id="stopka2">
- </body>
- </html>
- <script>
- $(document).ready(function(){
- $('#employee_data').DataTable();
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement