Meraki Infrastructure FormulaAES 4.0

"", 'database' => "", 'cloud' => "", 'code' => "", 'globe' => "" ]; $color_index = 0; try { $stmt = $conn->prepare('SELECT * FROM "REPOSITORY" ORDER BY "REPOSITORY_NAME" ASC'); $stmt->execute(); $repositories = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($repositories as $repo) { // --- New: Assign random icon and cycling color --- $color = $icon_colors[$color_index % count($icon_colors)]; $color_index++; $random_icon_key = array_rand($tech_icons); $icon_html = str_replace(' {$icon_html} " . htmlspecialchars($repo['REPOSITORY_NAME'], ENT_QUOTES, 'UTF-8') . " {$chevron_svg} "; $stmtProjects = $conn->prepare('SELECT * FROM "PROJECT" WHERE "REPOSITORY_ID" = :repo_id ORDER BY "PROJECT_NAME" ASC'); $stmtProjects->bindParam(':repo_id', $repo['REPOSITORY_ID'], PDO::PARAM_INT); $stmtProjects->execute(); $projects = $stmtProjects->fetchAll(PDO::FETCH_ASSOC); echo "

"; foreach ($projects as $project) { $project_icon = ""; echo " {$project_icon} " . htmlspecialchars($project['PROJECT_NAME'], ENT_QUOTES, 'UTF-8') . " {$chevron_svg} "; $stmtComponents = $conn->prepare('SELECT * FROM "COMPONENT" WHERE "PROJECT_ID" = :project_id ORDER BY "COMPONENT_NAME" ASC'); $stmtComponents->bindParam(':project_id', $project['PROJECT_ID'], PDO::PARAM_INT); $stmtComponents->execute(); $components = $stmtComponents->fetchAll(PDO::FETCH_ASSOC); echo "

"; foreach ($components as $component) { $component_icon = ""; echo " {$component_icon} " . htmlspecialchars($component['COMPONENT_NAME'], ENT_QUOTES, 'UTF-8') . " "; } echo "

"; } echo "

"; } } catch(PDOException $e) { echo "Error: " . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); } $conn = null; ?>