1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / etteodyr / www / admin / actions /
Filename : update_blog_exec.php
back
<?php
ob_start();
include 'dbconnection.php';
$sno = mysqli_real_escape_string($conn, $_POST['sno']);
$title = mysqli_real_escape_string($conn, $_POST['title']);
$url = mysqli_real_escape_string($conn, $_POST['url']);
$author = mysqli_real_escape_string($conn, $_POST['author']);
$category = mysqli_real_escape_string($conn, $_POST['category']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$image = $_FILES["image"];

if (empty($image["name"])) {
    $sql = "UPDATE blog SET title='$title',url='$url', author='$author', category='$category', description='$description' WHERE sno=$sno";
} else {
    $imageExtension = pathinfo($image["name"], PATHINFO_EXTENSION);
    $newfilename = round(microtime(true)) . '.' . $imageExtension;
    $targetDirectory = "../uploads_blog/";
    $targetPath = $targetDirectory . $newfilename;

    // Move the uploaded file to the target directory
    if (move_uploaded_file($image["tmp_name"], $targetPath)) {
        echo "The file " . basename($image["name"]) . " has been uploaded, and your information has been added to the directory";
    } else {
        echo "Sorry, there was a problem uploading your file.";
        exit;
    }

    $sql = "UPDATE blog SET title='$title',url='$url', author='$author', category='$category',  image='$newfilename', description='$description' WHERE sno= $sno";
}

if (!mysqli_query($conn, $sql)) {
    die('Error: ' . mysqli_error($conn));
} else {
    header("location: ../blog.php?status=1");
    exit;
}

mysqli_close($conn);
?>