<?php
include 'config.php';

  $id = $_GET['id'];

  $sql = mysqli_query($conn, "SELECT * FROM `category` WHERE id='$id'");

  $row = mysqli_fetch_array($sql);


 
  if(isset($_POST['update']))
  {

     $name = $_POST['name'];

    $img =$_FILES['file'];
    $filename=$img['name'];
    $filepath=$img['tmp_name'];
    $fileerror=$img['error'];

  

    if(!$filename=="")
    {
            $destypath="upload/".$filename;
            move_uploaded_file($filepath, $destypath);
        $ab = "UPDATE `category` SET `name`='$name',`image`='$destypath' WHERE id='$id'";
        $reb = mysqli_query($conn, $ab);
        if($reb==TRUE)
        {
            echo ("<script LANGUAGE='JavaScript'>
            window.alert('Succesfully Updated');
            window.location.href='banner.php';
            </script>");
        }
    } 
    else
    {
        $ab = "UPDATE `category` SET `name`='$name' WHERE id='$id'";
        $reb = mysqli_query($conn, $ab);
        if($reb==TRUE)
        {
             echo ("<script LANGUAGE='JavaScript'>
            window.alert('Succesfully Updated');
            window.location.href='banner.php';
            </script>");
        }
    }  

  }
?>
                  
<?php include 'comman/links.php'; ?>
     <!-- Layout wrapper -->
    <div class="layout-wrapper layout-content-navbar">
      <div class="layout-container">
        <!-- Menu -->
  <?php  include 'comman/sidebar.php'; ?>

        <!-- Layout container -->
        <div class="layout-page">
         <?php include 'comman/header.php';   ?>

          <!-- Content wrapper -->
          <div class="content-wrapper">
            <!-- Content -->

            <div class="container-xxl flex-grow-1 container-p-y">
              <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Admin /</span>Edit category</h4>

              <div class="row">
                <div class="col-md-12">
                  <ul class="nav nav-pills flex-column flex-md-row mb-3">
                    <!-- <li class="nav-item">
                      <a class="nav-link active" href="javascript:void(0);"><i class="bx bx-user me-1"></i> Account</a>
                    </li> -->
                    <!-- <li class="nav-item">
                      <a class="nav-link" href="pages-account-settings-notifications.html"
                        ><i class="bx bx-bell me-1"></i> Notifications</a
                      >
                    </li> -->
                    <!-- <li class="nav-item">
                      <a class="nav-link" href="pages-account-settings-connections.html"
                        ><i class="bx bx-link-alt me-1"></i> Connections</a
                      >
                    </li> -->
                  </ul>
                  <div class="card mb-4">
                    <!-- <h5 class="card-header">Profile Details</h5> -->
                    <!-- Account -->
                    <!-- <div class="card-body">
                      <div class="d-flex align-items-start align-items-sm-center gap-4">
                         <div class="button-wrapper">
                          <label for="upload" class="btn btn-primary me-2 mb-4" tabindex="0">
                            <span class="d-none d-sm-block">Upload new photo</span>
                            <i class="bx bx-upload d-block d-sm-none"></i>
                            <input
                              type="file"
                              id="upload"
                              class="account-file-input"
                              hidden
                              accept="image/png, image/jpeg"
                            />
                          </label>
                          

                          <p class="text-muted mb-0">Allowed JPG, GIF or PNG. Max size of 800K</p>
                        </div>
                      </div>
                    </div> -->
                    <hr class="my-0" />
                    <div class="card-body">
                    <form  method="POST"  enctype="multipart/form-data" >
                        <div class="row">
                          <div class="mb-3 col-md-6">
                          <label for="defaultSelect" class="form-label">Edit Title</label>
                                <input type="text" name="name"   class="form-control"  value="<?php echo $row['name'] ?>" > 
                          </div>
                          
                          <div class="mb-3 col-md-6">
                             <div class="mb-3">
                          
                                <label class="form-label">Edit Image</label>
                                <input name="file" class="form-control" type="file" accept="image/*" onchange="loadFile(event)">
                                <p><img id="output" height="120" width="200" src="<?php echo $row['image'];   ?>"></p>
                                <script>
                                    var loadFile = function(event) {
                                        var image = document.getElementById('output');
                                        image.src=URL.createObjectURL(event.target.files[0]);
                                    };
                                </script>

                          </div>
                           </div>
                         </div>  
                         <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                            <button type="submit" name="update" class="btn btn-primary">Save changes</button>
                          </div>
                      </form>
                    </div>
                    <!-- /Account -->
                  </div>
                  <hr>
               </div>
            </div>
           
            <!-- / Content -->
<?php include 'comman/footer.php'; ?>
<script>
  function up(id)
  {
    jQuery.ajax
        ({
            url:'edit_ban.php',
            type:'post',
            data:'id='+id+'&type=data',
            success:function(data)
            {
               alert(data);
                // $('.ddd').html(data);
            }
        });
  }
</script>
<script>
  function dle(id)
  {
    swal({
  title: "Are You Want To Delete?",
//   text: "Are you want to delete!",
  icon: "warning",
  buttons: true,
  dangerMode: true,
})
.then((willDelete) => {
  if (willDelete) {
            window.location = "bn_dl.php?id="+id;
    swal("Poof! Your imaginary file has been deleted!", {
      icon: "success",
    });
  } else {
    swal("Your imaginary file is safe!");
  }
});
    
    
        
  }
</script>
<script>
	   $(document).ready(function(){
		   $('#bn').unbind().submit(function(e){
			   e.preventDefault();
			   var data=document.getElementById('bn');
				var formdata= new FormData(data);
  				$.ajax({
					   type: "POST",
					   url: "bn_process.php",
					   data: formdata,
					   processData: false,
					   contentType: false,
					   cache: false,
					   success: function (data) 
					   {
						   if(data==1)
						   {
                swal({
                title: "Good job!",
                text: "Slide Show Added!",
                icon: "success",
              }).then(function() {
                                    window.location = "banner.php";
                                });
                                                
							 
						   }
						   else
						   {
								 alert(data);
						   }
					 
					   }
				   });
		   })
	   })
    </script>