| Server IP : 172.67.187.206 / Your IP : 172.71.28.156 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/training/group/ |
Upload File : |
<?php
include("../session.php");
if ($role != 'group') {
header("Location: ../index.php");
exit;
}
$name = "";
$pass_percentage = "80";
$curriculum_year = "2565-2567";
$is_edit = false;
// แก้ไข: ดึงข้อมูลเดิม
if (isset($_GET['id'])) {
$is_edit = true;
$id = intval($_GET['id']);
$result = mysqli_query($conn, "SELECT * FROM subjects WHERE id = $id AND group_id = $user_id");
if ($row = mysqli_fetch_assoc($result)) {
$name = $row['name'];
$pass_percentage = $row['pass_percentage'];
$curriculum_year = $row['curriculum_year'];
} else {
echo "ไม่พบข้อมูลวิชา หรือไม่มีสิทธิ์แก้ไขวิชานี้";
exit;
}
}
// บันทึกข้อมูล
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = trim($_POST['name']);
$pass_percentage = intval($_POST['pass_percentage']);
$curriculum_year = $_POST['curriculum_year'];
if ($is_edit) {
$sql = "UPDATE subjects SET name = '$name', pass_percentage = $pass_percentage, curriculum_year = '$curriculum_year' WHERE id = $id AND group_id = $user_id";
} else {
$sql = "INSERT INTO subjects (name, group_id, pass_percentage, curriculum_year) VALUES ('$name', $user_id, $pass_percentage, '$curriculum_year')";
}
mysqli_query($conn, $sql);
header("Location: subjects.php");
exit;
}
?>
<!DOCTYPE html>
<html lang="th">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title><?php echo $is_edit ? "แก้ไข" : "เพิ่ม"; ?> วิชา</title>
<!-- Bootstrap 5 CSS -->
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- Font Awesome Icons -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
:root {
--primary-color: #4e73df;
--secondary-color: #858796;
--success-color: #1cc88a;
--danger-color: #e74a3b;
--warning-color: #f6c23e;
--light-bg: #f8f9fc;
}
body {
background-color: var(--light-bg);
font-family: 'Prompt', sans-serif;
padding-top: 56px;
}
.main-navbar {
background: linear-gradient(90deg, var(--primary-color) 0%, #224abe 100%);
padding: 0.5rem 1rem;
}
.main-navbar .navbar-brand {
color: white;
font-weight: 600;
}
.main-navbar .nav-link {
color: rgba(255, 255, 255, 0.8);
padding: 0.75rem 1rem;
border-radius: 0.375rem;
transition: all 0.3s;
margin: 0 0.25rem;
}
.main-navbar .nav-link:hover,
.main-navbar .nav-link.active {
color: white;
background-color: rgba(255, 255, 255, 0.1);
}
.main-navbar .nav-link i {
margin-right: 0.5rem;
}
.card {
border: none;
border-radius: 0.5rem;
box-shadow: 0 0.15rem 1.75rem 0 rgba(58, 59, 69, 0.1);
margin-bottom: 1.5rem;
}
.card-header {
background-color: #f8f9fc;
border-bottom: 1px solid #e3e6f0;
padding: 1rem 1.25rem;
}
.btn-primary {
background-color: var(--primary-color);
border-color: var(--primary-color);
}
.btn-success {
background-color: var(--success-color);
border-color: var(--success-color);
}
.user-dropdown .dropdown-toggle::after {
display: none;
}
.user-dropdown .dropdown-toggle {
display: flex;
align-items: center;
color: rgba(255, 255, 255, 0.8);
text-decoration: none;
}
.user-dropdown .dropdown-toggle:hover {
color: white;
}
.user-dropdown .dropdown-menu {
margin-top: 0.5rem;
border: none;
box-shadow: 0 0.5rem 1rem rgba(0, 0, 0, 0.15);
}
@media (max-width: 992px) {
.navbar-collapse {
background-color: var(--primary-color);
padding: 1rem;
border-radius: 0.5rem;
margin-top: 0.5rem;
}
}
</style>
<!-- Font from Google Fonts -->
<link href="https://fonts.googleapis.com/css2?family=Prompt:wght@300;400;500;600;700&display=swap" rel="stylesheet">
</head>
<body>
<!-- Main Navbar -->
<nav class="navbar navbar-expand-lg fixed-top main-navbar">
<div class="container-fluid">
<a class="navbar-brand" href="#">
<i class="fas fa-laptop-code me-2"></i>
ระบบข้อสอบออนไลน์
</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav"
aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav me-auto">
<li class="nav-item">
<a class="nav-link" href="dashboard.php">
<i class="fas fa-tachometer-alt"></i>
ภาพรวม
</a>
</li>
<li class="nav-item">
<a class="nav-link active" href="subjects.php">
<i class="fas fa-book"></i>
จัดการวิชา
</a>
</li>
</ul>
<div class="user-dropdown dropdown">
<a href="#" class="dropdown-toggle" id="userDropdown" data-bs-toggle="dropdown" aria-expanded="false">
<div>
<div class="fw-bold text-white"><?php echo htmlspecialchars($u_name); ?></div>
<!-- <div class="small" style="color: rgba(255, 255, 255, 0.7);">กลุ่ม</div> -->
</div>
<i class="fas fa-chevron-down ms-2"></i>
</a>
<ul class="dropdown-menu dropdown-menu-end shadow">
<li><a class="dropdown-item" href="../logout.php"><i class="fas fa-sign-out-alt me-2"></i> ออกจากระบบ</a></li>
</ul>
</div>
</div>
</div>
</nav>
<!-- Main Content -->
<div class="container-fluid px-4 mt-4">
<div class="card">
<div class="card-header d-flex justify-content-between align-items-center">
<h6 class="m-0 fw-bold"><?php echo $is_edit ? "แก้ไข" : "เพิ่ม"; ?> วิชา</h6>
<a href="subjects.php" class="btn btn-sm btn-secondary"><i class="fas fa-arrow-left me-1"></i> กลับ</a>
</div>
<div class="card-body">
<form method="post" action="">
<div class="mb-3">
<label for="name" class="form-label">ชื่อวิชา</label>
<input type="text" name="name" id="name" class="form-control" required value="<?php echo htmlspecialchars($name); ?>">
</div>
<div class="mb-3">
<label for="curriculum_year" class="form-label">หลักสูตรปี</label>
<select name="curriculum_year" id="curriculum_year" class="form-select" required>
<option value="2565-2567" <?php echo $curriculum_year == "2565-2567" ? "selected" : ""; ?>>2565-2567</option>
<option value="2568" <?php echo $curriculum_year == "2568" ? "selected" : ""; ?>>2568</option>
</select>
</div>
<div class="mb-3">
<label for="pass_percentage" class="form-label">เปอร์เซ็นต์ที่ต้องผ่าน (%)</label>
<input type="number" name="pass_percentage" id="pass_percentage" class="form-control" required min="1" max="100" value="<?php echo htmlspecialchars($pass_percentage); ?>">
</div>
<button type="submit" class="btn btn-success"><?php echo $is_edit ? "อัปเดต" : "บันทึก"; ?></button>
</form>
</div>
</div>
</div>
<!-- Bootstrap Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>