1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / www / aumathaexport.com / editcontroller /
Filename : editpro.php
back
<?php
require '../DB/db.php'; // Include the database connection file

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $id = $_POST['id']; // Retrieve the id from the hidden input field
    $pname = isset($_POST["p_name"]) ? $_POST["p_name"] : "";
    $pcat = isset($_POST["cat"]) ? $_POST["cat"] : "";
    $ptype = isset($_POST["type"]) ? $_POST["type"] : "";
    $pdes = isset($_POST["p_des"]) ? $_POST["p_des"] : "";

    // Check if a new image is uploaded
    if (isset($_FILES['p_img']) && $_FILES['p_img']['error'] === UPLOAD_ERR_OK) {
        // File upload handling
        $imgName = $_FILES['p_img']['name'];
        $imgTemp = $_FILES['p_img']['tmp_name'];
        $imgDestination = '../imgupload/pUpload/' . $imgName;
        move_uploaded_file($imgTemp, $imgDestination);
        
        // Update the product details with the new image and provided data
        $sql = "UPDATE products SET 
                c_id = IF('$pcat'='', c_id, '$pcat'), 
                p_name = IF('$pname'='', p_name, '$pname'), 
                p_img = '$imgName', 
                p_des = IF('$pdes'='', p_des, '$pdes'), 
                type = IF('$ptype'='', type, '$ptype') 
                WHERE id = $id";
    } else {
        // If no new image is uploaded, retain the previous image in the database and update with provided data
        $sql = "UPDATE products SET 
                c_id = IF('$pcat'='', c_id, '$pcat'), 
                p_name = IF('$pname'='', p_name, '$pname'), 
                p_des = IF('$pdes'='', p_des, '$pdes'), 
                type = IF('$ptype'='', type, '$ptype') 
                WHERE id = $id";
    }

    if ($conn->query($sql) === TRUE) {
        // Redirect to home.php after successful update
        header("Location: ../admin.php");
        exit;
    } else {
        // Display error message if the update fails
        echo "Error updating product: " . $conn->error;
    }
}
?>