1save-update-blog.php

<?php

include "./connection/config.php";

// Validate and sanitize input
$blog_id = mysqli_real_escape_string($conn, $_POST["blog_id"]);
$blog_title = mysqli_real_escape_string($conn, $_POST["blog_title"]);
$blog_desc = mysqli_real_escape_string($conn, $_POST["blog_desc"]);
$blog_image = mysqli_real_escape_string($conn, $_POST["blog_image"]);

// Check if a new image is uploaded
if ($_FILES["blog_image"]["name"]) {
    $file_name = $_FILES["blog_image"]["name"];
    // Handle file upload securely, move to a secure directory
    $target_dir = "image/upload";
    $target_file = $target_dir . basename($_FILES["blog_image"]["name"]);
    move_uploaded_file($_FILES["blog_image"]["tmp_name"], $target_file);
} else {
    // If no new image uploaded, keep the existing one
    $target_file = $_POST["current_image"];
}

$sql = "UPDATE blog SET blog_title = ?, blog_desc = ?, blog_image = ? WHERE blog_id = ?";
$stmt = $conn->prepare($sql);
/* ---------------- START : Old code File uploaded 15-12-2023 */
// $stmt->bind_param("ssisi", $productName, $productDesc, $productCategory, $file_name, $productId);
/* ---------------- END : Old code File uploaded 15-12-2023 */

/* ---------------- START : New code (GP) File uploaded 15-12-2023 */
$stmt->bind_param("sssi", $blog_title, $blog_desc, $target_file, $blog_id);
/* ---------------- END : New code (GP) File uploaded 15-12-2023 */

if ($stmt->execute()) {
    // Redirect to the product list page if the update is successful
    // header("Location: all-blogs.php");
    echo '<script type="text/javascript">';
    echo 'alert("Blogs Updated successfully!");';
    echo 'window.location.href = "all-blogs.php";';  // Redirect to the category list page
    echo '</script>';
    exit();
} else {
    // Handle the error appropriately
    echo "Error updating record: " . $stmt->error;
}

$stmt->close();
$conn->close();

docroot: /home/u739277164/domains/ozatagro.com/public_html

curdir: /home/u739277164/domains/ozatagro.com/public_html/admin_panel

	.	4096
	..	4096
X	add-product.php	21524
	assets	4096
	connection	4096
X	contact-lead.php	20725
X	delete-image.php	573
	image	16384
X	ozat-spices.php	20720
X	policy-change.php	12729
X	save-update-blog.php	1922
X	save-update-image.php	1684