From ca451761ed2f46eec72d93ef5b830aaccd0bbe38 Mon Sep 17 00:00:00 2001
From: Patrick McGuire <insidenothing@gmail.com>
Date: Tue, 21 Jul 2020 16:08:55 -0400
Subject: [PATCH] test db

---
 api/maryland_voter.php | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/api/maryland_voter.php b/api/maryland_voter.php
index 3cb99c8..0a4923c 100644
--- a/api/maryland_voter.php
+++ b/api/maryland_voter.php
@@ -1,7 +1,11 @@
 <?PHP
+/*
 ini_set('display_errors', 1);
 ini_set('display_startup_errors', 1);
 error_reporting(E_ALL);
+*/
+include_once('/var/www/secure.php'); //outside webserver
+
 
 function cut_part_out($start,$end,$whole){
   $parts = explode($start,$whole);
@@ -40,6 +44,7 @@ function getPage($url,$cookie,$post){
 }
 
 function md_voter_lookup($SearchFirstName,$SearchLastName,$DOBMonth,$DOBDay,$DOBYear,$SearchZipCode,$SearchHouseNumber,$SearchMiddleInitial){
+  global $petition;
   $post['ctl00$MainContent$btnSearch'] = "Search";
   $post['btnSearch'] = "Search";
   $post['ctl00$MainContent$listLanguages'] = "en";
@@ -74,6 +79,9 @@ function md_voter_lookup($SearchFirstName,$SearchLastName,$DOBMonth,$DOBDay,$DOB
   //echo "<h1>STEP 2: SBE RESULTS</h1>";
   $return['debug'] = htmlspecialchars($result['html']);
   $return['html']  = $result['html']; 
+  $html = $mysqli->real_escape_string($result['html']);
+  $petition->query("INSERT INTO `RemoteVoterList` (`date_validated`, `txtSearchFirstName`, `txtSearchLastName`, `txtDOBMonth`, `txtDOBDay`, `txtDOBYear`, `txtSearchZipCode`, `txtSearchHouseNumber`, `txtSearchMiddleInitial`, `sbe_response`)
+VALUES (now(), '$SearchFirstName', '$SearchLastName', '$DOBMonth', '$DOBDay', '$DOBYear', '$SearchZipCode', '$SearchHouseNumber', '$SearchMiddleInitial', '$html')");
   return $return;
 }
 
-- 
2.20.1