One Hat Cyber Team

Your IP : 3.144.105.255

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: update_shift.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) {
    echo json_encode(['success' => false, 'message' => 'Database connection failed: ' . $e->getMessage()]);
    exit;
}

// 获取数据
$employeeName = $_POST['employee_name'];
$day = strtolower($_POST['day']) . '_status'; // 将 day 转换为数据库字段名
$shiftStatus = $_POST['shift_status'];

if (!$employeeName || !$day || !$shiftStatus) {
    echo json_encode(['success' => false, 'message' => 'Invalid input data']);
    exit;
}

try {
    // 更新数据库
    $stmt = $pdo->prepare("UPDATE employee_schedule SET $day = :shift_status WHERE employee_name = :employee_name");
    $stmt->execute([
        ':shift_status' => $shiftStatus,
        ':employee_name' => $employeeName,
    ]);

echo json_encode(['success' => true, 'message' => 'Shift updated successfully']);
} catch (PDOException $e) {
    echo json_encode(['success' => false, 'message' => 'Update failed: ' . $e->getMessage()]);
}