--- a/displayAgency.php +++ b/displayAgency.php @@ -4,9 +4,9 @@ include_header("Agency"); $agency = htmlentities(strip_tags($_REQUEST['agency'])); - echo '<img src="graphs/displayMethodCountGraph.php?agency=' . stripslashes($agency) . '">'; - echo '<img src="graphs/displayCnCGraph.php?agency=' . stripslashes($agency) . '">'; - echo '<img src="graphs/displayMethodValueGraph.php?agency=' . stripslashes($agency) . '">'; + MethodCountGraph($agency); + CnCGraph($agency); + MethodValueGraph($agency); /*biggest contracts spending by year spending by industry/category @@ -63,9 +63,10 @@ split by portfolio */ include_header("Agencies"); +agenciesGraph(); $query = 'SELECT SUM("value"), "agencyName" FROM contractnotice -WHERE "childCN" = 0 +WHERE "childCN" is null GROUP BY "agencyName" '; $query = $conn->prepare($query); $query->execute();