Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache/2

System:

Linux 5.15.0-161-generic

PHP Version:

8.1.32

User:

myvacationholi

Directory:

/home/myvacationholi/domains/myvacationholidays.in/private_html/admin

Free Space:

14.04 GB

🔧 Quick Actions

✏️ Editing: all-blogs.php

<?php
include 'config.php';

// Fetch all blog posts from the database
 $query = "SELECT * FROM blog_posts ORDER BY created_at DESC";
 $result = $conn->query($query);

// Delete blog action
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    
    // Now delete the blog record
    $deleteQuery = "DELETE FROM blog_posts WHERE id = ?";
    $deleteStmt = $conn->prepare($deleteQuery);
    $deleteStmt->bind_param('i', $delete_id);

if ($deleteStmt->execute()) {
        echo "<script>alert('Blog post deleted successfully!'); window.location.href='all-blogs.php';</script>";
    } else {
        echo "<script>alert('Error deleting blog post.'); window.location.href='all-blogs.php';</script>";
    }
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
   <title>All Blogs</title>

<link href="https://fonts.googleapis.com/css?family=Ubuntu:400,500,700" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/icon/themify-icons/themify-icons.css">

<link rel="stylesheet" type="text/css" href="assets/icon/icofont/css/icofont.css">

<link rel="stylesheet" type="text/css" href="assets/icon/simple-line-icons/css/simple-line-icons.css">

<link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap/css/bootstrap.min.css">

<link rel="stylesheet" type="text/css" href="assets/css/main.css">

<link rel="stylesheet" type="text/css" href="assets/css/responsive.css">
   
   <style>
      .blog-title {
        max-width: 300px;
        white-space: nowrap;
        overflow: hidden;
        text-overflow: ellipsis;
      }
      .blog-content {
        max-width: 400px;
        max-height: 60px;
        overflow: hidden;
        text-overflow: ellipsis;
      }
      .blog-image {
        max-width: 100px;
        max-height: 60px;
        object-fit: cover;
      }
   </style>
</head>

<div class="content-wrapper">
         <div class="container-fluid">
            <div class="row">
               <div class="main-header">
                  <h4>All Blogs</h4>
               </div>
            </div>

<div class="row">
               <div class="col-sm-12">
                  <div class="card">
                     <div class="card-header d-flex justify-content-between align-items-center">
                        <h5>Blog Posts</h5>
                        <a href="add-blog.php" class="btn btn-primary">
                           <i class="icofont icofont-plus"></i> Add New Blog
                        </a>
                     </div>
                     <div class="card-block">
                        <div class="table-responsive">
                           <table class="table table-bordered table-striped">
                              <thead>
                                 <tr>
                                    <th>#</th>
                                    <th>Title</th>
                                    <th>Content</th>
                                    <th>Image</th>
                                    <th>Created At</th>
                                    <th>Actions</th>
                                 </tr>
                              </thead>
                              <tbody>
                                 <?php
                                 if ($result->num_rows > 0) {
                                    $count = 1;
                                    while ($row = $result->fetch_assoc()) {
                                       // Strip HTML tags for content preview
                                       $contentPreview = strip_tags($row['content']);
                                       if (strlen($contentPreview) > 100) {
                                           $contentPreview = substr($contentPreview, 0, 100) . '...';
                                       }
                                       
                                       echo "<tr>";
                                       echo "<td>" . $count++ . "</td>";
                                       echo "<td class='blog-title' title='" . htmlspecialchars($row['title']) . "'>" . htmlspecialchars($row['title']) . "</td>";
                                       echo "<td class='blog-content' title='" . htmlspecialchars($contentPreview) . "'>" . $contentPreview . "</td>";
                                       echo "<td>";
                                       if (!empty($row['image_url'])) {
                                           echo "<img src='" . htmlspecialchars($row['image_url']) . "' alt='Blog Image' class='blog-image'>";
                                       } else {
                                           echo "No Image";
                                       }
                                       echo "</td>";
                                       echo "<td>" . date('M d, Y', strtotime($row['created_at'])) . "</td>";
                                       echo "<td>
                                                <a href='edit_blog.php?id=" . $row['id'] . "' class='btn btn-primary btn-sm'>
                                                    <i class='icofont icofont-edit'></i> Edit
                                                </a>
                                                <a href='all-blogs.php?delete_id=" . $row['id'] . "' class='btn btn-danger btn-sm' onclick=\"return confirm('Are you sure you want to delete this blog post?');\">
                                                    <i class='icofont icofont-trash'></i> Delete
                                                </a>
                                             </td>";
                                       echo "</tr>";
                                    }
                                 } else {
                                    echo "<tr><td colspan='6' class='text-center'>No blog posts found</td></tr>";
                                 }
                                 ?>
                              </tbody>
                           </table>
                        </div>
                     </div>
                  </div>
               </div>
            </div>
         </div>
      </div>
   </div>

<script src="assets/plugins/Jquery/dist/jquery.min.js"></script>
    <script src="assets/plugins/jquery-ui/jquery-ui.min.js"></script>
    <script src="assets/plugins/tether/dist/js/tether.min.js"></script>

<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>

<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.js"></script>
    <script src="assets/plugins/jquery.nicescroll/jquery.nicescroll.min.js"></script>

<script src="assets/plugins/classie/classie.js"></script>

<script src="assets/plugins/notification/js/bootstrap-growl.min.js"></script>

<script type="text/javascript" src="assets/js/main.min.js"></script>
    <script type="text/javascript" src="assets/pages/dashboard.js"></script>
    <script type="text/javascript" src="assets/pages/elements.js"></script>
    <script src="assets/js/menu.min.js"></script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: all-blogs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation