Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/public_html/website_6ca89795/admin/ |
Upload File : |
<?php
include('../dbcon.php');
include('header.php');
include('function.php');
// Fetch data
if (isset($_GET['sid'])) {
$id = mysqli_real_escape_string($conn, $_GET['sid']);
$sql = "SELECT * FROM project WHERE id='$id'";
$run = mysqli_query($conn, $sql);
$blog = mysqli_fetch_assoc($run);
if (!$blog) {
echo '<script>alert("Data not found"); window.location="bloglist.php";</script>';
exit;
}
} else {
echo '<script>alert("Invalid Request"); window.location="bloglist.php";</script>';
exit;
}
?>
<div class="container">
<h2>Update Blog</h2>
<script src="https://cdn.ckeditor.com/4.16.2/standard/ckeditor.js"></script>
<form method="post" enctype="multipart/form-data">
<input type="hidden" name="sid" value="<?php echo $id; ?>">
<div class="form-group">
<label>Title</label>
<input type="text" name="title" class="form-control"
value="<?php echo htmlspecialchars($blog['title']); ?>" required>
</div>
<div class="form-group">
<label>Author Name</label>
<input type="text" name="submenu" class="form-control"
value="<?php echo htmlspecialchars($blog['submenu']); ?>">
</div>
<div class="form-group">
<label>Page Title</label>
<input type="text" name="page_title" class="form-control"
value="<?php echo htmlspecialchars($blog['page_title']); ?>">
</div>
<div class="form-group">
<label>Description</label>
<input type="text" name="description" class="form-control"
value="<?php echo htmlspecialchars($blog['description']); ?>">
</div>
<div class="form-group">
<label>Keywords</label>
<input type="text" name="keywords" class="form-control"
value="<?php echo htmlspecialchars($blog['keywords']); ?>">
</div>
<div class="form-group">
<label>Robots</label>
<input type="text" name="robots" class="form-control"
value="<?php echo htmlspecialchars($blog['robots']); ?>">
</div>
<div class="form-group">
<label>Canonical</label>
<input type="text" name="canonical" class="form-control"
value="<?php echo htmlspecialchars($blog['canonical']); ?>">
</div>
<div class="form-group">
<label>Content</label>
<textarea name="subtitle1" id="subtitle1"><?php echo htmlspecialchars($blog['subtitle1']); ?></textarea>
</div>
<!-- MAIN IMAGE -->
<div class="form-group">
<label>Current Image</label><br>
<img src="dataimg/<?php echo $blog['image']; ?>" width="120">
</div>
<div class="form-group">
<label>New Image</label>
<input type="file" name="image">
</div>
<!-- DETAIL IMAGE -->
<div class="form-group">
<label>Current Detail Image</label><br>
<img src="dataimg/<?php echo $blog['detailimage']; ?>" width="120">
</div>
<div class="form-group">
<label>New Detail Image</label>
<input type="file" name="detailimage">
</div>
<br>
<button type="submit" name="submit" class="btn btn-primary">Update</button>
</form>
<script>
CKEDITOR.replace('subtitle1');
</script>
</div>
<?php
// ================= UPDATE LOGIC =================
if (isset($_POST['submit'])) {
$id = mysqli_real_escape_string($conn, $_POST['sid']);
$title = mysqli_real_escape_string($conn, $_POST['title']);
$submenu = mysqli_real_escape_string($conn, $_POST['submenu']);
$page_title = mysqli_real_escape_string($conn, $_POST['page_title']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$keywords = mysqli_real_escape_string($conn, $_POST['keywords']);
$robots = mysqli_real_escape_string($conn, $_POST['robots']);
$canonical = mysqli_real_escape_string($conn, $_POST['canonical']);
$subtitle1 = mysqli_real_escape_string($conn, $_POST['subtitle1']);
$titleslug = slug($title);
// FILES
$image = $_FILES['image']['name'];
$tmp = $_FILES['image']['tmp_name'];
$detailimage = $_FILES['detailimage']['name'];
$tmp2 = $_FILES['detailimage']['tmp_name'];
// OLD VALUES
$imageName = $blog['image'];
$detailImageName = $blog['detailimage'];
// MAIN IMAGE UPDATE
if (!empty($image)) {
$imageName = time() . '_img_' . $image;
if (!empty($blog['image']) && file_exists("dataimg/" . $blog['image'])) {
unlink("dataimg/" . $blog['image']);
}
move_uploaded_file($tmp, "dataimg/$imageName");
}
// DETAIL IMAGE UPDATE
if (!empty($detailimage)) {
$detailImageName = time() . '_detail_' . $detailimage;
if (!empty($blog['detailimage']) && file_exists("dataimg/" . $blog['detailimage'])) {
unlink("dataimg/" . $blog['detailimage']);
}
move_uploaded_file($tmp2, "dataimg/$detailImageName");
}
// FINAL UPDATE
$qry = "UPDATE project SET
title='$title',
submenu='$submenu',
titleslug='$titleslug',
page_title='$page_title',
description='$description',
keywords='$keywords',
robots='$robots',
canonical='$canonical',
subtitle1='$subtitle1',
image='$imageName',
detailimage='$detailImageName'
WHERE id='$id'";
if (mysqli_query($conn, $qry)) {
echo '<script>alert("Updated Successfully"); window.location="blogshow.php";</script>';
} else {
echo '<script>alert("Update Failed");</script>';
}
}
?>
<!-- / Content -->
<div class="content-backdrop fade"></div>
</div>
<!-- Content wrapper -->
</div>
<!-- / Layout page -->
</div>
</div>
<!-- / Layout wrapper -->
<!-- Core JS -->
<!-- build:js assets/vendor/js/core.js -->
<script src="../assets/vendor/libs/jquery/jquery.js"></script>
<script src="../assets/vendor/libs/popper/popper.js"></script>
<script src="../assets/vendor/js/bootstrap.js"></script>
<script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>
<script src="../assets/vendor/js/menu.js"></script>
<!-- endbuild -->
<!-- Vendors JS -->
<!-- Main JS -->
<script src="../assets/js/main.js"></script>
<!-- Page JS -->
<!-- Place this tag in your head or just before your close body tag. -->
<script async defer src="https://buttons.github.io/buttons.js"></script>
</body>
</html>