Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/jkma.co.in/public_html

Free Space:

1.93 TB

🔧 Quick Actions

✏️ Editing: excelup.php

<?php
// upload_students.php
// Full single-file uploader + importer using excel_reader.php (php-excel-reader style)

// DB config
$DB_hostname = "localhost";
$DB_username = "u176930106_mittal";
$DB_password = "Mittal#9292";
$DB_dbname   = "u176930106_mittal";
// ---- DB connect ----
$con = new mysqli($DB_hostname, $DB_username, $DB_password, $DB_dbname);
if ($con->connect_error) {
    die("DB connect error: " . $con->connect_error);
}

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

// Helper: convert various Excel date formats to Y-m-d (if you need it)
function dtconverta($excel_date) {
    $excel_date = trim($excel_date);
    if ($excel_date === '') return null;
    // If numeric (Excel serial date)
    if (is_numeric($excel_date)) {
        $unix = ($excel_date - 25569) * 86400;
        return gmdate("Y-m-d", (int)$unix);
    }
    // Try common formats
    $d = DateTime::createFromFormat('d/m/Y', $excel_date);
    if ($d) return $d->format('Y-m-d');
    $d = DateTime::createFromFormat('d-m-Y', $excel_date);
    if ($d) return $d->format('Y-m-d');
    $ts = strtotime($excel_date);
    if ($ts !== false) return date('Y-m-d', $ts);
    return null;
}

// HTML upload form
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    ?>
    <!DOCTYPE html>
    <html>
    <head><meta charset="utf-8"><title>Upload Students Excel</title></head>
    <body>
      <h2>Upload Excel (.xls / .xlsx)</h2>
      <form method="post" enctype="multipart/form-data">
         <select class="form-control" name="class" required>
            <option value="">Select Class
            <?php
            $resc=mysqli_query($con,"select `id`,`class` from `classes` where `status`='1' order by `class`");
            while($rowc=mysqli_fetch_object($resc)) {
            ?>
                <option value="<?php print $rowc->class; ?>"><?php print $rowc->class ?>
            <?php } ?>
        </select>
        <input type="file" name="mexcel" accept=".xls,.xlsx" required>
        <button type="submit">Upload & Import</button>
      </form>
    </body>
    </html>
    <?php
    exit;
}

// ---- Handle upload ----
if (!isset($_FILES['mexcel']) || $_FILES['mexcel']['error'] !== UPLOAD_ERR_OK) {
    die("File upload error. Make sure you selected a file and file size is within limit.");
}

$userfile_name = $_FILES['mexcel']['name'];
$userfile_tmp  = $_FILES['mexcel']['tmp_name'];

$ext = strtolower(pathinfo($userfile_name, PATHINFO_EXTENSION));
if (!in_array($ext, ['xls', 'xlsx'])) {
    die("Please upload a valid Excel file (.xls or .xlsx).");
}

// create docs folder if not exists
$docsDir = __DIR__ . '/docs';
if (!is_dir($docsDir)) {
    if (!mkdir($docsDir, 0755, true)) {
        die("Unable to create docs directory.");
    }
}

$path = time() . "_" . preg_replace('/[^A-Za-z0-9.\-_]/','_', $userfile_name);
$uppath = $docsDir . '/' . $path;

if (!move_uploaded_file($userfile_tmp, $uppath)) {
    die("Failed to move uploaded file.");
}

// ---- Read Excel using excel_reader.php ----
require_once 'excel_reader.php'; // make sure this file exists and defines PhpExcelReader
$excel = new PhpExcelReader();
$excel->read($uppath);

// Sheet check
if (!isset($excel->sheets[0])) {
    die("No sheets found in the uploaded Excel.");
}
$sheet = $excel->sheets[0];
$numRows = isset($sheet['numRows']) ? (int)$sheet['numRows'] : 0;
if ($numRows < 2) {
    die("Excel seems to be empty or only header present.");
}

// ---- detect class from filename e.g. "IX - A" ----
preg_match('/([IVXLC0-9]+ *- *[A-Z0-9]+)/i', $userfile_name, $m);
//$class = isset($m[0]) ? strtoupper(trim($m[0])) : "UNKNOWN";
$class = $_POST['class'];

$con->set_charset('utf8mb4');

// Optional: begin transaction for speed
$con->begin_transaction(MYSQLI_TRANS_START_READ_WRITE);

$inserted = 0;
$errors = [];

// We assume row 1 is header. Start from row 2
for ($r = 2; $r <= $numRows; $r++) {
    // Safe access: excel_reader uses 1-based column indices
    $admno  = isset($sheet['cells'][$r][5])  ? trim($sheet['cells'][$r][5])  : '';
    $rollno = isset($sheet['cells'][$r][6])  ? trim($sheet['cells'][$r][6])  : '';
    $name   = isset($sheet['cells'][$r][7])  ? trim($sheet['cells'][$r][7])  : '';
    $mobile = isset($sheet['cells'][$r][9])  ? trim($sheet['cells'][$r][9])  : '';
    $email  = isset($sheet['cells'][$r][28]) ? trim($sheet['cells'][$r][28]) : '';

// skip blank name rows
    if ($name === '' || strtolower($name) === 'student\'s name' || strtolower($name) === 'name') {
        continue;
    }

// sanitize phone (keep digits only)
    $mobile_digits = preg_replace('/\D+/', '', $mobile);
    if ($mobile_digits === '') $mobile_sql = "NULL"; else $mobile_sql = "'" . $con->real_escape_string($mobile_digits) . "'";

// sanitize email
    $email_sql = ($email === '' ? "NULL" : "'" . $con->real_escape_string($email) . "'");

// sanitize name, admno, rollno, class
    $name_sql  = "'" . $con->real_escape_string($name) . "'";
    $adm_sql   = ($admno === '' ? "NULL" : "'" . $con->real_escape_string($admno) . "'");
    $roll_sql  = ($rollno === '' ? "NULL" : "'" . $con->real_escape_string($rollno) . "'");
    $class_sql = "'" . $con->real_escape_string($class) . "'";

$sql = "INSERT INTO students (name, mobile, email, class, admno, rollno, idno) 
            VALUES ($name_sql, $mobile_sql, $email_sql, $class_sql, $adm_sql, $roll_sql, NULL)";

if ($con->query($sql)) {
        $inserted++;
    } else {
        $errors[] = "Row $r error: " . $con->error;
    }
}

// commit
if (count($errors) === 0) {
    $con->commit();
} else {
    // you can choose to commit partial inserts or rollback - here we commit and report errors
    $con->commit();
    // $con->rollback();
}

$con->close();

// Output result
echo "<h3>Import result</h3>";
echo "<p>File processed: <b>" . htmlspecialchars($userfile_name) . "</b></p>";
echo "<p>Detected class: <b>" . htmlspecialchars($class) . "</b></p>";
echo "<p>Rows inserted: <b>$inserted</b></p>";

if (!empty($errors)) {
    echo "<h4>Errors (" . count($errors) . ")</h4><ul>";
    foreach ($errors as $e) {
        echo "<li>" . htmlspecialchars($e) . "</li>";
    }
    echo "</ul>";
}

echo "<p><a href=\"excelup.php\">Upload another file</a></p>";
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: excelup.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation