Advertisement
Guest User

Untitled

a guest
Mar 21st, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
  1. <?php
  2. $connect = mysqli_connect("localhost", "root", "password", "dbname");
  3. $query ="SELECT * FROM player ORDER BY unique_id DESC";
  4. $result = mysqli_query($connect, $query);
  5. ?>
  6. <!DOCTYPE html>
  7. <html>
  8. <head>
  9. <title>Player Data</title>
  10. <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  11. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  12. <script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
  13. <script src="https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js"></script>
  14. <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css" />
  15. </head>
  16. <body>
  17. <br /><br />
  18. <div class="container">
  19. <h3 align="center"> Player Data</h3>
  20. <br />
  21. <div class="table-responsive">
  22. <table id="employee_data" class="table table-striped table-bordered">
  23. <thead>
  24. <tr>
  25. <td>username</td>
  26. <td>unique_id</td>
  27.  
  28. </tr>
  29. </thead>
  30. <?php
  31. while($row = mysqli_fetch_array($result))
  32. {
  33. echo '
  34. <tr>
  35. <td>'.$row["username"].'</td>
  36. <td>'.$row["unique_id"].'</td>
  37. </tr>
  38. ';
  39. }
  40. ?>
  41. </table>
  42. </div>
  43. </div>
  44. </body>
  45. </html>
  46. <script>
  47. $(document).ready(function(){
  48. $('#employee_data').DataTable();
  49. });
  50. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement