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: delete-employee.php

<?php
// delete-employee.php

// Include database connection
include('config/db.php');

// Check if 'id' is passed via the URL
if (isset($_GET['id'])) {
    $employee_id = $_GET['id'];

// Prepare SQL statement to delete the employee record
    $query = "DELETE FROM employees WHERE id = ?";
    
    // Prepare and execute the statement
    if ($stmt = mysqli_prepare($conn, $query)) {
        mysqli_stmt_bind_param($stmt, "i", $employee_id);
        $result = mysqli_stmt_execute($stmt);

// Check if deletion was successful
        if ($result) {
            // Redirect back to the employee listing page with a success message
            header("Location: employees.php?message=Employee deleted successfully");
        } else {
            // Redirect back to the employee listing page with an error message
            header("Location: employees.php?message=Failed to delete employee");
        }

// Close the statement
        mysqli_stmt_close($stmt);
    } else {
        // Handle error if the statement cannot be prepared
        header("Location: employees.php?message=Error preparing the query");
    }
} else {
    // If no ID is passed, redirect back to employee list with an error message
    header("Location: employees.php?message=No employee ID provided");
}

// Close the database connection
mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete-employee.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation