requireLogin();
echo "內容管理API測試
";
try {
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
// Test database connection
echo "資料庫連接測試
";
echo "✅ 資料庫連接成功
";
// Test content_plans table structure
echo "content_plans表結構測試
";
$required_fields = ['id', 'brand_id', 'title', 'description', 'target_keywords', 'duration_months', 'frequency_per_week', 'status'];
$query = "DESCRIBE content_plans";
$stmt = $db->prepare($query);
$stmt->execute();
$fields = $stmt->fetchAll(PDO::FETCH_ASSOC);
$existing_fields = array_column($fields, 'Field');
foreach ($required_fields as $field) {
if (in_array($field, $existing_fields)) {
echo "✅ 欄位 '{$field}' 存在
";
} else {
echo "❌ 欄位 '{$field}' 不存在
";
}
}
// Test content_articles table
echo "content_articles表測試
";
$query = "SELECT COUNT(*) as count FROM content_articles";
$stmt = $db->prepare($query);
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
echo "✅ content_articles表存在，目前有 {$result['count']} 筆記錄
";
// Test API call
echo "API調用測試
";
echo "";
echo "";
} catch (Exception $e) {
echo "❌ 發生錯誤: " . htmlspecialchars($e->getMessage()) . "
";
}
?>