phpcms批量发布文章

<?php
// 假设这是你的数据库连接信息
$host = 'localhost';
$dbname = 'phpcms';
$user = 'root';
$pass = '';

// 连接数据库
$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);

// 假设这是你要发布的文章数据
$articles = [
    ['title' => '文章1', 'content' => '这是文章1的内容', 'category_id' => 1],
    ['title' => '文章2', 'content' => '这是文章2的内容', 'category_id' => 2],
    // 更多文章...
];

// 批量插入文章
foreach ($articles as $article) {
    $stmt = $pdo->prepare("INSERT INTO `v9_news` (title, content, category_id) VALUES (:title, :content, :category_id)");
    $stmt->bindParam(':title', $article['title']);
    $stmt->bindParam(':content', $article['content']);
    $stmt->bindParam(':category_id', $article['category_id']);
    $stmt->execute();
}

echo "文章发布成功！";
?>