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/public_html/admin-pages

Free Space:

30.84 GB

🔧 Quick Actions

✏️ Editing: update-about-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
if (isset($_REQUEST['Insert'])) {
    // Debugging output
    echo "<br>";

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

// Check if a file is uploaded
    if (is_uploaded_file($_FILES['banner_image_name']['tmp_name'])) {
        $sql_Up = "INSERT INTO `tbl_banner`(`banner_image_name`, `banner_name`, `banner_type`) 
                   VALUES ('$image_names', '$banner_name', '67')";
        if (mysqli_query($link, $sql_Up)) {
            move_uploaded_file($_FILES['banner_image_name']['tmp_name'], "../header-image/" . $image_names);
            $msg = "<p style='color:green;'>Save Meta Successfully !!!</p>";
        } else {
            $msg = "<p style='color:red;'>Error: " . mysqli_error($link) . "</p>";
        }
    } else {
        // If no file uploaded, allow saving only `banner_name`
        $sql_Up = "INSERT INTO `tbl_banner`(`banner_name`, `banner_type`) 
                   VALUES ('$banner_name', '67')";
        if (mysqli_query($link, $sql_Up)) {
            $msg = "<p style='color:green;'>Save Meta Name Successfully!!!</p>";
        } else {
            $msg = "<p style='color:red;'>Error: " . 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;'>Update Successfully!!!</p>";
        } else {
            $msg = "<p style='color:red;'>Error: " . 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;'>Update Successfully!!!</p>";
        } else {
            $msg = "<p style='color:red;'>Error: " . 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;'>Delete Successfully!!!</p>";
    } else {
        $msg = "<p style='color:red;'>Error: " . mysqli_error($link) . "</p>";
    }
}

$sql = "SELECT * FROM `tbl_banner` WHERE `banner_type`='67' limit 1";
$data = mysqli_query($link, $sql);
$count = mysqli_num_rows($data);
?>
<section id="page-title" class="row">
  <div class="col-md-8">
    <h1>About 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 About 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>
        </form>
        
        
        
        
        
      </div>
    <?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>
        <br>
       
        <br>
        <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-about-meta.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation