requireLogin();
// Get article ID from URL
$article_id = $_GET['id'] ?? '';
$plan_id = $_GET['plan_id'] ?? '';
if (empty($article_id) && empty($plan_id)) {
header('Location: content.php');
exit();
}
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
$article = null;
$plan = null;
// Get article data if editing
if (!empty($article_id)) {
$query = "SELECT ca.*, cp.title as plan_title, b.name as brand_name
FROM content_articles ca
LEFT JOIN content_plans cp ON ca.plan_id = cp.id
LEFT JOIN brands b ON cp.brand_id = b.id
WHERE ca.id = :article_id";
$stmt = $db->prepare($query);
$stmt->bindParam(':article_id', $article_id);
$stmt->execute();
$article = $stmt->fetch(PDO::FETCH_ASSOC);
if ($article) {
$plan_id = $article['plan_id'];
}
}
// Get plan data
if (!empty($plan_id)) {
$query = "SELECT cp.*, b.name as brand_name
FROM content_plans cp
LEFT JOIN brands b ON cp.brand_id = b.id
WHERE cp.id = :plan_id";
$stmt = $db->prepare($query);
$stmt->bindParam(':plan_id', $plan_id);
$stmt->execute();
$plan = $stmt->fetch(PDO::FETCH_ASSOC);
}
if (!$plan) {
header('Location: content.php');
exit();
}
?>
<?php echo $article ? '編輯文章' : '新增文章'; ?> - SEO AI 自動化系統