<?php
require './security.php';
include_once '../scripts/DBAccess.php';
$constellationResult = DBAccess::getConstellations();
$rows = count($constellationResult, 0);
$title = 'Constellations';
$head = '';
$content = " <h1 class=\"heading\">Manage Constellations</h1>\t\n\n<div class='container'>\n<table class=\"eventsTable\" cellspacing=\"0\">\n<tr>\n<th class=\"width20\" >Name</th>\n<th class=\"width50\" >Description</th>\n<th class=\"width20\" >Cartoon</th>\n<th class=\"width10\" >Count</th>\n</tr>\n";
for ($i = 0; $i < $rows; $i++) {
$starPairResult = DBAccess::getStarPairs($constellationResult[$i]['ConstellationID']);
$count = count($starPairResult, 0);
$content = $content . "\n\n\t<tr>\n\t<td class=\"conRow\" >" . $constellationResult[$i]['ConstellationName'] . "</td> \n\t<td class=\"conRow\" >" . $constellationResult[$i]['ConstellationDescription'] . "</td> \n\t<td class=\"conRow\" ><img class=\"width100\" alt=\"Picture of " . $constellationResult[$i]['ConstellationName'] . "\" src=\"" . $constellationResult[$i]['ConstellationCartoon'] . "\" /></td> \n\t<td class=\"conRow centre\" >" . $count . "</td> \n\t<tr /> \n\t\n\t";
}
$content = $content . "\t\n</table></div>";
require '../template/adminTemplate.php';
