/home/hdwebsolution/www/ns-interior/admin-pages/update-about-meta.php
<?php include('site-header.php'); ?>
<!-- end of LOGO CONTAINER -->
<!-- - - - - - - - - - - - - -->
<!-- start of SIDEBAR -->
<!-- - - - - - - - - - - - - -->
<?php include('left-nevigation.php'); ?>
<!-- - - - - - - - - - - - - -->
<!-- end of SIDEBAR -->
<!-- - - - - - - - - - - - - -->
<main id="playground">
<!-- - - - - - - - - - - - - -->
<!-- start of TOP NAVIGATION -->
<!-- - - - - - - - - - - - - -->
<?php include('site-top-header.php'); ?>
<!-- - - - - - - - - - - - - -->
<!-- end of TOP NAVIGATION -->
<!-- - - - - - - - - - - - - -->
<!-- PAGE TITLE -->
<?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>
<section>
<div class="container">
<div class="row">
<div class="col-lg-12"></div>
</div>
</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>
<!--<form method="post">-->
<!-- <input type="hidden" name="del_banner_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="del" style="width:100%;">Delete</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'); ?>
<script type="text/javascript">
$(document).ready(function() {
$('textarea').each(function() {
$(this).val($(this).val().trim());
});
});
</script>