eligible.php

   1 <?PHP
   2 ob_start();
   3 include_once('header.php');
   4 $head = ob_get_clean();
   5 $web_first_name   = $_COOKIE['web_first_name'];
   6 $web_last_name    = $_COOKIE['web_last_name'];
   7 $web_house_number = $_COOKIE['web_house_number'];
   8 $web_zip_code     = $_COOKIE['web_zip_code'];
   9 if ($web_first_name != '' && $web_last_name != '' && $web_house_number != '' && $web_zip_code != ''){
  10   // ok to check for records
  11 }else{
  12   header('Location: warning_incomplete.php');
  13 }
  14 $q = "select * from VoterList where LASTNAME = '$web_last_name' and FIRSTNAME = '$web_first_name' and HOUSE_NUMBER = '$web_house_number' and RESIDENTIALZIP5 = '$web_zip_code'";
  15 $r = $petition->query($q);
  16 $d = mysqli_fetch_array($r);
  17 if ($d['VTRID'] != ''){
  18    $VTRID      = $d['VTRID'];
  19    $FIRSTNAME  = $d['FIRSTNAME'];
  20    $MIDDLENAME = $d['MIDDLENAME'];
  21    $LASTNAME   = $d['LASTNAME'];
  22    $ADDRESS    = $d['ADDRESS'];
  23    $RESIDENTIALCITY   = $d['RESIDENTIALCITY'];
  24    $COUNTY            = $d['COUNTY'];
  25    $RESIDENTIALZIP5   = $d['RESIDENTIALZIP5'];
  26 }else{
  27    header('Location: warning_not_found.php');
  28 }
  29 echo $head;
  30
  31 $available='';
  32 $q2 = "SELECT * FROM petitions";
  33 $r2 = $petition->query($q2);
  34 while($d2 = mysqli_fetch_array($r2)){
  35  $field = $d2['eligibleVoterListField'];
  36  $pass = $d2['eligibleVoterListEquals'];
  37  if ($d[$field] == $pass){
  38    $available .= "<div class='row'>
  39   <div class='col-sm-2'><input type='radio' id='petition' name='petition" value='$d2[petition_id]'"> </div>
  40   <div class='col-sm-8'>$d2[petition_name]</div>
  41   <div class='col-sm-2'>$field == $pass</div>
  42     </div>";
  43  }
  44
  45 }
  46
  47
  48
  49 ?>
  50 <div class='row'>
  51  <div class='col-sm-12'> You Are also eligible to sign each of these petitions [location name] </div>
  52 </div>
  53
  54 <?PHP echo $available;?>
  55
  56   <div class='row'>
  57     <div class='col-sm-12'>  <button type="button" class="btn btn-success">Next</button> <div>
  58    </div>
  59
  60
  61 <?PHP include_once('footer.php');