/page_3_2.php

<?php ob_start();?>
<?php include("second_header.php"); ?>
	<?php
	session_start();
	$roll=$_SESSION['myValue']; 
	include('connect.php');
	 $query = "SELECT * FROM ice_3_2 WHERE roll='$roll'";
	 $result = mysql_query($query) or die(mysql_error());
		$count = mysql_num_rows($result);
		if($count==1){
while ($row = mysql_fetch_array($result)) {
$roll = $row['roll'];
$name = $row['name'];
$sub1 = $row['sub1'];
$sub2 = $row['sub2'];
$sub3 = $row['sub3'];
$sub4 = $row['sub4'];
$sub5 = $row['sub5'];
$sub6 = $row['sub6'];
$sub7 = $row['sub7'];
$sub8 = $row['sub8'];
$sub9 = $row['sub9'];
$sub10 = $row['sub10'];
$sub11 = $row['sub11'];
$cgpa=$row['CGPA'];


}
}
else{
	echo '<h1>Search result not found';
}

	?>
	<?php
	 include('connect.php');
	 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'";
	 $result1 = mysql_query($query1) or die(mysql_error());
		$count1 = mysql_num_rows($result1);
		while ($row1 = mysql_fetch_array($result1)) {
			$f_name=$row1['F_name'];
			$m_name=$row1['M_name'];
			$session = $row1['session'];
			$reg = $row1['reg'];
		}

	?>
	<?php
	?>
	<?php 
	if($sub1>=80){$result1=4.00;}
	else if($sub1>=75){$result1=3.75;}
	else if($sub1>=70){$result1=3.50;}
	else if($sub1>=65){$result1=3.25;}
	else if($sub1>=60){$result1=3.00;}
	else if($sub1>=55){$result1=2.75;}
	else if($sub1>=50){$result1=2.50;}
	else if($sub1>=45){$result1=2.25;}
	else if($sub1>=40){$result1=2.00;}
	else if($sub1<40){$result1=0.00;}
	else echo "Wrong";

	if($sub2>=80){$result2=4.00;}
	else if($sub2>=75){$result2=3.75;}
	else if($sub2>=70){$result2=3.50;}
	else if($sub2>=65){$result2=3.25;}
	else if($sub2>=60){$result2=3.00;}
	else if($sub2>=55){$result2=2.75;}
	else if($sub2>=50){$result2=2.50;}
	else if($sub2>=45){$result2=2.25;}
	else if($sub2>=40){$result2=2.00;}
	else if($sub2<40){$result2=0.00;}
	else echo "Wrong";

	if($sub3>=80){$result3=4.00;}
	else if($sub3>=75){$result3=3.75;}
	else if($sub3>=70){$result3=3.50;}
	else if($sub3>=65){$result3=3.25;}
	else if($sub3>=60){$result3=3.00;}
	else if($sub3>=55){$result3=2.75;}
	else if($sub3>=50){$result3=2.50;}
	else if($sub3>=45){$result3=2.25;}
	else if($sub3>=40){$result3=2.00;}
	else if($sub3<40){$result3=0.00;}
	else echo "Wrong";

	if($sub4>=80){$result4=4.00;}
	else if($sub4>=75){$result4=3.75;}
	else if($sub4>=70){$result4=3.50;}
	else if($sub4>=65){$result4=3.25;}
	else if($sub4>=60){$result4=3.00;}
	else if($sub4>=55){$result4=2.75;}
	else if($sub4>=50){$result4=2.50;}
	else if($sub4>=45){$result4=2.25;}
	else if($sub4>=40){$result4=2.00;}
	else if($sub4<40){$result4=0.00;}
	else echo "Wrong";

	if($sub5>=80){$result5=4.00;}
	else if($sub5>=75){$result5=3.75;}
	else if($sub5>=70){$result5=3.50;}
	else if($sub5>=65){$result5=3.25;}
	else if($sub5>=60){$result5=3.00;}
	else if($sub5>=55){$result5=2.75;}
	else if($sub5>=50){$result5=2.50;}
	else if($sub5>=45){$result5=2.25;}
	else if($sub5>=40){$result5=2.00;}
	else if($sub5<40){$result5=0.00;}
	else echo "Wrong";
	
	if($sub6>=80){$result6=4.00;}
	else if($sub6>=75){$result6=3.75;}
	else if($sub6>=70){$result6=3.50;}
	else if($sub6>=65){$result6=3.25;}
	else if($sub6>=60){$result6=3.00;}
	else if($sub6>=55){$result6=2.75;}
	else if($sub6>=50){$result6=2.50;}
	else if($sub6>=45){$result6=2.25;}
	else if($sub6>=40){$result6=2.00;}
	else if($sub6<40){$result6=0.00;}
	else echo "Wrong";
	
	if($sub7>=80){$result7=4.00;}
	else if($sub7>=75){$result7=3.75;}
	else if($sub7>=70){$result7=3.50;}
	else if($sub7>=65){$result7=3.25;}
	else if($sub7>=60){$result7=3.00;}
	else if($sub7>=55){$result7=2.75;}
	else if($sub7>=50){$result7=2.50;}
	else if($sub7>=45){$result7=2.25;}
	else if($sub7>=40){$result7=2.00;}
	else if($sub7<40){$result7=0.00;}
	else echo "Wrong";

	if($sub8>=80){$result8=4.00;}
	else if($sub8>=75){$result8=3.75;}
	else if($sub8>=70){$result8=3.50;}
	else if($sub8>=65){$result8=3.25;}
	else if($sub8>=60){$result8=3.00;}
	else if($sub8>=55){$result8=2.75;}
	else if($sub8>=50){$result8=2.50;}
	else if($sub8>=45){$result8=2.25;}
	else if($sub8>=40){$result8=2.00;}
	else if($sub8<40){$result8=0.00;}
	else echo "Wrong";

	if($sub9>=80){$result9=4.00;}
	else if($sub9>=75){$result9=3.75;}
	else if($sub9>=70){$result9=3.50;}
	else if($sub9>=65){$result9=3.25;}
	else if($sub9>=60){$result9=3.00;}
	else if($sub9>=55){$result9=2.75;}
	else if($sub9>=50){$result9=2.50;}
	else if($sub9>=45){$result9=2.25;}
	else if($sub9>=40){$result9=2.00;}
	else if($sub9<40){$result9=0.00;}
	else echo "Wrong";

	if($sub10>=80){$result10=4.00;}
	else if($sub10>=75){$result10=3.75;}
	else if($sub10>=70){$result10=3.50;}
	else if($sub10>=65){$result10=3.25;}
	else if($sub10>=60){$result10=3.00;}
	else if($sub10>=55){$result10=2.75;}
	else if($sub10>=50){$result10=2.50;}
	else if($sub10>=45){$result10=2.25;}
	else if($sub10>=40){$result10=2.00;}
	else if($sub10<40){$result10=0.00;}
	else echo "Wrong";
	if($sub11>=80){$result11=4.00;}
	else if($sub11>=75){$result11=3.75;}
	else if($sub11>=70){$result11=3.50;}
	else if($sub11>=65){$result11=3.25;}
	else if($sub11>=60){$result11=3.00;}
	else if($sub11>=55){$result11=2.75;}
	else if($sub11>=50){$result11=2.50;}
	else if($sub11>=45){$result11=2.25;}
	else if($sub11>=40){$result11=2.00;}
	else if($sub11<40){$result11=0.00;}
	else echo "Wrong";
	?>
