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/inputdata.in/public_html/bnadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewregistration.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url = basename(__FILE__) . "?" . (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');

// Define your table and columns
$table = "distributors";  // Assuming you're working with the distributors table
$pkey = "did";  // Primary key for distributors (did instead of id)
$status = "status";

// Handle delete action
if (isset($_REQUEST['delete']) && $_REQUEST['delete'] == "yes") {
    mysqli_query($con, "DELETE FROM `".$table."` WHERE `".$pkey."` = '".$_REQUEST['did']."'");
    $_SESSION['msg'] = "Entry is deleted successfully.";
    header("Location:".$_SERVER['PHP_SELF']);
    exit();
}

// Handle status update
if (isset($_REQUEST['status']) && isset($_REQUEST['did'])) {
    $status_value = $_REQUEST['status'];
    $did = $_REQUEST['did']; // Changed from id to did
    // Update status in the database
    mysqli_query($con, "UPDATE `".$table."` SET `status` = '$status_value' WHERE `".$pkey."` = '$did'");
    $_SESSION['msg'] = "Status updated successfully.";
    header("Location:".$_SERVER['PHP_SELF']);
    exit();
}

// Fetch the data from distributors table
$pg = isset($_GET['pg']) ? $_GET['pg'] : 1;

$upper = 25;
$lower = $upper * ($pg - 1);
$sql = "SELECT * FROM `".$table."` WHERE 1";
$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");
?>

function updateStatus(page, did, status) {
    var fd = confirm("Are you sure to update the status?");
    if (fd == true) {
        location.href = page + "?did=" + did + "&status=" + status;
    }
}
</script>

<body>

<div class="page-container">
    
    <?php include("includes/leftmenu.php"); ?>
    
    
    <div class="main-content">
        
        <?php include("includes/header.php"); ?>
        
        <div class="main-content-inner">
            
            <div class="col-lg-12 mt-4">
                <div class="card">
                    <div class="card-body">
                        <h4 class="header-title">List of Distributors</h4>
                        <form action="#" method="post">
                            <div class="form-group">
                                <input class="form-control" type="text" name="name" id="name" value="<?php echo isset($_REQUEST['name']) ? $_REQUEST['name'] : ''; ?>" placeholder="By Distributor Name">
                            </div>
                            <button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
                        </form>
                        <button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
                        <div class="cleaner h20"></div>

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

<?php if (isset($_SESSION['msg']) && $_SESSION['msg']) { ?>
                            <span class="grtxt"><?php echo $_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">Type</td>
                                    <td align="left">Customer Name</td>
                                    <td align="left">Customer Id</td>
                                    <td align="left">Mobile</td>
                                    <td align="left">Email</td>
                                    <td align="left">Area</td>
                                    <td align="left">Password</td>
                                    <td align="left">Status</td>
                                    <td align="left">Options</td>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                if ($lower == 0) {
                                    $flag = 0;
                                } else {
                                    $flag = $lower;
                                }
                                $sql = "SELECT * FROM `".$table."` WHERE 1";
                                if (isset($_REQUEST['name']) && $_REQUEST['name'] != "") {
                                    $sql .= " AND `dhname` LIKE '%".$_REQUEST['name']."%'";
                                }
                                $sql .= " ORDER BY `".$pkey."` DESC LIMIT $lower, $upper";
                                $res = mysqli_query($con, $sql);
                                if (mysqli_num_rows($res) >= 1) {
                                    while ($row = mysqli_fetch_assoc($res)) {
                                ?>
                                        <tr <?php if ($row[$status] == 0) { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
                                            <td align="left"><?php print $flag; ?></td>
                                            <td align="left"><?php print dtconvert($row['date']); ?></td>
                                            <td align="left"><?php print $row['type']; ?></td>
                                            <td align="left"><?php print $row['dhname']; ?></td>
                                            <td align="left"><?php print $row['cusid']; ?></td>
                                            <td align="left"><?php print $row['mobile']; ?></td>
                                            <td align="left"><?php print $row['email']; ?></td>
                                            <td align="left"><?php print $row['area']; ?></td>
                                            <td align="left"><?php print $row['password']; ?></td>
                                            <td align="left">
                                                <?php
                                                    if ($row['status'] == 1) {
                                                        echo 'Approved';
                                                    } elseif ($row['status'] == 0) {
                                                        echo 'Rejected';
                                                    }
                                                ?>
                                            </td>
                                            <td align="left">
                                                
												<?php if ($row['status'] == 1) { // If status is approved ?>
                                                    <a href="javascript:void();" onClick="updateStatus('<?php print basename(__FILE__); ?>', '<?php print $row[$pkey]; ?>', '0');">Reject</a> |
                                                <?php } elseif ($row['status'] == 0) { // If status is rejected ?>
                                                    <a href="javascript:void();" onClick="updateStatus('<?php print basename(__FILE__); ?>', '<?php print $row[$pkey]; ?>', '1');">Approve</a> |
                                                <?php } ?>
                                                <a href="javascript:void();" onClick="del('<?php print basename(__FILE__); ?>', '<?php print $row[$pkey]; ?>');">Delete</a>
                                            </td>
                                        </tr>
                                <?php 
                                    }
                                } else { 
                                ?>
                                    <tr>
                                        <td colspan="20">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>
    
    <?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewregistration.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation