Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/anjal_vaathi/post/admin255

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: questions.php

<?php
require_once 'db/config.php';
require_once 'SimpleExcelReader.php'; // Include the simple reader
session_start();

// CRUD operations for Questions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['add_question'])) {
        $question_text = $conn->real_escape_string($_POST['question_text']);
        $category = $conn->real_escape_string($_POST['category']);
        $subcategory = $conn->real_escape_string($_POST['subcategory']);
        $option_a = $conn->real_escape_string($_POST['option_a']);
        $option_b = $conn->real_escape_string($_POST['option_b']);
        $option_c = $conn->real_escape_string($_POST['option_c']);
        $option_d = $conn->real_escape_string($_POST['option_d']);
        $correct_answer = $conn->real_escape_string($_POST['correct_answer']);
        
        $stmt = $conn->prepare("INSERT INTO questions (question_text, category, subcategory, option_a, option_b, option_c, option_d, correct_answer) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("ssssssss", $question_text, $category, $subcategory, $option_a, $option_b, $option_c, $option_d, $correct_answer);
        $stmt->execute();
        
        $_SESSION['message'] = "Question added successfully";
        $_SESSION['message_type'] = "success";
        header("Location: questions.php");
        exit();
    } elseif (isset($_POST['update_question'])) {
        $id = (int)$_POST['id'];
        $question_text = $conn->real_escape_string($_POST['question_text']);
        $category = $conn->real_escape_string($_POST['category']);
        $subcategory = $conn->real_escape_string($_POST['subcategory']);
        $option_a = $conn->real_escape_string($_POST['option_a']);
        $option_b = $conn->real_escape_string($_POST['option_b']);
        $option_c = $conn->real_escape_string($_POST['option_c']);
        $option_d = $conn->real_escape_string($_POST['option_d']);
        $correct_answer = $conn->real_escape_string($_POST['correct_answer']);
        
        $stmt = $conn->prepare("UPDATE questions SET question_text=?, category=?, subcategory=?, option_a=?, option_b=?, option_c=?, option_d=?, correct_answer=? WHERE id=?");
        $stmt->bind_param("ssssssssi", $question_text, $category, $subcategory, $option_a, $option_b, $option_c, $option_d, $correct_answer, $id);
        $stmt->execute();
        
        $_SESSION['message'] = "Question updated successfully";
        $_SESSION['message_type'] = "success";
        header("Location: questions.php");
        exit();
    } elseif (isset($_POST['delete_question'])) {
        $id = (int)$_POST['id'];
        $stmt = $conn->prepare("DELETE FROM questions WHERE id=?");
        $stmt->bind_param("i", $id);
        $stmt->execute();
        
        $_SESSION['message'] = "Question deleted successfully";
        $_SESSION['message_type'] = "success";
        header("Location: questions.php");
        exit();
    } elseif (isset($_POST['bulk_upload'])) {
        // Handle bulk upload
        if (isset($_FILES['bulk_file']) && $_FILES['bulk_file']['error'] == 0) {
            $file = $_FILES['bulk_file']['tmp_name'];
            $filename = $_FILES['bulk_file']['name'];
            $ext = strtolower(pathinfo($filename, PATHINFO_EXTENSION));
            $imported = 0;
            $errors = [];
            $data = [];
            
            // Handle XLSX files using SimpleExcelReader
            if ($ext == 'xlsx') {
                if (class_exists('ZipArchive')) {
                    $data = SimpleExcelReader::readXLSX($file);
                    if (empty($data)) {
                        $errors[] = "Could not read Excel file. Please ensure it's a valid .xlsx file.";
                    }
                } else {
                    $errors[] = "ZipArchive extension is not enabled. Please use CSV format or contact hosting support.";
                }
            } 
            // Handle XLS files (older format) - provide instructions
            elseif ($ext == 'xls') {
                $errors[] = "Old Excel format (.xls) is not supported. Please open the file in Excel, then save as 'Excel Workbook (.xlsx)' or 'CSV UTF-8' and upload again.";
            }
            // Handle CSV files
            elseif ($ext == 'csv') {
                if (($handle = fopen($file, "r")) !== FALSE) {
                    // Handle UTF-8 BOM
                    $bom = fread($handle, 3);
                    if ($bom != "\xEF\xBB\xBF") {
                        rewind($handle);
                    }
                    
                    while (($row = fgetcsv($handle, 10000, ",")) !== FALSE) {
                        $data[] = $row;
                    }
                    fclose($handle);
                } else {
                    $errors[] = "Could not open the CSV file";
                }
            } else {
                $errors[] = "Unsupported file format. Please upload .xlsx or .csv files.";
            }
            
            // Process the data
            if (!empty($data) && empty($errors)) {
                // Remove header row if it exists (check first row for headers)
                $header = array_shift($data);
                $expectedHeaders = ['Question Text', 'Category', 'Subcategory', 'Option A', 'Option B', 'Option C', 'Option D', 'Correct Answer'];
                
                // Verify header (optional - can skip if not matching)
                $headerValid = true;
                if ($header && count($header) >= 8) {
                    $headerCheck = array_slice($header, 0, 8);
                    $headerValid = true; // Accept any header, we'll just use column positions
                }
                
                $row_number = 1;
                foreach ($data as $row) {
                    $row_number++;
                    
                    // Skip empty rows
                    if (empty(array_filter($row))) continue;
                    
                    // Check if row has at least 8 columns
                    if (count($row) >= 8) {
                        $question_text = $conn->real_escape_string(trim($row[0]));
                        $category = $conn->real_escape_string(trim($row[1]));
                        $subcategory = $conn->real_escape_string(trim($row[2]));
                        $option_a = $conn->real_escape_string(trim($row[3]));
                        $option_b = $conn->real_escape_string(trim($row[4]));
                        $option_c = $conn->real_escape_string(trim($row[5]));
                        $option_d = $conn->real_escape_string(trim($row[6]));
                        $correct_answer = strtoupper(trim($row[7]));
                        
                        // Validate correct answer
                        if (!in_array($correct_answer, ['A', 'B', 'C', 'D'])) {
                            $errors[] = "Row $row_number: Invalid correct answer '$correct_answer'. Must be A, B, C, or D.";
                            continue;
                        }
                        
                        // Check if question text is not empty
                        if (empty($question_text)) {
                            $errors[] = "Row $row_number: Question text is empty.";
                            continue;
                        }
                        
                        // Insert into database
                        $stmt = $conn->prepare("INSERT INTO questions (question_text, category, subcategory, option_a, option_b, option_c, option_d, correct_answer) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
                        $stmt->bind_param("ssssssss", $question_text, $category, $subcategory, $option_a, $option_b, $option_c, $option_d, $correct_answer);
                        
                        if ($stmt->execute()) {
                            $imported++;
                        } else {
                            $errors[] = "Row $row_number: Database error - " . $stmt->error;
                        }
                    } else {
                        $errors[] = "Row $row_number: Invalid format - needs 8 columns, has " . count($row);
                    }
                }
            }
            
            // Set session message
            if ($imported > 0) {
                $_SESSION['message'] = "Successfully imported $imported questions.";
                $_SESSION['message_type'] = "success";
            } else {
                $_SESSION['message'] = "No questions were imported.";
                $_SESSION['message_type'] = "warning";
            }
            
            if (!empty($errors)) {
                $_SESSION['bulk_errors'] = $errors;
                $_SESSION['message'] .= " " . count($errors) . " errors occurred.";
            }
            
            header("Location: questions.php");
            exit();
        } else {
            $error_message = "Please select a file to upload.";
            if ($_FILES['bulk_file']['error'] == UPLOAD_ERR_INI_SIZE || $_FILES['bulk_file']['error'] == UPLOAD_ERR_FORM_SIZE) {
                $error_message = "File is too large. Maximum size is 2MB.";
            } elseif ($_FILES['bulk_file']['error'] == UPLOAD_ERR_NO_FILE) {
                $error_message = "No file was selected.";
            }
            
            $_SESSION['message'] = $error_message;
            $_SESSION['message_type'] = "danger";
            header("Location: questions.php");
            exit();
        }
    }
}

// Fetch all questions
$questions = $conn->query("SELECT * FROM questions ORDER BY category, subcategory");
$categories = $conn->query("SELECT DISTINCT category FROM questions ORDER BY category");
$subcategories = $conn->query("SELECT DISTINCT subcategory FROM questions WHERE subcategory != '' ORDER BY subcategory");
?>

<!doctype html>
<html lang="en">

<?php include('includes/head.php')?>

<div id="layout-wrapper">
    <?php include('includes/topbar.php')?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0 font-size-18">Questions Management</h4>
                            <div class="page-title-right">
                                <button type="button" class="btn btn-primary me-2" data-bs-toggle="modal" data-bs-target="#bulkUploadModal">
                                    <i class="bx bx-upload me-1"></i> Bulk Upload
                                </button>
                                <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#addQuestionModal">
                                    <i class="bx bx-plus me-1"></i> Add New Question
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <?php if (isset($_SESSION['message'])): ?>
                <div class="alert alert-<?= $_SESSION['message_type'] ?? 'success' ?> alert-dismissible fade show" role="alert">
                    <?= $_SESSION['message'] ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
                <?php unset($_SESSION['message'], $_SESSION['message_type']); endif; ?>
                
                
                <?php if (isset($_SESSION['bulk_errors']) && !empty($_SESSION['bulk_errors'])): ?>
                <div class="alert alert-warning alert-dismissible fade show" role="alert">
                    <strong>Errors (<?= count($_SESSION['bulk_errors']) ?>):</strong>
                    <ul class="mb-0 mt-1" style="max-height: 300px; overflow-y: auto;">
                        <?php foreach ($_SESSION['bulk_errors'] as $error): ?>
                        <li><?= htmlspecialchars($error) ?></li>
                        <?php endforeach; ?>
                    </ul>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
                <?php unset($_SESSION['bulk_errors']); endif; ?>
                
                
                <div class="modal fade" id="bulkUploadModal" tabindex="-1">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Bulk Upload Questions</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                            </div>
                            <form method="post" enctype="multipart/form-data">
                                <div class="modal-body">
                                    <div class="mb-3">
                                        <label class="form-label">Upload File</label>
                                        <input type="file" class="form-control" name="bulk_file" accept=".xlsx,.csv" required>
                                        <div class="form-text mt-2">
                                            <strong>Supported formats:</strong> Excel (.xlsx) or CSV (.csv)
                                        </div>
                                    </div>
                                    
                                    <div class="alert alert-info">
                                        <i class="bx bx-info-circle"></i>
                                        <strong>How to prepare your Excel file:</strong>
                                        <ol class="mb-0 mt-2">
                                            <li>Download the sample file below</li>
                                            <li>Open in <strong>Microsoft Excel</strong></li>
                                            <li>Add your questions in the same format</li>
                                            <li>Save as <strong>Excel Workbook (.xlsx)</strong></li>
                                            <li>Upload here</li>
                                        </ol>
                                    </div>
                                    
                                    <div class="alert alert-warning">
                                        <strong>Required Columns (in order):</strong><br>
                                        <code>Question Text | Category | Subcategory | Option A | Option B | Option C | Option D | Correct Answer</code><br>
                                        <small>Correct Answer must be: A, B, C, or D</small>
                                    </div>
                                </div>
                                <div class="modal-footer">
                                    <a href="sample_questions.xlsx" class="btn btn-secondary me-auto" download>
                                        <i class="bx bx-download"></i> Download Sample Excel
                                    </a>
                                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                                    <button type="submit" name="bulk_upload" class="btn btn-primary">Upload & Import</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                
                
                <div class="modal fade" id="addQuestionModal" tabindex="-1">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Add New Question</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                            </div>
                            <form method="post">
                                <div class="modal-body">
                                    <div class="mb-3">
                                        <label class="form-label">Question Text</label>
                                        <textarea class="form-control" name="question_text" rows="3" required></textarea>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6 mb-3">
                                            <label class="form-label">Category</label>
                                            <select class="form-select" name="category" required>
                                                <option value="">Select Category</option>
                                                <?php while($cat = $categories->fetch_assoc()): ?>
                                                <option value="<?= htmlspecialchars($cat['category']) ?>"><?= htmlspecialchars($cat['category']) ?></option>
                                                <?php endwhile; ?>
                                            </select>
                                        </div>
                                        <div class="col-md-6 mb-3">
                                            <label class="form-label">Subcategory</label>
                                            <select class="form-select" name="subcategory">
                                                <option value="">None</option>
                                                <?php 
                                                $subcategories->data_seek(0);
                                                while($subcat = $subcategories->fetch_assoc()): ?>
                                                <option value="<?= htmlspecialchars($subcat['subcategory']) ?>"><?= htmlspecialchars($subcat['subcategory']) ?></option>
                                                <?php endwhile; ?>
                                            </select>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label class="form-label">Options</label>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">A</span>
                                            <input type="text" class="form-control" name="option_a" required>
                                        </div>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">B</span>
                                            <input type="text" class="form-control" name="option_b" required>
                                        </div>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">C</span>
                                            <input type="text" class="form-control" name="option_c" required>
                                        </div>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">D</span>
                                            <input type="text" class="form-control" name="option_d" required>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label class="form-label">Correct Answer</label>
                                        <select class="form-select" name="correct_answer" required>
                                            <option value="A">A</option>
                                            <option value="B">B</option>
                                            <option value="C">C</option>
                                            <option value="D">D</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="modal-footer">
                                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                                    <button type="submit" name="add_question" class="btn btn-primary">Save Question</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                
                
                <div class="modal fade" id="editQuestionModal" tabindex="-1">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Edit Question</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                            </div>
                            <form method="post">
                                <input type="hidden" name="id" id="edit_question_id">
                                <div class="modal-body">
                                    <div class="mb-3">
                                        <label class="form-label">Question Text</label>
                                        <textarea class="form-control" id="edit_question_text" name="question_text" rows="3" required></textarea>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6 mb-3">
                                            <label class="form-label">Category</label>
                                            <select class="form-select" id="edit_category" name="category" required>
                                                <option value="">Select Category</option>
                                                <?php 
                                                $categories->data_seek(0);
                                                while($cat = $categories->fetch_assoc()): ?>
                                                <option value="<?= htmlspecialchars($cat['category']) ?>"><?= htmlspecialchars($cat['category']) ?></option>
                                                <?php endwhile; ?>
                                            </select>
                                        </div>
                                        <div class="col-md-6 mb-3">
                                            <label class="form-label">Subcategory</label>
                                            <select class="form-select" id="edit_subcategory" name="subcategory">
                                                <option value="">None</option>
                                                <?php 
                                                $subcategories->data_seek(0);
                                                while($subcat = $subcategories->fetch_assoc()): ?>
                                                <option value="<?= htmlspecialchars($subcat['subcategory']) ?>"><?= htmlspecialchars($subcat['subcategory']) ?></option>
                                                <?php endwhile; ?>
                                            </select>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label class="form-label">Options</label>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">A</span>
                                            <input type="text" class="form-control" id="edit_option_a" name="option_a" required>
                                        </div>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">B</span>
                                            <input type="text" class="form-control" id="edit_option_b" name="option_b" required>
                                        </div>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">C</span>
                                            <input type="text" class="form-control" id="edit_option_c" name="option_c" required>
                                        </div>
                                        <div class="input-group mb-2">
                                            <span class="input-group-text">D</span>
                                            <input type="text" class="form-control" id="edit_option_d" name="option_d" required>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label class="form-label">Correct Answer</label>
                                        <select class="form-select" id="edit_correct_answer" name="correct_answer" required>
                                            <option value="A">A</option>
                                            <option value="B">B</option>
                                            <option value="C">C</option>
                                            <option value="D">D</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="modal-footer">
                                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                                    <button type="submit" name="update_question" class="btn btn-primary">Update Question</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                
                
                <div class="modal fade" id="deleteQuestionModal" tabindex="-1">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Confirm Deletion</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                            </div>
                            <form method="post">
                                <input type="hidden" name="id" id="delete_question_id">
                                <div class="modal-body">
                                    <p>Are you sure you want to delete this question? This action cannot be undone.</p>
                                </div>
                                <div class="modal-footer">
                                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                                    <button type="submit" name="delete_question" class="btn btn-danger">Delete</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                
                
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title">Questions List</h4>
                                <div class="table-responsive">
                                    <table id="questionsTable" class="table table-bordered dt-responsive nowrap w-100">
                                        <thead class="table-light">
                                            <tr>
                                                <th>ID</th>
                                                <th>Question</th>
                                                <th>Category</th>
                                                <th>Subcategory</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php while($question = $questions->fetch_assoc()): ?>
                                            <tr>
                                                <td><?= $question['id'] ?></td>
                                                <td><?= htmlspecialchars(substr($question['question_text'], 0, 50)) ?>...</td>
                                                <td><?= htmlspecialchars($question['category']) ?></td>
                                                <td><?= htmlspecialchars($question['subcategory']) ?></td>
                                                <td>
                                                    <button class="btn btn-sm btn-outline-primary edit-question me-1" 
                                                            data-id="<?= $question['id'] ?>"
                                                            data-text="<?= htmlspecialchars($question['question_text']) ?>"
                                                            data-category="<?= htmlspecialchars($question['category']) ?>"
                                                            data-subcategory="<?= htmlspecialchars($question['subcategory']) ?>"
                                                            data-option-a="<?= htmlspecialchars($question['option_a']) ?>"
                                                            data-option-b="<?= htmlspecialchars($question['option_b']) ?>"
                                                            data-option-c="<?= htmlspecialchars($question['option_c']) ?>"
                                                            data-option-d="<?= htmlspecialchars($question['option_d']) ?>"
                                                            data-correct="<?= htmlspecialchars($question['correct_answer']) ?>">
                                                        <i class="bx bx-edit-alt"></i> Edit
                                                    </button>
                                                    <button class="btn btn-sm btn-outline-danger delete-question" 
                                                            data-id="<?= $question['id'] ?>">
                                                        <i class="bx bx-trash"></i> Delete
                                                    </button>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <?php include('includes/footer.php')?>
    </div>
</div>

<?php include('includes/rightbar.php')?>
<?php include('includes/scripts.php')?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: questions.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation