Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/domains/allspikes.in/public_html/admin

Free Space:

2 TB

🔧 Quick Actions

✏️ Editing: addbulk.php

<?php
require'config.php';

if (isset($_REQUEST["import"])) 
{
    
    $fileName = $_FILES["image"]["tmp_name"];
    $files = $_FILES["image"]["name"];
     $ext = pathinfo($files, PATHINFO_EXTENSION);
     date_default_timezone_set('Asia/Kolkata');
    $currentTime = date( 'd-m-Y h:i:s A', time () );
 
    if ($ext == 'csv' ) 
    {
    
        if ($_FILES["image"]["size"] > 0) 
        {
            
            $file = fopen($fileName, "r");
            $count=0;
            while (($column = fgetcsv($file, 10000, ",")) !== FALSE) 
            {
                 
            if ($count > 0)
            {
                $Category = "";
                if (isset($column[0])) {
                     $Category = $column[0];
                }
                $subcat = "";
                if (isset($column[1])) {
                    $subcat = $column[1];
                }
                $subcat2 = "";
                if (isset($column[2])) {
                    $subcat2 = $column[2];
                }
                $product = "";
                if (isset($column[3])) {
                    $product = $column[3];
                }
                $mrp = "";
                if (isset($column[4])) {
                    $mrp = $column[4];
                }
                $price = "";
                if (isset($column[5])) {
                    $price = $column[5];
                }
                $size = "";
                if (isset($column[6])) {
                    $size = $column[6];
                }
                $stock = "";
                if (isset($column[7])) {
                    $stock = $column[7];
                } 
                
                $title = "";
                if (isset($column[8])) {
                    $title = $column[8];
                }
                $desc = "";
                if (isset($column[9])) {
                    $desc = $column[9];
                }
                $specific = "";
                if (isset($column[10])) {
                    $specific = $column[10];
                }
                $image = "";
                if (isset($column[11])) {
                    $image = $column[11];
                }
                $rating = "";
                if (isset($column[12])) {
                    $rating = $column[12];
                }
                
        
                 
                       $sqlInsert = "INSERT INTO `product`(`category`,`rating`, `subcategory`, `subcategory2`, `name`,  `mrp`, `image`, `sellprice`, `stock`, `size`, `title`, `description`, `specification`, `status`, `date`) VALUES ('$Category','$rating','$subcat','$subcat2', '$product', '$mrp', '$image', '$price', '$stock', '$size', '$title', '$desc', '$specific', '0', '$currentTime')";
                   
                    $insertId = mysqli_query($con,$sqlInsert);
                    
                    
                    if (! empty($insertId)) 
                    {
                        $msg= '<div class="alert alert-success" role="alert" style="width:40%">
                          Success ! CSV Data Imported Into the database.
                        </div>';
                        echo "<script>setTimeout(function(){ window.location = 'products.php'; },2000);</script>";
                    } 
                    else 
                    {
                        $msg= '<div class="alert alert-danger" role="alert" style="width:40%">
                          Alert !  Problem in Importing CSV Data.
                        </div>';
                    }
                
                
            }
           $count++; }
        }
   
    }
    else
    { 
        ?>
        <script>
            alert("Invalid file type");
        </script>
        <?php
    }
}
require'header.php';   
?>
 <main role="main" class="main-content">
        <div class="container-fluid">
          <div class="row justify-content-center">
            <div class="col-12">
              <h2 class="page-title">Add Product</h2>
              
              <div class="row">
        
                <div class="col-md-12">
                  <div class="card shadow mb-4">
                    <div class="card-header">
                      <strong class="card-title">Add Product in bulk</strong>
                        <a href="products.php" class="btn btn-primary float-right ml-3" type="button"><i class="fe fe-arrow-left "></i>Product List</a>

</div>
                    <div class="card-body">
                      <form class="needs-validation" method="POST" enctype="multipart/form-data" novalidate>
                        <?php if(isset($msg)){ echo $msg; } ?>
                        <div class="form-row">
                          
                            <div class="col-md-12 mb-3">
                              <label for="customFile">Product CSV File</label>
                               <div class="custom-file">
                                <input type="file" class="custom-file-input" id="customFile" name="image"   required>
                                <label class="custom-file-label" for="customFile">Choose file</label>
                              </div>
                               
                            </div>
                         
                        </div>
                       
                        <button class="btn btn-primary" name="import" type="submit">Submit form</button>
                      </form>
                    </div> 
                  </div> 
                </div> 
              </div> 
            </div> 
          </div> 
        </div> 
 
      </main>
      
      <script src="https://cdn.ckeditor.com/4.20.0/standard/ckeditor.js"></script>
        
        <script>
                        CKEDITOR.replace( 'editor1' );
                </script>
        <script>
                        CKEDITOR.replace( 'description' );
                </script>
        <script>
                        CKEDITOR.replace( 'specification' );
                </script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addbulk.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation