批量导入产品分类

<?php
// 批量导入产品分类
function importCategories(string $csvFile): int {
    $handle = fopen($csvFile, 'r');
    $count = 0;

    while (($row = fgetcsv($handle)) !== false) {
        [$name, $parentId] = $row;

        $stmt = db()->prepare(
            'INSERT INTO categories (name, parent_id) VALUES (?, ?)'
        );
        $stmt->execute([$name, $parentId]);
        $count++;
    }

    fclose($handle);
    return $count;
}