<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->

<?php include('include/header.php'); ?>

<?php 
if(isset($_POST['submit'])){

    $id=$_POST['id'];
    $work_experience=$_POST['work_experience'];
    $art_education=$_POST['art_education'];
    $physical_education=$_POST['physical_education'];
    $thinking_skill=$_POST['thinking_skill'];
    $social_skill=$_POST['social_skill'];
    $emotional_skill=$_POST['emotional_skill'];
    $teachers=$_POST['teachers'];
    $seniors=$_POST['seniors'];
    $school_mates=$_POST['school_mates'];
    $environment=$_POST['environment'];
    $art=$_POST['art'];
    $music=$_POST['music'];
    $computer=$_POST['computer'];
    $spoken_english=$_POST['spoken_english'];
    $physical_activity=$_POST['physical_activity'];

    $sql = $conn->query("UPDATE results SET work_experience='$work_experience',art_education='$art_education',physical_education='$physical_education',thinking_skill='$thinking_skill',social_skill='$social_skill',emotional_skill='$emotional_skill',teachers='$teachers',seniors='$seniors',school_mates='$school_mates',environment='$environment',art='$art',music='$music',computer='$computer',spoken_english='$spoken_english',physical_activity='$physical_activity' WHERE id='$id'");
    
    if($sql){
        echo '<script>alert("Added successfully"); location.href="results_details";</script>';

    }else{
        echo '<script>alert("Oops Something Went Wrong!");</script>';
    }

}
?>

<style>
    #myTabContent .input-group{
        width: 100%;
    }
    #myTabContent h2{
        width: 100%;
        text-align: center;
        border-top: 1px solid #7b7b7b;
        color: #fff;
        font-size: 20px;
        margin: 15px;
        padding-top: 20px;
    }
    .form-control:disabled, .form-control[readonly] {
        background-color: #152036;
        opacity: 0.5;
    }
</style>
<div class="breadcome-area">
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="breadcome-list">
                    <div class="row">
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="breadcomb-wp">
                                <div class="breadcomb-icon">
                                    <i class="icon nalika-home"></i>
                                </div>
                                <div class="breadcomb-ctn">
                                    <h2>Add Result</h2>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">

                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>
<div class="single-product-tab-area mg-b-30">

    <!-- Single pro tab review Start-->

    <div class="single-pro-review-area">

        <div class="container-fluid">

            <div class="row">

                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">

                    <div class="review-tab-pro-inner">
                        <div id="myTabContent" class="tab-content custom-product-edit">

                         <div class="row">

                            <div class="col-md-6 col-sm-6 col-xs-12">
                                <div class="input-group mg-b-pro-edt">
                                 <select class="form-control" name="student_id" onchange="getdata(this.value)" required>
                                    <option value="">Select Student</option>
                                    <?php
                                    $q = "SELECT * FROM students INNER JOIN results ON results.student_id=students.id";
                                    $query = mysqli_query($conn,$q);
                                    while($res = mysqli_fetch_array($query)) { ?>
                                        <option value="<?php echo $res['id'] ?>"><?php echo $res['student_name'] ?></option>
                                    <?php } ?>
                                </select>

                            </div>
                        </div>
                    </div>
                    <div id="data">
                    </div>
                </div>

            </div>

        </div>

    </div>

</div>

</div>

</div>

<script>
 function getdata(e) {
  $.ajax({
      url: "getstudentdata.php",
      type: "POST",
      data: {
          id: e,
      },
      success: function(response){
              // console.log(response);
          $('#data').html(response);
      },
  })
}
</script>

<?php include('include/footer.php'); ?>