admin/search.php

   1 <?PHP
   2 include_once('bots.php');
   3 include_once('../slack.php');
   4 include_once('security.php');
   5 include_once('/var/www/secure.php'); //outside webserver
   6 include_once('functions.php');
   7 include_once('header.php');
   8 $LASTNAME='';
   9 if ($_POST['LASTNAME']){
  10   $LASTNAME=$_POST['LASTNAME'];
  11 }
  12 if($LASTNAME != ''){
  13   echo "<ol>";
  14   $q = "select * from VoterList2 where LASTNAME like '%$LASTNAME%' limit 0, 5000 ";
  15   echo "$q";
  16   $r = $petition->query($q);
  17   while ($d = mysqli_fetch_array($r,MYSQLI_ASSOC)){
  18    echo "<li>'$d[FIRSTNAME]' '$d[LASTNAME]' '$d[HOUSE_NUMBER]' '$d[RESIDENTIALZIP5]'</li>";
  19   }
  20   echo "</ol>";
  21 }
  22 ?>
  23 <form method='POST'>
  24 Last Name <input name='LASTNAME'><input type='submit'>
  25 </form>
  26
  27 <?
  28
  29
  30 include_once('footer.php');