Na}{

File Content: `update.php`

<?php

include "../config/connection.php";

if(isset($_POST["id"])){
    $id = $_POST["id"];
    $title = $_POST["title"];
    $discription = $_POST["discription"];
    $old_file = $_POST["old_file"];
    
    // Create slug for blog post
    function createSlug($string, $addSlash = false) {
        $slug = strtolower($string);
        $slug = str_replace(' ', '-', $slug);  // Replace spaces with hyphens
        $slug = preg_replace('/[^a-z0-9\-]/', '', $slug); // Remove non-alphanumeric characters
        return $addSlash ? '/' . $slug : $slug;  // Add leading slash if needed
    }

    $slug = createSlug($title, true);  // Slug with leading slash
    $title_url = createSlug($title);  // Slug without leading slash
   
    if (!empty($_FILES["new_file"]["name"])) {
        // If a new file is uploaded, handle it
        $file = $_FILES['new_file']["name"];
        $tmp_file = $_FILES["new_file"]["tmp_name"];
        $new_image = rand() . "-" . $file;
        
        // Move the uploaded file
        move_uploaded_file($tmp_file, '../../assets/img/tablets/' . $new_image);
        
        // Remove the old image file
        unlink("../../assets/images/tablets/" . $old_file);
        
        // Update the database with the new image and slug
        $sql = "UPDATE products SET product_image='$new_image', product_title='$title',title_url='$title_url', product_desc='$discription', slug_url='$slug' WHERE id='$id'";
    } else {
        // No new file uploaded, just update the title, description, and slug
        $sql = "UPDATE products SET product_title='$title', title_url='$title_url', product_desc='$discription', slug_url='$slug' WHERE id='$id'";
    }
    
    // Execute the query
    $result = mysqli_query($con, $sql);
    
    if ($result) {
        echo "1";  // Successfully updated
    } else {
        echo "0";  // Failed to update
    }
}
?>

Name	Size	Permission
delete.php	744 bytes	0666
display-data.php	3025 bytes	0666
insert.php	2483 bytes	0666
login.php	683 bytes	0666
update.php	1931 bytes	0666

File Content: update.php

File Content: `update.php`