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

       <?php
         $q = "SELECT * FROM popup limit 1";
        $result  = mysqli_query($conn,$q);
        $row = mysqli_fetch_assoc($result);
       $count =  mysqli_num_rows($result);

       if(isset($_FILES['image']['name'])){
        $imgurl=$_POST['img_url'];
        $img=$_FILES['image']['name'];
        $image = uniqid().$_FILES['image']['name'];
        $path = 'uploads/'.$image;
        if ($img!='') {
            
         if ($count>0) {
        $que="UPDATE `popup` SET `image`='$path' LIMIT 1";
        }else{
             $que="INSERT INTO popup (image) values('$path')";  
        }
    }else{
         $que = "DELETE FROM popup";
    }
    
        if ($conn->query($que) === TRUE) {
            unlink($imgurl);
            move_uploaded_file($_FILES['image']['tmp_name'], $path);
            echo '<script>alert("Updated successfully"); location.href="popup_image.php"</script>';
        }else {
          echo '<script>alert("Something went wrong");</script>';
        }
    }

      
        // 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>Popup Image </h2>
                                            </div>
                                        </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="file-upload-inner ts-forms" style="margin-bottom:15px;">
                                                            <div class="input prepend-small-btn">
                                                                <div class="file-button">
                                                                    Browse
                                                                    <input type="file" name="image" accept="image/*" onchange="document.getElementById('prepend-small-btn').value = this.value;">
                                                                </div>
                                                                <input type="text" id="prepend-small-btn"  placeholder="Select Image" readonly>
                                                                <input type="hidden" name="img_url" value="<?php echo $row['image'] ?>">
                                                            </div>
                                                        </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="index.php" class="btn btn-ctl-bt waves-effect waves-light">cancel

                                                        </a>
                                                        
                                                        <button onclick="del(<?php echo $res['id'] ?>)" data-toggle="tooltip" title="Trash" class="pd-setting-ed"><i class="fa fa-trash" aria-hidden="true"></i></button>

                                                </div>

                                                </div>

                                            <div class="text-center col-lg-6 col-md-6 col-sm-6 col-xs-12">
                                                <img src="<?php echo $row['image'] ?>" style="width: 50%;">
                                            </div>
                                           

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

                                </div>

                            </div>

                        </div>

                    </div>

                </div>

            </div>
            <script>
    function del(e) {
      var verify = confirm("Do you really want to delete!!!");
      if(verify) {
          $.ajax({
              url: "delete.php",
              type: "POST",
              data: {
                  popup_id: e,
              },
              success: function(response){
                 location.reload();
              },
          })
      }
  }
</script>
        <?php include('include/footer.php'); ?>