From 2b1e9dcfcac892e8daa339a9fb4f450c345667a7 Mon Sep 17 00:00:00 2001
From: Luka Hietala <luka.hietala08@gmail.com>
Date: Thu, 30 Oct 2025 09:50:16 +0200
Subject: [PATCH] kisumirrille siveltimet

---
 admin.php | 34 +++++++++++++++++++++++++++++++++-
 1 file changed, 33 insertions(+), 1 deletion(-)

diff --git a/admin.php b/admin.php
index f5f8adf..61c3e68 100644
--- a/admin.php
+++ b/admin.php
@@ -1,5 +1,26 @@
 <?php
     include "connect.php";
+
+    // Vaihda rooli
+    if (isset($_POST['rooli']) && $_SERVER['REQUEST_METHOD'] === 'POST') {
+        $id = $_POST["id"];
+        $rooli = $_POST['rooli'];
+
+        echo $id, $rooli;
+        $stmt = $conn->prepare("UPDATE kayttajat SET opettaja=(?) WHERE id=(?);");
+        $stmt->bind_param("ss", $rooli, $id);
+        
+        if ($stmt->execute()) {
+            header("Location: " . $_SERVER['PHP_SELF']);
+            exit();
+        } else {
+            echo "Virhe: " . $stmt->error;
+        }
+        
+        $stmt->close();
+    }
+
+    // Hae käyttäjät
     $sql = "SELECT * FROM kayttajat";
     $result = $conn->query($sql);
 
@@ -38,11 +59,22 @@
                 <tr>
                     <?php 
                         echo "<td>" . $kayttaja["nimi"] . "</td>";
-                        echo ($kayttaja['opettaja'] == "1") ? '<td>Opettaja</td>' : '<td>Opiskelija</td>';
                     ?>
+                    <td>
+                        <form action="" method="POST" id="rooli-form">
+                             <?php 
+                                echo "<input type='hidden' id='id' name='id' value={$kayttaja['id']}>"
+                            ?>
+                            <select name="rooli">
+                                <option value="0" <?= ($kayttaja['opettaja'] === '0') ? 'selected' : '' ?>>Opiskelija</option>
+                                <option value="1" <?= ($kayttaja['opettaja'] === '1') ? 'selected' : '' ?>>Opettaja</option>
+                            </select>
+                        </form>
+                    </td>
                 </tr>
             <?php endforeach; ?>
         </table>
     </main>
+    <input type="submit" form="rooli-form" value="Tallenna"/>
 </body>
 </html>
\ No newline at end of file
-- 
2.47.3