/page_4_2.php

https://gitlab.com/optimistic_mamun/project1 · PHP · 290 lines · 275 code · 15 blank · 0 comment · 223 complexity · 15dd901306065d44b06f0066f083ab37 MD5 · raw file 

    

  1. <?php ob_start();?>
    2. 

  2. <?php include("second_header.php"); ?>
    3. 

  3. 	<?php
    4. 

  4. 	session_start();
    5. 

  5. 	$roll=$_SESSION['myValue']; 
    6. 

  6. 	include('connect.php');
    7. 

  7. 	 $query = "SELECT * FROM ice_4_2 WHERE roll='$roll'";
    8. 

  8. 	 $result = mysql_query($query) or die(mysql_error());
    9. 

  9. 		$count = mysql_num_rows($result);
    10. 

  10. 		if($count==1){
    11. 

  11. while ($row = mysql_fetch_array($result)) {
    12. 

  12. $roll = $row['roll'];
    13. 

  13. $name = $row['name'];
    14. 

  14. $sub1 = $row['sub1'];
    15. 

  15. $sub2 = $row['sub2'];
    16. 

  16. $sub3 = $row['sub3'];
    17. 

  17. $sub4 = $row['sub4'];
    18. 

  18. $sub5 = $row['sub5'];
    19. 

  19. $sub6 = $row['sub6'];
    20. 

  20. $sub7 = $row['sub7'];
    21. 

  21. $sub8 = $row['sub8'];
    22. 

  22. $sub9 = $row['sub9'];
    23. 

  23. $sub10 = $row['sub10'];
    24. 

  24. $sub11 = $row['sub11'];
    25. 

  25. $cgpa=$row['CGPA'];
    26. 

  26.  $_SESSION['roll']=$roll;
    27. 

  27. 

  28. }
    29. 

  29. }
    30. 

  30. else{
    31. 

  31. 	echo '<h1>Search result not found';
    32. 

  32. }
    33. 

  33. 

  34. 	?>
    35. 

  35. 	<?php
    36. 

  36. 	 include('connect.php');
    37. 

  37. 	 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'";
    38. 

  38. 	 $result1 = mysql_query($query1) or die(mysql_error());
    39. 

  39. 		$count1 = mysql_num_rows($result1);
    40. 

  40. 		while ($row1 = mysql_fetch_array($result1)) {
    41. 

  41. 			$f_name=$row1['F_name'];
    42. 

  42. 			$m_name=$row1['M_name'];
    43. 

  43. 			$session = $row1['session'];
    44. 

  44. 			$reg = $row1['reg'];
    45. 

  45. 		}
    46. 

  46. 

  47. 	?>
    48. 

  48. 	<?php
    49. 

  49. 	?>
    50. 

  50. 	<?php 
    51. 

  51. 	if($sub1>=80){$result1=4.00;}
    52. 

  52. 	else if($sub1>=75){$result1=3.75;}
    53. 

  53. 	else if($sub1>=70){$result1=3.50;}
    54. 

  54. 	else if($sub1>=65){$result1=3.25;}
    55. 

  55. 	else if($sub1>=60){$result1=3.00;}
    56. 

  56. 	else if($sub1>=55){$result1=2.75;}
    57. 

  57. 	else if($sub1>=50){$result1=2.50;}
    58. 

  58. 	else if($sub1>=45){$result1=2.25;}
    59. 

  59. 	else if($sub1>=40){$result1=2.00;}
    60. 

  60. 	else if($sub1<40){$result1=0.00;}
    61. 

  61. 	else echo "Wrong";
    62. 

  62. 

  63. 	if($sub2>=80){$result2=4.00;}
    64. 

  64. 	else if($sub2>=75){$result2=3.75;}
    65. 

  65. 	else if($sub2>=70){$result2=3.50;}
    66. 

  66. 	else if($sub2>=65){$result2=3.25;}
    67. 

  67. 	else if($sub2>=60){$result2=3.00;}
    68. 

  68. 	else if($sub2>=55){$result2=2.75;}
    69. 

  69. 	else if($sub2>=50){$result2=2.50;}
    70. 

  70. 	else if($sub2>=45){$result2=2.25;}
    71. 

  71. 	else if($sub2>=40){$result2=2.00;}
    72. 

  72. 	else if($sub2<40){$result2=0.00;}
    73. 

  73. 	else echo "Wrong";
    74. 

  74. 

  75. 	if($sub3>=80){$result3=4.00;}
    76. 

  76. 	else if($sub3>=75){$result3=3.75;}
    77. 

  77. 	else if($sub3>=70){$result3=3.50;}
    78. 

  78. 	else if($sub3>=65){$result3=3.25;}
    79. 

  79. 	else if($sub3>=60){$result3=3.00;}
    80. 

  80. 	else if($sub3>=55){$result3=2.75;}
    81. 

  81. 	else if($sub3>=50){$result3=2.50;}
    82. 

  82. 	else if($sub3>=45){$result3=2.25;}
    83. 

  83. 	else if($sub3>=40){$result3=2.00;}
    84. 

  84. 	else if($sub3<40){$result3=0.00;}
    85. 

  85. 	else echo "Wrong";
    86. 

  86. 

  87. 	if($sub4>=80){$result4=4.00;}
    88. 

  88. 	else if($sub4>=75){$result4=3.75;}
    89. 

  89. 	else if($sub4>=70){$result4=3.50;}
    90. 

  90. 	else if($sub4>=65){$result4=3.25;}
    91. 

  91. 	else if($sub4>=60){$result4=3.00;}
    92. 

  92. 	else if($sub4>=55){$result4=2.75;}
    93. 

  93. 	else if($sub4>=50){$result4=2.50;}
    94. 

  94. 	else if($sub4>=45){$result4=2.25;}
    95. 

  95. 	else if($sub4>=40){$result4=2.00;}
    96. 

  96. 	else if($sub4<40){$result4=0.00;}
    97. 

  97. 	else echo "Wrong";
    98. 

  98. 

  99. 	if($sub5>=80){$result5=4.00;}
    100. 

  100. 	else if($sub5>=75){$result5=3.75;}
    101. 

  101. 	else if($sub5>=70){$result5=3.50;}
    102. 

  102. 	else if($sub5>=65){$result5=3.25;}
    103. 

  103. 	else if($sub5>=60){$result5=3.00;}
    104. 

  104. 	else if($sub5>=55){$result5=2.75;}
    105. 

  105. 	else if($sub5>=50){$result5=2.50;}
    106. 

  106. 	else if($sub5>=45){$result5=2.25;}
    107. 

  107. 	else if($sub5>=40){$result5=2.00;}
    108. 

  108. 	else if($sub5<40){$result5=0.00;}
    109. 

  109. 	else echo "Wrong";
    110. 

  110. 	
    111. 

  111. 	if($sub6>=80){$result6=4.00;}
    112. 

  112. 	else if($sub6>=75){$result6=3.75;}
    113. 

  113. 	else if($sub6>=70){$result6=3.50;}
    114. 

  114. 	else if($sub6>=65){$result6=3.25;}
    115. 

  115. 	else if($sub6>=60){$result6=3.00;}
    116. 

  116. 	else if($sub6>=55){$result6=2.75;}
    117. 

  117. 	else if($sub6>=50){$result6=2.50;}
    118. 

  118. 	else if($sub6>=45){$result6=2.25;}
    119. 

  119. 	else if($sub6>=40){$result6=2.00;}
    120. 

  120. 	else if($sub6<40){$result6=0.00;}
    121. 

  121. 	else echo "Wrong";
    122. 

  122. 	
    123. 

  123. 	if($sub7>=80){$result7=4.00;}
    124. 

  124. 	else if($sub7>=75){$result7=3.75;}
    125. 

  125. 	else if($sub7>=70){$result7=3.50;}
    126. 

  126. 	else if($sub7>=65){$result7=3.25;}
    127. 

  127. 	else if($sub7>=60){$result7=3.00;}
    128. 

  128. 	else if($sub7>=55){$result7=2.75;}
    129. 

  129. 	else if($sub7>=50){$result7=2.50;}
    130. 

  130. 	else if($sub7>=45){$result7=2.25;}
    131. 

  131. 	else if($sub7>=40){$result7=2.00;}
    132. 

  132. 	else if($sub7<40){$result7=0.00;}
    133. 

  133. 	else echo "Wrong";
    134. 

  134. 

  135. 	if($sub8>=80){$result8=4.00;}
    136. 

  136. 	else if($sub8>=75){$result8=3.75;}
    137. 

  137. 	else if($sub8>=70){$result8=3.50;}
    138. 

  138. 	else if($sub8>=65){$result8=3.25;}
    139. 

  139. 	else if($sub8>=60){$result8=3.00;}
    140. 

  140. 	else if($sub8>=55){$result8=2.75;}
    141. 

  141. 	else if($sub8>=50){$result8=2.50;}
    142. 

  142. 	else if($sub8>=45){$result8=2.25;}
    143. 

  143. 	else if($sub8>=40){$result8=2.00;}
    144. 

  144. 	else if($sub8<40){$result8=0.00;}
    145. 

  145. 	else echo "Wrong";
    146. 

  146. 

  147. 	if($sub9>=80){$result9=4.00;}
    148. 

  148. 	else if($sub9>=75){$result9=3.75;}
    149. 

  149. 	else if($sub9>=70){$result9=3.50;}
    150. 

  150. 	else if($sub9>=65){$result9=3.25;}
    151. 

  151. 	else if($sub9>=60){$result9=3.00;}
    152. 

  152. 	else if($sub9>=55){$result9=2.75;}
    153. 

  153. 	else if($sub9>=50){$result9=2.50;}
    154. 

  154. 	else if($sub9>=45){$result9=2.25;}
    155. 

  155. 	else if($sub9>=40){$result9=2.00;}
    156. 

  156. 	else if($sub9<40){$result9=0.00;}
    157. 

  157. 	else echo "Wrong";
    158. 

  158. 

  159. 	if($sub10>=80){$result10=4.00;}
    160. 

  160. 	else if($sub10>=75){$result10=3.75;}
    161. 

  161. 	else if($sub10>=70){$result10=3.50;}
    162. 

  162. 	else if($sub10>=65){$result10=3.25;}
    163. 

  163. 	else if($sub10>=60){$result10=3.00;}
    164. 

  164. 	else if($sub10>=55){$result10=2.75;}
    165. 

  165. 	else if($sub10>=50){$result10=2.50;}
    166. 

  166. 	else if($sub10>=45){$result10=2.25;}
    167. 

  167. 	else if($sub10>=40){$result10=2.00;}
    168. 

  168. 	else if($sub10<40){$result10=0.00;}
    169. 

  169. 	else echo "Wrong";
    170. 

  170. 	if($sub11>=80){$result11=4.00;}
    171. 

  171. 	else if($sub11>=75){$result11=3.75;}
    172. 

  172. 	else if($sub11>=70){$result11=3.50;}
    173. 

  173. 	else if($sub11>=65){$result11=3.25;}
    174. 

  174. 	else if($sub11>=60){$result11=3.00;}
    175. 

  175. 	else if($sub11>=55){$result11=2.75;}
    176. 

  176. 	else if($sub11>=50){$result11=2.50;}
    177. 

  177. 	else if($sub11>=45){$result11=2.25;}
    178. 

  178. 	else if($sub11>=40){$result11=2.00;}
    179. 

  179. 	else if($sub11<40){$result11=0.00;}
    180. 

  180. 	else echo "Wrong";
    181. 

  181. 	?>
    182. 

  182. <div id="header">
    183. 

  183. <h1>Your Result:</h1>
    184. 

  184. 	Name: <?php echo $name; ?></br>
    185. 

  185. 	Father's Name: <?php echo $f_name; ?></br>
    186. 

  186. 	Mother's Name: <?php echo $m_name; ?></br>
    187. 

  187. 	Session: <?php echo $session; ?></br> 
    188. 

  188. 	Reg. No: <?php echo $reg; ?></br>
    189. 

  189. 	Roll: <?php echo $roll; ?></br>
    190. 

  190. 	</div>
    191. 

  191. 	<div id="in_header">
    192. 

  192. 	<table>
    193. 

  193. 	<tr id="r">
    194. 

  194. 		<th>Subject Code</th>
    195. 

  195. 		<th>Subject Name</th>
    196. 

  196. 		<th>Credit</th>
    197. 

  197. 		<th>Marks</th>
    198. 

  198. 		<th>GPA</th>
    199. 

  199. 	</tr>
    200. 

  200. 	<tr id="r">
    201. 

  201. 		<td>ICE-4201</td>
    202. 

  202. 		<td>Project</td>
    203. 

  203. 		<td>1.50</td>
    204. 

  204. 		<td><?php echo $sub1;?></td>
    205. 

  205. 		<td><?php echo $result1;?></td>
    206. 

  206. 	</tr>
    207. 

  207. 	<tr id="r">
    208. 

  208. 		<td>ICE-4202</td>
    209. 

  209. 		<td>Information System Analysis & Software Engineering</td>
    210. 

  210. 		<td>3.00</td>
    211. 

  211. 		<td><?php echo $sub2;?></td>
    212. 

  212. 		<td><?php echo $result2;?></td>
    213. 

  213. 	</tr>
    214. 

  214. 	<tr id="r">
    215. 

  215. 		<td>ICE-4203</td>
    216. 

  216. 		<td>Sessional Based on ICE-4202</td>
    217. 

  217. 		<td>.75</td>
    218. 

  218. 		<td><?php echo $sub3;?></td>
    219. 

  219. 		<td><?php echo $result3;?></td>
    220. 

  220. 	</tr>
    221. 

  221. 	<tr id="r">
    222. 

  222. 		<td>ICE-4204</td>
    223. 

  223. 		<td>Microwave & Fiber Optic Communication</td>
    224. 

  224. 		<td>3.00</td>
    225. 

  225. 		<td><?php echo $sub4;?></td>
    226. 

  226. 		<td><?php echo $result4;?></td>
    227. 

  227. 	</tr>
    228. 

  228. 	<tr id="r">
    229. 

  229. 		<td>ICE-4205</td>
    230. 

  230. 		<td>Sessional Based on ICE-4204</td>
    231. 

  231. 		<td>0.75</td>
    232. 

  232. 		<td><?php echo $sub5;?></td>
    233. 

  233. 		<td><?php echo $result5;?></td>
    234. 

  234. 	</tr>
    235. 

  235. 	<tr id="r">
    236. 

  236. 		<td>ICE-4206</td>
    237. 

  237. 		<td>Satellite Communication and Radar</td>
    238. 

  238. 		<td>3.00</td>
    239. 

  239. 		<td><?php echo $sub6;?></td>
    240. 

  240. 		<td><?php echo $result6;?></td>
    241. 

  241. 	</tr>
    242. 

  242. 	<tr id="r">
    243. 

  243. 		<td>ICE-4207</td>
    244. 

  244. 		<td>Neural and Fuzzy Systems in Communications</td>
    245. 

  245. 		<td>3.00</td>
    246. 

  246. 		<td><?php echo $sub7;?></td>
    247. 

  247. 		<td><?php echo $result7;?></td>
    248. 

  248. 	</tr>
    249. 

  249. 	<tr id="r">
    250. 

  250. 		<td>ICE-4208</td>
    251. 

  251. 		<td>Digital Signal Processing</td>
    252. 

  252. 		<td>3.00</td>
    253. 

  253. 		<td><?php echo $sub8;?></td>
    254. 

  254. 		<td><?php echo $result8;?></td>
    255. 

  255. 	</tr>
    256. 

  256. 	<tr id="r">
    257. 

  257. 		<td>ICE-4209</td>
    258. 

  258. 		<td>Sessional Based on ICE-4208</td>
    259. 

  259. 		<td>0.75</td>
    260. 

  260. 		<td><?php echo $sub9;?></td>
    261. 

  261. 		<td><?php echo $result9;?></td>
    262. 

  262. 	</tr>
    263. 

  263. 	<tr id="r">
    264. 

  264. 		<td>ICE-4210</td>
    265. 

  265. 		<td>Viva-voce</td>
    266. 

  266. 		<td>0.75</td>
    267. 

  267. 		<td><?php echo $sub10;?></td>
    268. 

  268. 		<td><?php echo $result10;?></td>
    269. 

  269. 	</tr>
    270. 

  270. 	<tr id="r">
    271. 

  271. 		<td>ICE-4211</td>
    272. 

  272. 		<td>Viva-voce on Project</td>
    273. 

  273. 		<td>.75</td>
    274. 

  274. 		<td><?php echo $sub11;?></td>
    275. 

  275. 		<td><?php echo $result11;?></td>
    276. 

  276. 	</tr>
    277. 

  277. 

  278. 

  279. 	<tr id="r1">
    280. 

  280. 		<td id="">Total CGPA</td>
    281. 

  281. 		<td id="ab1"></td>
    282. 

  282. 		<td id="ab1"></td>
    283. 

  283. 		<td id="ab1"></td>
    284. 

  284. 		<td id="ab1"><?php echo $cgpa ?></td>
    285. 

  285. 	</tr>
    286. 

  286. 	</table></br>
    287. 

  287. 	<h3 id="ab">Your CGPA is <?php echo $cgpa; ?>.</h3>
    288. 

  288. 		<a href="download_4_2.php"target="_blank"><h1>Download this form</h1></a>
    289. 

  289. 

  290. </div>
    291.