Update report.php

diff --git a/admin/report.php b/admin/report.php
index b32a164..06c1da6 100644 (file)
--- a/admin/report.php
+++ b/admin/report.php
@@ -1,20 +1,19 @@
 <?PHP 
-
 include_once('security.php');
-
 include_once('header.php');
 slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
-?>
-
-<h1>Petition Reports</h1>
-
-
-
-<pre>
-<?PHP print_r($_COOKIE); ?>
-</pre>
-
+$group_id = $_COOKIE['group_id'];
+$q="SELECT * FROM petitions where group_id = '$group_id'";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){
+  echo "<h1>$d[petition_name]</h1>";
+ $pID = $d['petition_id'];
+  $q2="SELECT * FROM signatures where group_id = '$group_id'";
+  $r2 = $petition->query($q2);
+  while($d2 = mysqli_fetch_array($r2)){
+    echo "<li>$d[date_time_signed] $d[signed_name_as] $d[signed_name_as_circulator] $d[contact_phone]</li>";
+  }
+}
 
-<?PHP
 include_once('footer.php');
 ?>