Gestionnaire de fichiers - Editer - /home/kridsana/webapp.cm.in.th/663012801/u66301280005/Final/mark_attendance.php
Arrière
<?php session_start(); include "db.php"; if (!isset($_SESSION['admin'])) { header("Location: index.php"); exit(); } if ($_SERVER["REQUEST_METHOD"] == "POST") { $studentCode = $_POST['studentCode']; $status = $_POST['status']; $date = date("Y-m-d"); // ตรวจสอบว่ามีข้อมูลของวันนี้อยู่แล้วหรือไม่ $check_stmt = $conn->prepare("SELECT * FROM attendance WHERE studentCode = ? AND date = ?"); $check_stmt->bind_param("ss", $studentCode, $date); $check_stmt->execute(); $check_result = $check_stmt->get_result(); if ($check_result->num_rows > 0) { // อัปเดตสถานะถ้ามีอยู่แล้ว $update_stmt = $conn->prepare("UPDATE attendance SET status = ? WHERE studentCode = ? AND date = ?"); $update_stmt->bind_param("sss", $status, $studentCode, $date); $update_stmt->execute(); } else { // เพิ่มข้อมูลใหม่ถ้ายังไม่มี $insert_stmt = $conn->prepare("INSERT INTO attendance (studentCode, date, status) VALUES (?, ?, ?)"); $insert_stmt->bind_param("sss", $studentCode, $date, $status); $insert_stmt->execute(); } header("Location: admin.php"); exit(); } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Génération de la page: 0.39 |
proxy
|
phpinfo
|
Réglages