Update analytics.php

[clinton/MarylandElectronicPetitionSignature.git] / admin / search.php

diff --git a/admin/search.php b/admin/search.php
index 3275a72..0f17dbb 100644 (file)
--- a/admin/search.php
+++ b/admin/search.php
@@ -5,25 +5,23 @@ include_once('security.php');
 include_once('/var/www/secure.php'); //outside webserver
 include_once('functions.php');
 include_once('header.php');
-$FIRSTNAME='';
-if ($_POST['FIRSTNAME']){
-  $FIRSTNAME=$_POST['FIRSTNAME'];
-}
 $LASTNAME='';
 if ($_POST['LASTNAME']){
   $LASTNAME=$_POST['LASTNAME'];
 }
-if($FIRSTNAME != '' && $LASTNAME != ''){
-  $q = "select * from VoterList where FIRSTNAME = '$FIRSTNAME' and LASTNAME = '$LASTNAME' ";
+if($LASTNAME != ''){
+  echo "<ol>";
+  $q = "select * from VoterList2 where LASTNAME like '%$LASTNAME%' limit 0, 5000 ";
   echo "$q";
   $r = $petition->query($q);
   while ($d = mysqli_fetch_array($r,MYSQLI_ASSOC)){
-  echo "<li>House Number: $d[HOUSE_NUMBER] Zip Code: $d[RESIDENTIALZIP5]</li>";
+   echo "<li>'$d[FIRSTNAME]' '$d[LASTNAME]' '$d[HOUSE_NUMBER]' '$d[RESIDENTIALZIP5]'</li>";
   }
+  echo "</ol>";
 }
 ?>
 <form method='POST'>
-<input name='FIRSTNAME'><input name='LASTNAME'><input type='submit'>
+Last Name <input name='LASTNAME'><input type='submit'>
 </form>
 
 <?