/download_3_2.php
https://gitlab.com/optimistic_mamun/project1 · PHP · 276 lines · 239 code · 37 blank · 0 comment · 222 complexity · 377043a62765e22679d4c49cd5c1022e MD5 · raw file
- <?php ob_start();?>
- <?php session_start();
- $roll=$_SESSION['roll'];
- 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);
-
- 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'];
- $_SESSION['roll']=$roll;
- }
- ?>
- <?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
- 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";
- ?>
- <?php
- require("fpdf/fpdf.php");
- $pdf=new FPDF();
- $pdf->AddPage();
- $pdf->SetFont("Arial","",11);
- $pdf->Cell(10,10,"",0,1,'L');
- $pdf->Cell(10,7,"Name: {$name}",0,1,'L');
- $pdf->Cell(10,7,"Father's Name: {$f_name}",0,1,'L');
- $pdf->Cell(10,7,"Mother's Name: {$m_name}",0,1,'L');
- $pdf->Cell(10,7,"Session: {$session}",0,1,'L');
- $pdf->Cell(10,7,"Roll: {$roll}",0,1,'L');
- $pdf->Cell(10,10,"",0,1,'L');
- $pdf->Cell(25,10,"subject code",1,0,'C');
- $pdf->Cell(105,10,"subject Name",1,0,'C');
- $pdf->Cell(20,10,"Credit",1,0,'C');
- $pdf->Cell(20,10,"Marks",1,0,'C');
- $pdf->Cell(15,10,"GPA",1,1,'C');
- $pdf->Cell(25,10,"ICE-3201",1,0,'C');
- $pdf->Cell(105,10,"Electronic Project Design and Development",1,0,'L');
- $pdf->Cell(20,10,"1.50",1,0,'C');
- $pdf->Cell(20,10,"{$sub1}",1,0,'C');
- $pdf->Cell(15,10,"{$result1}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3202",1,0,'C');
- $pdf->Cell(105,10,"DBMS, Data Warehousing & Data Mining",1,0,'L');
- $pdf->Cell(20,10,"3.00",1,0,'C');
- $pdf->Cell(20,10,"{$sub2}",1,0,'C');
- $pdf->Cell(15,10,"{$result2}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3203",1,0,'C');
- $pdf->Cell(105,10,"Telecommunication Systems, Networks and Switching",1,0,'L');
- $pdf->Cell(20,10,"3.00",1,0,'C');
- $pdf->Cell(20,10,"{$sub3}",1,0,'C');
- $pdf->Cell(15,10,"{$result3}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3204",1,0,'C');
- $pdf->Cell(105,10,"Sessional Based on ICE-3203",1,0,'L');
- $pdf->Cell(20,10,"0.75",1,0,'C');
- $pdf->Cell(20,10,"{$sub4}",1,0,'C');
- $pdf->Cell(15,10,"{$result4}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3205",1,0,'C');
- $pdf->Cell(105,10,"Digital Communication",1,0,'L');
- $pdf->Cell(20,10,"3.00",1,0,'C');
- $pdf->Cell(20,10,"{$sub5}",1,0,'C');
- $pdf->Cell(15,10,"{$result5}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3206",1,0,'C');
- $pdf->Cell(105,10,"Sessional Based on ICE-3205",1,0,'L');
- $pdf->Cell(20,10,"1.50",1,0,'C');
- $pdf->Cell(20,10,"{$sub6}",1,0,'C');
- $pdf->Cell(15,10,"{$result6}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3207",1,0,'C');
- $pdf->Cell(105,10,"Antennas and Radio Wave Propagation",1,0,'L');
- $pdf->Cell(20,10,"3.00",1,0,'C');
- $pdf->Cell(20,10,"{$sub7}",1,0,'C');
- $pdf->Cell(15,10,"{$result7}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3208",1,0,'C');
- $pdf->Cell(105,10,"Sessional Based on ICE-3207",1,0,'L');
- $pdf->Cell(20,10,"0.75",1,0,'C');
- $pdf->Cell(20,10,"{$sub8}",1,0,'C');
- $pdf->Cell(15,10,"{$result8}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3209",1,0,'C');
- $pdf->Cell(105,10,"Information Theory and Coding",1,0,'L');
- $pdf->Cell(20,10,"3.00",1,0,'C');
- $pdf->Cell(20,10,"{$sub9}",1,0,'C');
- $pdf->Cell(15,10,"{$result9}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3210",1,0,'C');
- $pdf->Cell(105,10,"Sessional Based on ICE-3209",1,0,'L');
- $pdf->Cell(20,10,"1.50",1,0,'C');
- $pdf->Cell(20,10,"{$sub10}",1,0,'C');
- $pdf->Cell(15,10,"{$result10}",1,1,'C');
- $pdf->Cell(25,10,"ICE-3211",1,0,'C');
- $pdf->Cell(105,10,"Viva-voce",1,0,'L');
- $pdf->Cell(20,10,"0.75",1,0,'C');
- $pdf->Cell(20,10,"{$sub11}",1,0,'C');
- $pdf->Cell(15,10,"{$result11}",1,1,'C');
- $pdf->Cell(170,10,"Total CGPA",1,0,'L');
- $pdf->Cell(15,10,"{$cgpa}",1,1,'C');
- $pdf->Cell(10,40,"",0,10,'C');
- $pdf->Cell(160,1,"--------------------------",0,1,'R');
- $pdf->Cell(160,10,"Chairman Signature",0,1,'R');
- $pdf->output();
- ?>