Diff between 7ac502a8ef7834de194e4b1b02937f990a328a51 and 02cc3e7e9d2aeef6222602dc786bdbfd909f7723

Changed Files

File Additions Deletions Status
admin.php +41 -0 added

Full Patch

diff --git a/admin.php b/admin.php
new file mode 100644
index 0000000..f704a9e
--- /dev/null
+++ b/admin.php
@@ -0,0 +1,41 @@
+<?php
+    include "connect.php";
+    $sql = "SELECT * FROM kayttajat";
+    $result = $conn->query($sql);
+
+    $kayttajat = [];
+    if ($result->num_rows > 0) {
+        while($row = $result->fetch_assoc()) {
+            $kayttajat[] = $row;
+        }
+    } else {
+        echo "Käyttäjiä ei löytynyt";
+    }
+
+    $conn->close();  
+?>
+
+<html lang="en">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <title>Hallintapaneeli</title>
+</head>
+<body>
+    <?php include "header.php"; ?>
+    <main>
+        <table>
+            <?php foreach ($kayttajat as $kayttaja): ?>
+                    <tr>
+                        <td>
+                            <?php 
+                                echo "<td>" . $kayttaja["nimi"] . "</td>";
+                                echo "<td>" . $kayttaja["opettaja"] . "</td>";
+                            ?>
+                        </td>
+                    </tr>
+                <?php endforeach; ?>
+        </table>
+    </main>
+</body>
+</html>
\ No newline at end of file