Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.111.1.lve.el8.x86_64

PHP Version:

7.4.33

User:

creativebazzar

Directory:

/home/creativebazzar/www/admin-pages

Free Space:

30.83 GB

🔧 Quick Actions

✏️ Editing: update-news-meta.php

<?php include('site-header.php'); ?>
<?php include('left-nevigation.php'); ?>
<main id="playground">
  <?php include('site-top-header.php'); ?>

<?php 
$image_name = isset($_FILES['banner_image_name']['name']) ? $_FILES['banner_image_name']['name'] : ''; 
$image_names = time() . "_" . $image_name;
$himage = isset($_REQUEST['himage']) ? $_REQUEST['himage'] : '';
$msg = "";
?>

<?php
// Ensure database connection is working
if (!$link) {
    die("<p style='color:red;'>Database connection failed: " . mysqli_connect_error() . "</p>");
}

if (isset($_REQUEST['Insert'])) {
    $banner_name = isset($_POST['banner_name']) ? mysqli_real_escape_string($link, $_POST['banner_name']) : '';

if (is_uploaded_file($_FILES['banner_image_name']['tmp_name'])) {
        // Handle file upload
        $sql_Up = "INSERT INTO `tbl_banner`(`banner_image_name`, `banner_name`, `banner_type`) 
                   VALUES ('$image_names', '$banner_name', '72')";
        if (mysqli_query($link, $sql_Up)) {
            move_uploaded_file($_FILES['banner_image_name']['tmp_name'], "../header-image/" . $image_names);
            $msg = "<p style='color:green;'>Saved Meta Successfully !</p>";
        } else {
            $msg = "<p style='color:red;'>Error inserting: " . mysqli_error($link) . "</p>";
        }
    } else {
        // Handle text-only insert
        $sql_Up = "INSERT INTO `tbl_banner`(`banner_name`, `banner_type`) 
                   VALUES ('$banner_name', '72')";
        if (mysqli_query($link, $sql_Up)) {
            $msg = "<p style='color:green;'>Saved Meta Name Successfully!</p>";
        } else {
            $msg = "<p style='color:red;'>Error inserting: " . mysqli_error($link) . "</p>";
        }
    }
}

if (isset($_REQUEST['Updt'])) {
    extract($_POST);
    if ($_FILES['banner_image_name']['name'] !== "") {
        $sql_up_ing = "UPDATE `tbl_banner` SET 
                            `banner_name`='$banner_name',
                            `banner_decs`='$banner_decs',
                            `banner_image_name`='$image_names',
                            `banner_link`='$banner_link'
                        WHERE banner_id='$img_id'";
        if (mysqli_query($link, $sql_up_ing)) {
            unlink("../header-image/$himage");
            move_uploaded_file($_FILES['banner_image_name']['tmp_name'], "../header-image/" . $image_names);
            $msg = "<p style='color:green;'>Updated Successfully!</p>";
        } else {
            $msg = "<p style='color:red;'>Error updating: " . mysqli_error($link) . "</p>";
        }
    } else {
        $sql_up_ing = "UPDATE `tbl_banner` SET 
                            `banner_name`='$banner_name',
                            `banner_decs`='$banner_decs',
                            `banner_link`='$banner_link'
                        WHERE banner_id='$img_id'";
        if (mysqli_query($link, $sql_up_ing)) {
            $msg = "<p style='color:orange;'>Updated Successfully !</p>";
        } else {
            $msg = "<p style='color:red;'>Error updating: " . mysqli_error($link) . "</p>";
        }
    }
}

if (isset($_REQUEST['del_banner_id']) && $_REQUEST['del_banner_id'] != "") {
    $del_banner_id = $_REQUEST['del_banner_id'];
    $sql = "DELETE FROM tbl_banner WHERE banner_id='$del_banner_id'";
    if (mysqli_query($link, $sql)) {
        unlink("../header-image/$himage");
        $msg = "<p style='color:red;'>Deleted Successfully!</p>";
    } else {
        $msg = "<p style='color:red;'>Error deleting: " . mysqli_error($link) . "</p>";
    }
}

// Fetch banners with banner_type = 69
$sql = "SELECT * FROM `tbl_banner` WHERE `banner_type`='72'";
$data = mysqli_query($link, $sql);
$count = mysqli_num_rows($data);

if (!$data) {
    $msg .= "<p style='color:red;'>Error fetching data: " . mysqli_error($link) . "</p>";
}
?>

<section id="page-title" class="row">
  <div class="col-md-8">
    <h1>News Meta Title, Meta Description, Meta Keywords</h1>
    <?= $msg; ?>
  </div>
  <div class="col-md-4">
    <ol class="breadcrumb pull-right no-margin-bottom">
      <li><a href="dashboard.php">Dashboard</a></li>
      <li class="active">Update News Meta Title, Meta Description, Meta Keywords</li>
    </ol>
  </div>
</section>

<div class="container-fluid">
  <div class="row">
    <?php while ($result = mysqli_fetch_array($data)) { ?>
      <form enctype="multipart/form-data" method="post">
        <div class="col-md-4">
          <label>Meta Title</label>
          <input type="text" name="banner_name" placeholder="Meta Title" class="form-control" value="<?= $result['banner_name']; ?>" required>
          <label>Meta Description</label>
          <input type="text" name="banner_link" placeholder="Meta Keywords" class="form-control" value="<?= $result['banner_link']; ?>"> 
          <label>Meta Keywords</label>
          <input type="text" name="banner_decs" placeholder="Meta Description" class="form-control" value="<?= $result['banner_decs']; ?>"> 
          <input type="hidden" name="img_id" value="<?= $result['banner_id']; ?>">
          <input type="hidden" name="himage" value="<?= $result['banner_image_name']; ?>">
          <div class="text-center"><button class="btn btn-primary" name="Updt" style="width:100%;">Update</button></div>
        </div>
      </form>
    <?php } ?>
  </div>
</div>

<?php if ($count < 1) { ?>
<div class="container-fluid" style="margin-top:80px;">
  <div class="row">
    <div class="col-md-4"></div>
    <form method="post" enctype="multipart/form-data">
      <div class="col-md-4">
        <input type="text" name="banner_name" placeholder="Meta Title" class="form-control" required>
        <div class="text-center"><button type="submit" name="Insert" class="btn btn-primary" style="width:100%;">Add</button></div>
      </div>
    </form>
    <div class="col-md-4"></div>
  </div>
</div>
<?php } ?>
<?php include('site-footer.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update-news-meta.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation