php采集新闻数据插入数据库

<?php
// 数据库连接配置
$host = 'localhost';
$dbname = 'news_db';
$user = 'db_user';
$pass = 'db_password';

try {
    // 创建PDO实例
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);
    
    // 准备SQL语句
    $stmt = $pdo->prepare("INSERT INTO news (title, content, publish_date) VALUES (:title, :content, :publish_date)");
    
    // 绑定参数并执行
    $stmt->bindParam(':title', $title);
    $stmt->bindParam(':content', $content);
    $stmt->bindParam(':publish_date', $publish_date);
    
    // 假设这些变量已经从新闻网站采集到了数据
    $title = '示例新闻标题';
    $content = '这是新闻的内容。';
    $publish_date = date('Y-m-d H:i:s');
    
    // 执行插入操作
    if ($stmt->execute()) {
        echo "数据插入成功！";
    } else {
        echo "数据插入失败：" . print_r($stmt->errorInfo(), true);
    }
} catch (PDOException $e) {
    echo "数据库连接失败：" . $e->getMessage();
}
?>