Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.62.1.el9_6.x86_64

PHP Version:

8.3.26

User:

u719773305

Directory:

/home/u719773305/domains/neelkantharc.in/public_html/admin

Free Space:

11.53 TB

🔧 Quick Actions

✏️ Editing: add-products.php

<?php
   $pagetitle = 'Add Product';
   $description='';
   $keywords = '';
   include'config.php';
         
         
   if(isset($_POST['submit']))
   {

$cat_id = $_POST['cat_id'];
       $subcat_id = $_POST['subcat_id'];
       
       $name = $_POST['name'];
       $title = $_POST['title'];
       
       $url_key = str_replace("---","-",preg_replace("/[^-a-zA-Z0-9s]/", "-", strtolower(trim($title))));
       
       
       $description = mysqli_real_escape_string($conn,$_POST['description']);
       
       $seo_title = mysqli_real_escape_string($conn,$_POST['seo_title']);
       $seo_keyword = mysqli_real_escape_string($conn,$_POST['seo_keyword']);
       $seo_description = mysqli_real_escape_string($conn,$_POST['seo_description']);
      
      
   
   
   
       $main_image = time().'_'.$_FILES['main_image']['name'];
       $image1 =time().'_'.$_FILES['image1']['name'];
       $image2 =time().'_'.$_FILES['image2']['name'];
       $image3 =time().'_'.$_FILES['image3']['name'];
       $image4 =time().'_'.$_FILES['image4']['name'];
       
       
       if(!empty($_FILES['main_image']['tmp_name'])) {
         
         move_uploaded_file($_FILES['main_image']['tmp_name'],'main-images/'.$main_image);
       }
       
       //gallery image 1
       
        if(!empty($_FILES['image1']['tmp_name'])) {
        
         move_uploaded_file($_FILES['image1']['tmp_name'],'main-images/gallery/'.$image1);
       }
       
       
       
        
       //gallery image 2
       
        if(!empty($_FILES['image2']['tmp_name'])) {
         
         move_uploaded_file($_FILES['image2']['tmp_name'],'main-images/gallery/'.$image2);
       }
       
           
        
       //gallery image 3
       
        if(!empty($_FILES['image3']['tmp_name'])) {
         
         move_uploaded_file($_FILES['image3']['tmp_name'],'main-images/gallery/'.$image3);
       }
       
               
        
       //gallery image 4
       
        if(!empty($_FILES['image4']['tmp_name'])) {
         
         move_uploaded_file($_FILES['image4']['tmp_name'],'main-images/gallery/'.$image4);
       }
       
   
            
        
       //gallery image 5
       
       //  if(!empty($_FILES['image5']['tmp_name'])) {
       
       //   move_uploaded_file($_FILES['image5']['tmp_name'],'main-images/gallery/'.$image5);
       // }
       
       
       // pdf
       
       $pdf =time().'_'.$_FILES['pdf']['name'];
       
       if(!empty($_FILES['pdf']['tmp_name'])) {
         
         move_uploaded_file($_FILES['pdf']['tmp_name'],'pdf/'.$pdf);
       }
           // video
       
    //   $video =time().'_'.$_FILES['video']['name'];
       
       $video = $_POST['video'];
       
    //     if(!empty($_FILES['video']['tmp_name'])) {
         
    //      move_uploaded_file($_FILES['video']['tmp_name'],'video/'.$video);
    //   }
       
       
   
   $reg_date = date("Y-m-d");
   
   $sql = "INSERT INTO `tl_products` ( `cat_id`,`subcat_id`,`sname`, `url`, `title`, `detail`, `pdf`, `main_image`, `gimg1`, `gimg2`, `gimg3`, `gimg4`, `video`, `seo_title`, `seo_keyword`, `seo_description`, `reg_date`) VALUES ('$cat_id','$subcat_id', '$name', '$url_key', '$title', '$description', '$pdf', '$main_image', '$image1', '$image2', '$image3', '$image4','$video', '$seo_title', '$seo_keyword', '$seo_description', '$reg_date')";
   
   
       if ($conn->query($sql) === TRUE) 
       {
           
                   echo "<script>alert('Product Added Successfully');window.location='add-products.php'</script>";
       }
       else
       {
             echo "<script>alert('Failed');window.location='add-products.php'</script>";
       }
       
       
   }
   
   if(!empty($_GET['id']))
   {
       // sql to delete a record
            $sql = "DELETE FROM tl_products WHERE id=".$_GET['id'];
            
            if ($conn->query($sql) === TRUE) {
                echo "<script>alert('Product deleted Successfully');window.location='add-products.php'</script>";
             
            } else {
              echo "Error deleting record: " . $conn->error;
            }

}
   
   
   include 'include/header.php';
   ?>

