Update eligible.php
[clinton/MarylandElectronicPetitionSignature.git] / 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-6'>$d2[petition_name]</div>
41 <div class='col-sm-4'>$field == $pass</div>
42 </div>";
43 }else{
44 $available .= "<div class='row'>
45 <div class='col-sm-2'> </div>
46 <div class='col-sm-6'><del>$d2[petition_name]</del></div>
47 <div class='col-sm-4'>$field != $pass</div>
48 </div>";
49 }
50 }
51 ?>
52 <div class='row'>
53 <div class='col-sm-12'>You Are eligible to sign each of these petitions.</div>
54 </div>
55
56 <?PHP echo $available;?>
57
58 <div class='row'>
59 <div class='col-sm-12' style='height:100px; text-align:center;'><button type="button" class="btn btn-success">Next</button><div>
60 </div>
61
62
63 <?PHP include_once('footer.php');