<h2>File Contents: /home/u885320773/domains/sugatu.in/public_html/vendor/process/add-product.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/public_html/vendor/process/add-product.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
include '../config.php';

// Sample POST data structure (Replace this with your actual form data)
$postData = array(
    'productid' =&gt; $_POST['productid'],
    'ptitle' =&gt; $_POST['ptitle'],
    'features' =&gt; $_POST['features'],
    'description' =&gt; $_POST['description'],
    'technical' =&gt; $_POST['technical'],
    'costprice' =&gt; $_POST['costprice'],
    'marginpercent' =&gt; $_POST['marginpercent'],
    'mrp' =&gt; $_POST['mrp'],
    'discountpercent' =&gt; $_POST['discountpercent'],
    'discounterprice' =&gt; $_POST['discounterprice'],
    'gstpercent' =&gt; $_POST['gstpercent'],
    'status' =&gt; $_POST['status'],
    'parentCategory' =&gt; $_POST['parentCategory'],
    'subCategory' =&gt; $_POST['subCategory'],
    'vendor' =&gt; $_POST['vendor'],
    'manufacturer' =&gt; $_POST['manufacturer'],
    'sku' =&gt; $_POST['sku'],
    'weight' =&gt; $_POST['weight'],
    'hsn' =&gt; $_POST['hsn'],

    's1name' =&gt; $_POST['s1name'],
    's2name' =&gt; $_POST['s2name'],
    's3name' =&gt; $_POST['s3name'],
    's4name' =&gt; $_POST['s4name'],
    's5name' =&gt; $_POST['s5name'],
    's6name' =&gt; $_POST['s6name'],
    's7name' =&gt; $_POST['s7name'],
    's8name' =&gt; $_POST['s8name'],
);


$disp=$postData['discounterprice'];
$gstp=$postData['gstpercent'];

$gstprice=(($disp*$gstp)/100)+$disp;


// Processing and uploading images
$imageUploadPath = '../assets/imgs/products/';
$imageFileNames = array(); // Array to store image file names

foreach ($_FILES as $key =&gt; $file) {
    if ($file['size'] &gt; 0 &amp;&amp; in_array(strtolower(pathinfo($file['name'], PATHINFO_EXTENSION)), ['jpg', 'jpeg', 'png', 'gif', 'webp'])) {
        $randomValue = uniqid('', true); // Generating a random value for the filename
        $newFileName = $randomValue . '.' . pathinfo($file['name'], PATHINFO_EXTENSION);
        $destination = $imageUploadPath . $newFileName;

        if (move_uploaded_file($file['tmp_name'], $destination)) {
            // Save filename to database for each image
            $imageFileNames[$key] = $newFileName;
        } else {
            echo &quot;Error uploading $key&quot;;
        }
    } else {
        // Handle case when no file is uploaded for this image field or it's not an image
        $imageFileNames[$key] = ''; // Set an empty string or null as the filename
    }
}

// Processing and uploading PDF files
$pdfUploadPath = '../assets/pdfs/standards/';
$pdfFileNames = array(); // Array to store PDF file names

foreach ($_FILES as $key =&gt; $file) {
    if ($file['size'] &gt; 0 &amp;&amp; $file['type'] == 'application/pdf') { // Check if a file is uploaded and it's a PDF file
        $randomValue = uniqid('', true); // Generating a random value for the filename
        $newFileName = $randomValue . '.pdf';
        $destination = $pdfUploadPath . $newFileName;

        if (move_uploaded_file($file['tmp_name'], $destination)) {
            // Save filename to database for each PDF file
            $pdfFileNames[$key] = $newFileName;
        } else {
            echo &quot;Error uploading $key&quot;;
        }
    } else {
        // Handle case when no file is uploaded or it's not a PDF for this field
        $pdfFileNames[$key] = ''; // Set an empty string or null as the filename
    }
}





// Inserting all file names into the database
$date = date(&quot;Y-m-d&quot;);
$imageColumns = implode(&quot;, &quot;, array_keys($imageFileNames));
$pdfColumns = implode(&quot;, &quot;, array_keys($pdfFileNames));
$imageValues = &quot;'&quot; . implode(&quot;', '&quot;, $imageFileNames) . &quot;'&quot;;
$pdfValues = &quot;'&quot; . implode(&quot;', '&quot;, $pdfFileNames) . &quot;'&quot;;

$sql = &quot;INSERT INTO products (ptitle, productid, features, description, technical, gmain, g1, g2, g3, g4, g5, g6, s1file, s2file, s3file, s4file, s5file, s6file, s7file, s8file, costprice, marginpercent, mrp, discountpercent, discounterprice, gstpercent, gstprice, status, parentCategory, subCategory, vendor, manufacturer, sku, weight, hsn, s1name, s2name, s3name, s4name, s5name, s6name, s7name, s8name, date)
        VALUES ('{$postData['ptitle']}', '{$postData['productid']}', '{$postData['features']}', '{$postData['description']}', '{$postData['technical']}', '{$imageFileNames['gmain']}', '{$imageFileNames['g1']}', '{$imageFileNames['g2']}', '{$imageFileNames['g3']}', '{$imageFileNames['g4']}', '{$imageFileNames['g5']}', '{$imageFileNames['g6']}', '{$pdfFileNames['s1file']}', '{$pdfFileNames['s2file']}', '{$pdfFileNames['s3file']}', '{$pdfFileNames['s4file']}', '{$pdfFileNames['s5file']}', '{$pdfFileNames['s6file']}', '{$pdfFileNames['s7file']}', '{$pdfFileNames['s8file']}', '{$postData['costprice']}', '{$postData['marginpercent']}', '{$postData['mrp']}', '{$postData['discountpercent']}', '{$postData['discounterprice']}', '{$postData['gstpercent']}', '$gstprice', '{$postData['status']}', '{$postData['parentCategory']}', '{$postData['subCategory']}', '{$postData['vendor']}', '{$postData['manufacturer']}', '{$postData['sku']}', '{$postData['weight']}', '{$postData['hsn']}', '{$postData['s1name']}', '{$postData['s2name']}', '{$postData['s3name']}', '{$postData['s4name']}', '{$postData['s5name']}', '{$postData['s6name']}', '{$postData['s7name']}', '{$postData['s8name']}', '$date')&quot;;



// echo $sql;

if ($conn-&gt;query($sql) === TRUE) {
    header(&quot;Location: ../products-warehouse-stock.php?productid={$postData['productid']}&amp;ptitle={$postData['ptitle']}&amp;add=success&quot;);
		exit();
} else {
    echo &quot;Error: &quot; . $sql . &quot;&lt;br&gt;&quot; . $conn-&gt;error;
}

$conn-&gt;close();
?&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fu885320773%2Fdomains%2Fsugatu.in%2Fpublic_html%2Fvendor%2Fprocess'>⬅ Back to Directory</a>