Update sign.php

diff --git a/sign.php b/sign.php
index 1c3313c..6249204 100644 (file)
--- a/sign.php
+++ b/sign.php
@@ -9,7 +9,10 @@ if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
 } else {
     $ip = $_SERVER['REMOTE_ADDR'];
 }
-$signed_name_as = $_POST['signed_name_as'];
-$date_of_birth = $_COOKIE['pDOB'];
-$petition->query("insert into signatures (VTRID,ip_address,date_of_birth,date_time_signed,petition_id,signed_name_as) values ('$VTRID','$ip','$date_of_birth',NOW(),'$petition_id','$signed_name_as')");
+$signed_name_as             = $_POST['signed_name_as'];
+$date_of_birth              = $_COOKIE['pDOB'];
+$signed_name_as_circulator  = $_POST['signed_name_as_circulator'];
+$contact_phone              = $_COOKIE['contact_phone'];
+$signature_status           = $_COOKIE['signature_status'];
+$petition->query("insert into signatures (VTRID,ip_address,date_of_birth,date_time_signed,petition_id,signed_name_as,signed_name_as_circulator,contact_phone,signature_status) values ('$VTRID','$ip','$date_of_birth',NOW(),'$petition_id','$signed_name_as','$signed_name_as_circulator','$contact_phone','$signature_status')");
 header('Location: eligible.php');