bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
  include 'includes/db.php';
  
        if(isset($_POST['submit'])){
            
            $name = $_POST['name']; 
            $enroll = $_POST['enroll']; 
       
            $sql = "SELECT * FROM `examform` WHERE enrollment_no = '$enroll' AND candidate = '$name'";
            $quary = mysqli_query($connection,$sql);
           
       
             $rowcount = mysqli_num_rows($quary);
           
            if($rowcount > 0){
                $qua = mysqli_fetch_array($quary);
                
                $coursename = $qua['coursename'];
                
                $exameyear = $qua['examyear'];
                
            //   print_r($quary2);
                
            }else{
               echo '<script>alert("Please Enter Valid Information");</script>';
               echo '<script>window.location.replace("result.php");</script>';
            }
            
        }
        
        if(isset($_GET['prin'])){
        
        
            $enroll = $_GET['prin']; 
       
            $sql = "SELECT * FROM `examform` WHERE enrollment_no = '$enroll'";
            $quary = mysqli_query($connection,$sql);
           
       
             $rowcount = mysqli_num_rows($quary);
           
            if($rowcount > 0){
                $qua = mysqli_fetch_array($quary);
                
                $coursename = $qua['coursename'];
                
                $exameyear = $qua['examyear'];
                
            //   print_r($quary2);
                
            }else{
               echo '<script>alert("Please Enter Valid Information");</script>';
               echo '<script>window.location.replace("admin/result_new.php");</script>';
            }
           
        
        }
    
 $i = 0;
    
 
?>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
     <title>State Board of Medical & Vocational Education | SBMVE </title>
      <link rel="shortcut icon" href="../images/logon.png" type="image/png">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-GLhlTQ8iRABdZLl6O3oVMWSktQOp6b7In1Zl3/Jr59b6EGGoI1aFkw7cmDA6j6gD" crossorigin="anonymous">
    <title>Document</title>
</head>
<style>
	.containers{
		width:1050px;
		max-width:100%;
		margin:auto;
		padding:20px;
	}
	.bluecolor{
	    color:#3c6eff;
	    margin:0;
	    font-weight:500;
	    /*font-size:8px;*/
	}
	.titles{
	    margin:5px 0;
	    /*font-size:10px;*/
	}
	
	@media screen and (max-width: 480px) {
        .bluecolor{
            color:#3c6eff;
            margin:0;
            font-weight:500;
            font-size:8px;
        }
        .titles{
            margin:4px 0;
            font-size:10px;
        }
        .userimg{
            width:38px!important;
            height:59px!important;
            
        }
        .reptable thead tr th{
            font-size:7px;   
            padding:5px;
        }
        .reptable tbody tr td{
            font-size:7px;   
            padding:5px;
        }
        .ingrep{
            height:42px!important;
        }
        .lasth1rep{
            font-size: 11px!important;
            font-weight: 700!important;
            text-align: center;
        }
        .paddrep1 h1{
            font-size: 10px;
        }
        .inst{
            font-size:5px;
        }
        .lastable thead tr th{
            font-size:5px;
            padding:0px;
        }
        .lastable tbody tr td{
            font-size:5px;
            padding:0px;
        }
    }
     
    @media screen and (min-device-width: 320px) and (max-device-width: 375px) { 
        .userimg{
            width:32px!important;
            height:59px!important;
            
        }
    }
    @media screen and (max-width: 320px) {
        .userimg{
            width:27px!important;
            height:59px!important;
            
        }
        
    }
    
    
	
</style>

