dedecms 代码批量

<?php
// 数据库连接配置
$host = 'localhost';
$user = 'root';
$password = '123456';
$dbname = 'dedecms';

// 连接数据库
$conn = new mysqli($host, $user, $password, $dbname);

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

// 开启事务
$conn->begin_transaction();

try {
    // 批量修改字段值的SQL语句
    $sql = "UPDATE `dede_archives` SET `status` = '1' WHERE `id` IN (1, 2, 3)";
    
    // 执行SQL语句
    if ($conn->query($sql) === TRUE) {
        // 提交事务
        $conn->commit();
        echo "批量修改成功";
    } else {
        // 回滚事务
        $conn->rollback();
        echo "批量修改失败: " . $conn->error;
    }
} catch (Exception $e) {
    // 回滚事务
    $conn->rollback();
    echo "发生异常: " . $e->getMessage();
}

// 关闭数据库连接
$conn->close();
?>

<?php
// 上传文件目录
$uploadDir = './uploads/';

// 创建上传目录（如果不存在）
if (!file_exists($uploadDir)) {
    mkdir($uploadDir, 0777, true);
}

// 处理上传的文件
if ($_FILES['files']['name'][0]) {
    $fileCount = count($_FILES['files']['name']);
    for ($i = 0; $i < $fileCount; $i++) {
        $tmpFilePath = $_FILES['files']['tmp_name'][$i];
        if ($tmpFilePath != "") {
            $newFilePath = $uploadDir . $_FILES['files']['name'][$i];
            if (move_uploaded_file($tmpFilePath, $newFilePath)) {
                echo "文件 " . $_FILES['files']['name'][$i] . " 上传成功<br>";
            } else {
                echo "文件 " . $_FILES['files']['name'][$i] . " 上传失败<br>";
            }
        }
    }
}
?>

<!-- HTML表单 -->
<form action="" method="post" enctype="multipart/form-data">
    <input type="file" name="files[]" multiple>
    <input type="submit" value="上传">
</form>