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

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

<?php 
$id=$_GET['id'];
if(isset($_POST['submit'])){

    $class_id=$_POST['class'];
    $section=$_POST['section'];
    $jaunsari_boys=$_POST['jaunsari_boys'];
    $jaunsari_girls=$_POST['jaunsari_girls'];
    $bhotia_boys=$_POST['bhotia_boys'];
    $bhotia_girls=$_POST['bhotia_girls'];
    $boxa_boys=$_POST['boxa_boys'];
    $boxa_girls=$_POST['boxa_girls'];
    $tharu_boys=$_POST['tharu_boys'];
    $tharu_girls=$_POST['tharu_girls'];
    $raji_boys=$_POST['raji_boys'];
    $raji_girls=$_POST['raji_girls'];

    $sql = $conn->query("UPDATE tribe_wise_student SET class_id='$class_id',section='$section',jaunsari_boys='$jaunsari_boys',jaunsari_girls='$jaunsari_girls',bhotia_boys='$bhotia_boys',bhotia_girls='$bhotia_girls',boxa_boys='$boxa_boys',boxa_girls='$boxa_girls',tharu_boys='$tharu_boys',tharu_girls='$tharu_girls',raji_boys='$raji_boys',raji_girls='$raji_girls' WHERE id='$id'");

    if($sql){
       echo '<script>alert("Added successfully"); location.href="tribe_wise_student"</script>';

   }else{
    echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
$q = "SELECT * FROM tribe_wise_student WHERE id='$id' limit 1";
        $result  = mysqli_query($conn,$q);
        $res = mysqli_fetch_assoc($result);
?>

<style>
    #myTabContent .input-group{
        width: 100%;
    }
</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>Edit Tribe Wise Student</h2>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                                        <!-- <div class="breadcomb-report">
                                            <button data-toggle="tooltip" data-placement="left" title="Download Report" class="btn"><i class="icon nalika-download"></i></button>
                                        </div> -->
                                    </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">
                                <form method="post" enctype="multipart/form-data">
                                    <div id="myTabContent" class="tab-content custom-product-edit">

                                       <div class="row">

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


                                            <!-- <div class="input-group mg-b-pro-edt">
                                                <select class="form-control" name="class_id" required>
                                                    <option value="">Select Class</option>
                                                    <?php
                                                    $q = "select * from class";
                                                    $query = mysqli_query($conn,$q);
                                                    while($row = mysqli_fetch_array($query)) { ?>
                                                        <option value="<?php echo $row['id'] ?>" <?php if ($row['id']==$res['id']){echo 'selected';} ?>
                                                        ><?php echo $row['class_name'] ?></option>
                                                    <?php } ?>
                                                </select>

                                            </div> -->

                                            <div class="input-group mg-b-pro-edt">
                                                <input type="text" name="class" class="form-control" placeholder="Class Name" value="<?php echo $res['class_id']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="text" name="section" class="form-control" placeholder="Section Name" value="<?php echo $res['section']; ?>">

                                            </div>
                                           
                                            
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="jaunsari_boys" class="form-control" placeholder="Jaunsari Boys" value="<?php echo $res['jaunsari_boys']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="jaunsari_girls" class="form-control" placeholder="Jaunsari Girls" value="<?php echo $res['jaunsari_girls']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="bhotia_boys" class="form-control" placeholder="Bhotia Boys" value="<?php echo $res['bhotia_boys']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="bhotia_girls" class="form-control" placeholder="Bhotia Girls" value="<?php echo $res['bhotia_girls']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="boxa_boys" class="form-control" placeholder="Boxa Boys" value="<?php echo $res['boxa_boys']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="boxa_girls" class="form-control" placeholder="Boxa Girls" value="<?php echo $res['boxa_girls']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="tharu_boys" class="form-control" placeholder="Tharu Boys" value="<?php echo $res['tharu_boys']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="tharu_girls" class="form-control" placeholder="Tharu Girls" value="<?php echo $res['tharu_girls']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="raji_boys" class="form-control" placeholder="Raji Boys" value="<?php echo $res['raji_boys']; ?>">

                                            </div>
                                            <div class="input-group mg-b-pro-edt">
                                                <input type="number" name="raji_girls" class="form-control" placeholder="Raji Girls" value="<?php echo $res['raji_girls']; ?>">

                                            </div>
                                            <div class="text-center custom-pro-edt-ds">

                                        <button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit">Save

                                        </button>

                                        <a href="tribe_wise_student" class="btn btn-ctl-bt waves-effect waves-light">cancel

                                        </a>

                                    </div>
                                            
                                        </div>



                                    </div>

                                </div>

                            </div>

                            <div class="row">

                                <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12" style="padding-right: 30px;">

                                    

                                </div>

                            </div>
                        </form>
                    </div>

                </div>

            </div>

        </div>

    </div>

</div>

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