<?php
session_start();
include('admin/config.php');
if (isset($_POST['roll_no'])) { 
    $roll_no=$_POST['roll_no'];
    $_SESSION['roll_no']=$roll_no;
    $q = "SELECT students.*,students.id as student_id,result_list.*, results.id as res_id,class.class_name FROM results LEFT JOIN students ON students.id=results.student_id LEFT JOIN class ON students.class_id=class.id LEFT JOIN result_list ON result_list.result_id=results.id WHERE students.id='$roll_no' AND results.session='".date('Y')."'";

    $query = mysqli_query($conn,$q);
    $res = mysqli_fetch_array($query); 
    $class=$res['class_name'];
        if(preg_match('/IX/i', $class) || preg_match('/X/i', $class) || preg_match('/XI/i', $class)){
            header("location: checkresult");
        }
    
    ?>
    <table class="table table-bordered" style="width:100%">
        <tr>
         <td><b>Name Of The Student</b></td>
         <td><?php echo $res['student_name']; ?></td>
         <td><b>Roll No.</b></td>
         <td><?php echo $res['student_id']; ?></td>
         <td><b>S NO.</b></td>
         <td><?php echo $res['res_id']; ?></td>
         <td><b>Class</b></td>
         <td><?php echo $res['class_name']; ?></td>
     </tr>
 </table>
 <div class="table-responsive">
    <div class="headline" id="headlines"><h2>EKLAVYA MODEL RESIDENTIAL SCHOOL, KALSI, DEHRADUN RESULT <br>(<?php echo date('Y')-1 ?>-<?php echo date('Y') ?>)</h2></div>
    <table class="table table-bordered" style="width:100%">
        <thead>
            <tr>
                <th>SUBJECT</th>
                <th>PA-1</th>
                <?php if($res['pa2']!=0){ ?>
                    <th>PA-2</th>
                <?php } ?>

                <?php if($res['theory1']!=0){ ?>
                    <th>THEORY-1</th>
                <?php } ?>

                <?php if($res['theory2']!=0){ ?>
                    <th>THEORY-2</th>
                <?php } ?>
                <th>GRAND TOTAL</th>
            </tr>
        </thead>
        <?php 
        $q = "SELECT subjects.*,result_list.*,students.student_name FROM results LEFT JOIN result_list ON result_list.result_id=results.id LEFT JOIN subjects ON subjects.id=result_list.subject_id LEFT JOIN students ON students.id=results.student_id WHERE students.id='$roll_no' AND results.session='".date('Y')."'";
        $query = mysqli_query($conn,$q);
        $total=0;
        while($subject = mysqli_fetch_array($query)) {
            $total+=$subject['pa1']+$subject['pa2']+$subject['theory1']+$subject['theory2'] ?>
            <tr>
                <td><?php echo $subject['subject_name']; ?></td>
                <td><?php echo $subject['pa1'];?></td>

                <?php if($subject['pa2']!=0){ ?>
                    <td><?php echo $subject['pa2'];?></td>
                <?php } ?>

                <?php if($subject['theory1']!=0){ ?>
                    <td><?php echo $subject['theory1'];?></td>
                <?php } ?>

                <?php if($subject['theory2']!=0){ ?>
                    <td><?php echo $subject['theory2'];?></td>
                <?php } ?>
                <td><?php echo $total;?></td>
            </tr>
        <?php } ?>
        
    </table>
    <?php } ?>