Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $flag = 0;
- $flag1 = 0;
- $flag2 = 0;
- $flag3 = 0;
- $disastervoln1 = "";
- $scounty1= "";
- $vskills1 = "";
- $etrain1 = "";
- $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);
- $disastervoln = $_POST["disastervoln"];
- $scounty = $_POST["scounty"];
- $other2 = filter_input(INPUT_POST, 'other2', FILTER_SANITIZE_STRING);
- $vskills = $_POST["vSkills"];
- $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);
- $faid = filter_input(INPUT_POST, 'faid', 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);
- $etrain = $_POST["etrain"];
- $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);
- $ehome = filter_input(INPUT_POST, 'ehome', FILTER_SANITIZE_STRING);
- $erelationship = filter_input(INPUT_POST, 'erelationship', 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);
- foreach($disastervoln as $entry){
- $disastervoln1 .= $entry.",";
- $flag = 1;
- }
- if ($flag == 1){
- $disastervoln1 =rtrim($disastervoln1);
- }
- foreach($scounty as $entry1){
- $scounty1 .= $entry1.",";
- $flag1 = 1;
- }
- if ($flag1 == 1){
- $scounty1 =rtrim($scounty1);
- }foreach($vskills as $entry2){
- $vskills1 .= $entry2.",";
- $flag2 = 1;
- }
- if ($flag2 == 1){
- $vskills1 =rtrim($vskills1);
- }
- foreach($etrain as $entry3){
- $etrain1 .= $entry3.",";
- $flag3 = 1;
- }
- if ($flag3 == 1){
- $etrain1 =rtrim($etrain1);
- }
- $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, disastervoln, scounty, other2, vskills, interpt, cdl, cpryn, faid, translate, 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, etrain, dist1, tdate1, dist2, tdate2, dist3, tdate3, dist4, tdate4, dist5, tdate5, felony, felonys, ehome, erelationship, ehphone, eaddress, ecity, ezip, hdyhau, bdesc) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
- $stmt->bindParam(1, $fname);
- $stmt->bindParam(1, $middle );
- $stmt->bindParam(1, $lname );
- $stmt->bindParam(1, $address );
- $stmt->bindParam(1, $city);
- $stmt->bindParam(1, $zip);
- $stmt->bindParam(1, $county);
- $stmt->bindParam(1, $mailing);
- $stmt->bindParam(1, $hphone);
- $stmt->bindParam(1, $mphone);
- $stmt->bindParam(1, $wphone);
- $stmt->bindParam(1, $ext);
- $stmt->bindParam(1, $fax);
- $stmt->bindParam(1, $email);
- $stmt->bindParam(1, $ethgroup);
- $stmt->bindParam(1, $other1);
- $stmt->bindParam(1, $occupation);
- $stmt->bindParam(1, $poe);
- $stmt->bindParam(1, $dob);
- $stmt->bindParam(1, $gender);
- $stmt->bindParam(1, $disastervoln1);
- $stmt->bindParam(1, $scounty1);
- $stmt->bindParam(1, $other2);
- $stmt->bindParam(1, $vskills1);
- $stmt->bindParam(1, $interpt);
- $stmt->bindParam(1, $cdl);
- $stmt->bindParam(1, $cpryn);
- $stmt->bindParam(1, $faid);
- $stmt->bindParam(1, $translate);
- $stmt->bindParam(1, $other3);
- $stmt->bindParam(1, $license1);
- $stmt->bindParam(1, $verf1);
- $stmt->bindParam(1, $num1);
- $stmt->bindParam(1, $exp1);
- $stmt->bindParam(1, $license2);
- $stmt->bindParam(1, $verf2);
- $stmt->bindParam(1, $num2);
- $stmt->bindParam(1, $exp2);
- $stmt->bindParam(1, $license3);
- $stmt->bindParam(1, $verf3);
- $stmt->bindParam(1, $num3);
- $stmt->bindParam(1, $exp3 );
- $stmt->bindParam(1, $license4);
- $stmt->bindParam(1, $verf4);
- $stmt->bindParam(1, $num4);
- $stmt->bindParam(1, $exp4);
- $stmt->bindParam(1, $license5);
- $stmt->bindParam(1, $verf5);
- $stmt->bindParam(1, $num5);
- $stmt->bindParam(1, $exp5);
- $stmt->bindParam(1, $lsrd);
- $stmt->bindParam(1, $syes);
- $stmt->bindParam(1, $bcert);
- $stmt->bindParam(1, $pauth);
- $stmt->bindParam(1, $etrain1);
- $stmt->bindParam(1, $dist1);
- $stmt->bindParam(1, $tdate1);
- $stmt->bindParam(1, $dist2);
- $stmt->bindParam(1, $tdate2);
- $stmt->bindParam(1, $dist3);
- $stmt->bindParam(1, $tdate3);
- $stmt->bindParam(1, $dist4);
- $stmt->bindParam(1, $tdate4);
- $stmt->bindParam(1, $dist5);
- $stmt->bindParam(1, $tdate5);
- $stmt->bindParam(1, $felony);
- $stmt->bindParam(1, $felonys);
- $stmt->bindParam(1, $ehome);
- $stmt->bindParam(1, $erelationship);
- $stmt->bindParam(1, $ehphone);
- $stmt->bindParam(1, $eaddress);
- $stmt->bindParam(1, $ecity);
- $stmt->bindParam(1, $ezip);
- $stmt->bindParam(1, $hdyhau);
- $stmt->bindParam(1, $bdesc);
- $stmt->execute();
- echo "<p>The user has been added.</p>";
- echo "\nPDOStatement::errorInfo():\n";
- $arr = $stmt->errorInfo();
- print_r($arr);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement