Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/admin

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: update_attendance.php

<?php
include 'config/db.php';

$id = $_POST['id'];
$employee_id = $_POST['employee_id'];
$status = $_POST['status'];
$check_in = $_POST['check_in'];
$check_out = $_POST['check_out'];
$notes = $_POST['notes'];
$recorded_by = $employee_id; // assuming self-punched, adjust if admin is recording
$date = date('Y-m-d'); // You can also pass this from frontend if needed

if ($id) {
    // ✅ UPDATE existing attendance
    $stmt = $conn->prepare("UPDATE attendance SET status = ?, check_in = ?, check_out = ?, notes = ? WHERE id = ?");
    $stmt->bind_param("ssssi", $status, $check_in, $check_out, $notes, $id);
    $stmt->execute();
} else {
    // ✅ INSERT new attendance
    // Check if already exists for safety (optional)
    $check = $conn->prepare("SELECT id FROM attendance WHERE employee_id = ? AND date = ?");
    $check->bind_param("is", $employee_id, $date);
    $check->execute();
    $check->store_result();

if ($check->num_rows > 0) {
        // If already exists, update it
        $check->bind_result($existing_id);
        $check->fetch();
        $stmt = $conn->prepare("UPDATE attendance SET status = ?, check_in = ?, check_out = ?, notes = ? WHERE id = ?");
        $stmt->bind_param("ssssi", $status, $check_in, $check_out, $notes, $existing_id);
        $stmt->execute();
    } else {
        // Otherwise insert
        $stmt = $conn->prepare("INSERT INTO attendance (employee_id, date, status, check_in, check_out, notes, recorded_by) VALUES (?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("isssssi", $employee_id, $date, $status, $check_in, $check_out, $notes, $recorded_by);
        $stmt->execute();
    }
}

header("Location: attendance-report.php");
exit();

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update_attendance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation