One Hat Cyber Team

Your IP : 18.119.120.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

View File Name : delete_schedule.php

<?php
// 数据库连接配置
$host = "localhost";
$dbname = "t001";
$username = "t001";
$password = "ZRTsRb6Ycp585AEC";

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die('数据库连接失败: ' . $e->getMessage());
}

// 获取要删除的班次ID
if (isset($_GET['id'])) {
    $id = intval($_GET['id']); // 确保ID是整数
    $stmt = $pdo->prepare("DELETE FROM employee_schedule WHERE id = :id");
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);

    if ($stmt->execute()) {
        header('Location: ws.php'); // 删除后重定向到班次列表页面
        exit;
    } else {
        echo "删除失败！";
    }
} else {
    echo "无效的请求！";
}
?>