Default page

Your IP: 216.73.216.124
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.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

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

Edit File: add_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());
}

// 获取表单数据
$name = $_POST['name'];
$monday = $_POST['monday'];
$tuesday = $_POST['tuesday'];
$wednesday = $_POST['wednesday'];
$thursday = $_POST['thursday'];
$friday = $_POST['friday'];
$saturday = $_POST['saturday'];
$sunday = $_POST['sunday'];

if (!$name) {
    die('Name is required.');
}

try {
    // 插入数据到数据库
    $stmt = $pdo->prepare("
        INSERT INTO employee_schedule (
            employee_name, schedule_date, monday_status, tuesday_status, 
            wednesday_status, thursday_status, friday_status, 
            saturday_status, sunday_status
        ) VALUES (:name, CURDATE(), :monday, :tuesday, :wednesday, :thursday, :friday, :saturday, :sunday)
    ");
    $stmt->execute([
        ':name' => $name,
        ':monday' => $monday,
        ':tuesday' => $tuesday,
        ':wednesday' => $wednesday,
        ':thursday' => $thursday,
        ':friday' => $friday,
        ':saturday' => $saturday,
        ':sunday' => $sunday
    ]);

echo '数据已成功添加！';
    header("Location: ws.php");
} catch (PDOException $e) {
    echo '数据添加失败: ' . $e->getMessage();
}
?>