<body>
    <section class="containers">
        <div class="py-2">
           <div class="text-center">
				<img class="ingrep" src="assets/images/LOGO.png" height="145px" width="100%"/>
		   </div>
        </div>
        <div class="">
			<h5 class="border border-dark titles">Course Name:- <span class="bluecolor">
			    <?php   
			        $query11 = mysqli_query($connection, "select * from coursename where name_id = '".$qua['coursename']."'");
                    $data11 = mysqli_fetch_array($query11); echo $data11['coursename'];
                ?>
			</span></h5>
		</div>
		<div class="row">
			<div class="col-6" style="padding-right:2px;">
				<div class="border text-center border-dark">					    
					<h6 class="titles">Name of Candidate</h6>
					<p class="bluecolor"><?=$qua['candidate']?></p>
					<h6 class="titles">Father’s/ Husband Name</h6>
					<p class="bluecolor"><?=$qua['father/husband']?></p>
					<h6 class="titles">Mother's Name</h6>
					<p class="bluecolor"><?=$qua['mothername']?></p>
				</div>
			</div>
			<div class="col-6" style="padding-left:2px;">
		        <div class="row">
		            <div class="col-9" style="padding-right:2px;">
		                <div class="border border-dark text-center">
		                    <h6 class="titles">Enrollment Number</h6>
			                <p class="bluecolor"><?=$qua['enrollment_no']?></p>
		                </div>
		                <div class="mt-1 border border-dark text-center" >
		                    <h6 class="titles">Batch:- <span class="bluecolor"><?=$qua['batch']?></span></h6>
		                </div>
		            </div>
		            <div class="col-3 text-center" style="padding-left:2px;">
		                <img class="userimg border border-dark" src="../institute/img/<?=$qua['photo']?>"  style="height: 85px; width:118px:"   />
		            </div> 
		            <div class="col-12 mt-1">
		                <div class="border border-dark text-center">
    	                    <h6 class="titles">Study Center</h6>
    		                <p class="bluecolor"><?=$qua['studycenter']?> </p>
    	                </div>
		            </div>
		        </div>        
			</div>
		</div>	
		<div class="py-2">
		    
		    <?php
                 for ($x = 1; $x <= 4; $x++) {
                    
                    
                    
		           $subjectname = "select * from subjectname where name_id = '$coursename' and year = '$x'";
		           $subjectquery = mysqli_query($connection,$subjectname);
		           
		           $coutsubject = mysqli_num_rows($subjectquery);
		           //print_r($coutsubject);
		            
			       $sql1 = "SELECT * FROM `result_new` WHERE enrollment_no = '$enroll' and examinationyear = '$x'";
                   $quary1 = mysqli_query($connection,$sql1);
                   
                   $sql3 = "SELECT * FROM `practical` WHERE enrollmentNo = '$enroll' and examinationyear = '$x'";
                    $quary3 = mysqli_query($connection,$sql3);
                
                
                    $rowcount1 = mysqli_num_rows($quary1);
			        $rowcountpra = mysqli_num_rows($quary3);
			         if($rowcount1 > 0 && $rowcountpra > 0){
			                $data1 = mysqli_fetch_array($quary3);
			                $data = mysqli_fetch_array($quary1);
			                
			        $sqldata = "SELECT * FROM `examform` WHERE enrollment_no = '$enroll' and examyear = '$x' ";
                    $quarydata = mysqli_query($connection,$sqldata);
                    $datafetch = mysqli_fetch_array($quarydata);   
                        
			    
            ?>
		    
			<div class="border border-dark px-2">
				<div class="row repexp">
					<div class="col-4 "><h6  class="titles">Semester <span class="bluecolor">
					    <?php
					         if($x == 1){
                                 $printres = "FIRST YEAR";
                             }else if($x == 2){
                                  $printres = "SECOND YEAR";
                             }else if($x == 3){
                                 $printres = "THIRD YEAR";
                             }else{
                                 $printres = "FOURTH YEAR";
                             }
                                echo $printres; 
					    ?>
					</span></h6>  </div>
					<div class="col-4 p-0 text-center"><h6 class="titles">Exam Session <span class="bluecolor"><?=$datafetch['session']?></span></h6></div>
					<div class="col-4 " style="text-align: right;"><h6 class="titles">Roll No. <span class="bluecolor"><?php   echo $datafetch['roll_no'];?></span></h6></div>
				</div>	
			</div>
			
			    <div class=" border-dark border-top">		    
				    <table class="table table-bordered text-center border-0 reptable">
                        <thead>
                          <tr>
                            <th>S.No.</th>
                            <th>Name of Subjects</th>
                            <th>Max. Marks</th>
                            <th>Obtained Theory</th>
                            <th>Max. Marks</th>
                            <th>Practical/ Viva</th>
                            <th>Total Marks</th>
                        </thead>
                        <tbody>
                            
                            <?php
                                $subject = "subject";
                                $number = 1;
        						while($subjectrow=mysqli_fetch_array($subjectquery)){
        						  //  print_r($subject);
    						?>
                            <tr>
                                <td><?php echo ++$i; ?></td>  
                                <td><?=$subjectrow['subject']?></td>
                                <td>
                                70                            
                                </td>
                                <td><?=$data[$subject.$number]?></td>
                                <td>
                                30                                
                                </td>
                                <td><?=$data1[$subject.$number]?></td> 
                                <td>
                                    <?php if($data[$subject.$number] && $data1[$subject.$number] != null){
                                            $x1 = $data[$subject.$number] + $data1[$subject.$number];
                                            echo $x1;
                                        }else{
                                            $var = null;
                                            echo $var;
                                        }
                                    ?>
                                </td>
                            </tr>
                            
                            <?php 
                                 $number++; 
        						}
                            ?>
                            
                            
                            
                          <tr>
                           <td colspan="2" style="border-bottom-style: hidden; border-left-style: hidden;">
                                <?php
                                     $total_given_mark = 70 * $coutsubject;
                               
                                        
                                     
                                    $mark_total = 0;

for ($i = 1; $i <= 20; $i++) {
                                        $subject_key = "subject" . $i;
                                    
                                        // Check if the subject is set before adding it to the total
                                        if (isset($data[$subject_key]) && $data[$subject_key] !== "") {
                                            $mark_total += $data[$subject_key];
                                        }
                                    }
                                    
                                    // Now $mark_total contains the sum of all set subjects
                                    // echo $mark_total;
                                     
                                     
                                     $mark_practal = 30 * $coutsubject;
                                     
                                     $practical_mark_total = 0;

for ($i = 1; $i <= 20; $i++) {
                                        $subject_key1 = "subject" . $i;
                                    
                                        // Check if the subject is set before adding it to the total
                                        if (isset($data[$subject_key1]) && $data[$subject_key1] !== "") {
                                            $practical_mark_total += $data1[$subject_key1];
                                        }
                                    }
                                    
                                    // Now $mark_total contains the sum of all set subjects
                                    // echo $mark_total;
                                     
                                     
                                     $y = $practical_mark_total+$mark_total;
                                     
                                     
                                     $total = $total_given_mark+$mark_practal; 
                                     $given_mark = $mark_total+$practical_mark_total;
                                     
                                     $mark_division = $given_mark/$total;
                                     
                                     $pres = $mark_division*100;
                                     
                                     if($x == 1){
                                         $printres = "FIRST YEAR";
                                     }else if($x == 2){
                                          $printres = "SECOND YEAR";
                                     }else if($x == 3){
                                         $printres = "THIRD YEAR";
                                     }else{
                                         $printres = "FOURTH YEAR";
                                     }
                                     
                                     
                                     
                                     echo   $printres ."  " ."PERCENT". "  ".round($pres, 2);
                                     
                                        
                               ?>
                           </td> 
                           <td>
                                <?php 
            
        
                                    echo $total_given_mark;
                           
                                ?>
                           </td>
                            <td><?php echo $mark_total;?></td> 
                            <td><?php echo $mark_practal; ?></td>
                            <td><?php echo $practical_mark_total ?></td> 
                            <td><?php echo $y; ?></td>
                          </tr>
  
                        </tbody>
                    </table>
                </div>
            <?php 
            
			         }
			         
                 }    
            ?>
            
	    </div>
	    <div class="row">
            <div class="col-8"> 
                <p class="inst">
                    INSTRUCTIONS<br>
                    1) All Subjects carry 100 Marks.<br>
                    2) To qualify in each subject, minimum marks must be 35%<br>
                    3) A candidate not obtaining minimum 35°arks are only eligible for grade F which means fail to Pass in the Examination<br>
                    4) To be eligible for Digree, Diploma, Certificate, a candidate must obtain Grade E, which means between 35% to 40%<br>
                </p>
            </div>
            <div class="col-4">
                <table class="table table-bordered lastable">
                    <thead>
                      <tr>
                        <th>Percentage</th>
                        <th>Grade</th> 
                      </tr>
                    </thead>
                    <tbody>
                      <tr>
                        <td style="padding:0px;">-90% and above up to 100%</td>
                        <td style="padding:0px;">A</td> 
                      </tr>
                      <tr>
                        <td style="padding:0px;">-70% and above up to 90%</td>
                        <td style="padding:0px;">B</td> 
                      </tr>
                      <tr>
                        <td style="padding:0px;">-50% and above up to 70%</td>
                        <td style="padding:0px;">C</td> 
                      </tr>
                      <tr>
                        <td style="padding:0px;">40% and above up to 50%</td>
                        <td style="padding:0px;">D</td> 
                      </tr>
                      <tr>
                        <td style="padding:0px;">-35% and above up to 40%</td>
                        <td style="padding:0px;">E</td> 
                      </tr>
                      <tr>
                        <td style="padding:0px;">- Below 35%</td>
                        <td style="padding:0px;">F</td> 
                      </tr>
                      
                    </tbody>
                  </table>
            </div>
        </div>            
        <div  style="text-align:center">
            <button type="button" class="btn btn-outline-warning repbut" onclick="window.print()">Print this page</button>
        </div>    
    </section>
    
   
</body>

</html>