Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/novanexus.in/public_html/test/admin

Free Space:

4.11 TB

🔧 Quick Actions

✏️ Editing: manage-reach-academy.php

<?php 
session_start();
include('includes/config.php');
error_reporting(0);

if(strlen($_SESSION['login']) == 0) { 
    header('location:index.php');
} else {
    // Set limit and search parameters
    $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 10;
    $search = isset($_GET['search']) ? mysqli_real_escape_string($con, $_GET['search']) : '';
    $search_By = isset($_GET['search_by']) ? mysqli_real_escape_string($con, $_GET['search_by']) : '';

// Pagination logic
    $page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
    $start = ($page - 1) * $limit;

// Validate and sanitize 'search_by' parameter
    $allowed_columns = ['name', 'email', 'phone_number'];
    if (!in_array($search_By, $allowed_columns)) {
        $search_By = ''; // Default to empty if invalid
    }

// Construct the query based on search criteria
    if (!empty($search_By) && !empty($search)) {
        // Apply search condition
        $query = mysqli_query($con, "SELECT * FROM reach_academy WHERE delete_status=0 AND $search_By LIKE '%$search%' ORDER BY Reach_id DESC LIMIT $start, $limit");
    } else {
        // No search, show all
        $query = mysqli_query($con, "SELECT * FROM reach_academy WHERE delete_status=0 ORDER BY Reach_id DESC LIMIT $start, $limit");
    }

// Check query success
    if (!$query) {
        die('Query Error: ' . mysqli_error($con));
    }

// Get total records for pagination
    if (!empty($search_By) && !empty($search)) {
        $sql = mysqli_query($con, "SELECT * FROM reach_academy WHERE delete_status=0 AND $search_By LIKE '%$search%'");
    } else {
        $sql = mysqli_query($con, "SELECT * FROM reach_academy WHERE delete_status=0");
    }
    $total_rows = mysqli_num_rows($sql);
    $total_pages = ceil($total_rows / $limit);

// Deleting records
    if ($_GET['action'] == 'del') {
        $Reaid = intval($_GET['Rid']);
        $query = mysqli_query($con, "UPDATE reach_academy SET delete_status = 1 WHERE Reach_id='$Reaid'");

if ($query) {
            echo "<script>alert('Record successfully deleted');
                  window.location.href = 'manage-reach-academy.php';</script>";
        } else {
            echo "<script>alert('Something went wrong: " . mysqli_error($con) . "');
                  window.location.href = 'manage-reach-academy.php';</script>";
        }
    }
    else if($_GET['action'] == 'status') {
        $tid=intval($_GET['tid']);
        $val=intval($_GET['val']);
        $value = ($val == 1) ? 0 : 1;

$query=mysqli_query($con,"UPDATE reach_academy set status_id='$value' where Reach_id='$tid'")or die(mysqli_error($con));
        if($query) {
            echo "<script>alert('Successfully updated');
                  window.location.href = 'manage-reach-academy.php';</script>";
        } else {
            echo "<script>alert('Something went wrong. Please try again');
                  window.location.href = 'manage-reach-academy.php';</script>";    
        }
    }
?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="Manage Reach Academy">
        <meta name="author" content="Coderthemes">
        <link rel="shortcut icon" href="assets/images/favicon.ico">
        <title>Manage Reach Academy</title>
        <?php include('includes/headerfiles.php'); ?>
    </head>

<div class="row">
                            <div class="col-sm-12">
                                <div class="page-title-box">
                                    <h4 class="page-title">Manage Reach Academy</h4>
                                    <ol class="breadcrumb p-0 m-0">
                                        <li>
                                            <a href="add-reach-academy.php" class="btn btn-success waves-effect waves-light">Add Category</a>
                                        </li>
                                    </ol>
                                    <div class="clearfix"></div>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-sm-12">
                                <div class="card-box">
                                    
                                    <form method="get" id="manage-form">
                                        <select name="search_by" class="form-control">
                                            <option value="">Search By</option>
                                            <option value="name" <?php echo ($search_By == "name") ? 'selected' : ''; ?>>Name</option>
                                            <option value="email" <?php echo ($search_By == "email") ? 'selected' : ''; ?>>Email</option>
                                            <option value="phone_number" <?php echo ($search_By == "phone_number") ? 'selected' : ''; ?>>Phone Number</option>
                                        </select>
                                        <input type="text" name="search" class="form-control" placeholder="search here" value="<?php echo $search; ?>">
                                        <button type="submit" class="btn btn-primary btn-sm fa fa-filter mt-3"></button>
                                        <a href="manage-reach-academy.php" class="btn btn-light btn-sm fa mt-3">&#xf021;</a>
                                        <select class="form-control" name="limit">
                                            <option value="10" <?php echo ($limit == "10") ? 'selected' : ''; ?>>10</option>
                                            <option value="50" <?php echo ($limit == "50") ? 'selected' : ''; ?>>50</option>
                                            <option value="100" <?php echo ($limit == "100") ? 'selected' : ''; ?>>100</option>
                                        </select>
                                    </form>
                                    
                                    
                                    <div class="table-responsive">
                                        <table class="table table-colored table-centered table-inverse m-0">
                                            <thead>
                                                <tr>
                                                    <th>S.No</th>
                                                    <th>Name</th>
                                                    <th>Phone Number</th>
                                                    <th>Email</th>
                                                    <th>Location</th>
                                                    <th>City</th>
                                                    <th>Address</th>
                                                    <th>Image</th>
                                                    <th>Thumb Image</th>
                                                    <th>Status</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                if (mysqli_num_rows($query) == 0) {
                                                ?>
                                                <tr>
                                                    <td colspan="6" align="center">
                                                        <h3 style="color:red">No record found</h3>
                                                    </td>
                                                </tr>
                                                <?php 
                                                } else {
                                                    $i = 0;
                                                    while($row = mysqli_fetch_array($query)) {
                                                        $i++;
                                                ?>
                                                <tr>
                                                    <td><b><?php echo $i; ?></b></td>
                                                    <td><?php echo htmlentities($row['name']); ?></td>
                                                    <td><?php echo htmlentities($row['phone_number']); ?></td>
                                                    <td><?php echo htmlentities($row['email']); ?></td>
                                                    <td><?php echo htmlentities($row['location']); ?></td>
                                                    <td><?php echo htmlentities($row['city']); ?></td>
                                                    <td><?php echo htmlentities($row['address']); ?></td>
                                                    <td>
                                                        <img src="addreachacademy/<?php echo $row['photo']; ?>" alt='' title="IMG" style="height: 80px;width: 90px;" />
                                                    </td>
                                                    <td>
                                                        <img src="addreachacademy/thumbnails/<?php echo $row['thumbnails']; ?>" alt="" title="IMG" style="height: 80px;width: 90px;" />
                                                    </td>

<td>
                                                    <a href="manage-reach-academy.php?tid=<?php echo intval($row['Reach_id']); ?>&action=status&val=<?php echo intval($row['status_id']); ?>" 
   onclick="return confirm('Do you want to update the status?')" 
   class="btn <?php echo ($row['status_id'] == 1) ? 'btn-success' : 'btn-danger'; ?>">
   <?php echo ($row['status_id'] == 1) ? 'Enable' : 'Disable'; ?>
</a>

</td>
                                                    <td>
                                                        <a href="edit-reach-academy.php?id=<?php echo htmlentities($row['Reach_id']); ?>" class="btn btn-warning">
                                                            <i class="fa fa-pencil" style="color: #000;"></i></a>
                                                            &nbsp;
                                                            <a href="manage-reach-academy.php?Rid=<?php echo htmlentities($row['Reach_id']); ?>&action=del" 
                                                                onclick="return confirm('Are you sure you want to delete this record?')" 
                                                                class="btn btn-danger">
                                                            <i class="fa fa-trash" style="color: #fff;"></i>
                                                            </a>
                                                    </td>
                                                </tr>
                                                <?php } } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div aria-label="Page navigation">
                            <ul class="pagination" id="page">
                                <li class="page-item">
                                    <?php 
                                        if($page > 1)
                                        { 
                                            $prev_page = $page - 1;
                                    ?>
                                        <a class="page-link" href="manage-reach-academy.php?page=<?php echo $prev_page ?>&search=<?php echo $search; ?>" aria-label="Previous">
                                        <span aria-hidden="true">&laquo;</span>
                                        <span class="sr-only">Previous</span>
                                        </a>
                                    <?php
                                        }
                                    ?>
                                </li>
                                <?php
                                    if($page == 1)
                                    {
                                        $c = 2;
                                    }
                                    else
                                    {
                                        $c = 1;
                                    }
                                    for($i = max(1, $page - 1); $i <= min($page + $c, $total_pages); $i++)
                                    {
                                        if($i == $page)
                                        {
                                            echo "<li class='page-item active'><a class='page-link' href='manage-reach-academy.php?page=$i&search_by=$search_By&search=$search'>$i</a></li>";
                                        }
                                        else
                                        {
                                            echo "<li class='page-item'><a class='page-link' href='manage-reach-academy.php?page=$i&search_by=$search_By&search=$search'>$i</a></li>";
                                        }
                                    }

if ($page < $total_pages) 
                                    {
                                        $next_page = $page + 1;
                                ?>
                                    <li class="page-item">
                                    <a class="page-link" href="manage-reach-academy.php?page=<?php echo $next_page; ?>&search=<?php echo $search; ?>" aria-label="Next">
                                    <span aria-hidden="true">&raquo;</span>
                                    <span class="sr-only">Next</span>
                                    </a>
                                    </li>
                                <?php } ?>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <?php include('includes/footer.php'); }?>
        <?php include('includes/footerfiles.php'); ?>
    </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-reach-academy.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation