connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Variable to hold success or error messages
$activity_message = "";
$attendance_message = "";
// Handle activity creation
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['activity_name']) && isset($_POST['activity_date'])) {
$activity_name = $_POST['activity_name'];
$activity_date = $_POST['activity_date'];
$sql = "INSERT INTO activities1 (activity_name, activity_date) VALUES (?, ?)";
$stmt = $conn->prepare($sql);
if ($stmt === false) {
die("Error preparing the SQL statement: " . $conn->error);
}
$stmt->bind_param("ss", $activity_name, $activity_date);
if ($stmt->execute()) {
$activity_message = "Activity created successfully!";
} else {
$activity_message = "Error: " . $stmt->error;
}
$stmt->close();
}
// Fetch activities
$activities_result = $conn->query("SELECT * FROM activities1");
// Handle attendance check and save
$studentData = "";
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['student_id']) && isset($_POST['activity_id']) && !isset($_POST['attendance_status'])) {
$student_id = $_POST['student_id'];
$activity_id = $_POST['activity_id'];
$sql = "SELECT * FROM student WHERE studentCode = ?";
$stmt = $conn->prepare($sql);
if ($stmt === false) {
die("Error preparing the SQL statement: " . $conn->error);
}
$stmt->bind_param("s", $student_id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$studentData = "
| " . $row["studentCode"] . " |
" . $row["firstname"] . " " . $row["surname"] . " |
มา
มาสาย
ลา
ขาด
|
";
}
} else {
$studentData = "| No results found |
";
}
$stmt->close();
}
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['attendance_status']) && isset($_POST['student_id']) && isset($_POST['activity_id'])) {
$attendance_status = $_POST['attendance_status'];
$student_id = $_POST['student_id'];
$activity_id = $_POST['activity_id'];
$date = date("Y-m-d"); // บันทึกวันที่ปัจจุบัน
$sql = "INSERT INTO attendance1 (student_id, activity_id, status, date) VALUES (?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
if ($stmt === false) {
die("Error preparing the SQL statement: " . $conn->error);
}
$stmt->bind_param("siss", $student_id, $activity_id, $attendance_status, $date);
if ($stmt->execute()) {
$attendance_message = "ข้อมูลถูก Upload ไปยัง Database แล้ว!"; // แสดงข้อความยืนยัน
} else {
$attendance_message = "เกิดข้อผิดพลาดในการ Upload ข้อมูล: " . $stmt->error; // แสดงข้อความข้อผิดพลาด
}
$stmt->close();
}
$conn->close();
?>
Activity Management