Advertisement
Guest User

Untitled

a guest
Dec 11th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. <!DOCTYPE>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>Strona</title>
  6. <link rel="stylesheet" href="styl.css">
  7. </head>
  8. <body>
  9. <div id="banner">
  10. <h2>Witam na tej stronie</h2>
  11. </div>
  12. <div id="lewy">
  13. <h3>Menu:</h3>
  14. <ol>
  15. <li>Strona główna</li>
  16. <li>Baza danych</li>
  17. </ol>
  18. </div>
  19. <div id="prawy">
  20. <?php
  21. $server = "localhost";
  22. $user = "root";
  23. $pass = "";
  24. $db = "egzamin";
  25. $conn = new mysqli($server, $user, $pass, $db);
  26. if (@$conn->connect_error) {
  27. die("Connection failed: " . $conn->connect_error);
  28. } else {
  29. echo "Połączono";
  30. }
  31. echo "<h1>Storona administracyjna</h1>";
  32. echo "<table border='2px'>";
  33. echo "<tr><th>Id</th><th>Login</th><th>Hasło</th><th>Mail</th><th>Admin</th></tr>";
  34. $sql = 'SELECT * FROM `uzytkownicy` ORDER BY `id_uzytkownika` ASC;';
  35. $tak=$conn->query($sql);
  36. while($row = $tak ->fetch_array(MYSQLI_ASSOC))
  37. {
  38. echo "<tr>";
  39. echo "<td>".$row['id_uzytkownika']."</td>";
  40. echo "<td>".$row['login']."</td>";
  41. echo "<td>".$row['haslo']."</td>";
  42. echo "<td>".$row['mail']."</td>";
  43. echo "<td>".$row['admin']."</td>";
  44. echo "<td><a href='usun.php?id=".$row['id_uzytkownika']."'>Usuń</a></td>";
  45. echo "</tr>";
  46. }
  47. // $results = mysql_query("select * from uzytkownicy", $conn);
  48. // $shows = array();
  49. // while ($show = mysql_fetch_object($results)) {
  50. // $shows[] = $show;
  51. // }
  52. // foreach ($shows as $show) {
  53. // echo $show->login."<br";
  54. // }
  55. echo "<a href='dodaj.php'>Dodaj</a>";
  56.  
  57. @$conn->close();
  58. ?>
  59. </div>
  60. <div id="stopka">
  61. Jakub Szekiełda 4Td
  62. </div>
  63. </body>
  64. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement