File Explorer

<?php include("includes/css.php");?>
 <style type="text/css">
     .table thead tr .head {
         background-color: #bcc149;
         text-align: center;
         font-weight: 800;
         font-size: 16px;
         color: #fff;
     }
     .table thead tr .month {
         text-align: center;
         font-size: 16px;
         color: #cc920e;
         font-weight: 600;
     }

.table thead tr th {
         background-color: #f8fb9b;
         color: #006caa;
         vertical-align: middle;
         text-align: center
     }

.table thead tr th .ttl {
         background-color: transparent;
         color: #006caa;
         vertical-align: middle;
         transform: rotate(-90deg);
         text-align: center
     }

.table tbody .head1 td {
         background-color: #026caa;
         color: #fff;
         text-align: center
     }

.table tbody .gradePer td {
         background-color: #d0f2fc;
         color: #000;
         text-align: center;
         font-weight: 600;
     }

.table tbody tr td {
         background-color: #f9f6ec;
         color: #000;
         text-align: center
     }

.boxtbl .table>tbody>tr>td {
         border-top: 0px solid #000 !important
     }

.table tbody tr td .box {
         border: 1px solid #ccc;
         width: 72px;
         height: 40px;
     }

.table tbody .head1 td,
     .table tbody .head2 td {
         background-color: #026caa;
         color: #fff;
         text-align: center
     }

.boxtbl1 tbody tr td {
         padding: 17px 0px
     }

</style>

<body>
  
<body class="hold-transition skin-blue sidebar-mini">
	<div class="wrapper">
		<?php include("includes/header.php");?>
		<?php include("includes/sidebar.php");?>
		
		<div class="content-wrapper"> 
			
			<section class="content">
				<div class="row"> 
					<div class="col-md-12">
						<div class="box box-primary">
							<div class="box-header with-border">
									<div class="col-md-12">
										<h3 class="box-title"> Exam Report Card Details:</h3>  
									</div>  
								</div>
                            <?php $student_id=$_SESSION['student_id']; ?>
                            <div class="box-header with-border">
                                    <div class="col-md-12">

<form method="post" action="">
                                      <div class="col-md-3">
                                        <h3 class="box-title">Exam :</h3> 
                                        <div class="btn-group ml-5">
                                             <select class="form-control" name="exam_id">
                                                <option>Select Exam</option>
                                                    <?php
                                            $sql2="SELECT exam_detail.* from exam_detail join report_detail on report_detail.exam_id=report_detail.id where report_detail.student_id='".$student_id."' group by exam_detail.ex_name";
                                            $exe2=mysqli_query($conn,$sql2);
                                            while ($res2=mysqli_fetch_array($exe2))
                                            { ?>
                                            <option value="<?php echo $res2['id']; ?>"><?php echo $res2['ex_name'];?></option>
                                            <?php
                                            }
                                            ?> 
                                            </select>                                   
                                        </div>
                                    </div>
                                    <div class="col-md-2">  
                                        <div class="ml-5 mt-15">
                                            <input type="submit" name="search"  class="btn btn-success btn-lg" value="Submit">       
                                        </div>
                                    </div>
                                    </form>
                                  </div>  
                                </div>
                                        
								
                                <?php $student_id=$_SESSION['student_id'];
                                if($_POST['search']){
                                  $exam_id=$_POST['exam_id'];
                                   $query_sql = mysqli_query($conn,"SELECT exam_detail.* from exam_detail where id='$exam_id'");
                                }else{
                                    $query_sql = mysqli_query($conn,"SELECT exam_detail.* from exam_detail "); 
                                }
                                
                                while($row_yr = mysqli_fetch_array($query_sql)){
                                if($row_yr['status'] == "Current"){ $status='Current';
                                }else{
                                    $status='past';
                                } }
                                $query = "SELECT report_detail.*,exam_detail.ex_name,session_year.year,session_year.month from report_detail join student on report_detail.student_id=student.id join exam_detail on report_detail.exam_id=exam_detail.id join session_year on exam_detail.year_id=session_year.id WHERE report_detail.student_id = '".$student_id."' and exam_detail.status = '".$status."'";  
                                    $result = mysqli_query($conn, $query);  
                                    $row = mysqli_fetch_array($result); ?>
								<div class="box-body">  
                                     <div class="row">
                                         <div class="col-lg-12 col-md-12 col-sm-12 table-responsive">
                                             <table class="table table-striped table-bordered">
                                                 <thead>
                                                     <tr>
                                                         <th colspan="36" class="head"> ACADEMIC PERPORMANCE REPORT</th>
                                                     </tr>
                                                     <tr>
                                                         <th>Test/Examination</th>
                                                         <th colspan="4" class="month"><?= $row['month']; ?></th>
                                                         <th rowspan="2">
                                                             <div class="ttl">Total</div>
                                                         </th>
                                                        
                                                         
                                                         <th rowspan="2">
                                                             <div class="ttl">Grade</div>
                                                         </th>
                                                         <th rowspan="2">
                                                             <div class="ttl">Grade&nbsp;Point</div>
                                                         </th>
                                                     </tr>
                                                     <tr>
                                                         <th>Subject</th>
                                                         <th colspan="4"><?= $row['ex_name']; ?></th>
                                                     </tr>
                                                 </thead>
                                                 <tbody>
                                                     <tr class="head1">
                                                         <td>Meter FAS</td>
                                                         <td>1</td>
                                                         <td>2</td>
                                                         <td>3</td>
                                                         <td>4</td>
                                                         <td>1</td>

