File Contents: /home/u885320773/domains/sugatu.in/admin/process/add-category.php

<?php
    include '../config.php';
    
    // Sample POST data structure (Replace this with your actual form data)
$postData = array(
    'cname' => $_POST['cname'],
    'parentid' => $_POST['parentid'],
);

// Processing and uploading images
$uploadPath = '../assets/imgs/productcategories/';
$allowedExtensions = array("jpg", "jpeg", "png", "gif","webp");
$imageFileNames = array(); // Array to store file names

foreach ($_FILES as $key => $file) {
    if ($file['size'] > 0) { // Check if a file is uploaded for this field
        $fileName = $file['name'];
        $fileTmpName = $file['tmp_name'];
        $fileExtension = pathinfo($fileName, PATHINFO_EXTENSION);
        $randomValue = uniqid('', true); // Generating a random value for the filename

if (in_array(strtolower($fileExtension), $allowedExtensions)) {
            $newFileName = $randomValue . '.' . $fileExtension;
            $destination = $uploadPath . $newFileName;

if (move_uploaded_file($fileTmpName, $destination)) {
                // Save filename to database for each image
                $imageFileNames[$key] = $newFileName;
            } else {
                echo "Error uploading $key";
            }
        } else {
            echo "Invalid file format for $key";
        }
    } else {
        // Handle case when no file is uploaded for this field
        $imageFileNames[$key] = ''; // Set an empty string or null as the filename
    }
}

$imageColumns = implode(", ", array_keys($imageFileNames));
$imageValues = "'" . implode("', '", $imageFileNames) . "'";

$sql = "INSERT INTO `productcategory`(`cname`, `parentid`, $imageColumns, `corder`) VALUES ('{$postData['cname']}', '{$postData['parentid']}',$imageValues,'0')";
 // echo $sql;

if ($conn->query($sql) === TRUE) {
        header("Location: ../product-categories.php?add=success");
		exit();
    } else {
        header("Location: ../product-categories.php?error=save");
		exit();
        
    }

$conn->close();

⬅ Back to Directory