System Manager v8.0

Editing: update-blog.php

<?php
include 'includes/auth.php';
include 'includes/db.php';

if (!isset($_POST['id'])) {
    header("Location: blog-list.php");
    exit;
}

$id = $_POST['id'];
$title = $_POST['title'];
$slug = $_POST['slug'];
$blog_date = $_POST['blog_date'];
$content = $_POST['content'];
$meta_title = $_POST['meta_title'];
$meta_description = $_POST['meta_description'];
$status = $_POST['status'];

$imageQuery = "";

// If new image uploaded
if (!empty($_FILES['image']['name'])) {

$uploadDir = __DIR__ . '/uploads/blog-images/';

// Create folder if not exists (same as save-blog.php)
    if (!is_dir($uploadDir)) {
        mkdir($uploadDir, 0755, true);
    }

$imageName = time() . '_' . basename($_FILES['image']['name']);

move_uploaded_file(
        $_FILES['image']['tmp_name'],
        $uploadDir . $imageName
    );

$imageQuery = ", featured_image='$imageName'";
}

mysqli_query($conn,"
UPDATE blogs SET
title='$title',
slug='$slug',
blog_date='$blog_date',
content='$content',
meta_title='$meta_title',
meta_description='$meta_description',
status='$status'
$imageQuery
WHERE id='$id'
");

header("Location: blog-list.php");
exit;

Cancel