<div id="header">
<h1>Your Result:</h1>
	Name: <?php echo $name; ?></br>
	Father's Name: <?php echo $f_name; ?></br>
	Mother's Name: <?php echo $m_name; ?></br>
	Session: <?php echo $session; ?></br> 
	Reg. No: <?php echo $reg; ?></br>
	Roll: <?php echo $roll; ?></br>
	</div>
	<div id="in_header">
	<table>
	<tr id="r">
		<th>Subject Code</th>
		<th>Subject Name</th>
		<th>Credit</th>
		<th>Marks</th>
		<th>GPA</th>
	</tr>
	<tr id="r">
		<td>ICE-3201</td>
		<td>Electronic Project Design and Development</td>
		<td>1.50</td>
		<td><?php echo $sub1;?></td>
		<td><?php echo $result1;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3202</td>
		<td>DBMS, Data Warehousing & Data Mining</td>
		<td>3.00</td>
		<td><?php echo $sub2;?></td>
		<td><?php echo $result2;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3203</td>
		<td>Telecommunication Systems, Networks and Switching.</td>
		<td>3.00</td>
		<td><?php echo $sub3;?></td>
		<td><?php echo $result3;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3204</td>
		<td>Sessional Based on ICE-3203</td>
		<td>.75</td>
		<td><?php echo $sub4;?></td>
		<td><?php echo $result4;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3205</td>
		<td>Digital Communication</td>
		<td>3.00</td>
		<td><?php echo $sub5;?></td>
		<td><?php echo $result5;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3206</td>
		<td>Sessional Based on ICE-3205</td>
		<td>1.50</td>
		<td><?php echo $sub6;?></td>
		<td><?php echo $result6;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3207</td>
		<td>Antennas and Radio Wave Propagation</td>
		<td>3.00</td>
		<td><?php echo $sub7;?></td>
		<td><?php echo $result7;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3208</td>
		<td>Sessional Based on ICE-3207</td>
		<td>.75</td>
		<td><?php echo $sub8;?></td>
		<td><?php echo $result8;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3209</td>
		<td>Information Theory and Coding</td>
		<td>3.00</td>
		<td><?php echo $sub9;?></td>
		<td><?php echo $result9;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3210</td>
		<td>Sessional Based on ICE-3209</td>
		<td>1.5</td>
		<td><?php echo $sub10;?></td>
		<td><?php echo $result10;?></td>
	</tr>
	<tr id="r">
		<td>ICE-3211</td>
		<td>Viva-voce</td>
		<td>.75</td>
		<td><?php echo $sub11;?></td>
		<td><?php echo $result11;?></td>
	</tr>


	<tr id="r1">
		<td id="">Total CGPA</td>
		<td id="ab1"></td>
		<td id="ab1"></td>
		<td id="ab1"></td>
		<td id="ab1"><?php echo $cgpa ?></td>
	</tr>
	</table></br>
	<h3 id="ab">Your CGPA is <?php echo $cgpa; ?>.</h3>
		<a href="download_3_2.php"target="_blank"><h1>Download this form</h1></a>

</div>