API tools faq
paste
Advertisement
Guest User

problem

a guest
Dec 18th, 2017
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.67 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XWTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <html>
  4. <head>
  5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  6. <title>Civil Service Online Registration</title>
  7. <link href="style.css" rel="stylesheet" type="text/css" media="screen" />
  8. </head>
  9. <body>
  10. <div class="header2">
  11. Civil Service Online Registration
  12. </div>
  13.  
  14. <div class="menu">
  15. <ul>
  16. <li><a href="index.php">Home</a></li>
  17. </ul>
  18. <ul>
  19. <li><a href="exam_sched.php">Examination Schedules</a></li>
  20. </ul>
  21. <ul>
  22. <li><a href="announcements.php">Announcements</a></li>
  23. </ul>
  24. <ul>
  25. <li><a href="faq.php">FAQ</a></li>
  26. </ul>
  27. <ul>
  28. <li><a href="about_us.php">About us</a>
  29. <ul>
  30. <li><a href="about_us_vision_mission.php">Vision & Mission</a></li>
  31. <li><a href="about_us_mandate.php">Mandate</a></li>
  32. <li><a href="about_us_values.php">Values</a></li>
  33. <li><a href="about_us_performance_pledge.php">Performance Pledge</a></li>
  34. <li><a href="about_us_historical_highlights.php">Historical Highlights</a></li>
  35. </ul>
  36. </li>
  37. </ul>
  38. </div>
  39.  
  40. <div style="margin: 0 auto; border: 2px solid #555555; width: 1030px; padding-bottom: 2px; text-align: left; font-size: 15px;">
  41. <form method="POST" action="applicant_registration.php" enctype="multipart/form-data">
  42. <div style="font-family: Tahoma, Geneva, sans-serif; width: 1030px; height:30px; border: 1px; margin-top: 40px; background:#696969; text-align:center; font-weight:bold; font-size: 20px; padding-top: 7px;">APPLICANT INFORMATION</div>
  43. <div style="margin-bottom: 0px; margin-top: 15px; margin-left: 800px; padding-top: 5px; color: #FF0000; font-size: 15px;">Note: Fields with * are required.</div>
  44. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 0px; margin-left: 10px; padding-top: 0px; text-decoration: underline;">ACCOUNT</div>
  45. <div style="margin-left: 15px;">
  46. <table>
  47. <tr>
  48. <td>Username:</td><td><input type="text" name="username" required />*</td>
  49. <td><div style="margin-left: 50px;">Password:</td><td><input type="password" name="password" required />*</div></td>
  50. </tr>
  51. <tr>
  52. <td>Email Address:</td><td><input type="text" name="emailadd">*</td>
  53. <td><div style="margin-left: 50px;">Confirm Password:</td><td><input type="password" name="confirmpassword" required />*</div></td>
  54. </tr>
  55. </table>
  56. </div>
  57.  
  58. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 5px; text-decoration: underline;">PERSONAL INFORMATION</div>
  59. <div style="margin-left: 15px;">
  60. Select image:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="file" name="avatar" required />
  61. <table>
  62. <tr>
  63. <td>First Name:</td><td><input type="text" name="fname" required />*</td>
  64. <td><div style="margin-left: 50px;">Height:</td><td><input type="text" name="height" required />(in meter)*</div></td>
  65. </tr>
  66. <tr>
  67. <td>Middle Name:</td><td><input type="text" name="midname" required />*</td>
  68. <td><div style="margin-left: 50px;">Weight:</td><td><input type="text" name="weight" required />(in newton)*</div></td>
  69. </tr>
  70. <tr>
  71. <td>Last Name:</td><td><input type="text" name="lname" required />*</td>
  72. <td><div style="margin-left: 50px;">Religion:</td><td><input type="text" name="religion" required />*</div></td>
  73. </tr>
  74. <tr>
  75. <td>Gender:</td><td><input type="radio" name="sex" value="Male" checked />Male&nbsp;<input type="radio" name="sex" value="Female"/>Female</td>
  76. <td><div style="margin-left: 50px;">Civil Status:</td>
  77. <td><select name="civstat" required>
  78. <option></option>
  79. <option value="Single">Single</option>
  80. <option value="Married">Married</option>
  81. <option value="In a relationship">In a relationship</option>
  82. <option value="Divorced">Divorced</option>
  83. <option value="Separated">Separated</option>
  84. <option value="Widow">Widowed</option>
  85. </select>*</div></td>
  86. </tr>
  87. <tr>
  88. <td>Birthdate:</td><td><input type="date" name="bdate" required />*</td>
  89. <td><div style="margin-left: 50px;">Contact Number:</td><td><input type="text" name="cnum" required />*</div></td>
  90. </tr>
  91. <tr>
  92. <td>Birthplace:</td><td><input type="text" name="bplace" required />*</td>
  93. <td><div style="margin-left: 50px;">Region:</td>
  94. <td><select name="region" required >
  95. <option></option>
  96. <option value="I">I</option>
  97. <option value="II">II</option>
  98. <option value="III">III</option>
  99. <option value="IV">IV</option>
  100. <option value="V">V</option>
  101. <option value="VI">VI</option>
  102. <option value="VII">VII</option>
  103. <option value="VIII">VIII</option>
  104. <option value="IX">IX</option>
  105. <option value="X">X</option>
  106. <option value="XI">XI</option>
  107. <option value="XII">XII</option>
  108. <option value="NCR">NCR</option>
  109. <option value="CAR">CAR</option>
  110. <option value="CARAGA">CARAGA</option>
  111. <option value="ARMM">ARMM</option>
  112. </select>*</div></td>
  113. </tr>
  114. <tr>
  115. <td>Age:</td><td><input type="text" name="age" required />*</td>
  116. <td><div style="margin-left: 50px;">City or Town:</td><td><input type="text" name="citytown" required />*</div></td>
  117. </tr>
  118. <tr>
  119. <td>Permanent Address:</td><td><textarea name="paddress" cols="35" rows="2" required ></textarea>*</td>
  120. <td><div style="margin-left: 50px;">Zip Code:</td><td><input type="text" name="zipcode" required />*</div></td>
  121. </tr>
  122. </table>
  123. </div>
  124.  
  125. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 5px; text-decoration: underline;">Mother's Maiden Name</div>
  126. <div style="margin-left: 15px; padding-bottom: 15px;">
  127. <table>
  128. <tr>
  129. <td>First Name:</td><td><input type="text" name="mm_fname" required />*</td>
  130. </tr>
  131. <tr>
  132. <td>Middle Name:</td><td><input type="text" name="mm_midname" required />*</td>
  133. </tr>
  134. <tr>
  135. <td>Last Name:</td><td><input type="text" name="mm_lname" required />*</td>
  136. </tr>
  137. </table>
  138. </div>
  139.  
  140. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 5px; text-decoration: underline;">Person to notify in case of emergency</div>
  141. <div style="margin-left: 15px; padding-bottom: 15px;">
  142. <table>
  143. <tr>
  144. <td>First Name:</td><td><input type="text" name="emer_fname" required />*</td>
  145. <td><div style="margin-left: 50px;">Contact Number:</td><td><input type="text" name="emer_cnum" required />*</div></td>
  146. </tr>
  147. <tr>
  148. <td>Middle Name:</td><td><input type="text" name="emer_midname" required />*</td>
  149. <td><div style="margin-left: 50px;">Address:</td><td><textarea name="emer_address" cols="35" rows="2" required ></textarea>*</div></td>
  150. </tr>
  151. <tr>
  152. <td>Last Name:</td><td><input type="text" name="emer_lname" required />*</td>
  153. <td><div style="margin-left: 50px;">Relation:</td><td><input type="text" name="relation" required />*</div></td>
  154. </tr>
  155. </table>
  156. </div>
  157.  
  158. <div style="font-family: Tahoma, Geneva, sans-serif; width: 1030px; height:30px; border: 1px; background:#696969; text-align:center; font-weight:bold; font-size: 20px; padding-top: 7px;">EDUCATIONAL INFORMATION</div>
  159. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 5px; text-decoration: underline;">ELEMENTARY</div>
  160. <div style="margin-left: 15px;">
  161. <table>
  162. <tr>
  163. <td>Attainment:</td>
  164. <td><select name="elem_attainment">
  165. <option></option>
  166. <option value="Graduated">Graduated</option>
  167. <option value="Not Graduated">Not Graduated</option>
  168. </select></td>
  169. <td><div style="margin-left: 50px;">Highest Grade Earned:</td><td><input type="text" name="elem_highest_grd_earned"/></div></td>
  170. </tr>
  171. <tr>
  172. <td>Year Graduated:</td><td><input type="text" name="elem_yr_graduated"/></td>
  173. <td><div style="margin-left: 50px;">School:</td><td><input type="text" name="elem_school" /></div></td>
  174. </tr>
  175. </table>
  176. </div>
  177.  
  178. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 15px; text-decoration: underline;">HIGHSCHOOL</div>
  179. <div style="margin-left: 15px;">
  180. <table>
  181. <tr>
  182. <td>Attainment:</td>
  183. <td><select name="highschool_attainment">
  184. <option></option>
  185. <option value="Graduated">Graduated</option>
  186. <option value="Not Graduated">Not Graduated</option>
  187. </select></td>
  188. <td><div style="margin-left: 50px;">Highest Year Earned:</td><td><input type="text" name="highschool_highest_yr_earned"/></div></td>
  189. </tr>
  190. <tr>
  191. <td>Year Graduated:</td><td><input type="text" name="highschool_yr_graduated"/></td>
  192. <td><div style="margin-left: 50px;">School:</td><td><input type="text" name="highschool_school" /></div></td>
  193. </tr>
  194. </table>
  195. </div>
  196.  
  197. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 15px; text-decoration: underline;">VOCATIONAL</div>
  198. <div style="margin-left: 15px;">
  199. <table>
  200. <tr>
  201. <td>Attainment:</td>
  202. <td><select name="vocational_attainment">
  203. <option></option>
  204. <option value="Graduated">Graduated</option>
  205. <option value="Not Graduated">Not Graduated</option>
  206. </select></td>
  207. <td><div style="margin-left: 50px;">Highest Year Earned:</td><td><input type="text" name="vocational_highest_yr_earned"/></div></td>
  208. </tr>
  209. <tr>
  210. <td>Year Graduated:</td><td><input type="text" name="vocational_yr_graduated"/></td>
  211. <td><div style="margin-left: 50px;">School:</td><td><input type="text" name="vocational_school" /></div></td>
  212. </tr>
  213. </table>
  214. </div>
  215.  
  216. <div style="font-weight: bold; margin-bottom: 10px; margin-top: 5px; margin-left: 10px; padding-top: 15px; text-decoration: underline;">COLLEGE</div>
  217. <div style="margin-left: 15px; padding-bottom: 15px;">
  218. <table>
  219. <tr>
  220. <td>Attainment:</td>
  221. <td><select name="college_attainment">
  222. <option></option>
  223. <option value="Graduated">Graduated</option>
  224. <option value="Not Graduated">Not Graduated</option>
  225. </select></td>
  226. <td><div style="margin-left: 50px;">Course:</td><td><input type="text" name="college_course" /></div></td>
  227. </tr>
  228. <tr>
  229. <td>Year Graduated:</td><td><input type="text" name="college_yr_graduated"/></td>
  230. <td><div style="margin-left: 50px;">Highest Year Earned:</td><td><input type="text" name="college_highest_yr_earned"/></div></td>
  231. </tr>
  232. <tr>
  233. <td>School:</td><td><input type="text" name="college_school" /></td>
  234. </tr>
  235. </table>
  236. </div>
  237.  
  238. <div style="font-family: Tahoma, Geneva, sans-serif; width: 1030px; height:30px; border: 1px; background:#696969; text-align:center; font-weight:bold; font-size: 20px; padding-top: 7px;">EMPLOYMENT INFORMATION</div>
  239. <div style="margin-left: 15px; padding-top: 15px; padding-bottom: 15px;">
  240. <table>
  241. <tr>
  242. <td>Currently Employed:</td>
  243. <td><select name="currently_employed" required >
  244. <option></option>
  245. <option value="Yes">Yes</option>
  246. <option value="No">No</option>
  247. </select>*</td>
  248. <td><div style="margin-left: 50px;">Present Employment:</td><td><input type="text" name="present_employment"/></div></td>
  249. </tr>
  250. <tr>
  251. <td>Office Name:</td><td><input type="text" name="office_name"/></td>
  252. <td><div style="margin-left: 50px;">Office Address:</td><td><input type="text" name="office_address"/></div></td>
  253. </tr>
  254. <tr>
  255. <td>Years in Employment:</td><td><input type="text" name="yrs_in_employment"/></td>
  256. <td><div style="margin-left: 50px;">Position:</td><td><input type="text" name="position"/></div></td>
  257. </tr>
  258. </table>
  259. </div>
  260.  
  261. <div style="font-family: Tahoma, Geneva, sans-serif; width: 1030px; height:30px; border: 1px; background:#696969; text-align:center; font-weight:bold; font-size: 20px; padding-top: 7px;">ELIGIBILITY INFORMATION</div>
  262. <div style="margin-left: 15px; padding-top: 15px; padding-bottom: 35px;">
  263. <table>
  264. <tr>
  265. <td>Examination Passed:</td><td><input type="text" name="examination_passed" /></td>
  266. <td><div style="margin-left: 50px;">Rating Obtained:</td><td><input type="text" name="rating_obtained" /></div></td>
  267. </tr>
  268. <tr>
  269. <td>Date of Examinaon:</td><td><input type="date" name="date_of_examination" /></td>
  270. <td><div style="margin-left: 50px;">Place of Examination:</td><td><input type="text" name="place_of_examination" /></div></td>
  271. </tr>
  272. </table>
  273. </div>
  274. <div style="margin-left: 870px; padding-top: 0px; padding-bottom: 15px;">
  275. <input type="submit" name="register" value="SUBMIT" />
  276. <input type="submit" name="reset" value="RESET" />
  277. </div>
  278. </form>
  279. </div>
  280.  
  281. <div class="submenu">
  282. <a href="index.php">Home</a> |
  283. <a href="examsched.php">Examination Schedules</a> |
  284. <a href="announcements.php">Announcements</a> |
  285. <a href="faq.php">FAQ</a> |
  286. <a href="aboutus.php">Contact us</a>
  287. </div>
  288.  
  289. <div class="footer">
  290. Copyright &copy; 2015 Civil Service Online Registration<br>
  291. All Rights Reserved.
  292. </div>
  293. </body>
  294. </html>
  295.  
  296.  
  297. <?php
  298. $hostname = "localhost";
  299. $username = "root";
  300. $password = "";
  301.  
  302. mysql_connect($hostname, $username, $password) or die ("Could not connect to the host.");
  303. mysql_select_db("cscdb") or die ("Cannot select db.");
  304.  
  305. if (isset($_POST['register'])){
  306.  
  307. $myusername = $_POST['username'];
  308. $mypassword = $_POST['password'];
  309. $myconfirmpassword = $_POST['confirmpassword'];
  310. $myemail_add = $_POST['emailadd'];
  311.  
  312. $avatar_name = $_FILES['avatar']['name'];
  313. $avatar_type = $_FILES['avatar']['type'];
  314. $avatar_size = $_FILES['avatar']['size'];
  315. $avatar_tmp_name = $_FILES['avatar']['tmp_name'];
  316.  
  317. $image = $avatar_name;
  318.  
  319. $myfname = $_POST['fname'];
  320. $mymidname = $_POST['midname'];
  321. $mylname = $_POST['lname'];
  322. $mygender = $_POST['sex'];
  323. $mybdate = $_POST['bdate'];
  324. $mybplace = $_POST['bplace'];
  325. $myage = $_POST['age'];
  326. $mypaddress = $_POST['paddress'];
  327. $myheight = $_POST['height'];
  328. $myweight = $_POST['weight'];
  329. $myreligion = $_POST['religion'];
  330. $mycivstat = $_POST['civstat'];
  331. $mycnum = $_POST['cnum'];
  332. $myregion = $_POST['region'];
  333. $mycitytown = $_POST['citytown'];
  334. $myzipcode = $_POST['zipcode'];
  335.  
  336. $mymm_fname = $_POST['mm_fname'];
  337. $mymm_midname = $_POST['mm_midname'];
  338. $mymm_lname = $_POST['mm_lname'];
  339.  
  340. $myemer_fname = $_POST['emer_fname'];
  341. $myemer_midname = $_POST['emer_midname'];
  342. $myemer_lname = $_POST['emer_lname'];
  343. $myemer_cnum = $_POST['emer_cnum'];
  344. $myemer_address = $_POST['emer_address'];
  345. $myemer_relation = $_POST['relation'];
  346.  
  347. $myelem_attainment = $_POST['elem_attainment'];
  348. $myelem_yr_graduated = $_POST['elem_yr_graduated'];
  349. $myelem_highest_grd_earned = $_POST['elem_highest_grd_earned'];
  350. $myelem_school = $_POST['elem_school'];
  351.  
  352. $myhischool_attainment = $_POST['highschool_attainment'];
  353. $myhischool_yr_graduated = $_POST['highschool_yr_graduated'];
  354. $myhischool_highest_yr_earned = $_POST['highschool_highest_yr_earned'];
  355. $myhischool_school = $_POST['highschool_school'];
  356.  
  357. $myvocational_attainment = $_POST['vocational_attainment'];
  358. $myvocational_yr_graduated = $_POST['vocational_yr_graduated'];
  359. $myvocational_highest_yr_earned = $_POST['vocational_highest_yr_earned'];
  360. $myvocational_school = $_POST['vocational_school'];
  361.  
  362. $mycollege_attainment = $_POST['college_attainment'];
  363. $mycollege_course = $_POST['college_course'];
  364. $mycollege_yr_graduated = $_POST['college_yr_graduated'];
  365. $mycollege_highest_yr_earned = $_POST['college_highest_yr_earned'];
  366. $mycollege_school = $_POST['college_school'];
  367.  
  368. $myemployment = $_POST['currently_employed'];
  369. $mypresent_employment = $_POST['present_employment'];
  370. $myoffice_name = $_POST['office_name'];
  371. $myoffice_address = $_POST['office_address'];
  372. $myyrs_in_employment = $_POST['yrs_in_employment'];
  373. $myposition = $_POST['position'];
  374.  
  375. $myexamination_passed = $_POST['examination_passed'];
  376. $myrating_obtained = $_POST['rating_obtained'];
  377. $mydate_of_examination = $_POST['date_of_examination'];
  378. $myplace_of_examination = $_POST['place_of_examination'];
  379.  
  380. $unamequery = "SELECT * FROM applicant WHERE USERNAME = '$myusername'";
  381. $res1 = mysql_query($unamequery) or die (mysql_error());
  382. $count1 = mysql_num_rows($res1) or die (mysql_error());
  383.  
  384. $passquery = "SELECT * FROM applicant WHERE PASSWORD = '$mypassword'";
  385. $res2 = mysql_query($passquery) or die (mysql_error());
  386. $count2 = mysql_num_rows($res2) or die (mysql_error());
  387.  
  388. $emailquery = "SELECT * FROM applicant WHERE EMAIL_ADDRESS = '$myemail_add'";
  389. $res3 = mysql_query($emailquery) or die (mysql_error());
  390. $count3 = mysql_num_rows($res3) or die (mysql_error());
  391.  
  392. //$namequery = "SELECT * FROM applicant WHERE FIRSTNAME = '$myfname', LASTNAME = '$mylname', MIDDLENAME = '$mymidname'";
  393. //$res4 = mysql_query($namequery) or die (mysql_error());
  394. //$count4 = mysql_num_rows($res4) or die (mysql_error());
  395.  
  396. if(strlen($mypassword)<=7){
  397. echo "<script type='text/JavaScript'>
  398. alert('Password should not be less than 8 characters.')
  399. </script>";
  400. }else if($mypassword!=$myconfirmpassword){
  401. echo "<script type='text/JavaScript'>
  402. alert('Password and Confirm Password did not match.')
  403. </script>";
  404. }else if ($count1==1){
  405. echo "<script type='text/JavaScript'>
  406. alert('Password already taken. Please use another one.')
  407. </script>";
  408. }else if ($count2==1){
  409. echo "<script type='text/JavaScript'>
  410. alert('Username already taken. Please use another one.')
  411. </script>";
  412. }else if ($count3==1){
  413. echo "<script type='text/JavaScript'>
  414. alert('Email address already taken. Please use another one.')
  415. </script>";
  416. //}else if ($count4!=0){
  417. //echo "<script type='text/JavaScript'>
  418. //alert('You are already registered!')
  419. //</script>";
  420. }else{
  421. move_uploaded_file($avatar_tmp_name,"images/applicant/$avatar_name");
  422.  
  423. $query = "INSERT INTO applicant (PHOTO, USERNAME, PASSWORD, CONFIRMPASSWORD, EMAIL_ADDRESS, BIRTHDATE, BIRTHPLACE, AGE, REGION, CITY_TOWN, FIRSTNAME, LASTNAME, MIDDLENAME, GENDER,
  424. EMERGENCY_FIRSTNAME, EMERGENCY_MIDDLENAME, EMERGENCY_LASTNAME, EMERGENCY_CONTACT_NUMBER, EMER_ADDRESS, RELATION, PERMANENT_ADDRESS, ZIPCODE, HEIGHT, WEIGHT, RELIGION, CIVIL_STATUS, CONTACT_NUMBER,
  425. MM_FIRSTNAME, MM_MIDDLENAME, MM_LASTNAME,
  426. ELEM_ATTAINMENT, ELEM_YR_GRADUATED, ELEM_HIGHEST_GRD_YR_EARNED, ELEM_SCHOOL, HIGHSCHOOL_ATTAINMENT,
  427. HIGHSCHOOL_YR_GRADUATED, HIGHSCHOOL_HIGHEST_YR_EARNED, HIGHSCHOOL_SCHOOL,
  428. VOCATIONAL_ATTAINMENT, VOCATIONAL_YR_GRADUATED, VOCATIONAL_HIGHEST_YR_EARNED, VOCATIONAL_SCHOOL,
  429. COLLEGE_ATTAINMENT, COLLEGE_YR_GRADUATED, COLLEGE_COURSE, COLLEGE_HIGHEST_YR_EARNED, COLLEGE_SCHOOL,
  430. CURRENTLY_EMPLOYED, PRESENT_EMPLOYMENT, OFFICE_NAME, OFFICE_ADDRESS, POSITION, YEARS_IN_EMPLOYMENT,
  431. EXAMINATION_PASSED, RATING_OBTAINED, DATE_OF_EXAMINATION, PLACE_OF_EXAMINATION)
  432. VALUES ('$image', '$myusername', '$mypassword', '$myconfirmpassword', '$myemail_add', '$mybdate', '$mybplace', '$myage', '$myregion', '$mycitytown', '$myfname', '$mylname', '$mymidname', '$mygender',
  433. '$myemer_fname', '$myemer_midname', '$myemer_lname', '$myemer_cnum', '$myemer_address', '$myemer_relation', '$mypaddress', '$myzipcode', '$myheight', '$myweight', '$myreligion', '$mycivstat', '$mycnum',
  434. '$mymm_fname', '$mymm_midname', '$mymm_lname',
  435. '$myelem_attainment', '$myelem_yr_graduated', '$myelem_highest_grd_earned', '$myelem_school',
  436. '$myhischool_attainment', '$myhischool_yr_graduated', '$myhischool_highest_yr_earned', '$myhischool_school',
  437. '$myvocational_attainment', '$myvocational_yr_graduated', '$myvocational_highest_yr_earned', '$myvocational_school',
  438. '$mycollege_attainment', '$mycollege_yr_graduated', '$mycollege_course', '$mycollege_highest_yr_earned', '$mycollege_school',
  439. '$myemployment', '$mypresent_employment', '$myoffice_name', '$myoffice_address', '$myposition', '$myyrs_in_employment',
  440. '$myexamination_passed', '$myrating_obtained', '$mydate_of_examination', '$myplace_of_examination')";
  441.  
  442. mysql_query($query) or die (mysql_error());
  443.  
  444. echo"<script>alert('Successfully registered.')</script>";
  445. //header ("location:index.php");
  446. }
  447. }
  448.  
  449. if (isset($_POST['reset'])){
  450. $_POST['username'] = "";
  451. $_POST['password'] = "";
  452. $_POST['confirmpassword'] = "";
  453. $_POST['emailadd']= "";
  454. $_POST['fname'] = "";
  455. $_POST['midname'] = "";
  456. $_POST['lname'] = "";
  457. $_POST['sex'] = "";
  458. $_POST['bdate'] = "";
  459. $_POST['bplace'] = "";
  460. $_POST['age'] = "";
  461. $_POST['paddress'] = "";
  462. $_POST['height'] = "";
  463. $_POST['weight'] = "";
  464. $_POST['religion'] = "";
  465. $_POST['civstat']= "";
  466. $_POST['cnum'] = "";
  467. $_POST['region'] = "";
  468. $_POST['citytown'] = "";
  469. $_POST['zipcode'] = "";
  470.  
  471. $_POST['mm_fname'] = "";
  472. $_POST['mm_midname'] = "";
  473. $_POST['mm_lname'] = "";
  474.  
  475. $_POST['emer_fname'] = "";
  476. $_POST['emer_midname'] = "";
  477. $_POST['emer_lname'] = "";
  478. $_POST['emer_cnum'] = "";
  479. $_POST['emer_address'] = "";
  480. $_POST['relation'] = "";
  481.  
  482. $_POST['elem_attainment'] = "";
  483. $_POST['elem_yr_graduated'] = "";
  484. $_POST['elem_highest_grd_earned'] = "";
  485. $_POST['elem_school'] = "";
  486.  
  487. $_POST['highschool_attainment'] = "";
  488. $_POST['highschool_yr_graduated'] = "";
  489. $_POST['highschool_highest_yr_earned'] = "";
  490. $_POST['highschool_school'] = "";
  491.  
  492. $_POST['vocational_attainment'] = "";
  493. $_POST['vocational_yr_graduated'] = "";
  494. $_POST['vocational_highest_yr_earned'] = "";
  495. $_POST['vocational_school'] = "";
  496.  
  497. $_POST['college_attainment'] = "";
  498. $_POST['college_yr_graduated'] = "";
  499. $_POST['college_course'] = "";
  500. $_POST['college_highest_yr_earned'] = "";
  501. $_POST['college_school'] = "";
  502.  
  503. $_POST['currently_employed'] = "";
  504. $_POST['office_name'] = "";
  505. $_POST['yrs_in_employment'] = "";
  506. $_POST['present_employment'] = "";
  507. $_POST['office_address'] = "";
  508. $_POST['position'] = "";
  509.  
  510. $_POST['examination_passed'] = "";
  511. $_POST['date_of_examination'] = "";
  512. $_POST['rating_obtained'] = "";
  513. $_POST['place_of_examination'] = "";
  514. }
  515. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!