requireLogin();
// Get brands data
require_once '../config/database.php';
$database = new Database();
$db = $database->getConnection();
$brands = [];
$query = "SELECT * FROM brands ORDER BY created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$brands = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get recent reports
$reports_query = "SELECT sr.*, b.name as brand_name FROM seo_reports sr
LEFT JOIN brands b ON sr.brand_id = b.id
ORDER BY sr.created_at DESC LIMIT 10";
$reports_stmt = $db->prepare($reports_query);
$reports_stmt->execute();
$recent_reports = $reports_stmt->fetchAll(PDO::FETCH_ASSOC);
// Get brand_id from URL parameter
$selected_brand_id = $_GET['brand_id'] ?? '';
?>
SEO分析 - SEO AI 自動化系統