<?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> Video</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 id="sub" method="POST"  ">
                        <div class="row">
                          <div class="mb-3 col-md-6">
                            <label for="firstName" class="form-label"> Title</label>
                            <input
                              class="form-control"
                              type="text"
                              id="firstName"
                              name="name"
                              
                              autofocus
                            />
                            <input type="text" hidden name="sub" value="sub"> 
                          </div>
                          <div class="mb-3 col-md-6">
                            <label for="">Video Link</label>
                            <input
                              class="form-control"
                              type="text"
                              id="firstName"
                              name="files"
                              value=" "
                              autofocus
                            />
                          </div>
                         </div>  
                        
                         <div class="mt-2">
                          <button type="submit" class="btn btn-primary me-2">Upload</button>
                          <button type="reset" class="btn btn-outline-secondary">Cancel</button>
                        </div>
                      </form>
                    </div>
                    <!-- /Account -->
                  </div>
                  <hr>
                  <div class="card">
                    <h5 class="card-header">View Video</h5>
                    <div class="card-body">
                    <div class="table-responsive text-nowrap">
                  <table class="table">
                    <thead>
                      <tr>
                        <th>Id</th>
                        <th>Title</th>
                        <th>Video</th>
                          <th>Actions</th>
                      </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">
                        <?php
                              $count=1;
                        $result = mysqli_query($conn,"SELECT * FROM video");
                        while($data = mysqli_fetch_array($result))
                        {
                         ?>
                      <td><?php echo $count;   ?></td>
                      <td><?php echo $data['name'];   ?></td>
                       
                      <td> 
                      <?php echo $data['video'];   ?>     
                      </td>
                         <td>
                               <a class="dropdown-item" href="edit_sub.php?id=<?php echo $data['id']  ?>"
                                ><i class="bx bx-edit-alt  "></i> Edit</a
                              >
                              <a onclick="dle('<?php echo $data['id']  ?>')" class="dropdown-item" href="javascript:void(0);"
                                ><i class="bx bx-trash  "></i> Delete</a
                              >
                            
                          </div>
                        </td>
                      </tr>
                      <?php
 $count++;
                        }
                    ?>
                    </tbody>
                  </table>
                </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
            <!-- / Content -->
<?php include 'comman/footer.php'; ?>
<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 = "sub_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(){
		   $('#sub').unbind().submit(function(e){
			   e.preventDefault();
			   var data=document.getElementById('sub');
				var formdata= new FormData(data);
  				$.ajax({
					   type: "POST",
					   url: "login_process2.php",
					   data: formdata,
					   processData: false,
					   contentType: false,
					   cache: false,
					   success: function (data) 
					   {
						   if(data==1)
						   {
                swal({
                title: "Good job!",
                text: "Sub Category Added!",
                icon: "success",
              }).then(function() {
                                    window.location = "video.php";
                                });
                                                
							 
						   }
						   else
						   {
								 alert(data);
						   }
					 
					   }
				   });
		   })
	   })
    </script>