Tutoring-Service-System/subject_edit.php at main · jethermasidong/Tutoring-Service-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<?php
session_start();
include "config.php";
if (!isset($_SESSION['user_id']) || $_SESSION['role']!=='admin') header("Location: login.php");

$id = $_GET['id'] ?? 0;
$res = mysqli_query($conn, "SELECT * FROM subjects WHERE subject_id=".$id);
$subject = mysqli_fetch_assoc($res);
if(!$subject){ header("Location: subjects.php"); exit(); }

$error="";
if($_SERVER['REQUEST_METHOD']==='POST'){
    $name = trim($_POST['subject_name']);
    $stmt = mysqli_prepare($conn,"UPDATE subjects SET subject_name=? WHERE subject_id=?");
    mysqli_stmt_bind_param($stmt,"si",$name,$id);
    if(mysqli_stmt_execute($stmt)) header("Location: subjects.php");
    else $error="Error updating subject.";
    mysqli_stmt_close($stmt);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Edit Subject</title>
<script src="https://cdn.tailwindcss.com"></script>
</head>

<body class="bg-gray-50 min-h-screen flex items-center justify-center px-4">

<div class="w-full max-w-md bg-white rounded-2xl shadow-lg p-8">

    <h1 class="text-3xl font-bold text-gray-900 mb-6 text-center">Edit Subject</h1>

    <?php if($error): ?>
    <div class="bg-red-100 text-red-700 p-3 rounded mb-4 text-sm text-center">
        <?php echo $error;?>
    </div>
    <?php endif;?>

    <form method="POST" class="space-y-5">
        <input type="text" name="subject_name" value="<?php echo htmlspecialchars($subject['subject_name']); ?>" required
            class="w-full border border-gray-300 rounded-lg px-4 py-3 focus:ring-2 focus:ring-blue-500 focus:outline-none"/>

        <button class="w-full bg-blue-600 text-white font-medium py-3 rounded-lg hover:bg-blue-700 transition">Update Subject</button>

        <a href="subjects.php" class="block text-center mt-3 text-gray-600 hover:underline">Back</a>
    </form>

</div>

</body>
</html>