Guest User

PHP OLD

a guest
Sep 12th, 2014
81
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. session_start();
  3. if(!isset($_SESSION['sess_user_id']) || (trim($_SESSION['sess_user_id']) == '')) {
  4.     header("location: login.php");
  5.     exit();
  6. }
  7. $record = filter_input(INPUT_POST, 'record', FILTER_SANITIZE_NUMBER_INT);
  8. $status = filter_input(INPUT_POST, 'status', FILTER_SANITIZE_STRING);
  9. $fname = filter_input(INPUT_POST, 'fname', FILTER_SANITIZE_STRING);
  10. $middle = filter_input(INPUT_POST, 'middle', FILTER_SANITIZE_STRING);
  11. $lname = filter_input(INPUT_POST, 'lname', FILTER_SANITIZE_STRING);
  12. $address = filter_input(INPUT_POST, 'address', FILTER_SANITIZE_STRING);
  13. $city = filter_input(INPUT_POST, 'city', FILTER_SANITIZE_STRING);
  14. $state = filter_input(INPUT_POST, 'state', FILTER_SANITIZE_STRING);
  15. $zip = filter_input(INPUT_POST, 'zip', FILTER_SANITIZE_STRING);
  16. $county = filter_input(INPUT_POST, 'county', FILTER_SANITIZE_STRING);
  17. $mailing = filter_input(INPUT_POST, 'mailing', FILTER_SANITIZE_STRING);
  18. $hphone = filter_input(INPUT_POST, 'hphone', FILTER_SANITIZE_STRING);
  19. $mphone = filter_input(INPUT_POST, 'mphone', FILTER_SANITIZE_STRING);
  20. $wphone = filter_input(INPUT_POST, 'wphone', FILTER_SANITIZE_STRING);
  21. $ext = filter_input(INPUT_POST, 'ext', FILTER_SANITIZE_STRING);
  22. $fax = filter_input(INPUT_POST, 'fax', FILTER_SANITIZE_STRING);
  23. $email = filter_input(INPUT_POST, 'email', FILTER_VALIDATE_EMAIL);
  24. $ethgroup = filter_input(INPUT_POST, 'ethgroup', FILTER_SANITIZE_STRING);
  25. $other1 = filter_input(INPUT_POST, 'other1', FILTER_SANITIZE_STRING);
  26. $occupation = filter_input(INPUT_POST, 'occupation', FILTER_SANITIZE_STRING);
  27. $poe = filter_input(INPUT_POST, 'poe', FILTER_SANITIZE_STRING);
  28. $dob = filter_input(INPUT_POST, 'dob', FILTER_SANITIZE_NUMBER_INT);
  29. $gender = filter_input(INPUT_POST, 'gender', FILTER_SANITIZE_STRING);
  30. $bhv = filter_input(INPUT_POST, 'bhv', FILTER_SANITIZE_STRING);
  31. $mrc = filter_input(INPUT_POST, 'mrc', FILTER_SANITIZE_STRING);
  32. $general = filter_input(INPUT_POST, 'general', FILTER_SANITIZE_STRING);
  33. $evv = filter_input(INPUT_POST, 'evv', FILTER_SANITIZE_STRING);
  34. $allCounties = filter_input(INPUT_POST, 'allCounties', FILTER_SANITIZE_STRING);
  35. $fillmore = filter_input(INPUT_POST, 'fillmore', FILTER_SANITIZE_STRING);
  36. $johnson = filter_input(INPUT_POST, 'johnson', FILTER_SANITIZE_STRING);
  37. $otoe = filter_input(INPUT_POST, 'otoe', FILTER_SANITIZE_STRING);
  38. $richardson = filter_input(INPUT_POST, 'richardson', FILTER_SANITIZE_STRING);
  39. $seward = filter_input(INPUT_POST, 'seward', FILTER_SANITIZE_STRING);
  40. $butler = filter_input(INPUT_POST, 'butler', FILTER_SANITIZE_STRING);
  41. $gage = filter_input(INPUT_POST, 'gage', FILTER_SANITIZE_STRING);
  42. $lancaster = filter_input(INPUT_POST, 'lancaster', FILTER_SANITIZE_STRING);
  43. $pawnee = filter_input(INPUT_POST, 'pawnee', FILTER_SANITIZE_STRING);
  44. $saline = filter_input(INPUT_POST, 'saline', FILTER_SANITIZE_STRING);
  45. $thayer = filter_input(INPUT_POST, 'thayer', FILTER_SANITIZE_STRING);
  46. $cass = filter_input(INPUT_POST, 'cass', FILTER_SANITIZE_STRING);
  47. $jefferson = filter_input(INPUT_POST, 'jefferspm', FILTER_SANITIZE_STRING);
  48. $nemaha = filter_input(INPUT_POST, 'nemaha', FILTER_SANITIZE_STRING);
  49. $polk = filter_input(INPUT_POST, 'polk', FILTER_SANITIZE_STRING);
  50. $saunders = filter_input(INPUT_POST, 'saunders', FILTER_SANITIZE_STRING);
  51. $york = filter_input(INPUT_POST, 'york', FILTER_SANITIZE_STRING);
  52. $aro = filter_input(INPUT_POST, 'aro', FILTER_SANITIZE_STRING);
  53. $clergy = filter_input(INPUT_POST, 'clergy', FILTER_SANITIZE_STRING);
  54. $intskills = filter_input(INPUT_POST, 'intskills', FILTER_SANITIZE_STRING);
  55. $bus = filter_input(INPUT_POST, 'bus', FILTER_SANITIZE_STRING);
  56. $child = filter_input(INPUT_POST, 'child', FILTER_SANITIZE_STRING);
  57. $law = filter_input(INPUT_POST, 'law', FILTER_SANITIZE_STRING);
  58. $cpr = filter_input(INPUT_POST, 'cpr', FILTER_SANITIZE_STRING);
  59. $data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING);
  60. $security = filter_input(INPUT_POST, 'security', FILTER_SANITIZE_STRING);
  61. $emergency = filter_input(INPUT_POST, 'emergency', FILTER_SANITIZE_STRING);
  62. $computer = filter_input(INPUT_POST, 'computer', FILTER_SANITIZE_STRING);
  63. $mechanical = filter_input(INPUT_POST, 'mechanical', FILTER_SANITIZE_STRING);
  64. $administration = filter_input(INPUT_POST, 'administration', FILTER_SANITIZE_STRING);
  65. $firstaid = filter_input(INPUT_POST, 'firstaid', FILTER_SANITIZE_STRING);
  66. $translation = filter_input(INPUT_POST, 'translation', FILTER_SANITIZE_STRING);
  67. $construction = filter_input(INPUT_POST, 'construction', FILTER_SANITIZE_STRING);
  68. $basicclean = filter_input(INPUT_POST, 'basicclean', FILTER_SANITIZE_STRING);
  69. $foodprep = filter_input(INPUT_POST, 'foodprep', FILTER_SANITIZE_STRING);
  70. $animalcare = filter_input(INPUT_POST, 'animalcare', FILTER_SANITIZE_STRING);
  71. $heavy = filter_input(INPUT_POST, 'heavy', FILTER_SANITIZE_STRING);
  72. $dataentry = filter_input(INPUT_POST, 'dataentry', FILTER_SANITIZE_STRING);
  73. $identification = filter_input(INPUT_POST, 'identification', FILTER_SANITIZE_STRING);
  74. $phone = filter_input(INPUT_POST, 'phone', FILTER_SANITIZE_STRING);
  75. $runner = filter_input(INPUT_POST, 'runner', FILTER_SANITIZE_STRING);
  76. $greeter = filter_input(INPUT_POST, 'greeter', FILTER_SANITIZE_STRING);
  77. $interviewer = filter_input(INPUT_POST, 'interviewer', FILTER_SANITIZE_STRING);
  78. $safety = filter_input(INPUT_POST, 'safety', FILTER_SANITIZE_STRING);
  79. $other2 = filter_input(INPUT_POST, 'other2', FILTER_SANITIZE_STRING);
  80. $interpt = filter_input(INPUT_POST, 'interpt', FILTER_SANITIZE_STRING);
  81. $cdl = filter_input(INPUT_POST, 'cdl', FILTER_SANITIZE_STRING);
  82. $cpryn = filter_input(INPUT_POST, 'cpryn', FILTER_SANITIZE_STRING);
  83. $translate = filter_input(INPUT_POST, 'translate', FILTER_SANITIZE_STRING);
  84. $other3 = filter_input(INPUT_POST, 'other3', FILTER_SANITIZE_STRING);
  85. $license1 = filter_input(INPUT_POST, 'license1', FILTER_SANITIZE_STRING);
  86. $verf1 = filter_input(INPUT_POST, 'verf1',FILTER_SANITIZE_NUMBER_INT);
  87. $num1 = filter_input(INPUT_POST, 'num1', FILTER_SANITIZE_STRING);
  88. $exp1 = filter_input(INPUT_POST, 'exp1', FILTER_SANITIZE_NUMBER_INT);
  89. $license2 = filter_input(INPUT_POST, 'license2', FILTER_SANITIZE_STRING);
  90. $verf2 = filter_input(INPUT_POST, 'verf2', FILTER_SANITIZE_NUMBER_INT);
  91. $num2 = filter_input(INPUT_POST, 'num2', FILTER_SANITIZE_STRING);
  92. $exp2 = filter_input(INPUT_POST, 'exp2', FILTER_SANITIZE_NUMBER_INT);
  93. $license3 = filter_input(INPUT_POST, 'license3', FILTER_SANITIZE_STRING);
  94. $verf3 = filter_input(INPUT_POST, 'verf3', FILTER_SANITIZE_NUMBER_INT);
  95. $num3 = filter_input(INPUT_POST, 'num3', FILTER_SANITIZE_STRING);
  96. $exp3 = filter_input(INPUT_POST, 'exp3', FILTER_SANITIZE_NUMBER_INT);
  97. $license4 = filter_input(INPUT_POST, 'license4', FILTER_SANITIZE_STRING);
  98. $verf4 = filter_input(INPUT_POST, 'verf4', FILTER_SANITIZE_NUMBER_INT);
  99. $num4 = filter_input(INPUT_POST, 'num4', FILTER_SANITIZE_STRING);
  100. $exp4 = filter_input(INPUT_POST, 'exp4', FILTER_SANITIZE_NUMBER_INT);
  101. $license5 = filter_input(INPUT_POST, 'license5', FILTER_SANITIZE_STRING);
  102. $verf5 = filter_input(INPUT_POST, 'verf5', FILTER_SANITIZE_NUMBER_INT);
  103. $num5 = filter_input(INPUT_POST, 'num5', FILTER_SANITIZE_STRING);
  104. $exp5 = filter_input(INPUT_POST, 'exp5', FILTER_SANITIZE_NUMBER_INT);
  105. $lsrd = filter_input(INPUT_POST, 'lsrd', FILTER_SANITIZE_STRING);
  106. $syes = filter_input(INPUT_POST, 'syes', FILTER_SANITIZE_STRING);
  107. $bcert = filter_input(INPUT_POST, 'bcert', FILTER_SANITIZE_STRING);
  108. $pauth = filter_input(INPUT_POST, 'pauth', FILTER_SANITIZE_STRING);
  109. $dist1 = filter_input(INPUT_POST, 'dist1', FILTER_SANITIZE_STRING);
  110. $tdate1 = filter_input(INPUT_POST, 'tdate1', FILTER_SANITIZE_NUMBER_INT);
  111. $dist2 = filter_input(INPUT_POST, 'dist2', FILTER_SANITIZE_STRING);
  112. $tdate2 = filter_input(INPUT_POST, 'tdate2', FILTER_SANITIZE_NUMBER_INT);
  113. $dist3 = filter_input(INPUT_POST, 'dist3', FILTER_SANITIZE_STRING);
  114. $tdate3 = filter_input(INPUT_POST, 'tdate3', FILTER_SANITIZE_NUMBER_INT);
  115. $dist4 = filter_input(INPUT_POST, 'dist4', FILTER_SANITIZE_STRING);
  116. $tdate4 = filter_input(INPUT_POST, 'tdate4', FILTER_SANITIZE_NUMBER_INT);
  117. $dist5 = filter_input(INPUT_POST, 'dist5', FILTER_SANITIZE_STRING);
  118. $tdate5 = filter_input(INPUT_POST, 'tdate5', FILTER_SANITIZE_NUMBER_INT);
  119. $felony = filter_input(INPUT_POST, 'felony', FILTER_SANITIZE_STRING);
  120. $felonys = filter_input(INPUT_POST, 'felonys', FILTER_SANITIZE_STRING);
  121. $ename = filter_input(INPUT_POST, 'ename', FILTER_SANITIZE_STRING);
  122. $erelation = filter_input(INPUT_POST, 'erelation', FILTER_SANITIZE_STRING);
  123. $ehphone = filter_input(INPUT_POST, 'ehphone', FILTER_SANITIZE_STRING);
  124. $eaddress = filter_input(INPUT_POST, 'eaddress', FILTER_SANITIZE_STRING);
  125. $ecity = filter_input(INPUT_POST, 'ecity', FILTER_SANITIZE_STRING);
  126. $ezip = filter_input(INPUT_POST, 'ezip', FILTER_SANITIZE_STRING);
  127. $hdyhau = filter_input(INPUT_POST, 'hdyhau', FILTER_SANITIZE_STRING);
  128. $bdesc = filter_input(INPUT_POST, 'bdesc', FILTER_SANITIZE_STRING);
  129.  
  130. if ($bhv == ""){
  131.     $bhv = "";
  132. }
  133. if ($mrc == ""){
  134.     $mrc = "";
  135. }
  136. if ($general == ""){
  137.     $general = "";
  138. }
  139. if ($evv == ""){
  140.     $evv = "";
  141. }
  142. if ($allCounties == ""){
  143.     $allCounties = "";
  144. }
  145. if ($fillmore == ""){
  146.     $fillmore = "";
  147. }
  148. if ($johnson == ""){
  149.     $johnson = "";
  150. }
  151. if ($otoe == ""){
  152.     $otoe = "";
  153. }
  154. if ($richardson == ""){
  155.     $richardson = "";
  156. }
  157. if ($seward == ""){
  158.     $seward = "";
  159. }
  160. if ($butler == ""){
  161.     $butler = "";
  162. }
  163. if ($gage == ""){
  164.     $gage = "";
  165. }
  166. if ($lancaster == ""){
  167.     $lancaster = "";
  168. }
  169. if ($pawnee == ""){
  170.     $pawnee = "";
  171. }
  172. if ($saline == ""){
  173.     $saline = "";
  174. }
  175. if ($thayer == ""){
  176.     $thayer = "";
  177. }
  178. if ($cass == ""){
  179.     $cass = "";
  180. }
  181. if ($jefferson == ""){
  182.     $jefferson = "";
  183. }
  184. if ($nemaha == ""){
  185.     $nemaha = "";
  186. }
  187. if ($polk == ""){
  188.     $polk = "";
  189. }
  190. if ($saunders == ""){
  191.     $saunders = "";
  192. }
  193. if ($york == ""){
  194.     $york = "";
  195. }
  196. if ($aro == ""){
  197.     $aro = "";
  198. }
  199. if ($clergy == ""){
  200.     $clergy = "";
  201. }
  202. if ($intskills == ""){
  203.     $intskills = "";
  204. }
  205. if ($child == ""){
  206.     $child = "";
  207. }
  208. if ($bus == ""){
  209.     $bus = "";
  210. }
  211. if ($law == ""){
  212.     $law = "";
  213. }
  214. if ($cpr == ""){
  215.     $cpr = "";
  216. }
  217. if ($data == ""){
  218.     $data = "";
  219. }
  220. if ($security == ""){
  221.     $security = "";
  222. }
  223. if ($emergency == ""){
  224.     $emergency = "";
  225. }
  226. if ($computer == ""){
  227.     $computer = "";
  228. }
  229. if ($mechanical == ""){
  230.     $mechanical = "";
  231. }
  232. if ($administration == ""){
  233.     $administration = "";
  234. }
  235. if ($firstaid == ""){
  236.     $firstaid = "";
  237. }
  238. if ($faid == ""){
  239.     $faid = "";
  240. }
  241. if ($translation == ""){
  242.     $translation = "";
  243. }
  244. if ($construction == ""){
  245.     $construction = "";
  246. }
  247. if ($basicclean == ""){
  248.     $basicclean = "";
  249. }
  250. if ($foodprep == ""){
  251.     $foodprep = "";
  252. }
  253. if ($animalcare == ""){
  254.     $animalcare = "";
  255. }
  256. if ($heavy == ""){
  257.     $heavy = "";
  258. }
  259. if ($dataentry == ""){
  260.     $dataentry = "";
  261. }
  262. if ($identification == ""){
  263.     $identification = "";
  264. }
  265. if ($phone == ""){
  266.     $phone = "";
  267. }
  268. if ($runner == ""){
  269.     $runner = "";
  270. }
  271. if ($greeter == ""){
  272.     $greeter = "";
  273. }
  274. if ($interviewer == ""){
  275.     $interviewer = "";
  276. }
  277. if ($safety == ""){
  278.     $safety = "";
  279. }
  280. if ($tdate1 == "00-00-0000"){
  281.     $tdate1 = "";
  282. }
  283. if ($tdate2 == "00-00-0000"){
  284.     $tdate2 = "";
  285. }
  286. if ($tdate3 == "00-00-0000"){
  287.     $tdate3 = "";
  288. }
  289. if ($tdate4 == "00-00-0000"){
  290.     $tdate4 = "";
  291. }
  292. if ($tdate5 == "00-00-0000"){
  293.     $tdate5 = "";
  294. }
  295. if ($verf1 == "00-00-0000"){
  296.     $tverf1 = "";
  297. }
  298. if ($exp1 == "00-00-0000"){
  299.     $exp1 = "";
  300. }
  301. if ($verf2 == "00-00-0000"){
  302.     $tverf2 = "";
  303. }
  304. if ($exp2 == "00-00-0000"){
  305.     $exp2 = "";
  306. }
  307. if ($verf3 == "00-00-0000"){
  308.     $tverf3 = "";
  309. }
  310. if ($exp3 == "00-00-0000"){
  311.     $exp3 = "";
  312. }
  313. if ($verf4 == "00-00-0000"){
  314.     $tverf4 = "";
  315. }
  316. if ($exp4 == "00-00-0000"){
  317.     $exp4 = "";
  318. }
  319. if ($verf5 == "00-00-0000"){
  320.     $tverf5 = "";
  321. }
  322. if ($exp5 == "00-00-0000"){
  323.     $exp5 = "";
  324. }
  325. $dbh = new PDO('mysql:host=localhost;dbname=petrzilk_test', 'petrzilk_dbAdmin', '');
  326. $stmt = $dbh->prepare("insert into VolunDB(status, 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, allCounties, 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, record) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  327. $stmt->bindParam(1,$status);
  328. $stmt->bindParam(2, $fname);
  329. $stmt->bindParam(3, $middle );
  330. $stmt->bindParam(4, $lname )    ;
  331. $stmt->bindParam(5, $address );
  332. $stmt->bindParam(6, $city);
  333. $stmt->bindParam(7, $state);
  334. $stmt->bindParam(8, $zip);
  335. $stmt->bindParam(9, $county);
  336. $stmt->bindParam(10, $mailing);
  337. $stmt->bindParam(11, $hphone);
  338. $stmt->bindParam(12, $mphone);
  339. $stmt->bindParam(13, $wphone);
  340. $stmt->bindParam(14, $ext);
  341. $stmt->bindParam(15, $fax);
  342. $stmt->bindParam(16, $email);
  343. $stmt->bindParam(17, $ethgroup);
  344. $stmt->bindParam(18, $other1);
  345. $stmt->bindParam(19, $occupation);
  346. $stmt->bindParam(20, $poe);
  347. $stmt->bindParam(21, $dob);
  348. $stmt->bindParam(22, $gender);
  349. $stmt->bindParam(23, $bhv);
  350. $stmt->bindParam(24, $mrc);
  351. $stmt->bindParam(25, $general);
  352. $stmt->bindParam(26, $evv);
  353. $stmt->bindParam(27, $allCounties);
  354. $stmt->bindParam(28, $fillmore);
  355. $stmt->bindParam(29, $johnson);
  356. $stmt->bindParam(30, $otoe);
  357. $stmt->bindParam(31, $richardson);
  358. $stmt->bindParam(32, $seward);
  359. $stmt->bindParam(33, $butler);
  360. $stmt->bindParam(34, $gage);
  361. $stmt->bindParam(35, $lancaster);
  362. $stmt->bindParam(36, $pawnee);
  363. $stmt->bindParam(37, $saline);
  364. $stmt->bindParam(38, $thayer);
  365. $stmt->bindParam(39, $cass);
  366. $stmt->bindParam(40, $jefferson);
  367. $stmt->bindParam(41, $nemaha);
  368. $stmt->bindParam(42, $polk);
  369. $stmt->bindParam(43, $saunders);
  370. $stmt->bindParam(44, $york);
  371. $stmt->bindParam(45, $other2);
  372. $stmt->bindParam(46, $aro );
  373. $stmt->bindParam(47, $clergy);
  374. $stmt->bindParam(48, $intskills);
  375. $stmt->bindParam(49, $interpt);
  376. $stmt->bindParam(50, $bus);
  377. $stmt->bindParam(51, $cdl);
  378. $stmt->bindParam(52, $child);
  379. $stmt->bindParam(53, $law);
  380. $stmt->bindParam(54, $cpr);
  381. $stmt->bindParam(55, $cpryn);
  382. $stmt->bindParam(56, $data);
  383. $stmt->bindParam(57, $security);
  384. $stmt->bindParam(58, $emergency);
  385. $stmt->bindParam(59, $computer);
  386. $stmt->bindParam(60, $mechanical);
  387. $stmt->bindParam(61, $administration);
  388. $stmt->bindParam(62, $firstaid);
  389. $stmt->bindParam(63, $faid);
  390. $stmt->bindParam(64, $translation);
  391. $stmt->bindParam(65, $translate);
  392. $stmt->bindParam(66, $construction);
  393. $stmt->bindParam(67, $basicclean);
  394. $stmt->bindParam(68, $foodprep);
  395. $stmt->bindParam(69, $animalcare);
  396. $stmt->bindParam(70, $heavy);
  397. $stmt->bindParam(71, $other3);
  398. $stmt->bindParam(72, $license1);
  399. $stmt->bindParam(73, $verf1);
  400. $stmt->bindParam(74, $num1);
  401. $stmt->bindParam(75, $exp1);
  402. $stmt->bindParam(76, $license2);
  403. $stmt->bindParam(77, $verf2);
  404. $stmt->bindParam(78, $num2);
  405. $stmt->bindParam(79, $exp2);
  406. $stmt->bindParam(80, $license3);
  407. $stmt->bindParam(81, $verf3);
  408. $stmt->bindParam(82, $num3);
  409. $stmt->bindParam(83, $exp3 );
  410. $stmt->bindParam(84, $license4);
  411. $stmt->bindParam(85, $verf4);
  412. $stmt->bindParam(86, $num4);
  413. $stmt->bindParam(87, $exp4);
  414. $stmt->bindParam(88, $license5);
  415. $stmt->bindParam(89, $verf5);
  416. $stmt->bindParam(90, $num5);
  417. $stmt->bindParam(91, $exp5);
  418. $stmt->bindParam(92, $lsrd);
  419. $stmt->bindParam(93, $syes);
  420. $stmt->bindParam(94, $bcert);
  421. $stmt->bindParam(95, $pauth);
  422. $stmt->bindParam(96, $dataentry);
  423. $stmt->bindParam(97, $identification);
  424. $stmt->bindParam(98, $phone);
  425. $stmt->bindParam(99, $runner);
  426. $stmt->bindParam(100, $greeter);
  427. $stmt->bindParam(101, $interviewer);
  428. $stmt->bindParam(102, $safety);
  429. $stmt->bindParam(103, $dist1);
  430. $stmt->bindParam(104, $tdate1);
  431. $stmt->bindParam(105, $dist2);
  432. $stmt->bindParam(106, $tdate2);
  433. $stmt->bindParam(107, $dist3);
  434. $stmt->bindParam(108, $tdate3);
  435. $stmt->bindParam(109, $dist4);
  436. $stmt->bindParam(110, $tdate4);
  437. $stmt->bindParam(111, $dist5);
  438. $stmt->bindParam(112, $tdate5);
  439. $stmt->bindParam(113, $felony);
  440. $stmt->bindParam(114, $felonys);
  441. $stmt->bindParam(115, $ename);
  442. $stmt->bindParam(116, $erelation);
  443. $stmt->bindParam(117, $ehphone);
  444. $stmt->bindParam(118, $eaddress);
  445. $stmt->bindParam(119, $ecity);
  446. $stmt->bindParam(120, $ezip);
  447. $stmt->bindParam(121, $hdyhau);
  448. $stmt->bindParam(122, $bdesc);
  449. $stmt->bindParam(123, $uid);
  450. $stmt->execute();
  451. header("location: volunForm.php?message=volunteer successfully added.");
  452. echo "user was added";
  453. echo "\nPDOStatement::errorInfo():\n";
  454. $arr = $stmt->errorInfo();
  455. print_r($arr);
  456.  
  457. ?>
RAW Paste Data