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

<?php
ob_start();
session_start();
include("includes/inall.php");
$url = basename(__FILE__) . "?" . (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');
$heading = "Mock Test Paper";
$addpage = "addtestmacdm.php";
$listpage = "viewtestsmacdm.php";
$table = "edutestpaperacdms";
$tablea = "eduquestionacdms";
$pkey = "tp_id";
$status = "tp_st";
if (isset($_REQUEST['delete']) && $_REQUEST['delete'] == "yes") {
    mysqli_query($con, "delete from `" . $table . "` where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
    mysqli_query($con, "delete from `" . $tablea . "` where `tref`='" . $_REQUEST['id'] . "'");
    $_SESSION['msg'] = "Entry is deleted successfully.";
    header("Location:" . $listpage);
    exit();
}
if (isset($_REQUEST['approve']) && $_REQUEST['approve'] == "yes") {
    $d = date("Y-m-d");
    mysqli_query($con, "update `" . $table . "` set `" . $status . "`='1' where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
    $got = "go" . $_REQUEST['got'];
    $_SESSION['msg'] = $heading . " is approved successfully.";
    header("Location:" . $listpage . "#" . $got);
    exit();
}
if (isset($_REQUEST['reject']) && $_REQUEST['reject'] == "yes") {
    mysqli_query($con, "update `" . $table . "` set `" . $status . "`='0' where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
    $got = "go" . $_REQUEST['got'];
    $_SESSION['msg'] = $heading . " is rejected successfully.";
    header("Location:" . $listpage . "#" . $got);
    exit();
}
if ($_GET['pg']) {
    $pg = $_GET['pg'];
} else {
    $pg = 1;
}
$upper = 25;
$lower = $upper * ($pg - 1);
$sql = "SELECT * FROM `" . $table . "` WHERE `tp_mcmn`='Mock'";

if (!empty($_REQUEST['name'])) {
    $sql .= " AND `tp_name` LIKE '%" . mysqli_real_escape_string($con, $_REQUEST['name']) . "%'";
}

if (!empty($_REQUEST['course'])) {
    $course_id = intval($_REQUEST['course']);
    $sql .= " AND FIND_IN_SET($course_id, tp_class)";
}

if (!empty($_REQUEST['subject'])) {
    $subject_id = intval($_REQUEST['subject']);
    $sql .= " AND FIND_IN_SET($subject_id, tp_subject)";
}

$sql .= " ORDER BY `tp_cdate` DESC LIMIT $lower,$upper";
$res = mysqli_query($con, $sql);

$num = mysqli_num_rows($res);
$pgno = intval($num / $upper);
if ($num % $upper != 0) {
    $pgno = $pgno + 1;
}
include("includes/headermain.php");
?>
<script language="javascript" type="text/javascript">
    function del(page, id) {
        var fd = confirm("Are you sure to delete this entry?");
        if (fd == true) {
            location.href = page + "?id=" + id + "&delete=yes";
        }
    }

function approve(page, id, got) {
        location.href = page + "?id=" + id + "&got=" + got + "&approve=yes";
    }

function reject(page, id, got) {
        location.href = page + "?id=" + id + "&got=" + got + "&reject=yes";
    }
</script>
<style>
    #name,
    #subject {
        height: 45px;
        /* same height */
        line-height: 45px;
    }
</style>

<body>
    
    
    <div id="preloader">
        <div class="loader"></div>
    </div>
    
    
    <div class="page-container">
        
        <?php include("includes/leftmenu.php"); ?>
        
        
        <div class="main-content">
            
            <?php include("includes/header.php"); ?>
            
            <div class="main-content-inner">
                
                <div> 
                    <div class="col-lg-12 mt-4">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="header-title">List of <?php print $heading; ?>(s)</h4>
                                <form action="#" method="post" class="row">
                                    <style>
                                        .equal-field {
                                            height: 40px !important;
                                        }
                                    </style>

<div class="form-group col-md-3">
                                        <label><b>By Set Name</b></label>
                                        <input class="form-control equal-field" type="text" name="name" id="name"
                                            value="<?php echo isset($_REQUEST['name']) ? $_REQUEST['name'] : ''; ?>"
                                            placeholder="Enter Set Name">
                                    </div>

<div class="form-group col-md-3">
                                        <label><b>Course</b></label>
                                        <select class="form-control equal-field" name="course" id="course">
                                            <option value="">-- Select Course --</option>
                                            <?php
                                            $courseResult = mysqli_query($con, "SELECT id, name FROM acdmclass ORDER BY name ASC");
                                            while ($row = mysqli_fetch_assoc($courseResult)) { ?>
                                                <option value="<?= $row['id']; ?>">
                                                    <?= $row['name']; ?>
                                                </option>
                                            <?php } ?>
                                        </select>
                                    </div>

<div class="form-group col-md-3">
                                        <label><b>Subject</b></label>
                                        <select class="form-control equal-field" name="subject" id="subject">
                                            <option value="">-- Select Subject --</option>
                                        </select>
                                    </div>

<div class="form-group col-md-3">
                                        <label><b>&nbsp;</b></label> 
                                        <div class="d-flex">
                                            <button type="submit" class="btn btn-primary equal-field w-50 mr-2">
                                                Search
                                            </button>
                                            <button type="button" class="btn btn-secondary equal-field w-50"
                                                onClick="showall('<?php print basename(__FILE__); ?>');">
                                                Show All
                                            </button>
                                        </div>
                                    </div>

</form>

<div class="cleaner h20"></div>
                                <?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 } ?>
                                <table class="table text-center">
                                    <thead class="text-uppercase bg-primary">
                                        <tr class="text-white">
                                            <td align="left">Sl.</td>
                                            <td align="left">Date</td>
                                            <td align="left">Language</td>
                                            <td align="left">Details</td>
                                            <td align="left">Downlaod</td>
                                            <td align="left">Added By</td>
                                            <td align="left">Options</td>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        if ($lower == 0) {
                                            $flag = 0;
                                        } else {
                                            $flag = $lower;
                                        }
                                        $sql = "select * from `" . $table . "` where `tp_mcmn`='Mock'";

if (!empty($_REQUEST['name'])) {
                                            $sql .= " and `tp_name` like '%" . mysqli_real_escape_string($con, $_REQUEST['name']) . "%'";
                                        }

if (!empty($_REQUEST['subject'])) {
                                            $subject_id = intval($_REQUEST['subject']);
                                            $sql .= " AND FIND_IN_SET($subject_id, tp_subject)";
                                        }

$sql .= " order by `tp_cdate` desc limit $lower,$upper";

//print $sql;
                                        $res = mysqli_query($con, $sql);
                                        if (mysqli_num_rows($res) >= 1) {
                                            while ($row = mysqli_fetch_assoc($res)) {
                                                $className = '';
                                                if (!empty($row['tp_class'])) {
                                                    $class_ids = $row['tp_class']; // e.g. "1,2,3"
                                                    $class_names = [];
                                                    $res_classes = mysqli_query($con, "SELECT name FROM acdmclass WHERE id IN ($class_ids)");
                                                    while ($cls = mysqli_fetch_assoc($res_classes)) {
                                                        $class_names[] = $cls['name'];
                                                    }
                                                    $className = implode(', ', $class_names);
                                                }
                                                $subject = '';
                                                if (!empty($row['tp_subject'])) {
                                                    $subject_ids = $row['tp_subject']; // e.g. "1,2,3"
                                                    $subject_names = [];
                                                    $res_subject = mysqli_query($con, "SELECT name FROM subjectacdms WHERE id IN ($subject_ids)");
                                                    while ($sub = mysqli_fetch_assoc($res_subject)) {
                                                        $subject_names[] = $sub['name'];
                                                    }
                                                    $subjectName = implode(', ', $subject_names);
                                                }

$rowc_names = implode(', ', $course_names);
                                                $rowc = mysqli_fetch_array(mysqli_query($con, "select * from `categories` where `id`='" . $row['tp_type'] . "'"));
                                                $rows = mysqli_fetch_array(mysqli_query($con, "select * from `subjectacdms` where `id`='" . $row['tp_subject'] . "'"));
                                                $numc = mysqli_num_rows(mysqli_query($con, "select * from `eduquestionacdms` where `tref`='" . $row['tp_id'] . "'"));
                                        ?>
                                                <tr <?php if ($row[$status] == "0") { ?>class="bg-red" <?php } ?> id="go<?php print $flag++; ?>">
                                                    <td align="left"><?php print $flag; ?></td>
                                                    <td class="light_text" align="left"><?php echo dtconvert($row['tp_cdate']); ?></td>
                                                    <td class="light_text" align="left"><?php echo $row['tp_lan']; ?></td>
                                                    <td class="light_text" align="left">
                                                        <strong>Class:</strong>&nbsp;<?php echo htmlspecialchars($className); ?><br>
                                                        
                                                        <strong>Subject:</strong>&nbsp;<?php echo htmlspecialchars($subjectName); ?><br>
                                                        <strong>Set Name:</strong>&nbsp;<?php echo $row['tp_name']; ?><br>
                                                        <strong>Qtys:</strong>&nbsp;<?php echo $numc; ?><br>
                                                        <strong>Marks:</strong>&nbsp;<?php echo $row['tp_tmarks']; ?><br>
                                                        <strong>Time:</strong>&nbsp;<?php echo $row['tp_emin']; ?> Mins<br>
                                                        <strong>Order:</strong>&nbsp;<?php echo $row['tp_ord']; ?><br>
                                                        <?php if ($row['tp_dedate'] != "0000-00-00") { ?><strong>Live Date:</strong>&nbsp;<?php echo dtconvert($row['tp_dedate']); ?><?php } ?>
                                                    </td>
                                                    <td class="light_text" align="left">
                                                        <?php if ($row['tp_excel'] != "") { ?>
                                                            <a href="docs/<?php echo $row['tp_excel']; ?>" target="_blank">Download Pdf</a><br>
                                                            <?php /* ?><a href="javascript:void();" data-toggle="modal" data-target="#exampleModalLong<?php print $flag; ?>">Details</a><?php */ ?>
                                                            <a href="viewqtysmpdfacdm.php?tid=<?php echo $row['tp_id']; ?>">List Qtys</a>
                                                        <?php } else { ?>
                                                            <?php if ($row['tp_cdate'] >= "2025-08-09") { ?>
                                                                <a href="viewqtysmckacdm.php?tid=<?php echo $row['tp_id']; ?>">List Qtys</a>
                                                            <?php } else { ?>
                                                                <a href="viewqtysmacdm.php?tid=<?php echo $row['tp_id']; ?>">List Qtys</a>
                                                            <?php } ?>
                                                        <?php } ?>

<?php /* ?><div class="modal fade" id="exampleModalLong<?php print $flag; ?>">
														<div class="modal-dialog">
															<div class="modal-content">
																<div class="modal-header">
																	<h5 class="modal-title">Details</h5>
																	<button type="button" class="close" data-dismiss="modal"><span>&times;</span></button>
																</div>
															  	<div class="modal-body">
																	<p>
																		<?php
																		$count=1;
																		$sqlq="select * from `eduquestion` where `tref`='".$row['tp_id']."'";
																		$resq=mysqli_query($con,$sqlq);
																		while($rowq=mysqli_fetch_assoc($resq)) {
																		?>
																			<?php print $count++; ?><br><?php print stripslashes(stripslashes($rowq['question'])); ?><br>
																			<?php if($row['qty_image']!="") { ?><a href="../qimages/<?php echo $row['qty_image']; ?>" target="_blank">View Qty Image</a><br><?php } ?>
																			1. <?php print stripslashes(stripslashes($rowq['answer1'])); ?><br>
																			<?php if($row['answer1_image']!="") { ?><a href="../qimages/<?php echo $row['answer1_image']; ?>" target="_blank">View Ans 1 Image</a><br><?php } ?>
																			2. <?php print stripslashes(stripslashes($rowq['answer2'])); ?><br>
																			<?php if($row['answer2_image']!="") { ?><a href="../qimages/<?php echo $row['answer2_image']; ?>" target="_blank">View Ans 2 Image</a><br><?php } ?>
																			3. <?php print stripslashes(stripslashes($rowq['answer3'])); ?><br>
																			<?php if($row['answer3_image']!="") { ?><a href="../qimages/<?php echo $row['answer3_image']; ?>" target="_blank">View Ans 3 Image</a><br><?php } ?>
																			4. <?php print stripslashes(stripslashes($rowq['answer4'])); ?><br>
																			<?php if($row['answer4_image']!="") { ?><a href="../qimages/<?php echo $row['answer4_image']; ?>" target="_blank">View Ans 4 answer4_image</a><br><?php } ?>
																			<strong>Right: <?php print stripslashes(stripslashes($rowq['answerright'])); ?></strong><br>
																			<strong>Marks: <?php print stripslashes(stripslashes($rowq['marks'])); ?><br><br>
																		<?php } ?>
																	</p>
																</div>
																<div class="modal-footer">
																	<button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
																	
																</div>
															</div>
														</div>
													</div><?php */ ?>
                                                    </td>
                                                    <td align="left">
                                                        <?php
                                                        // Fetch admin record for created_by ID
                                                        $admin = mysqli_fetch_assoc(mysqli_query($con, "SELECT username, type, ref FROM `admin` WHERE id='" . $row['created_by'] . "'"));

if ($admin['type'] == "user") {
                                                            // If admin type is 'user', fetch name from users table using ref
                                                            $user = mysqli_fetch_assoc(mysqli_query($con, "SELECT name FROM `users` WHERE id='" . $admin['ref'] . "'"));
                                                            echo htmlspecialchars($user['name']);
                                                        } else {
                                                            // Otherwise, just show admin username
                                                            echo htmlspecialchars($admin['username']);
                                                        }
                                                        ?>
                                                    </td>
                                                    <td align="left">
                                                        <?php if ($_SESSION['logtype'] == "superadmin" || $_SESSION['logtype'] == "user") { ?>
                                                            <a href="<?php print $addpage; ?>?eid=<?php print $row[$pkey]; ?>&action=Update&name=<?php print $_REQUEST['name']; ?>&flag=<?php print $flag; ?>">Edit</a>&nbsp;
                                                            <?php
                                                            /*<a href="#" onClick="del('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>');return false;">Delete</a>*/
                                                            ?>
                                                            <?php if ($row[$status] == "1") { ?>
                                                                <br><a href="#" onClick="reject('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>');return false;">Deactivate</a>
                                                            <?php } else { ?>
                                                                <br><a href="#" class="redtxt" onClick="approve('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>');return false;">Activate</a>
                                                            <?php } ?>
                                                        <?php } ?>
                                                    </td>
                                                </tr>
                                            <?php }
                                        } else { ?>
                                            <tr>
                                                <td colspan="15">Sorry, nothing found.</td>
                                            </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>
                                <?php if ($num >= 1) { ?>
                                    <div class="cleaner h20"></div>
                                    
                                    <?php include("includes/pagination.php"); ?>
                                    
                                <?php } ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
        </div>
        
        <?php include("includes/footer.php"); ?>
    </div>
    <script>
        var courseSubjects = {};

var allSubjects = [];

// ✅ Load mappings from PHP
        <?php
        $mappingQuery = mysqli_query($con, "
    SELECT 
        e.tp_class,
        s.id AS subject_id,
        s.name
    FROM edutestpaperacdms e
    JOIN subjectacdms s ON FIND_IN_SET(s.id, e.tp_subject)
    ORDER BY s.name ASC
");

$allSubjectsList = [];

while ($row = mysqli_fetch_assoc($mappingQuery)) {
            $subject_id = $row['subject_id'];
            $subject_name = addslashes($row['name']);

// ✅ All Subjects array for default view
            $allSubjectsList[$subject_id] = $subject_name;

$courseIds = explode(",", $row['tp_class']);
            foreach ($courseIds as $cid) {
                $cid = trim($cid);
                echo "courseSubjects['$cid'] = courseSubjects['$cid'] || []; 
              courseSubjects['$cid'].push({
                  id: '{$row['subject_id']}',
                  name: '{$row['name']}'
              });";
            }
        }
        ?>

// ✅ Convert PHP array to JS
        allSubjects = <?php echo json_encode($allSubjectsList); ?>;

// ✅ Populate subject dropdown
        function loadSubjects(subjects) {
            var subjectDropdown = document.getElementById("subject");
            subjectDropdown.innerHTML = '<option value="">-- Select Subject --</option>';

for (var id in subjects) {
                subjectDropdown.innerHTML += `<option value="${id}">${subjects[id]}</option>`;
            }
        }

// ✅ Initial: show all subjects
        document.addEventListener("DOMContentLoaded", function() {
            document.getElementById("subject").disabled = false;
            loadSubjects(allSubjects);
        });

// ✅ On course change
        document.getElementById("course").addEventListener("change", function() {
            var courseId = this.value;

if (courseId && courseSubjects[courseId]) {
                document.getElementById("subject").disabled = false;

let subMap = {};
                courseSubjects[courseId].forEach(function(sub) {
                    subMap[sub.id] = sub.name;
                });

loadSubjects(subMap);

} else {
                // ✅ If no course selected → show ALL subjects
                document.getElementById("subject").disabled = false;
                loadSubjects(allSubjects);
            }
        });
    </script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewtestsmacdm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation