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

<?php
ob_start();
session_start();
include("includes/inall.php");
$url = basename(__FILE__) . "?" . (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');
$heading = "Pratice Test Paper";
$addpage = "addtestacdm.php";
$listpage = "viewtestsacdm.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`='Practice'";
if (isset($_REQUEST['name']) && $_REQUEST['name'] != "") {
    $sql .= " and `tp_name` like '%" . $_REQUEST['name'] . "%'";
}

if (!empty($_REQUEST['subject'])) {
    $sql .= " and `tp_subject`='" . intval($_REQUEST['subject']) . "'";
}
$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">
                                    <div class="form-group col-md-4">
                                        
                                        <input class="form-control" type="text" name="name" id="name" value="<?php print $_REQUEST['name']; ?>" placeholder="By Set Name">
                                    </div>
                                    <div class="form-group col-md-4">
                                        <select class="form-control" name="subject" id="subject">
                                            <option value="">-- Select Subject --</option>
                                            <?php
                                            $subres = mysqli_query($con, "SELECT * FROM `subjectacdms` ORDER BY name ASC");

while ($sub = mysqli_fetch_assoc($subres)) { ?>
                                                <option value="<?php echo $sub['id']; ?>"
                                                    <?php if (isset($_REQUEST['subject']) && $_REQUEST['subject'] == $sub['id']) echo "selected"; ?>>
                                                    <?php echo htmlspecialchars($sub['name']); ?>
                                                </option>
                                            <?php } ?>
                                        </select>
                                    </div>

<div class="form-group col-md-4">
                                        <button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
                                        <button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft"
                                            onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
                                    </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`='Practice'";
                                        if (isset($_REQUEST['name']) && $_REQUEST['name'] != "") {
                                            $sql .= " and `tp_name` like '%" . $_REQUEST['name'] . "%'";
                                        }

if (!empty($_REQUEST['subject'])) {
                                            $sql .= " and `tp_subject`='" . intval($_REQUEST['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)) {
                                                $rowc = mysqli_fetch_array(mysqli_query($con, "select * from `categories` where `id`='" . $row['tp_type'] . "'"));
                                                $course_ids = explode(',', $row['tp_type']); // array of selected IDs
                                                $course_names = [];
                                                if (!empty($course_ids)) {
                                                    $ids_str = implode(',', array_map('intval', $course_ids)); // sanitize
                                                    $res_courses = mysqli_query($con, "SELECT `name` FROM `categories` WHERE `id` IN ($ids_str)");
                                                    while ($rc = mysqli_fetch_assoc($res_courses)) {
                                                        $course_names[] = $rc['name'];
                                                    }
                                                }

$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);
                                                }

$rowc_names = implode(', ', $course_names); // final string of course names
                                                $subjectNames = '';
                                                if (!empty($row['tp_subject'])) {
                                                    $subject_ids = $row['tp_subject']; // e.g. "1,3,5"
                                                    $sub_names = [];
                                                    $res_subs = mysqli_query($con, "SELECT name FROM subjectacdms WHERE id IN ($subject_ids)");
                                                    while ($sub = mysqli_fetch_assoc($res_subs)) {
                                                        $sub_names[] = $sub['name'];
                                                    }
                                                    $subjectNames = implode(', ', $sub_names);
                                                }
                                                $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($subjectNames); ?><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>Deactivation 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 Excel</a><br><?php } ?>
                                                        <a href="javascript:void();" data-toggle="modal" data-target="#exampleModalLong<?php print $flag; ?>">Details</a>
                                                        <br><a href="viewqtysmacdm.php?tid=<?php echo $row['tp_id']; ?>">List Qtys</a>
                                                        <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 `eduquestionacdms` where `tref`='" . $row['tp_id'] . "'";
                                                                            $resq = mysqli_query($con, $sqlq);
                                                                            while ($rowq = mysqli_fetch_assoc($resq)) {
                                                                                // Show description if exists
                                                                                if (!empty(trim($rowq['description']))) {
                                                                            ?>
                                                                        <div style="text-align:center; font-weight:bold; margin-bottom:10px;">
                                                                            <?php print stripslashes($rowq['description']); ?>
                                                                        </div>
                                                                    <?php
                                                                                }
                                                                    ?>
                                                                    <span style="
        display:inline-block;
        width:20px;
        height:20px;
        line-height:20px;
        text-align:center;
        background-color:orange;
        color:white;
        border-radius:50%;
        font-weight:bold;
        margin-right:5px;
    ">
                                                                        <?php print $count++; ?>
                                                                    </span>&nbsp;<?php print stripslashes(stripslashes($rowq['question'])); ?><br>
                                                                    1. <?php print stripslashes(stripslashes($rowq['answer1'])); ?><br>
                                                                    2. <?php print stripslashes(stripslashes($rowq['answer2'])); ?><br>
                                                                    3. <?php print stripslashes(stripslashes($rowq['answer3'])); ?><br>
                                                                    4. <?php print stripslashes(stripslashes($rowq['answer4'])); ?><br>
                                                                    <strong>Marks: <?php print stripslashes(stripslashes($rowq['marks'])); ?></strong><br>
                                                                    <strong>N Marks: <?php print stripslashes(stripslashes($rowq['nmarks'])); ?></strong><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>
                                                    </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>
    
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewtestsacdm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation