From dfad877869569e4733d6b3e55dd3df6faa5f74c2 Mon Sep 17 00:00:00 2001
From: Luka Hietala <luka.hietala08@gmail.com>
Date: Mon, 10 Nov 2025 13:24:52 +0200
Subject: [PATCH] vaihda uuteen sql

---
 public/login.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/public/login.php b/public/login.php
index c7ae80f..967a9b6 100644
--- a/public/login.php
+++ b/public/login.php
@@ -9,14 +9,14 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') {
     
     if (!empty($name) && !empty($password)) {
         // etsi käyttäjä
-        $sql = "SELECT * FROM teachers WHERE name = '{$name}'";
+        $sql = "SELECT * FROM teachers WHERE username = '{$name}'";
         $result = $conn->query($sql);
 
         if ($result->num_rows > 0) {
             $user = $result->fetch_assoc();
 
             // tarkista salasanan hash, php defaultti (bcrypt)
-            if (password_verify($password, $user['password'])) {
+            if (password_verify($password, $user['password_hash'])) {
                 $_SESSION['user_id'] = $user['id'];
                 $_SESSION['user_name'] = $user['name'];
                 header('Location: ../public/admin.php');
-- 
2.47.3