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-event-gallery.php

<?php 
session_start();
include('includes/config.php');
error_reporting(0);
if(strlen($_SESSION['login'])==0)
  { 
header('location:index.php');
}
else{

if($_GET['action'] == 'del')
{
    $catid=intval($_GET['cid']);
    $query=mysqli_query($con,"UPDATE event_gallery set delete_status=1 where image_id='$catid'")or die(mysqli_error($con));
    if($query)
    {
        echo "<script>alert('Post successfully deleted');
              window.location.href = 'manage-event-gallery.php';</script>";
        
    }
    else{
        echo "<script>alert('Something went wrong. Please try again');
                window.location.href = 'manage-event-gallery.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="A fully featured admin theme which can be used to build CRM, CMS, etc.">
        <meta name="author" content="Coderthemes">

<link rel="shortcut icon" href="assets/images/favicon.ico">
        
        <title><?php echo $page_title; ?> | Manage Gallery</title>

<?php include('includes/headerfiles.php');?>

</head>

<div id="wrapper">

<?php include('includes/topheader.php');?>

<?php include('includes/leftsidebar.php');?>

<div class="content-page">
                
                <div class="content">
                    <div class="container">

<div class="row">
                            <div class="col-xs-12">
                                <div class="page-title-box">
                                    <h4 class="page-title">Gallery List</h4>
                                    <ol class="breadcrumb p-0 m-0">
                                        <li>
                                            <a href="add-event-gallery.php" class="btn btn-success waves-effect waves-light">Add Event Images</a>
                                        </li>
                                      
                                    </ol>
                                    <div class="clearfix"></div>
                                </div>
                            </div>
                        </div>

<?php if($_SESSION['error']){ ?>
                                    <div class="alert alert-danger" role="alert">
                                        <strong>Oh snap!</strong> <?php echo $_SESSION['error'];?></div>
                                    <?php } 
                                        unset($_SESSION['error']);
                                    ?>
                            </div>
                        </div>

<?php 
                    $limit = ($_GET['limit']) ? $_GET['limit'] : 10;
                    $search = "";

if (isset($_GET["page"])) 
                    {
                        $page = $_GET["page"];
                        $search = $_GET['search'];
                        $search_By = $_GET['search_by'];
                    } 
                    else 
                    {
                        $page = 1;
                    }
                    $start = ($page - 1) * $limit;
                    if(!empty($_GET['search_by']) || !empty($_GET['search']))
                    {
                        $search = $_GET['search'];
                        $search_By = $_GET['search_by'];

$query1=mysqli_query($con,"SELECT event_gallery.*, event_category.event_title, DATE_FORMAT(event_category.event_date, '%d-%M-%Y') as eventDate from event_gallery LEFT JOIN event_category ON event_category.category_id = event_gallery.category_id WHERE event_gallery.delete_status=0 AND $search_By LIKE '%$search%' ORDER BY event_category.event_title, event_gallery.sort_order ASC LIMIT $start, $limit");

$sql1 = $query=mysqli_query($con,"SELECT event_gallery.*, event_category.event_title from event_gallery LEFT JOIN event_category ON event_category.category_id = event_gallery.category_id WHERE event_gallery.delete_status=0 AND $search_By LIKE '%$search%'");
                        $total_rows = mysqli_num_rows($sql1);
                        $total_pages = ceil($total_rows / $limit);
                    }
                    else
                    {
                        $query1=mysqli_query($con,"SELECT event_gallery.*, event_category.event_title, DATE_FORMAT(event_category.event_date, '%d-%M-%Y') as eventDate from event_gallery LEFT JOIN event_category ON event_category.category_id = event_gallery.category_id WHERE event_gallery.delete_status=0 ORDER BY event_category.event_title, event_gallery.sort_order ASC LIMIT $start, $limit");

<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="event_title" <?php echo ($search_By == "event_title") ? 'selected' : ''; ?>>Event Title</option>
                                <option value="image_name" <?php echo ($search_By == "image_name") ? 'selected' : ''; ?>>Image Name</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-event-gallery.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>Event Title</th>
<th>Image Name</th>
<th>Image</th>
<th>Sort Order</th>
<th>Action</th>
</tr>
</thead>
<tbody>

<?php
$i=$start;
if($total_rows==0)
{
?>
<tr>

<td colspan="7" align="center"><h3 style="color:red">No record found</h3></td>
<tr>
<?php 
} else {
while($row=mysqli_fetch_array($query1))
{
    $i++;
?>
 <tr>
<td><b><?php echo $i;?></b></td>
<td><?php echo $row['event_title'];?></td>
<td><?php echo $row['image_name'];?></td>
<td><img src="GalleryImages/<?php echo $row['event_image']; ?>" alt='' title="IMG" style="height: 80px;width: 90px;" /></td>
<td width="90" align="center"><b><?php echo htmlentities($row['sort_order']);?></b></td>

<td width="120">
	<a href="edit-event-gallery.php?id=<?php echo htmlentities($row['image_id']);?>" class="btn btn-warning"><i class="fa fa-pencil" style="color: #000;"></i></a> 
    &nbsp;
    <a class="btn btn-danger" href="manage-event-gallery.php?cid=<?php echo htmlentities($row['image_id']);?>&&action=del" onclick="return confirm('Do you want to delete ?')"> <i class="fa fa-trash-o" style="color: #fff"></i></a> </td>
 </tr>
<?php } }?>
                                               
                                            </tbody>
                                        </table>
                                    </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-event-gallery.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-event-gallery.php?page=$i&search_by=$search_By&search=$search'>$i</a></li>";
                                        }
                                        else
                                        {
                                            echo "<li class='page-item'><a class='page-link' href='manage-event-gallery.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-event-gallery.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>

<?php include('includes/footer.php');?>

</div>

</div>

<?php include('includes/footerfiles.php');?>
    </body>
</html>
<?php } ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-event-gallery.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation