PHP

<?php
$fname = filter_input(INPUT_POST, 'fname', FILTER_SANITIZE_STRING);
$middle = filter_input(INPUT_POST, 'middle', FILTER_SANITIZE_STRING);
$lname = filter_input(INPUT_POST, 'lname', FILTER_SANITIZE_STRING);
$address = filter_input(INPUT_POST, 'address', FILTER_SANITIZE_STRING);
$city = filter_input(INPUT_POST, 'city', FILTER_SANITIZE_STRING);
$state = filter_input(INPUT_POST, 'state', FILTER_SANITIZE_STRING);
$zip = filter_input(INPUT_POST, 'zip', FILTER_SANITIZE_STRING);
$county = filter_input(INPUT_POST, 'county', FILTER_SANITIZE_STRING);
$mailing = filter_input(INPUT_POST, 'mailing', FILTER_SANITIZE_STRING);
$hphone = filter_input(INPUT_POST, 'hphone', FILTER_SANITIZE_STRING);
$mphone = filter_input(INPUT_POST, 'mphone', FILTER_SANITIZE_STRING);
$wphone = filter_input(INPUT_POST, 'wphone', FILTER_SANITIZE_STRING);
$ext = filter_input(INPUT_POST, 'ext', FILTER_SANITIZE_STRING);
$fax = filter_input(INPUT_POST, 'fax', FILTER_SANITIZE_STRING);
$email = filter_input(INPUT_POST, 'email', FILTER_VALIDATE_EMAIL);
$ethgroup = filter_input(INPUT_POST, 'ethgroup', FILTER_SANITIZE_STRING);
$other1 = filter_input(INPUT_POST, 'other1', FILTER_SANITIZE_STRING);
$occupation = filter_input(INPUT_POST, 'occupation', FILTER_SANITIZE_STRING);
$poe = filter_input(INPUT_POST, 'poe', FILTER_SANITIZE_STRING);
$dob = filter_input(INPUT_POST, 'dob', FILTER_SANITIZE_NUMBER_INT);
$gender = filter_input(INPUT_POST, 'gender', FILTER_SANITIZE_STRING);
$bhv = filter_input(INPUT_POST, 'bhv', FILTER_SANITIZE_STRING);
$mrc = filter_input(INPUT_POST, 'mrc', FILTER_SANITIZE_STRING);
$general = filter_input(INPUT_POST, 'general', FILTER_SANITIZE_STRING);
$evv = filter_input(INPUT_POST, 'evv', FILTER_SANITIZE_STRING);
$all = filter_input(INPUT_POST, 'all', FILTER_SANITIZE_STRING);
$fillmore = filter_input(INPUT_POST, 'fillmore', FILTER_SANITIZE_STRING);
$johnson = filter_input(INPUT_POST, 'johnson', FILTER_SANITIZE_STRING);
$otoe = filter_input(INPUT_POST, 'otoe', FILTER_SANITIZE_STRING);
$richardson = filter_input(INPUT_POST, 'richardson', FILTER_SANITIZE_STRING);
$seward = filter_input(INPUT_POST, 'seward', FILTER_SANITIZE_STRING);
$butler = filter_input(INPUT_POST, 'butler', FILTER_SANITIZE_STRING);
$gage = filter_input(INPUT_POST, 'gage', FILTER_SANITIZE_STRING);
$lancaster = filter_input(INPUT_POST, 'lancaster', FILTER_SANITIZE_STRING);
$pawnee = filter_input(INPUT_POST, 'pawnee', FILTER_SANITIZE_STRING);
$saline = filter_input(INPUT_POST, 'saline', FILTER_SANITIZE_STRING);
$thayer = filter_input(INPUT_POST, 'thayer', FILTER_SANITIZE_STRING);
$cass = filter_input(INPUT_POST, 'cass', FILTER_SANITIZE_STRING);
$jefferson = filter_input(INPUT_POST, 'jefferspm', FILTER_SANITIZE_STRING);
$nemaha = filter_input(INPUT_POST, 'nemaha', FILTER_SANITIZE_STRING);
$polk = filter_input(INPUT_POST, 'polk', FILTER_SANITIZE_STRING);
$saunders = filter_input(INPUT_POST, 'saunders', FILTER_SANITIZE_STRING);
$york = filter_input(INPUT_POST, 'york', FILTER_SANITIZE_STRING);
$aro = filter_input(INPUT_POST, 'aro', FILTER_SANITIZE_STRING);
$clergy = filter_input(INPUT_POST, 'clergy', FILTER_SANITIZE_STRING);
$intskills = filter_input(INPUT_POST, 'intskills', FILTER_SANITIZE_STRING);
$bus = filter_input(INPUT_POST, 'bus', FILTER_SANITIZE_STRING);
$child = filter_input(INPUT_POST, 'child', FILTER_SANITIZE_STRING);
$law = filter_input(INPUT_POST, 'law', FILTER_SANITIZE_STRING);
$cpr = filter_input(INPUT_POST, 'cpr', FILTER_SANITIZE_STRING);
$data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING);
$security = filter_input(INPUT_POST, 'security', FILTER_SANITIZE_STRING);
$emergency = filter_input(INPUT_POST, 'emergency', FILTER_SANITIZE_STRING);
$computer = filter_input(INPUT_POST, 'computer', FILTER_SANITIZE_STRING);
$mechanical = filter_input(INPUT_POST, 'mechanical', FILTER_SANITIZE_STRING);
$administration = filter_input(INPUT_POST, 'administration', FILTER_SANITIZE_STRING);
$firstaid = filter_input(INPUT_POST, 'firstaid', FILTER_SANITIZE_STRING);
$translation = filter_input(INPUT_POST, 'translation', FILTER_SANITIZE_STRING);
$construction = filter_input(INPUT_POST, 'construction', FILTER_SANITIZE_STRING);
$basicclean = filter_input(INPUT_POST, 'basicclean', FILTER_SANITIZE_STRING);
$foodprep = filter_input(INPUT_POST, 'foodprep', FILTER_SANITIZE_STRING);
$animalcare = filter_input(INPUT_POST, 'animalcare', FILTER_SANITIZE_STRING);
$heavy = filter_input(INPUT_POST, 'heavy', FILTER_SANITIZE_STRING);
$dataentry = filter_input(INPUT_POST, 'dataentry', FILTER_SANITIZE_STRING);
$identifcation = filter_input(INPUT_POST, 'identification', FILTER_SANITIZE_STRING);
$phone = filter_input(INPUT_POST, 'phone', FILTER_SANITIZE_STRING);
$runner = filter_input(INPUT_POST, 'runner', FILTER_SANITIZE_STRING);
$greeter = filter_input(INPUT_POST, 'greeter', FILTER_SANITIZE_STRING);
$interviewer = filter_input(INPUT_POST, 'interviewer', FILTER_SANITIZE_STRING);
$safety = filter_input(INPUT_POST, 'safety', FILTER_SANITIZE_STRING);
$other2 = filter_input(INPUT_POST, 'other2', FILTER_SANITIZE_STRING);
$interpt = filter_input(INPUT_POST, 'interpt', FILTER_SANITIZE_STRING);
$cdl = filter_input(INPUT_POST, 'cdl', FILTER_SANITIZE_STRING);
$cpryn = filter_input(INPUT_POST, 'cpryn', FILTER_SANITIZE_STRING);
$translate = filter_input(INPUT_POST, 'translate', FILTER_SANITIZE_STRING);
$other3 = filter_input(INPUT_POST, 'other3', FILTER_SANITIZE_STRING);
$license1 = filter_input(INPUT_POST, 'license1', FILTER_SANITIZE_STRING);
$verf1 = filter_input(INPUT_POST, 'verf1',FILTER_SANITIZE_NUMBER_INT);
$num1 = filter_input(INPUT_POST, 'num1', FILTER_SANITIZE_STRING);
$exp1 = filter_input(INPUT_POST, 'exp1', FILTER_SANITIZE_NUMBER_INT);
$license2 = filter_input(INPUT_POST, 'license2', FILTER_SANITIZE_STRING);
$verf2 = filter_input(INPUT_POST, 'verf2', FILTER_SANITIZE_NUMBER_INT);
$num2 = filter_input(INPUT_POST, 'num2', FILTER_SANITIZE_STRING);
$exp2 = filter_input(INPUT_POST, 'exp2', FILTER_SANITIZE_NUMBER_INT);
$license3 = filter_input(INPUT_POST, 'license3', FILTER_SANITIZE_STRING);
$verf3 = filter_input(INPUT_POST, 'verf3', FILTER_SANITIZE_NUMBER_INT);
$num3 = filter_input(INPUT_POST, 'num3', FILTER_SANITIZE_STRING);
$exp3 = filter_input(INPUT_POST, 'exp3', FILTER_SANITIZE_NUMBER_INT);
$license4 = filter_input(INPUT_POST, 'license4', FILTER_SANITIZE_STRING);
$verf4 = filter_input(INPUT_POST, 'verf4', FILTER_SANITIZE_NUMBER_INT);
$num4 = filter_input(INPUT_POST, 'num4', FILTER_SANITIZE_STRING);
$exp4 = filter_input(INPUT_POST, 'exp4', FILTER_SANITIZE_NUMBER_INT);
$license5 = filter_input(INPUT_POST, 'license5', FILTER_SANITIZE_STRING);
$verf5 = filter_input(INPUT_POST, 'verf5', FILTER_SANITIZE_NUMBER_INT);
$num5 = filter_input(INPUT_POST, 'num5', FILTER_SANITIZE_STRING);
$exp5 = filter_input(INPUT_POST, 'exp5', FILTER_SANITIZE_NUMBER_INT);
$lsrd = filter_input(INPUT_POST, 'lsrd', FILTER_SANITIZE_STRING);
$syes = filter_input(INPUT_POST, 'syes', FILTER_SANITIZE_STRING);
$bcert = filter_input(INPUT_POST, 'bcert', FILTER_SANITIZE_STRING);
$pauth = filter_input(INPUT_POST, 'pauth', FILTER_SANITIZE_STRING);
$dist1 = filter_input(INPUT_POST, 'dist1', FILTER_SANITIZE_STRING);
$tdate1 = filter_input(INPUT_POST, 'tdate1', FILTER_SANITIZE_NUMBER_INT);
$dist2 = filter_input(INPUT_POST, 'dist2', FILTER_SANITIZE_STRING);
$tdate2 = filter_input(INPUT_POST, 'tdate2', FILTER_SANITIZE_NUMBER_INT);
$dist3 = filter_input(INPUT_POST, 'dist3', FILTER_SANITIZE_STRING);
$tdate3 = filter_input(INPUT_POST, 'tdate3', FILTER_SANITIZE_NUMBER_INT);
$dist4 = filter_input(INPUT_POST, 'dist4', FILTER_SANITIZE_STRING);
$tdate4 = filter_input(INPUT_POST, 'tdate4', FILTER_SANITIZE_NUMBER_INT);
$dist5 = filter_input(INPUT_POST, 'dist5', FILTER_SANITIZE_STRING);
$tdate5 = filter_input(INPUT_POST, 'tdate5', FILTER_SANITIZE_NUMBER_INT);
$felony = filter_input(INPUT_POST, 'felony', FILTER_SANITIZE_STRING);
$felonys = filter_input(INPUT_POST, 'felonys', FILTER_SANITIZE_STRING);
$ename = filter_input(INPUT_POST, 'ename', FILTER_SANITIZE_STRING);
$erelation = filter_input(INPUT_POST, 'erelation', FILTER_SANITIZE_STRING);
$ehphone = filter_input(INPUT_POST, 'ehphone', FILTER_SANITIZE_STRING);
$eaddress = filter_input(INPUT_POST, 'eaddress', FILTER_SANITIZE_STRING);
$ecity = filter_input(INPUT_POST, 'ecity', FILTER_SANITIZE_STRING);
$ezip = filter_input(INPUT_POST, 'ezip', FILTER_SANITIZE_STRING);
$hdyhau = filter_input(INPUT_POST, 'hdyhau', FILTER_SANITIZE_STRING);
$bdesc = filter_input(INPUT_POST, 'bdesc', FILTER_SANITIZE_STRING);
$dbh = new PDO('mysql:host=localhost;dbname=petrzilk_test', 'petrzilk_dbAdmin', '##########');
$stmt = $dbh->prepare("insert into VolunDB(fname, middle, lname, address, city, state, zip, county, mailing, hphone, mphone, wphone, ext, fax, email, ethgroup, other1, occupation, poe, dob, gender, bhv, mrc, general, evv, all, fillmore, johnson, otoe, richardson, seward, butler, gage, lancaster, pawnee, saline, thayer, cass, jefferson, nemaha, polk, saunders, york, other2, aro, clergy, intskills, interpt, bus, cdl, child, law, cpr, cpryn, data, security, emergency, computer, mechanical, administration, firstaid, faid, translation, translate, construction, basicclean, foodprep, animalcare, heavy, other3, license1, verf1, num1, exp1, license2, verf2, num2, exp2, license3, verf3, num3, exp3, license4, verf4, num4, exp4, license5, verf5, num5, exp5, lsrd, syes, bcert, pauth, dataentry, identification, phone, runner, greeter, interviewer, safety, dist1, tdate1, dist2, tdate2, dist3, tdate3, dist4, tdate4, dist5, tdate5, felony, felonys, ename, erelation, ehphone, eaddress, ecity, ezip, hdyhau, bdesc) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
$stmt->bindParam(1, $fname);
$stmt->bindParam(2, $middle );
$stmt->bindParam(3, $lname );
$stmt->bindParam(4, $address );
$stmt->bindParam(5, $city);
$stmt->bindParam(6, $state);
$stmt->bindParam(7, $zip);
$stmt->bindParam(8, $county);
$stmt->bindParam(9, $mailing);
$stmt->bindParam(10, $hphone);
$stmt->bindParam(11, $mphone);
$stmt->bindParam(12, $wphone);
$stmt->bindParam(13, $ext);
$stmt->bindParam(14, $fax);
$stmt->bindParam(15, $email);
$stmt->bindParam(16, $ethgroup);
$stmt->bindParam(17, $other1);
$stmt->bindParam(18, $occupation);
$stmt->bindParam(19, $poe);
$stmt->bindParam(20, $dob);
$stmt->bindParam(21, $gender);
$stmt->bindParam(22, $bhv);
$stmt->bindParam(23, $mrc);
$stmt->bindParam(24, $general);
$stmt->bindParam(25, $evv);
$stmt->bindParam(26, $all);
$stmt->bindParam(27, $fillmore);
$stmt->bindParam(28, $johnson);
$stmt->bindParam(29, $otoe);
$stmt->bindParam(30, $richardson);
$stmt->bindParam(31, $seward);
$stmt->bindParam(32, $butler);
$stmt->bindParam(33, $gage);
$stmt->bindParam(34, $lancaster);
$stmt->bindParam(35, $pawnee);
$stmt->bindParam(36, $saline);
$stmt->bindParam(37, $thayer);
$stmt->bindParam(38, $cass);
$stmt->bindParam(39, $jefferson);
$stmt->bindParam(40, $nemaha);
$stmt->bindParam(41, $polk);
$stmt->bindParam(42, $saunders);
$stmt->bindParam(43, $york);
$stmt->bindParam(44, $other2);
$stmt->bindParam(45, $aro );
$stmt->bindParam(46, $clergy);
$stmt->bindParam(47, $intskills);
$stmt->bindParam(48, $interpt);
$stmt->bindParam(49, $bus);
$stmt->bindParam(50, $cdl);
$stmt->bindParam(51, $child);
$stmt->bindParam(52, $law);
$stmt->bindParam(53, $cpr);
$stmt->bindParam(54, $cpryn);
$stmt->bindParam(55, $data);
$stmt->bindParam(56, $security);
$stmt->bindParam(57, $emergency);
$stmt->bindParam(58, $computer);
$stmt->bindParam(59, $mechanical);
$stmt->bindParam(60, $administration);
$stmt->bindParam(61, $firstaid);
$stmt->bindParam(62, $faid);
$stmt->bindParam(63, $translation);
$stmt->bindParam(64, $translate);
$stmt->bindParam(65, $construction);
$stmt->bindParam(66, $basicclean);
$stmt->bindParam(67, $foodprep);
$stmt->bindParam(68, $animalcare);
$stmt->bindParam(69, $heavy);
$stmt->bindParam(70, $other3);
$stmt->bindParam(71, $license1);
$stmt->bindParam(72, $verf1);
$stmt->bindParam(73, $num1);
$stmt->bindParam(74, $exp1);
$stmt->bindParam(75, $license2);
$stmt->bindParam(76, $verf2);
$stmt->bindParam(77, $num2);
$stmt->bindParam(78, $exp2);
$stmt->bindParam(79, $license3);
$stmt->bindParam(80, $verf3);
$stmt->bindParam(81, $num3);
$stmt->bindParam(82, $exp3 );
$stmt->bindParam(83, $license4);
$stmt->bindParam(84, $verf4);
$stmt->bindParam(85, $num4);
$stmt->bindParam(86, $exp4);
$stmt->bindParam(87, $license5);
$stmt->bindParam(88, $verf5);
$stmt->bindParam(89, $num5);
$stmt->bindParam(90, $exp5);
$stmt->bindParam(91, $lsrd);
$stmt->bindParam(92, $syes);
$stmt->bindParam(93, $bcert);
$stmt->bindParam(94, $pauth);
$stmt->bindParam(95, $dataentry);
$stmt->bindParam(96, $identification);
$stmt->bindParam(97, $phone);
$stmt->bindParam(98, $runner);
$stmt->bindParam(99, $greeter);
$stmt->bindParam(100, $interviewer);
$stmt->bindParam(101, $safety);
$stmt->bindParam(102, $dist1);
$stmt->bindParam(103, $tdate1);
$stmt->bindParam(104, $dist2);
$stmt->bindParam(105, $tdate2);
$stmt->bindParam(106, $dist3);
$stmt->bindParam(107, $tdate3);
$stmt->bindParam(108, $dist4);
$stmt->bindParam(109, $tdate4);
$stmt->bindParam(110, $dist5);
$stmt->bindParam(111, $tdate5);
$stmt->bindParam(112, $felony);
$stmt->bindParam(113, $felonys);
$stmt->bindParam(114, $ename);
$stmt->bindParam(115, $erelation);
$stmt->bindParam(116, $ehphone);
$stmt->bindParam(117, $eaddress);
$stmt->bindParam(118, $ecity);
$stmt->bindParam(119, $ezip);
$stmt->bindParam(120, $hdyhau);
$stmt->bindParam(121, $bdesc);
$stmt->execute();
echo "<p>The user has been added.</p>";
echo "\nPDOStatement::errorInfo():\n";
$arr = $stmt->errorInfo();
print_r($arr);

?>