query($q); $d = mysqli_fetch_array($r,MYSQLI_ASSOC); return $d['petition_name']; } $signed_name_as = $petition->real_escape_string($_POST['signed_name_as']); $date_of_birth = $petition->real_escape_string($_COOKIE['pDOB']); $signed_name_as_circulator = $petition->real_escape_string($_POST['signed_name_as_circulator']); $contact_phone = $petition->real_escape_string($_COOKIE['pPHONE']); $signature_status = $petition->real_escape_string($_COOKIE['signature_status']); $bot_check = $petition->real_escape_string($_SERVER['HTTP_USER_AGENT']); global $time_on_site; if (empty($_COOKIE['start_time'])){ setcookie("start_time", time()); $time_on_site = 0; }else{ $now = time(); $time_on_site = $now - $_COOKIE['start_time']; } $petition->query("insert into signatures (bot_check,VTRID,ip_address,date_of_birth,date_time_signed,just_date,petition_id,signed_name_as,signed_name_as_circulator,contact_phone,signature_status) values ('$bot_check','$VTRID','$ip','$date_of_birth',NOW(),NOW(),'$petition_id','$signed_name_as','$signed_name_as_circulator','$contact_phone','$signature_status')") or die(mysqli_error($petition)); if($petition_id == '' || $petition_id == '0'){ slack_general_admin("MISSING petition_id",'md-petition-signed'); echo "