phpcms 批量更新栏目

<?php
// 假设我们有一个数组，包含需要更新的栏目ID和新的标题
$update_data = [
    ['id' => 1, 'title' => '新标题1'],
    ['id' => 2, 'title' => '新标题2'],
    ['id' => 3, 'title' => '新标题3'],
];

// 连接数据库
$db = pc_base::load_model('category_model');
$db->set_model($this->modelid);

foreach ($update_data as $data) {
    $db->update(array('catname' => $data['title']), array('catid' => $data['id']));
}

echo "批量更新完成！";
?>

// 分批处理示例
$batch_size = 10;
$total_count = count($update_data);
for ($i = 0; $i < $total_count; $i += $batch_size) {
    $batch_data = array_slice($update_data, $i, $batch_size);
    foreach ($batch_data as $data) {
        $db->update(array('catname' => $data['title']), array('catid' => $data['id']));
    }
}

$db->begin_transaction();
try {
    foreach ($update_data as $data) {
        $db->update(array('catname' => $data['title']), array('catid' => $data['id']));
    }
    $db->commit();
} catch (Exception $e) {
    $db->rollback();
    echo "批量更新失败：" . $e->getMessage();
}