<div class="container-fluid">
   
   <div class="d-sm-flex align-items-center justify-content-between mb-4">
      <h1 class="h3 mb-0 text-gray-800">Add Products</h1>
   </div>
   
   <div class="row">
      
      <div class="col-xl-12 col-lg-12">
         <div class="card shadow mb-4">
            <div class="card-header py-3">
               <h6 class="font-weight-bold text-primary add-client">
                  Add Products
               </h6>
               <form method="post" role="form" class="php-email-form1 row" enctype="multipart/form-data">
                    <div class="col-md-4 form-group">
                        <label>Select Main Category</label>
                            <select class="form-select" aria-label="Default select example" name="cat_id" id="cat" required>
                              <option selected>Select Category</option>
                              <?php 
                         
                                $sql = "SELECT id, name FROM tl_cat ORDER BY id ASC";
                                $result = $conn->query($sql);
                               
                                if ($result->num_rows > 0) {
                                  // output data of each row
                                  while($cat_row = $result->fetch_assoc()) {
                         
                                ?>
                              
                              <option value="<?php echo $cat_row['id'];?>"><?php echo $cat_row['name'];?></option>
                              <?php } } ?>
                              
                            </select>
                    </div>
                  <div class="col-md-4 form-group">
                     <label>Select Sub Category</label>
                     <select class="form-select" aria-label="Default select example" name="subcat_id" id="subcat">
                              <option value="">Select Sub Category</option>
                              
                              
                            </select>
                  </div>
                  
                  <div class="col-md-4 form-group">
                     <label>Product Title</label>
                     <input type="text" name="title" class="form-control" id="cname" placeholder="Title" required>
                  </div>
                  
                  <div class="col-md-4 form-group">
                     <label>Upload Product Main Image</label>
                     <input class="form-control" type="file" name="main_image" id="formFile" required>
                  </div>
                  <div class="col-md-12 form-group">
                     <label>Details</label>
                     <textarea class="form-control" name="description" id="description" rows="3" placeholder="Content" required></textarea>
                  </div>
                  
                  <hr>
                  
                  <div class="col-md-6 form-group">
                     <label>Upload Category Image1</label>
                     <input class="form-control" type="file" name="image1" id="formFile" required>
                  </div>
                  
                  
                  <div class="col-md-6 form-group">
                     <label>Upload Category Image2</label>
                     <input class="form-control" type="file" name="image2" id="formFile" required>
                  </div>
                  
                  
                  <div class="col-md-6 form-group">
                     <label>Upload Category Image3</label>
                     <input class="form-control" type="file" name="image3" id="formFile" required>
                  </div>
                  
                  <div class="col-md-6 form-group">
                     <label>Upload Category Image4</label>
                     <input class="form-control" type="file" name="image4" id="formFile" required>
                  </div>
                  <hr>
                  
                  
                  <div class="col-md-6 form-group">
                     <label>Upload PDF</label>
                     <input class="form-control" type="file" name="pdf" id="formFile" required>
                  </div>
                  
                  
                  <div class="col-md-6 form-group">
                     <label>Upload Video</label>
                     
                     <input class="form-control" type="url" name="video" id="formFile" required>
                  </div>
                  
                  
                  <hr>
                  <div class="col-lg-12">
                     <h6 class="font-weight-bold text-primary add-client">
                        SEO SECTION
                     </h6>
                  </div>
                  <div class="col-md-12 form-group">
                     <textarea class="form-control" name="seo_title" id="cmessage" rows="3" placeholder="SEO Title" required></textarea>
                  </div>
                  <div class="col-md-12 form-group">
                     <textarea class="form-control" name="seo_keyword" id="cmessage" rows="3" placeholder="SEO Keywords" required></textarea>
                  </div>
                  <div class="col-md-12 form-group">
                     <textarea class="form-control" name="seo_description" id="cmessage" rows="3" placeholder="Description" required></textarea>
                  </div>
                  <div class="col-md-12 buttons-submit"><button type="submit" name="submit" class="btn btn-primary othrCall">Submit</button></div>
               </form>
               <hr>
               <div class="table-responsive">
                  <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                     <thead>
                        <tr>
                           <th>S.No.</th>
                           <th>Main Category</th>
                           <th>Sub Category</th>
                           <th>Product Title</th>
                           <th>PDF</th>
                           <th>Youtube Video</th>
                           <th>Action</th>
                        </tr>
                     </thead>
                     <tbody>
                         <?php 
                         
                                 $sql = "SELECT id, cat_id,subcat_id,title,pdf,video FROM tl_products ORDER BY id DESC";
                                $result = $conn->query($sql);
                                $i=1;
                                if ($result->num_rows > 0) {
                                  // output data of each row
                                  while($row = $result->fetch_assoc()) {
                                      $cid = $row['cat_id'];
                                      $sid = $row['subcat_id'];
                                      
                                         $csql = "SELECT id, name as catname FROM tl_cat WHERE id='$cid' ORDER BY id DESC";
                                            $cat_row = $conn->query($csql)->fetch_assoc();
                                            
                                            
                                            $scsql = "SELECT id, sname as scatname FROM tl_subcat WHERE id='$sid' ORDER BY id DESC";
                                            $scat_row = $conn->query($scsql)->fetch_assoc();
                                    
                         
                         ?>
                        <tr>
                           <th scope="row"><?php echo $i++;?></th>
                           <td><?php echo $cat_row['catname'];?></td>
                           <td><?php echo $scat_row['scatname'];?></td>
                           <td><?php echo $row['title'];?></td>
                           <td class="pdf-section"><a href="pdf/<?php echo $row['pdf'];?>"><img src="main-images/pdf-icon.png"></a></td>
                           <td><iframe width="100%" height="150" src="<?php echo $row['video'];?>" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe></td>
                           
                           <td class="edit-section">
                              <a href="edit-products.php?id=<?php echo $row['id'];?>">
                              <button class="btn btn-success">
                              Edit </button> 
                              </a>
                              <a href="?id=<?php echo $row['id'];?>">
                              <button class="btn btn-primary">
                              Delete</button></a>
                           </td>
                        </tr>
                        
                        <?php 
                                  }
                            } else {
                              echo "0 results";
                            }
                            $conn->close();
                        
                        ?>
                        
                     </tbody>
                  </table>
               </div>
            </div>
         </div>
      </div>
   </div>
</div>

<?php
   include 'include/footer.php';
   ?>
   <script>
    $(document).ready(function(){
      $("#cat").change(function(){
        // alert("The text has been changed.");
        
        var catid = $("#cat").val();
        
        
        jQuery.ajax({
				url:'subcat.php',
				type:'post',
				data:'id='+catid,
				success:function(result){
				    console.log(result);
				// 	jQuery('#tr_'+catid).hide(500);
					 $("#subcat").html (result);
				}
			});
        
        
        
      });
    });
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-products.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation