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

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

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

    $house_id=$_POST['house_id'];
    $housemistress=$_POST['house_mistress'];
    $assistant=$_POST['assistant'];
    // $co_house=$_POST['co_house'];
    $total_girls=$_POST['total_girls'];
    
    $que="UPDATE `house_mistress` SET `house_id`='$house_id',`house_mistress`='$housemistress',`assistant`='$assistant',`total_girls`='$total_girls' WHERE id='$id' LIMIT 1";
    if($que){
        echo '<script>alert("Update successfully"); location.href="house_mistress"</script>';

    }else{
        echo '<script>alert("Oops Something Went Wrong!");</script>';
    }
    
}
$q = "SELECT * FROM house_mistress WHERE id='$id' limit 1";
        $result  = mysqli_query($conn,$q);
        $row = 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 House Mistress</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">
                                <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="house_id" required>
                                                        <option value="">Select House Name</option>
                                                    <?php
                                                    $q = "select * from house";
                                                    $query = mysqli_query($conn,$q);
                                                    while($res = mysqli_fetch_array($query)) { ?>
                                                        <option value="<?php echo $res['id']; ?>" <?php if ($res['id']==$row['house_id']){echo 'selected';} ?>><?php echo $res['house_name']; ?></option>
                                                    <?php } ?>
                                                    </select> 
                                                </div>
                                                
                                                <div class="input-group mg-b-pro-edt">
                                                    <input type="text" name="house_mistress" class="form-control" placeholder="House Mistress" value="<?php echo $row['house_mistress'] ?>">

                                                </div>
                                                <div class="input-group mg-b-pro-edt">
                                                    <input type="text" name="assistant" class="form-control" placeholder="Assistant House Master" value="<?php echo $row['assistant'] ?>">

                                                </div>
                                                <!-- <div class="input-group mg-b-pro-edt">
                                                    <input type="text" name="co_house" class="form-control" placeholder="Co. House Mistress" value="<?php echo $row['co_house'] ?>">

                                                </div> -->
                                                <div class="input-group mg-b-pro-edt">
                                                    <input type="number" name="total_girls" class="form-control" placeholder="Total No. Of Girls" value="<?php echo $row['total_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="house_mistress" class="btn btn-ctl-bt waves-effect waves-light">cancel

                                                </a>

                                            </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'); ?>