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

       <?php
       if(isset($_POST['description'])){
        $description=$_POST['description'];
        $status=$_POST['status'];
         
        $que="UPDATE `note` SET `description`='$description',`status`='$status' LIMIT 1";
    
        if ($conn->query($que) === TRUE) {
            echo '<script>alert("Updated successfully"); location.href="note.php"</script>';
        }else {
          echo '<script>alert("Something went wrong");</script>';
        }
    }

        $q = "SELECT * FROM note LIMIT 1";
        $result  = mysqli_query($conn,$q);
        $row = mysqli_fetch_assoc($result);
        // print_r($row);
        ?>
       <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>Note </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">
                                <div id="myTabContent" class="tab-content custom-product-edit">

                                        <div class="row">

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

                                                    <div class="mg-b-pro-edt">

                                                        <select class="form-control" name="status">
                                                            <option value="1" <?php if($row['status']==1) echo 'selected'; ?>>Active</option>
                                                            <option value="0" <?php if($row['status']==0) echo 'selected'; ?>>Inactive</option>
                                                        </select>

                                                    </div>
                                                    <div class="mg-b-pro-edt">

                                                        <textarea rows="10" class="form-control" name="description" placeholder="Note" ><?php echo $row['description'] ?></textarea>

                                                    </div>


                                                </div>

                                            
                                            </div>

                                        </div>

                                        <div class="row">

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

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

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

                                                        </button>

                                                    <a href="index.php" class="btn btn-ctl-bt waves-effect waves-light">cancel

                                                        </a>

                                                </div>

                                            </div>

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

                                </div>

                            </div>

                        </div>

                    </div>

                </div>

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