API tools faq
paste
Guest User

Untitled

a guest
May 27th, 2018
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.05 KB | None | 0 0
raw download clone embed print report
  1. //include database connection
  2. require ("../db_connect.php");
  3.  
  4. if(isset($_GET['GRNO'])) {
  5. $GRNO = $_GET['GRNO'];
  6. }
  7. if(isset($_GET['SeatNo'])) {
  8. $SeatNo = $_GET['SeatNo'];
  9. }
  10.  
  11. $query = "SELECT *
  12. FROM stud_admission_details, stud_personal_details, stu_app
  13. WHERE stud_admission_details.SeatNo = '".$SeatNo."'
  14. AND stud_admission_details.seatNo = stud_personal_details.SeatNo
  15. AND stud_admission_details.SeatNo = stu_app.ssc_seat_no";
  16.  
  17. $statement = $con->prepare($query);
  18. $statement->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
  19.  
  20. $statement->execute();
  21.  
  22. $userData_List = array();
  23.  
  24. while($row=$statement->fetch(PDO::FETCH_ASSOC)){
  25. $userData_List = $row;
  26. }
  27.  
  28. $statement->closeCursor();
  29. unset($con);
  30. unset($statement);
  31.  
  32. echo json_encode($userData_List);
  33.  
  34. if(isset($_POST['updatePersonalDetails'])) {
  35. try{
  36. //TOTAL 29 RECORDS
  37. $query_stud_personal_details = $time_zone." UPDATE stud_personal_details
  38. SET
  39. `Surname` = UPPER(?), `StudentName` = UPPER(?), `FatherName` = UPPER(?), `MotherName` = UPPER(?),
  40. `DOB` = ?, `Gender` = ?, `AddLine1` = UPPER(?), `AddLine2` = UPPER(?), `AddLine3` = UPPER(?), `Pincode` = ?,
  41. `NativeAddLine1` = UPPER(?), `NativeAddLine2` = UPPER(?), `NativeAddLine3` = UPPER(?), `NativePincode` = ?,
  42. `BloodGroup` = ?, `POB` = UPPER(?), `MotherTongue` = ?, `Religion` = ?, `Caste` = ?, `SubCaste` = ?,
  43. `Handicapped` = ?, Foreigner = ?, `studentNumber` = ?, `parentNumber` = ?, `homeNumber` = ?, Email = ?,
  44. `Spectacles` = ?, `AadharNo` = ?, personalDetails = '1', personalDetailsAccess = NOW()
  45. WHERE
  46. SeatNo = ?";
  47.  
  48. //TOTAL 16 RECORDS
  49. $query_stu_app = $time_zone." UPDATE stu_app
  50. SET
  51. `center_code` = '', `sch_indx_no` = '3206001', `app_no` = '',
  52. `stu_sname` = UPPER(?), `stu_fname` = UPPER(?), `stu_fath_name` = UPPER(?), `stu_moth_name` = UPPER(?),
  53. `addr1` = UPPER(?), `addr2` = UPPER(?), `addr3` = UPPER(?), `pin_cod` = ?,
  54. `gender_id` = ?, `cast_id` = ?, `handi_id` = ?,
  55. `medium_id` = '1', `stu_exm_cateA` = '1', `stu_exm_cateB` = '1', `stu_exm_cateC` = '2',
  56. `stu_exm_cateE` = ?, `stream_id` = '1', `enrol_month` = '', `enrol_year` = '',
  57. `enrol_no` = '', `last_exm_month` = '', `last_exm_year` = '', `last_exm_seat` = '',
  58. `total_exemption_claim` = '0', `1_lang_sub_code` = '01', `1_lang_ans_code` = '1',
  59. `xmp_1_seat` = '', `xmp_1_month` = '', `xmp_1_year` = '', `xmp_1_marks` = '',
  60. `xmp_2_seat` = '', `xmp_2_month` = '', `xmp_2_year` = '', `xmp_2_marks` = '',
  61. `xmp_3_seat` = '', `xmp_3_month` = '', `xmp_3_year` = '', `xmp_3_marks` = '',
  62. `xmp_4_seat` = '', `xmp_4_month` = '', `xmp_4_year` = '', `xmp_4_marks` = '',
  63. `xmp_5_seat` = '', `xmp_5_month` = '', `xmp_5_year` = '', `xmp_5_marks` = '',
  64. `xmp_6_seat` = '', `xmp_6_month` = '', `xmp_6_year` = '', `xmp_6_marks` = '',
  65. `xmp_7_seat` = '', `xmp_7_month` = '', `xmp_7_year` = '', `xmp_7_marks` = '',
  66. `xmp_8_seat` = '', `xmp_8_month` = '', `xmp_8_year` = '', `xmp_8_marks` = '',
  67. `photo_id` = '', `sign_id` = '',
  68. `session_cal_id` = '6', `app_date` = NOW(), `upload_status` = 'no', `delete_status` = 'no',
  69. `evs_sub_code` = '31', `evs_ans_code` = '1',
  70. `elgbl_month` = '', `elgbl_year` = '', `elgbl_type` = '', `elgbl_cert_no` = '',
  71. `div_id` = '4', `dob` = ?, `religion_id` = ?, `rand_no` = '', `course_id` = '27',
  72. `iso_singl` = '0', `phy_edu` = '30', `phy_edu_lang` = '1',
  73. `xmp_9_seat` = '', `xmp_9_month` = '', `xmp_9_year` = '', `xmp_9_marks` = '', aadhar_no = ?
  74. WHERE
  75. ssc_seat_no = ?";
  76.  
  77. //prepare query for execution
  78. $stmt_stud_personal_details = $con->prepare($query_stud_personal_details);
  79. $stmt_stu_app = $con->prepare($query_stu_app);
  80.  
  81. //PREPARING PAPAMETERS FOR stmt_stud_personal_details
  82. $stu_sname = trim(preg_replace('/s+/',' ', $_POST['stu_sname']));
  83. $stmt_stud_personal_details->bindParam(1, $stu_sname);
  84. $stu_fname = trim(preg_replace('/s+/',' ', $_POST['stu_fname']));
  85. $stmt_stud_personal_details->bindParam(2, $stu_fname);
  86. $stu_fath_name = trim(preg_replace('/s+/',' ', $_POST['stu_fath_name']));
  87. $stmt_stud_personal_details->bindParam(3, $stu_fath_name);
  88. $stu_moth_name = trim(preg_replace('/s+/',' ', $_POST['stu_moth_name']));
  89. $stmt_stud_personal_details->bindParam(4, $stu_moth_name);
  90.  
  91. $stmt_stud_personal_details->bindParam(5, $_POST['DOB']);
  92.  
  93. $gender_id = $_POST['gender_id'];
  94. if($gender_id == 1)
  95. $gender = 'M';
  96. else
  97. $gender = 'F';
  98.  
  99. $stmt_stud_personal_details->bindParam(6, $gender);
  100.  
  101. $addr1 = trim(preg_replace('/s+/',' ', $_POST['addr1']));
  102. $stmt_stud_personal_details->bindParam(7, $addr1);
  103. $addr2 = trim(preg_replace('/s+/',' ', $_POST['addr2']));
  104. $stmt_stud_personal_details->bindParam(8, $addr2);
  105. $addr3 = trim(preg_replace('/s+/',' ', $_POST['addr3']));
  106. $stmt_stud_personal_details->bindParam(9, $addr3);
  107. $stmt_stud_personal_details->bindParam(10, $_POST['pin_cod']);
  108.  
  109. $naddr1 = trim(preg_replace('/s+/',' ', $_POST['naddr1']));
  110. $stmt_stud_personal_details->bindParam(11, $naddr1);
  111. $naddr2 = trim(preg_replace('/s+/',' ', $_POST['naddr2']));
  112. $stmt_stud_personal_details->bindParam(12, $naddr2);
  113. $naddr3 = trim(preg_replace('/s+/',' ', $_POST['naddr3']));
  114. $stmt_stud_personal_details->bindParam(13, $naddr3);
  115. $stmt_stud_personal_details->bindParam(14, $_POST['npin_cod']);
  116.  
  117. $stmt_stud_personal_details->bindParam(15, $_POST['BloodGroup']);
  118.  
  119. $POB = trim(preg_replace('/s+/',' ', $_POST['POB']));
  120. $stmt_stud_personal_details->bindParam(16, $POB);
  121.  
  122. $stmt_stud_personal_details->bindParam(17, $_POST['MotherTongue']);
  123.  
  124. $religion_id = $_POST['religion_id'];
  125. if($religion_id == 0)
  126. $religion = 'NON-MINORITY';
  127. else if($religion_id == 1)
  128. $religion = 'MUSLIM';
  129. else if($religion_id == 2)
  130. $religion = 'CHRISTIAN';
  131. else if($religion_id == 3)
  132. $religion = 'BUDDHIST';
  133. else if($religion_id == 4)
  134. $religion = 'SIKH';
  135. else if($religion_id == 5)
  136. $religion = 'PARSI';
  137. else if($religion_id == 6)
  138. $religion = 'JAIN';
  139. $stmt_stud_personal_details->bindParam(18, $religion);
  140.  
  141. $cast_id = $_POST['cast_id'];
  142. if($cast_id == 1)
  143. $cast = 'SC';
  144. else if($cast_id == 2)
  145. $cast = 'ST';
  146. else if($cast_id == 3)
  147. $cast = 'VJ(A)';
  148. else if($cast_id == 4)
  149. $cast = 'NT(B)';
  150. else if($cast_id == 5)
  151. $cast = 'NT(C)';
  152. else if($cast_id == 6)
  153. $cast = 'NT(D)';
  154. else if($cast_id == 7)
  155. $cast = 'OBC';
  156. else if($cast_id == 8)
  157. $cast = 'SBC';
  158. else if($cast_id == 9)
  159. $cast = 'OPEN';
  160. else if($cast_id == 10)
  161. $cast = 'MARATHA(ESBC)';
  162. else if($cast_id == 11)
  163. $cast = 'MUSLIM(SBC-A)';
  164. $stmt_stud_personal_details->bindParam(19, $cast);
  165.  
  166. $SubCaste = trim(preg_replace('/s+/',' ', $_POST['SubCaste']));
  167. $stmt_stud_personal_details->bindParam(20, $SubCaste);
  168.  
  169. $handi_id = $_POST['handi_id'];
  170. if($handi_id == 0)
  171. $handi = 'NO-HANDICAPPED';
  172. else if($handi_id == 1)
  173. $handi = 'BLIND';
  174. else if($handi_id == 2)
  175. $handi = 'DEAF';
  176. else if($handi_id == 3)
  177. $handi = 'DUMB';
  178. else if($handi_id == 4)
  179. $handi = 'ORTHOPAEDICALLY HANDICAPPED';
  180. else if($handi_id == 5)
  181. $handi = 'SPASTIC';
  182. else if($handi_id == 6)
  183. $handi = 'LEARNING DISABLITY';
  184. else if($handi_id == 7)
  185. $handi = 'AUTISM';
  186. else if($handi_id == 8)
  187. $handi = 'CEREBRAL PALSY';
  188. else if($handi_id == 9)
  189. $handi = 'MENTALLY RETARDED';
  190. $stmt_stud_personal_details->bindParam(21, $handi);
  191.  
  192. $stu_exm_cateE = $_POST['stu_exm_cateE'];
  193. if($stu_exm_cateE == 1)
  194. $Foreigner = 'YES';
  195. else
  196. $Foreigner = 'NO';
  197. $stmt_stud_personal_details->bindParam(22, $Foreigner);
  198.  
  199. $stmt_stud_personal_details->bindParam(23, $_POST['studentNumber']);
  200. $stmt_stud_personal_details->bindParam(24, $_POST['parentNumber']);
  201. $stmt_stud_personal_details->bindParam(25, $_POST['homeNumber']);
  202.  
  203. $stmt_stud_personal_details->bindParam(26, $_POST['Email']);
  204. $stmt_stud_personal_details->bindParam(27, $_POST['Spectacles']);
  205. $stmt_stud_personal_details->bindParam(28, $_POST['aadhar_no']);
  206.  
  207. $stmt_stud_personal_details->bindParam(29, $_POST['SeatNo']);
  208.  
  209.  
  210. //PREPARING PAPAMETERS FOR stmt_stu_app
  211. $stmt_stu_app->bindParam(1, $stu_sname);
  212. $stmt_stu_app->bindParam(2, $stu_fname);
  213. $stmt_stu_app->bindParam(3, $stu_fath_name);
  214. $stmt_stu_app->bindParam(4, $stu_moth_name);
  215. $stmt_stu_app->bindParam(5, $addr1);
  216. $stmt_stu_app->bindParam(6, $addr2);
  217. $stmt_stu_app->bindParam(7, $addr3);
  218. $stmt_stu_app->bindParam(8, $_POST['pin_cod']);
  219. $stmt_stu_app->bindParam(9, $gender_id);
  220. $stmt_stu_app->bindParam(10, $cast_id);
  221. $stmt_stu_app->bindParam(11, $handi_id);
  222. $stmt_stu_app->bindParam(12, $stu_exm_cateE);
  223. $stmt_stu_app->bindParam(13, $_POST['DOB']);
  224. $stmt_stu_app->bindParam(14, $religion_id);
  225. $stmt_stu_app->bindParam(15, $_POST['aadhar_no']);
  226.  
  227. $stmt_stu_app->bindParam(16, $_POST['SeatNo']);
  228.  
  229. // Execute the query
  230. if($stmt_stu_app->execute() && $stmt_stud_personal_details->execute()) {
  231. //echo "Student Parent Details";
  232. $stmt_stud_personal_details->closeCursor();
  233. $stmt_stu_app->closeCursor();
  234. //$stmt_stud_personal_details = null;
  235. //$stmt_stu_app = null;
  236. //$con = null;
  237. //echo "Connection Closed";
  238. echo json_encode(array(
  239. 'status' => 'success',
  240. 'message'=> 'success message'
  241. ));
  242. } else {
  243. $arr1 = $stmt_stud_personal_details->errorInfo();
  244. print_r($arr1);
  245. $arr2 = $stmt_stu_app->errorInfo();
  246. print_r($arr2);
  247. //echo "UNABLE TO CREATED STUDENT.";
  248. echo json_encode(array(
  249. 'status' => 'error',
  250. 'message'=> 'error message'
  251. ));
  252. }
  253. }//end try
  254. catch(PDOException $exception){
  255. echo "ERROR: " . $exception->getMessage();
  256. }
  257. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!