phpcms 批量更新栏目页

// 示例代码：使用事务处理批量更新
try {
    $db->beginTransaction();
    foreach ($updateData as $data) {
        $sql = "UPDATE `phpcms_category` SET `title` = :title WHERE `catid` = :catid";
        $stmt = $db->prepare($sql);
        $stmt->bindParam(':title', $data['title']);
        $stmt->bindParam(':catid', $data['catid']);
        $stmt->execute();
    }
    $db->commit();
} catch (Exception $e) {
    $db->rollBack();
    echo "更新失败: " . $e->getMessage();
}

// 示例代码：分批处理批量更新
$batchSize = 100;
$totalCount = count($updateData);
for ($i = 0; $i < $totalCount; $i += $batchSize) {
    $batchData = array_slice($updateData, $i, $batchSize);
    // 执行批量更新操作
}