<td>2</td>
                                                         <td>3</td>
                                                     </tr>
                                                     <tr class="head2">
                                                         <td>MARKS</td>
                                                         <td>5</td>
                                                         <td>5</td>
                                                         <td>5</td>
                                                         <td>5</td>
                                                         <td>20</td>
                                                         <td>5</td>
                                                         <td>5</td>
                                                     </tr>
                                        <?php $student_id=$_SESSION['student_id'];
                                              $exam_id=$row['exam_id'];
                                                   $sub="General Knowledge";
                                                   $subs="Grade%";
                                         $sqllt="SELECT * from subject where subject_name !='$sub' and subject_name !='$subs'";
                                            $exelt=mysqli_query($conn,$sqllt);
                                            while ($reslt=mysqli_fetch_array($exelt)){
                                              $sid=$reslt['id']; ?>
                                        <tr>
                                            <td><?= $reslt['subject_name'];  ?></td>   
                                            <?php 
                                           // $sqlsz=mysqli_query($conn,"SELECT * from meter_fas");
                                            //while ($resz=mysqli_fetch_array($sqlsz)) { 
                                                //$no=$resz['number'];
                                            $sql2="SELECT student_marks.*,report_detail.exam_id from student_marks join report_detail on student_marks.report_id=report_detail.id  where student_marks.subject_id='$sid' and report_detail.student_id='$student_id' and report_detail.exam_id='$exam_id' ";
                                            $exe2=mysqli_query($conn,$sql2);
                                            while ($res2=mysqli_fetch_array($exe2))
                                            { ?>
                                            <td><?= $res2['meter_fas']; ?></td>
                                            <td><?= $res2['meter_fas2']; ?></td>
                                            <td><?= $res2['meter_fas3']; ?></td>
                                            <td><?= $res2['meter_fas4']; ?></td>
                                            <td><?= $res2['t20']; ?></td>
                                            <td><?= $res2['grade']; ?></td>
                                            <td><?= $res2['grade_point']; ?></td>
                                        </tr><?php } } ?>
                                                     <?php $svid='7'; ?>
                                                     <tr class="gradePer">
                                                         <td>Grade%</td>
                                                         <?php 
                                           // $sqlsz=mysqli_query($conn,"SELECT * from meter_fas");
                                            //while ($resz=mysqli_fetch_array($sqlsz)) { 
                                                //$no=$resz['number'];
                                            $sql_gd=mysqli_query($conn,"SELECT student_marks.*,report_detail.exam_id from student_marks join report_detail on student_marks.report_id=report_detail.id  where student_marks.subject_id='$svid' and report_detail.student_id='$student_id' and report_detail.exam_id='$exam_id'");
                                            while ($res_gd=mysqli_fetch_array($sql_gd))
                                            {  ?>
                                            <td><?= $res_gd['meter_fas']; ?></td>
                                            <td><?= $res_gd['meter_fas2']; ?></td>
                                            <td><?= $res_gd['meter_fas3']; ?></td>
                                            <td><?= $res_gd['meter_fas4']; ?></td>
                                            <td><?= $res_gd['t20']; ?></td>
                                            <td><?= $res_gd['fa_marks']; ?></td>
                                            <td><?= $res_gd['sa_marks']; ?></td>
                                            <td><?= $res_gd['total_marks']; ?></td>
                                            <td><?= $res_gd['grade']; ?></td>
                                            <td><?= $res_gd['grade_point']; ?></td>
                                        </tr><?php }  ?>
                                                     <?php $sub="General Knowledge";
                                         $sqllt="SELECT * from subject where subject_name ='$sub'";
                                            $exelt=mysqli_query($conn,$sqllt);
                                            $reslt=mysqli_fetch_array($exelt);
                                              $srid=$reslt['id']; ?>
                                                     <tr>
                                                         <td>General Knowledge </td>
                                                         <?php 
                                            $sqlgk=mysqli_query($conn,"SELECT student_marks.*,report_detail.exam_id from student_marks join report_detail on student_marks.report_id=report_detail.id  where student_marks.subject_id='$srid' and report_detail.student_id='$student_id' and report_detail.exam_id='$exam_id'");
                                            while($resgk=mysqli_fetch_array($sqlgk))
                                            { ?>
                                            <td><?= $resgk['meter_fas']; ?></td>
                                            <td><?= $resgk['meter_fas2']; ?></td>
                                            <td><?= $resgk['meter_fas3']; ?></td>
                                            <td><?= $resgk['meter_fas4']; ?></td>
                                            <td><?= $resgk['t20']; ?></td>
                                            <td><?= $resgk['fa_marks']; ?></td>
                                            <td><?= $resgk['sa_marks']; ?></td>
                                            <td><?= $resgk['total_marks']; ?></td>
                                            <td><?= $resgk['grade']; ?></td>
                                            <td><?= $resgk['grade_point']; ?></td>
                                        </tr><?php }  ?>
                                                     </tr>
                                                     <?php $svid='9'; ?>
                                                     <tr class="gradePer">
                                                         <td>Grade%</td>
                                                         <?php 
                                            $sql_gd=mysqli_query($conn,"SELECT student_marks.*,report_detail.exam_id from student_marks join report_detail on student_marks.report_id=report_detail.id  where student_marks.subject_id='$svid' and report_detail.student_id='$student_id' and report_detail.exam_id='$exam_id'");
                                            while ($res_gd=mysqli_fetch_array($sql_gd))
                                            { ?>
                                            <td><?= $res_gd['meter_fas']; ?></td>
                                            <td><?= $res_gd['meter_fas2']; ?></td>
                                            <td><?= $res_gd['meter_fas3']; ?></td>
                                            <td><?= $res_gd['meter_fas4']; ?></td>
                                            <td><?= $res_gd['t20']; ?></td>
                                            <td><?= $res_gd['fa_marks']; ?></td>
                                            <td><?= $res_gd['sa_marks']; ?></td>
                                            <td><?= $res_gd['total_marks']; ?></td>
                                            <td><?= $res_gd['grade']; ?></td>
                                            <td><?= $res_gd['grade_point']; ?></td>
                                        </tr><?php }  ?>
                                                 </tbody>
                                             </table>
                                         </div>
                                     </div>
                                 </div>
                             </div>
                         </div>
                  <div class="clearfix"></div>
             </div>
                 </section>
             </div>

<?php include("includes/footer.php");?>
             <?php include("includes/js.php");?>

</body>

</html>

Editing File: report-card-old.php