Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>List of Users</title>
  6. </head>
  7. <body>
  8. <h1>Pick a user. Any user. I dare you.</h1>
  9. <table>
  10. <thead>
  11. <tr>
  12. <td>Usernames:</td>
  13. </tr>
  14. </thead>
  15. <tbody>
  16. <?php
  17. $host = "localhost";
  18. $user = "test1";
  19. $pass = "1kozlovsas";
  20. $db = "test1";
  21. $conn = new mysqli($host, $user, $pass, $db);
  22.  
  23. $sql = "SELECT username FROM ass1dat";
  24. $result = $conn->query($sql);
  25. if ($result->num_rows > 0) {
  26. while($row = $result->fetch_assoc()) {
  27. $retUser = $row["username"];
  28. echo '
  29. <tr>
  30. <td>
  31. <a href="getuserinfo.php?id='.$retUser.'">
  32. <button type="button" class="btn btn-info">'.$retUser.'</button>
  33. </a>
  34. </tr>
  35. ';
  36. }
  37. }
  38. ?>
  39. </tbody>
  40. </table>
  41. </body>
  42. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement