/core/register/entries/submitchoices.php

https://github.com/adivik2000/nigraha · PHP · 304 lines · 273 code · 31 blank · 0 comment · 6 complexity · c1058e81f25d07af0dfbc7328dd18084 MD5 · raw file 

    

  1. <?php
    2. 

  2.       $conn = mysql_connect("localhost", "root", "password") or die(mysql_error());
    3. 

  3.       mysql_select_db("mnit_profiles", $conn);
    4. 

  4.       $res = mysql_query("SELECT * FROM students WHERE userid='".$_POST['userid']."'") or die(mysql_error());
    5. 

  5.       $arr = mysql_fetch_assoc($res);
    6. 

  6.                 
    7. 

  7. ?>
    8. 

  8. <html>
    9. 

  9. <head>
    10. 

  10.   <title>MNIT Registration Step 5</title>
    11. 

  11. </head>
    12. 

  12. 

  13. <body bgcolor="#FFFFFF" link="#2080D0" vlink="#0060B0" alink="#000000" marginheight="10">
    14. 

  14.   <table align="center" border="0" width="75%" cellspacing="0" cellpadding="3">
    15. 

  15.     <tr>
    16. 

  16.       <td width="100%" valign="bottom">
    17. 

  17.         <table border="0" width="100%" cellspacing="0" cellpadding="2">
    18. 

  18.           <tr>
    19. 

  19.             <td bgcolor="#000000">
    20. 

  20.               <table border="0" width="100%" cellspacing="0" cellpadding="2">
    21. 

  21.                 <tr>
    22. 

  22.                   <td width="92%" nowrap bgcolor="#FFE880"><b>MNIT Account Registration (Even Semester) 2007</b></td>
    23. 

  23. 

  24.                   <td width="8%" align="right" valign="bottom" nowrap bgcolor="#FFE880"><small><b>Step
    25. 

  25.                   5</b></small></td>
    26. 

  26.                 </tr>
    27. 

  27.               </table>
    28. 

  28.             </td>
    29. 

  29.           </tr>
    30. 

  30.         </table>
    31. 

  31.       </td>
    32. 

  32. 

  33.       <td valign="bottom">
    34. 

  34.         <table border="0" width="100%" cellspacing="0" cellpadding="2">
    35. 

  35.           <tr>
    36. 

  36.             <td bgcolor="#000000">
    37. 

  37.               <table border="0" width="100%" cellspacing="0" cellpadding="1">
    38. 

  38.                 <tr>
    39. 

  39.                   <td bgcolor="#C080F0"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    40. 

  40.                 </tr>
    41. 

  41.               </table>
    42. 

  42.             </td>
    43. 

  43.           </tr>
    44. 

  44.         </table>
    45. 

  45.       </td>
    46. 

  46. 

  47.       <td valign="bottom">
    48. 

  48.         <table border="0" width="100%" cellspacing="0" cellpadding="2">
    49. 

  49.           <tr>
    50. 

  50.             <td bgcolor="#000000">
    51. 

  51.               <table border="0" width="100%" cellspacing="0" cellpadding="1">
    52. 

  52.                 <tr>
    53. 

  53.                   <td bgcolor="#FFC040"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    54. 

  54.                 </tr>
    55. 

  55.               </table>
    56. 

  56.             </td>
    57. 

  57.           </tr>
    58. 

  58.         </table>
    59. 

  59.       </td>
    60. 

  60. 

  61.       <td valign="bottom">
    62. 

  62.         <table border="0" width="100%" cellspacing="0" cellpadding="2">
    63. 

  63.           <tr>
    64. 

  64.             <td bgcolor="#000000">
    65. 

  65.               <table border="0" width="100%" cellspacing="0" cellpadding="1">
    66. 

  66.                 <tr>
    67. 

  67.                   <td bgcolor="#80C0F0"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    68. 

  68.                 </tr>
    69. 

  69.               </table>
    70. 

  70.             </td>
    71. 

  71.           </tr>
    72. 

  72.         </table>
    73. 

  73.       </td>
    74. 

  74. 

  75.       <td valign="bottom">
    76. 

  76.         <table border="0" width="100%" cellspacing="0" cellpadding="2">
    77. 

  77.           <tr>
    78. 

  78.             <td bgcolor="#000000">
    79. 

  79.               <table border="0" width="100%" cellspacing="0" cellpadding="1">
    80. 

  80.                 <tr>
    81. 

  81.                   <td bgcolor="#80F0C0"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    82. 

  82.                 </tr>
    83. 

  83.               </table>
    84. 

  84.             </td>
    85. 

  85.           </tr>
    86. 

  86.         </table>
    87. 

  87.       </td>
    88. 

  88. 

  89.       <td valign="bottom">
    90. 

  90.         <table border="0" width="100%" cellspacing="0" cellpadding="2">
    91. 

  91.           <tr>
    92. 

  92.             <td bgcolor="#000000">
    93. 

  93.               <table border="0" width="100%" cellspacing="0" cellpadding="1">
    94. 

  94.                 <tr>
    95. 

  95.                   <td bgcolor="#F09090"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    96. 

  96.                 </tr>
    97. 

  97.               </table>
    98. 

  98.             </td>
    99. 

  99.           </tr>
    100. 

  100.         </table>
    101. 

  101.       </td>
    102. 

  102.     </tr>
    103. 

  103.   </table>
    104. 

  104. 

  105.   <table align="center" width="75%" border="0" cellspacing="0" cellpadding="0">
    106. 

  106.     <tr>
    107. 

  107.       <td valign="top">
    108. 

  108.         <table border="0" width="100%" cellspacing="0" cellpadding="3">
    109. 

  109.           <tr>
    110. 

  110.             <td>
    111. 

  111.               <table border="0" width="*%" cellspacing="0" cellpadding="2">
    112. 

  112.                 <tr>
    113. 

  113.                   <td bgcolor="#000000">
    114. 

  114.                     <table border="0" width="100%" cellspacing="0" cellpadding="1">
    115. 

  115.                       <tr>
    116. 

  116.                         <td bgcolor="#C080F0"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    117. 

  117.                       </tr>
    118. 

  118.                     </table>
    119. 

  119.                   </td>
    120. 

  120.                 </tr>
    121. 

  121.               </table>
    122. 

  122.             </td>
    123. 

  123.           </tr>
    124. 

  124. 

  125.           <tr>
    126. 

  126.             <td>
    127. 

  127.               <table border="0" width="*%" cellspacing="0" cellpadding="2">
    128. 

  128.                 <tr>
    129. 

  129.                   <td bgcolor="#000000">
    130. 

  130.                     <table border="0" width="100%" cellspacing="0" cellpadding="1">
    131. 

  131.                       <tr>
    132. 

  132.                         <td bgcolor="#FFC040"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    133. 

  133.                       </tr>
    134. 

  134.                     </table>
    135. 

  135.                   </td>
    136. 

  136.                 </tr>
    137. 

  137.               </table>
    138. 

  138.             </td>
    139. 

  139.           </tr>
    140. 

  140. 

  141.           <tr>
    142. 

  142.             <td>
    143. 

  143.               <table border="0" width="*%" cellspacing="0" cellpadding="2">
    144. 

  144.                 <tr>
    145. 

  145.                   <td bgcolor="#000000">
    146. 

  146.                     <table border="0" width="100%" cellspacing="0" cellpadding="1">
    147. 

  147.                       <tr>
    148. 

  148.                         <td bgcolor="#80C0F0"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    149. 

  149.                       </tr>
    150. 

  150.                     </table>
    151. 

  151.                   </td>
    152. 

  152.                 </tr>
    153. 

  153.               </table>
    154. 

  154.             </td>
    155. 

  155.           </tr>
    156. 

  156. 

  157.           <tr>
    158. 

  158.             <td>
    159. 

  159.               <table border="0" width="*%" cellspacing="0" cellpadding="2">
    160. 

  160.                 <tr>
    161. 

  161.                   <td bgcolor="#000000">
    162. 

  162.                     <table border="0" width="100%" cellspacing="0" cellpadding="1">
    163. 

  163.                       <tr>
    164. 

  164.                         <td bgcolor="#80F0C0"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    165. 

  165.                       </tr>
    166. 

  166.                     </table>
    167. 

  167.                   </td>
    168. 

  168.                 </tr>
    169. 

  169.               </table>
    170. 

  170.             </td>
    171. 

  171.           </tr>
    172. 

  172. 

  173.           <tr>
    174. 

  174.             <td>
    175. 

  175.               <table border="0" width="*%" cellspacing="0" cellpadding="2">
    176. 

  176.                 <tr>
    177. 

  177.                   <td bgcolor="#000000">
    178. 

  178.                     <table border="0" width="100%" cellspacing="0" cellpadding="1">
    179. 

  179.                       <tr>
    180. 

  180.                         <td bgcolor="#F09090"><font size="-2">&nbsp;&nbsp;&nbsp;</font></td>
    181. 

  181.                       </tr>
    182. 

  182.                     </table>
    183. 

  183.                   </td>
    184. 

  184.                 </tr>
    185. 

  185.               </table>
    186. 

  186.             </td>
    187. 

  187.           </tr>
    188. 

  188.         </table>
    189. 

  189.       </td>
    190. 

  190. 

  191.       <td width="100%" valign="top">
    192. 

  192.         <table width="100%" border="0" cellspacing="0" cellpadding="3">
    193. 

  193.           <tr>
    194. 

  194.             <td>
    195. 

  195.               <table border="0" width="100%" cellspacing="0" cellpadding="2">
    196. 

  196.                 <tr>
    197. 

  197.                   <td bgcolor="#000000">
    198. 

  198.                     <table border="0" width="100%" cellspacing="0" cellpadding="3">
    199. 

  199.                       <tr>
    200. 

  200.                         <td valign="top" bgcolor="#E0E0E0">
    201. 

  201.                           <p>
    202. 

  202.                             <?php
    203. 

  203.                                 $count=1;
    204. 

  204.                                 while(isset($_POST['add'.$count])) {
    205. 

  205.                                   if($_POST['add'.$count]!='') $courses[]=$_POST['add'.$count];
    206. 

  206.                                   $count++;
    207. 

  207.                                 }
    208. 

  208.                                 if (($arr['semester'] == 6) and (isset($_POST['miniproj'])) and (trim($_POST['facultymp']) != ''))
    209. 

  209.                                     $courses[] = trim($_POST['facultymp'])." - MP";
    210. 

  210.                                 $toadd = serialize($courses);
    211. 

  211.                                 $squery = mysql_query("UPDATE students SET courses='".$toadd."' WHERE userid = '".$arr['userid']."'");
    212. 

  212.                             ?>
    213. 

  213.                             All Done!<br>
    214. 

  214.                             The student has been registered for the following courses:
    215. 

  215.                             <center><h3>MALAVIYA NATIONAL INSTITUTE OF TECHNOLOGY, JAIPUR</h3></center>
    216. 

  216.                             <table width="100%" border="0">
    217. 

  217.                               <tr>
    218. 

  218.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">Branch: <?php echo $arr['dept'] ?>
    219. 

  219.                                 </font></td>
    220. 

  220. 

  221.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">Semester: <?php echo $arr['semester'] ?></font></td>
    222. 

  222. 

  223.                                 <td width="35%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo date("F j, Y, g:i a"); ?></font></td>
    224. 

  224.                               </tr>
    225. 

  225. 

  226.                               <tr>
    227. 

  227.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
    228. 

  228. 

  229.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
    230. 

  230. 

  231.                                 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
    232. 

  232.                               </tr>
    233. 

  233. 

  234.                               <tr>
    235. 

  235.                                 <td width="25%"><font face="Verdana, Arial, Helvetica, sans-serif">Student ID: <?php echo $arr['userid'] ?>
    236. 

  236.                                 </font></td>
    237. 

  237. 

  238.                                 <td width="40%"><font face="Verdana, Arial, Helvetica, sans-serif">
    239. 

  239.                                 <?php echo $arr['fullname'] ?></font></td>
    240. 

  240.                                 
    241. 

  241. 

  242.                                 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Year Of Joining: <?php echo $arr['yearofjoin'] ?></font></td>
    243. 

  243.                               </tr>
    244. 

  244.                             
    245. 

  245.                               <tr>
    246. 

  246.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
    247. 

  247. 

  248.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
    249. 

  249. 

  250.                                 <td><font face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
    251. 

  251.                               </tr>
    252. 

  252.                               
    253. 

  253.                             </table><table width="100%" border="1">
    254. 

  254.                               <tr>
    255. 

  255.                                 <td><center><strong>Course Code</strong></center></td>
    256. 

  256.                                 <td><center><strong>Title</strong></center></td> 
    257. 

  257.                                 <td><center><strong>Credits</strong></center></td>
    258. 

  258.                                 <td><center><strong>Category</strong></center></td>
    259. 

  259.                               </tr>
    260. 

  260.                               <?php 
    261. 

  261.                                 mysql_select_db("mnit_master");
    262. 

  262.                                 $credits=0;
    263. 

  263.                                 foreach($courses as $code) {
    264. 

  264.                                   $que1 = mysql_query("SELECT * FROM syllabus WHERE code='".$code."'") or die(mysql_error());
    265. 

  265.                                   $list = mysql_fetch_assoc($que1);
    266. 

  266.                                                                     
    267. 

  267.                                   echo "<tr>
    268. 

  268.                                   <td><center>".$code."</center></td>
    269. 

  269.                                   <td><center>".$list['title']."</center></td>"; 
    270. 

  270.                                   $dispcredit=$list['credits'];
    271. 

  271.                                   if($list['credits']=='') $dispcredit=3;
    272. 

  272.                                   $credits+=$dispcredit;
    273. 

  273.                                   echo "<td><center>".$dispcredit."</center></td>
    274. 

  274.                                   <td><center>".$list['area']."</center></td></tr>";
    275. 

  275.                                   
    276. 

  276.                                 }
    277. 

  277.                                 echo"<tr>
    278. 

  278.                                   <td colspan=2>TOTAL CREDITS</td> 
    279. 

  279.                                   <td><center>".$credits."</center></td>
    280. 

  280.                                   <td>&nbsp; </td>
    281. 

  281.                                   </tr>";
    282. 

  282.                               ?>
    283. 

  283.                             </table>
    284. 

  284.                             
    285. 

  285.                         </p>
    286. 

  286.                         <p><a href="index.php">NEXT REGISTRATION!</a></p>
    287. 

  287. 			            </td>
    288. 

  288.                       </tr>
    289. 

  289.                     </table>
    290. 

  290.                   </td>
    291. 

  291.                 </tr>
    292. 

  292.               </table>
    293. 

  293.             </td>
    294. 

  294.           </tr>
    295. 

  295.         </table>
    296. 

  296.       </td>
    297. 

  297.     </tr>
    298. 

  298.   </table>
    299. 

  299. 

  300.   <center>
    301. 

  301.     <small><b>&#169; 2005-2007 Malaviya National Institute of Technology</b></small>
    302. 

  302.   </center>
    303. 

  303. </body>
    304. 

  304. </html>
    305.