Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Strona</title>
- <link rel="stylesheet" href="styl.css">
- </head>
- <body>
- <div id="banner">
- <h2>Witam na tej stronie</h2>
- </div>
- <div id="lewy">
- <h3>Menu:</h3>
- <ol>
- <li>Strona główna</li>
- <li>Baza danych</li>
- </ol>
- </div>
- <div id="prawy">
- <?php
- $server = "localhost";
- $user = "root";
- $pass = "";
- $db = "egzamin";
- $conn = new mysqli($server, $user, $pass, $db);
- if (@$conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- } else {
- echo "Połączono";
- }
- echo "<h1>Storona administracyjna</h1>";
- echo "<table border='2px'>";
- echo "<tr><th>Id</th><th>Login</th><th>Hasło</th><th>Mail</th><th>Admin</th></tr>";
- $sql = 'SELECT * FROM `uzytkownicy` ORDER BY `id_uzytkownika` ASC;';
- $tak=$conn->query($sql);
- while($row = $tak ->fetch_array(MYSQLI_ASSOC))
- {
- echo "<tr>";
- echo "<td>".$row['id_uzytkownika']."</td>";
- echo "<td>".$row['login']."</td>";
- echo "<td>".$row['haslo']."</td>";
- echo "<td>".$row['mail']."</td>";
- echo "<td>".$row['admin']."</td>";
- echo "<td><a href='usun.php?id=".$row['id_uzytkownika']."'>Usuń</a></td>";
- echo "</tr>";
- }
- // $results = mysql_query("select * from uzytkownicy", $conn);
- // $shows = array();
- // while ($show = mysql_fetch_object($results)) {
- // $shows[] = $show;
- // }
- // foreach ($shows as $show) {
- // echo $show->login."<br";
- // }
- echo "<a href='dodaj.php'>Dodaj</a>";
- @$conn->close();
- ?>
- </div>
- <div id="stopka">
- Jakub Szekiełda 4Td
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement