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/udan.org.in/public_htmlbkp/webadmin

Free Space:

1.92 TB

🔧 Quick Actions

✏️ Editing: aadpp.php

<?php
ob_start();
session_start();
include("includes/inall.php");

// === FORM SUBMISSION (Save / Update) ===
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['submitin'])) {
    $tp_id = intval($_POST['tp_type']);
    $num_sections = intval($_POST['num_sections']);
    $section_q = $_POST['section_q'] ?? [];
    $section_m = $_POST['section_m'] ?? [];
    $section_n = $_POST['section_n'] ?? [];
    $qid = $_POST['qid'] ?? [];
    $ranswer = $_POST['ranswer'] ?? [];
    $qmarks = $_POST['qmarks'] ?? [];
    $qnmarks = $_POST['qnmarks'] ?? [];

if ($tp_id <= 0) {
        $_SESSION['msgerr'] = "Please select a valid test paper.";
        header("Location: " . $_SERVER['PHP_SELF']);
        exit;
    }

// --- PDF Upload ---
    if (!empty($_FILES['pdf_file']['name'])) {
        $pdf_name = time() . '_' . basename($_FILES['pdf_file']['name']);
        move_uploaded_file($_FILES['pdf_file']['tmp_name'], "uploads/" . $pdf_name);
        mysqli_query($con, "UPDATE edutestpaper SET tp_excel='" . mysqli_real_escape_string($con, $pdf_name) . "' WHERE tp_id=$tp_id");
    }

// --- Fetch existing sections ---
    $existing_sections = [];
    $sec_res = mysqli_query($con, "SELECT * FROM test_sections WHERE tp_id=$tp_id ORDER BY section_id ASC");
    while ($row = mysqli_fetch_assoc($sec_res)) {
        $existing_sections[] = $row;
    }

$section_ids = [];
    $q_global_index = 1;

// --- Process Sections ---
    for ($i = 0; $i < $num_sections; $i++) {
        $total_input = intval($section_q[$i] ?? 0); // user input
        $marks = floatval($section_m[$i] ?? 0);
        $nmarks = floatval($section_n[$i] ?? 0);

if (isset($existing_sections[$i])) {
            // Update section
            $section_id = $existing_sections[$i]['section_id'];
            $existing_noq = intval($existing_sections[$i]['no_of_questions']);

mysqli_query($con, "UPDATE test_sections 
                                SET no_of_questions=$total_input, marks=$marks, neg_marks=$nmarks 
                                WHERE section_id=$section_id");
        } else {
            // Insert new section
            mysqli_query($con, "INSERT INTO test_sections 
                                (tp_id, section_name, no_of_questions, marks, neg_marks) 
                                VALUES ($tp_id, 'Section " . ($i + 1) . "', $total_input, $marks, $nmarks)");
            $section_id = mysqli_insert_id($con);
        }

$section_ids[] = $section_id;

// --- Questions for this section ---
        $existing_qids = [];
        // fetch existing questions for section
        $qa_res = mysqli_query($con, "SELECT * FROM eduquestion WHERE tref=$tp_id AND section_id=$section_id ORDER BY qtyorder ASC");
        while ($qa_row = mysqli_fetch_assoc($qa_res)) {
            $existing_qids[] = $qa_row;
        }

$existing_count = count($existing_qids);
        for ($j = 0; $j < $total_input; $j++) {
            $question_id = intval($qid[$q_global_index] ?? 0);
            $answer = trim($ranswer[$q_global_index] ?? '');
            $qmarks_val = floatval($qmarks[$q_global_index] ?? $marks);
            $qnmarks_val = floatval($qnmarks[$q_global_index] ?? $nmarks);

if (isset($existing_qids[$j])) {
                // Update existing question
                $qid_db = $existing_qids[$j]['question_id'];
                mysqli_query($con, "UPDATE eduquestion SET 
                                    answerrightopt='" . mysqli_real_escape_string($con, $answer) . "',
                                    marks=$qmarks_val,
                                    nmarks=$qnmarks_val,
                                    qtyorder=$q_global_index,
                                    section_id=$section_id
                                    WHERE question_id=$qid_db");
            } elseif ($answer != '') {
                // Insert new question (for additional input)
                mysqli_query($con, "INSERT INTO eduquestion 
                                    (tref, qtyorder, answerrightopt, marks, nmarks, section_id)
                                    VALUES ($tp_id, $q_global_index, '" . mysqli_real_escape_string($con, $answer) . "', $qmarks_val, $qnmarks_val, $section_id)");
            }

$q_global_index++;
        }
    }

$_SESSION['msg'] = "Test paper sections and answers saved successfully!";
    header("Location: " . $_SERVER['PHP_SELF'] . "?tp_id=$tp_id");
    exit;
}

// === AJAX: Fetch existing answers and sections dynamically ===
if (isset($_POST['action']) && $_POST['action'] === 'fetch_answers') {
    $tp_id_ajax = intval($_POST['tp_id'] ?? 0);
    $response = ['answers' => [], 'sections' => [], 'total_questions' => 0, 'pdf' => ''];

if ($tp_id_ajax > 0) {
        $tp_res = mysqli_query($con, "SELECT tp_noques, tp_excel FROM edutestpaper WHERE tp_id=$tp_id_ajax LIMIT 1");
        if ($tp_row = mysqli_fetch_assoc($tp_res)) {
            $response['total_questions'] = intval($tp_row['tp_noques']);
            $response['pdf'] = $tp_row['tp_excel'];
        }

$sec_res = mysqli_query($con, "SELECT * FROM test_sections WHERE tp_id=$tp_id_ajax ORDER BY section_id ASC");
        while ($sec_row = mysqli_fetch_assoc($sec_res)) {
            $response['sections'][] = [
                'section_id' => intval($sec_row['section_id']),
                'section_name' => $sec_row['section_name'],
                'no_of_questions' => intval($sec_row['no_of_questions']),
                'marks' => floatval($sec_row['marks']),
                'neg_marks' => floatval($sec_row['neg_marks'])
            ];
        }

$qa_res = mysqli_query($con, "SELECT * FROM eduquestion WHERE tref=$tp_id_ajax ORDER BY qtyorder ASC");
        while ($qa_row = mysqli_fetch_assoc($qa_res)) {
            $sec_id = intval($qa_row['section_id']);
            if (!isset($response['answers'][$sec_id])) $response['answers'][$sec_id] = [];
            $response['answers'][$sec_id][] = [
                'question_id' => intval($qa_row['question_id']),
                'answer' => $qa_row['answerrightopt'],
                'marks' => floatval($qa_row['marks']),
                'nmarks' => floatval($qa_row['nmarks'])
            ];
        }
    }

header('Content-Type: application/json');
    echo json_encode($response);
    exit;
}

// === Normal Page Load ===
$tp_id = intval($_GET['tp_id'] ?? 0);
$total_questions = 0;
$existing_pdf = '';

if ($tp_id > 0) {
    $tp_res = mysqli_query($con, "SELECT tp_noques, tp_excel FROM edutestpaper WHERE tp_id=$tp_id LIMIT 1");
    if ($tp_row = mysqli_fetch_assoc($tp_res)) {
        $total_questions = intval($tp_row['tp_noques']);
        $existing_pdf = $tp_row['tp_excel'];
    }
}

include("includes/headermain.php");
?>

<body>
    <div class="page-container">
        <?php include("includes/leftmenu.php"); ?>
        <div class="main-content">
            <?php include("includes/header.php"); ?>
            <div class="main-content-innera">
                <div class="col-lg-12 mt-5">
                    <div class="card shadow-sm border-0">
                        <div class="card-body">
                            <h4 class="header-title mb-4">Upload / Edit Test Paper</h4>

<?php if (!empty($_SESSION['msg'])): ?>
                                <div class="alert alert-success"><?php echo $_SESSION['msg'];
                                                                    $_SESSION['msg'] = ''; ?></div>
                            <?php endif; ?>
                            <?php if (!empty($_SESSION['msgerr'])): ?>
                                <div class="alert alert-danger"><?php echo $_SESSION['msgerr'];
                                                                $_SESSION['msgerr'] = ''; ?></div>
                            <?php endif; ?>

<div class="row">
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label">*Select Test Paper</label>
                                        <select class="form-control form-select" name="tp_type" id="tp_type" required>
                                            <option value="">Select</option>
                                            <?php
                                            $res = mysqli_query($con, "SELECT e.*, s.name AS subject_name FROM edutestpaper e 
                                        LEFT JOIN subjectacdms s ON s.id = e.tp_subject 
                                        WHERE e.tp_st = '1'");
                                            while ($row = mysqli_fetch_assoc($res)) {
                                                $class_ids = array_filter(array_map('trim', explode(',', $row['tp_class'])));
                                                $class_names = [];
                                                if (!empty($class_ids)) {
                                                    $ids_str = implode(',', array_map('intval', $class_ids));
                                                    $res_classes = mysqli_query($con, "SELECT `name` FROM `acdmclass` WHERE `id` IN ($ids_str)");
                                                    while ($rc = mysqli_fetch_assoc($res_classes)) $class_names[] = $rc['name'];
                                                }
                                                $row_class_names = implode(', ', $class_names);
                                                echo "<option value='" . intval($row['tp_id']) . "'" . ($row['tp_id'] == $tp_id ? " selected" : "") . ">" .
                                                    htmlspecialchars($row_class_names . ' - ' . $row['subject_name'] . ' - ' . $row['tp_lan'] . ' - ' . $row['tp_name']) .
                                                    "</option>";
                                            }
                                            ?>
                                        </select>
                                    </div>

<div class="col-md-4 mb-3">
                                        <label class="form-label">*Upload PDF</label>
                                        <input type="file" class="form-control" name="pdf_file" accept="application/pdf">
                                        <div id="pdf_info" class="mt-2">
                                            <?php if ($existing_pdf): ?>
                                                Existing PDF: <a href="uploads/<?php echo htmlspecialchars($existing_pdf); ?>" target="_blank"><?php echo htmlspecialchars($existing_pdf); ?></a>
                                            <?php endif; ?>
                                        </div>
                                    </div>

<div class="col-md-4 mb-3">
                                        <label class="form-label">Number of Sections:</label>
                                        <input type="number" name="num_sections" id="num_sections" class="form-control" max="20" value="1">
                                    </div>
                                </div>

<div id="sections_area" class="mb-3"></div>
                                <div class="mb-2">
                                    Total Questions in Sections: <strong id="total_section_q">0</strong> / <strong id="total_questions"><?php echo intval($total_questions); ?></strong>
                                </div>
                                <div id="questions_area"></div>

</div>
                    </div>
                </div>
            </div>

<?php include("includes/footer.php"); ?>
        </div>
    </div>

$(document).on('change', '#tp_type', function() {
                var tp_id = $(this).val();
                if (!tp_id) return;

$.post('', {
                    action: 'fetch_answers',
                    tp_id: tp_id
                }, function(response) {
                    if (response) {
                        totalQuestions = response.total_questions || null;
                        $('#total_questions').text(totalQuestions ? totalQuestions : 'Not Have Any Limit Seted');
                        existing_sections = response.sections || [];
                        existing_answers = response.answers || [];

$('#num_sections').val(existing_sections.length || 1);
                        generateSections(existing_sections.length || 1);
                    }
                }, 'json');
            });

function updateSectionTotal() {
                var total = 0;
                $('.section_q').each(function() {
                    var val = parseInt($(this).val()) || 0;
                    total += val;
                });
                $('#total_section_q').text(total);
                return total;
            }

function generateSections(num) {
                $('#sections_area').empty();
                var remaining = totalQuestions;

$('.section_q').each(function() { // recalc remaining
                    remaining -= parseInt($(this).val()) || 0;
                });

for (var i = 0; i < num; i++) {
                    var s = existing_sections[i] || {};
                    var q = s.no_of_questions || 0;
                    var m = s.marks || 0;
                    var n = s.neg_marks || 0;
                    var sec_id = s.section_id || 0;

// prevent exceeding total questions
                    if (totalQuestions && q > remaining) q = remaining;

$('#sections_area').append(`
<div class="section_div mb-3" data-idx="${i+1}" data-section-id="${sec_id}">
    <h5>Section ${i+1} <button type="button" class="btn btn-sm btn-danger remove-section"><i class="fa fa-trash"></i></button></h5>
    <div class="row g-2">
        <div class="col-md-4">
            <label>Number of Questions:</label>
            <input type="number" class="form-control section_q" name="section_q[${i}]" value="${q}" min="0" ${totalQuestions ? 'max="'+remaining+'"' : ''}>
        </div>
        <div class="col-md-4">
            <label>Marks per Question:</label>
            <input type="number" class="form-control section_m_input" name="section_m[${i}]" value="${m}" step="0.01">
        </div>
        <div class="col-md-4">
            <label>Negative Marks per Question:</label>
            <input type="number" class="form-control section_n_input" name="section_n[${i}]" value="${n}" step="0.01">
        </div>
    </div>
</div>`);
                }

updateSectionTotal();
                generateQuestions();
            }

function generateQuestions() {
                $('#questions_area').empty();
                var q_global_index = 1;

$('.section_div').each(function() {
                    var $section = $(this);
                    var sec_idx = $section.data('idx');
                    var sec_id = $section.data('section-id');
                    var count = parseInt($section.find('.section_q').val()) || 0;
                    var marks = parseFloat($section.find('.section_m_input').val()) || 0;
                    var nmarks = parseFloat($section.find('.section_n_input').val()) || 0;
                    if (count <= 0) return;

var html = `<h5>Section ${sec_idx} Questions</h5><div class="row">`;
                    var section_answers = existing_answers[sec_id] || [];

for (var i = 0; i < count; i++) {
                        var ansData = section_answers[i] || {};
                        html += `<div class="col-md-3 mb-2">
<input type="hidden" name="qid[${q_global_index}]" value="${ansData.question_id||0}">
<label>Q${i+1} Answer</label>
<select class="form-control form-select" name="ranswer[${q_global_index}]">
<option value="">Select</option>
${[1,2,3,4].map(o=>`<option value="Option ${o}" ${ansData.answer==='Option '+o?'selected':''}>Option ${o}</option>`).join('')}
</select>
<input type="hidden" name="qmarks[${q_global_index}]" value="${ansData.marks!==undefined?ansData.marks:marks}">
<input type="hidden" name="qnmarks[${q_global_index}]" value="${ansData.nmarks!==undefined?ansData.nmarks:nmarks}">
</div>`;
                        q_global_index++;
                    }

html += '</div>';
                    $('#questions_area').append(html);
                });

updateSectionTotal();
            }

$(document).on('input change', '#num_sections', function() {
                var num = parseInt($(this).val()) || 1;
                generateSections(num);
            });

$(document).on('input change', '.section_q', function() {
                var total = updateSectionTotal();
                var val = parseInt($(this).val()) || 0;
                var max_val = parseInt($(this).attr('max')) || totalQuestions;

if (total > totalQuestions) {
                    alert("⚠️ Total questions cannot exceed test paper limit (" + totalQuestions + ")");
                    $(this).val(max_val - (total - val));
                    updateSectionTotal();
                }

generateQuestions();
            });

$(document).on('input change', '.section_m_input, .section_n_input', function() {
                generateQuestions();
            });

$(document).on('click', '.remove-section', function() {
                $(this).closest('.section_div').remove();
                updateSectionTotal();
                generateQuestions();
            });

var initialSections = parseInt($('#num_sections').val());
            if (initialSections) generateSections(initialSections);
        });
    </script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: aadpp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation