<h2>File Contents: /home/u885320773/domains/sugatu.in/.trash/combokit-details.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/.trash/combokit-details.php'><textarea name='file_content' rows='10' cols='50'>&lt;!DOCTYPE html&gt;
&lt;html class=&quot;no-js&quot; lang=&quot;en&quot;&gt;

&lt;head&gt;
    &lt;meta charset=&quot;utf-8&quot; /&gt;
    &lt;title&gt;Sugatu - Solar Combo Kits&lt;/title&gt;
    &lt;meta http-equiv=&quot;x-ua-compatible&quot; content=&quot;ie=edge&quot; /&gt;
    &lt;meta name=&quot;description&quot; content=&quot;&quot; /&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot; /&gt;
    &lt;meta property=&quot;og:title&quot; content=&quot;&quot; /&gt;
    &lt;meta property=&quot;og:type&quot; content=&quot;&quot; /&gt;
    &lt;meta property=&quot;og:url&quot; content=&quot;&quot; /&gt;
    &lt;meta property=&quot;og:image&quot; content=&quot;&quot; /&gt;
    &lt;!-- Favicon --&gt;
    &lt;link rel=&quot;shortcut icon&quot; type=&quot;image/x-icon&quot; href=&quot;assets/imgs/theme/favicon.png&quot; /&gt;
    &lt;!-- Template CSS --&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;assets/css/plugins/slider-range.css&quot; /&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;assets/css/main.css?v=5.6&quot; /&gt;
    &lt;link href=&quot;https://cdn.jsdelivr.net/npm/bootstrap-icons/font/bootstrap-icons.css&quot; rel=&quot;stylesheet&quot;&gt;

    &lt;script src=&quot;https://code.jquery.com/jquery-3.6.0.min.js&quot;&gt;&lt;/script&gt;
   &lt;!-- &lt;script src=&quot;assets/js/cart.js&quot;&gt;&lt;/script&gt; --&gt;
    &lt;script&gt;
         $(document).ready(function () {
    var subtotals = {}; // JavaScript object to store subtotals

    // Initialize subtotals and total on page load
    initializeSubtotals();
    updateTotal();



   // Function to initialize subtotals on page load
function initializeSubtotals() {
    $(&quot;.qty-val&quot;).each(function () {
        var row = $(this).closest(&quot;tr&quot;);
        var productId = row.data(&quot;product-id&quot;);
        var quantity = parseInt($(this).text()) || 0;
        var price = parseFloat(row.find(&quot;.price&quot;).text().replace('₹', '').trim()) || 0;
        var subtotal = quantity * price;
        row.data(&quot;subtotal&quot;, subtotal);
        subtotals[productId] = subtotal;
    });

    // Update the total and subtotal displays
    updateTotal();
    updateSubtotalDisplay();
}

// Function to update subtotal display
function updateSubtotalDisplay() {
    var totalSubtotal = 0;

    // Iterate through each product row
    $(&quot;.qty-val&quot;).each(function () {
        var subtotal = parseFloat($(this).closest(&quot;tr&quot;).data(&quot;subtotal&quot;)) || 0;
        totalSubtotal += subtotal;
    });

    // Update the content of the subtotal &lt;h4&gt; tag
    $(&quot;#subtotalValue&quot;).text('₹' + totalSubtotal.toFixed(2));
}

    // Function to update subtotal for the row
    
// Function to update subtotal for the row
function updateSubtotal(element) {
    var row = element.closest(&quot;tr&quot;);
    var quantityElement = row.find(&quot;.qty-val&quot;);
    var priceElement = row.find(&quot;.price&quot;);

    // Retrieve quantity and price values
    var quantity = parseInt(quantityElement.text()) || 0;
    var price = parseFloat(priceElement.text().replace('₹', '').trim()) || 0;

    // Update quantity and calculate subtotal
    if (element.hasClass(&quot;qty-down&quot;)) {
        quantity = Math.max(quantity - 1, 1); // Ensure quantity is not less than 1
    } else {
        quantity += 1;
    }

    var subtotal = quantity * price;
    quantityElement.text(quantity);
    row.data(&quot;subtotal&quot;, subtotal);

    // Update 'subtotals' object with the new subtotal value
    var productId = row.data(&quot;product-id&quot;);
    subtotals[productId] = subtotal;

    // Debugging output
    console.log(&quot;Updated Subtotal for Product ID &quot; + productId + &quot;: ₹&quot; + subtotal.toFixed(2));

    // Update subtotal display
    updateSubtotalDisplay();
}



    // Function to update the total price
    function updateTotal() {
        var totalPrice = 0;

        // Iterate through each product row
        $(&quot;.qty-val&quot;).each(function () {
            var subtotal = parseFloat($(this).closest(&quot;tr&quot;).data(&quot;subtotal&quot;)) || 0;
            totalPrice += subtotal;
        });

        // Calculate discount value based on discount percent
        var discountPercent = parseFloat(document.getElementById(&quot;discountPercent&quot;).value) || 0;
        var discountValue = (discountPercent / 100) * totalPrice;

        // Update the content of the discount and total &lt;h5&gt; and &lt;h4&gt; tags
        $(&quot;#discountValue&quot;).text('₹' + discountValue.toFixed(2));
        $(&quot;#totalValue&quot;).text('₹' + (totalPrice - discountValue).toFixed(2));

        // Update a hidden input field with the total value (for submission to PHP)
        $(&quot;#totalInput&quot;).val((totalPrice - discountValue).toFixed(2));

        // Debugging output
        console.log(&quot;Total Price: ₹&quot; + totalPrice.toFixed(2));
        console.log(&quot;Discount Value: ₹&quot; + discountValue.toFixed(2));
    }

    // Function to update hidden form field with subtotal data
    function updateHiddenField() {
        // Convert JavaScript object to a JSON string
        var subtotalsJson = JSON.stringify(subtotals);

        // Update the value of the hidden form field
        $(&quot;#subtotalsInput&quot;).val(subtotalsJson);

        // Debugging output
        console.log(&quot;Updated Subtotals JSON: &quot; + subtotalsJson);
    }
    
    // Function to update the displayed price for a row
function updateDisplayedPrice(row) {
    var quantity = parseInt(row.find(&quot;.qty-val&quot;).text()) || 0;
    var price = parseFloat(row.find(&quot;.price&quot;).text().replace('₹', '').trim()) || 0;

    var displayedPrice = quantity * price;
    row.find(&quot;.text-brand&quot;).text('₹' + displayedPrice.toFixed(2));
}

// Event handler for quantity decrease
$(document).on(&quot;click&quot;, &quot;.qty-down, .qty-up&quot;, function () {
    var row = $(this).closest(&quot;tr&quot;);
    updateSubtotal($(this));
    updateTotal(); // Update the total after changing quantity
    updateHiddenField(); // Update hidden form field
    updateDisplayedPrice(row); // Update the displayed price
});
});

        &lt;/script&gt;

    &lt;style&gt;
    .zoomContainer, .zoomWindow {
        z-index: 997;
    }
    tr.non-changeable .qty-down,
tr.non-changeable .qty-up {
    /* Add styles to visually indicate or disable quantity change */
    opacity: 0.3;
    pointer-events: none; /* Disable pointer events to make the links non-clickable */
}

    .zoomContainer, .zoomWindow {
        z-index: 997;
    }
    ul{
        /* list-style-type: '✔  '; */
        list-style-type:disc;
    }
    
    .hidden {
      display: none;
    }
    
    
    @media only screen and (max-width: 480px){
.table td {
    text-align: left;
}
.shopping-summery table &gt; :not(caption) &gt; * &gt; * {
    padding: 5px;
}
}
    
    
    
    &lt;/style&gt;
&lt;/head&gt;

&lt;body&gt;
 
    &lt;?php 
    
    include 'includes/header.php'; 
    
    
    if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;GET&quot; &amp;&amp; isset($_REQUEST['combokitid'])) {
  
        $combokitid = $_REQUEST['combokitid'];
        $product_id = $combokitid;

        include 'admin/config.php';

        // Fetch Parent Category Name
        $sql2 = &quot;SELECT cktitle,features,description,combokitimage,discountpercent FROM combokits WHERE combokitid = '$combokitid'&quot;;
        $result2 = $conn-&gt;query($sql2);
        if ($result2-&gt;num_rows &gt; 0) {
            while ($row = $result2-&gt;fetch_assoc()) {
                $cktitle = $row['cktitle'];
                $features = $row['features'];
                $description = $row['description'];
                $combokitimage = $row['combokitimage'];
                $discountpercent = $row['discountpercent'];
            }
        }

        $ptitle = $cktitle;
        $gmain = $combokitimage;

       // $sqll=&quot;SELECT ck.id, ck.combokitid, ck.cktitle, ck.combokitimage, cc.ckname as 'ckcategory' FROM combokits ck JOIN combokitcategory cc ON ck.parentCategory = cc.id WHERE ck.parentCategory = $catid;&quot;;

    
      
    
    } 
    
    ?&gt;

    

    &lt;main class=&quot;main&quot;&gt;
        &lt;div class=&quot;page-header breadcrumb-wrap&quot;&gt;
            &lt;div class=&quot;container&quot;&gt;
                &lt;div class=&quot;breadcrumb&quot;&gt;
                    &lt;a href=&quot;index.html&quot; rel=&quot;nofollow&quot;&gt;&lt;i class=&quot;fi-rs-home mr-5&quot;&gt;&lt;/i&gt;Home&lt;/a&gt;
                    &lt;span&gt;&lt;/span&gt; Combo Kits
                    &lt;span&gt;&lt;/span&gt; &lt;?php echo $cktitle; ?&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;container mb-80 mt-50&quot;&gt;
            &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-sm-12 mb-40&quot;&gt;
                    &lt;div class=&quot;row&quot;&gt;
                        &lt;div class=&quot;col-md-6 mb-40&quot;&gt;
                           &lt;img src=&quot;admin/assets/imgs/combokits/&lt;?php echo $combokitimage ?&gt;&quot; style=&quot;width:100%; border:solid 1px #efefef; border-radius:10px&quot;&gt;
                        &lt;/div&gt;
                        &lt;div class=&quot;col-md-6 mb-40&quot;&gt;
                            &lt;h1 class=&quot;heading-2 mb-10&quot;&gt;&lt;?php echo $cktitle; ?&gt;&lt;/h1&gt;
                            &lt;?php
                                include 'admin/config.php';
                                $sql = &quot;SELECT cp.id, cp.changeqty, cp.combokitid, cp.productid, cp.pquantity, p.discounterprice, p.gstpercent FROM combokitproduct cp JOIN products p ON cp.productid = p.id WHERE cp.combokitid = $combokitid;&quot;;

                                $result = $conn-&gt;query($sql);

                                if (!$result) {
                                    die(&quot;Error executing query: &quot; . $conn-&gt;error);
                                }

                                $totalDiscounterPrice = 0; // Initialize total discounted price
                                $totalGstPrice = 0; // Initialize total price including GST

                                if ($result-&gt;num_rows &gt; 0) {
                                    // Output data of each row
                                    // Loop through the query result
                                    while($row = $result-&gt;fetch_assoc()) {
                                        $discounterPrice = $row['discounterprice'];
                                        $quantity = $row['pquantity'];
                                        $changeQty = $row['changeqty'];
                                        $price = $quantity * $discounterPrice;
                                        $gstPercent = $row['gstpercent'];
                                        $gstPrice = (($price * $gstPercent) / 100) + $price;

                                        // Accumulate total discounted price and total price including GST
                                        $totalDiscounterPrice += $price;
                                        $totalGstPrice += $gstPrice;
                                    }
                                }

                            ?&gt;
                            &lt;div class=&quot;detail-info&quot;&gt;
                            &lt;div class=&quot;clearfix product-price-cover&quot;&gt;
                                &lt;div class=&quot;row&quot;&gt;
                                    &lt;div class=&quot;col-sm-12&quot;&gt;
                                        &lt;div class=&quot;product-price primary-color float-left&quot; style=&quot;margin-bottom:0;&quot;&gt;
                                            &lt;span class=&quot;current-price text-brand&quot;&gt;₹&lt;?php echo $totalDiscounterPrice; ?&gt;&lt;/span&gt;
                                            &lt;span&gt;
                                                &lt;span class=&quot;save-price font-md color3 ml-15&quot;&gt;Including GST&lt;/span&gt;
                                                &lt;span class=&quot;old-price font-md ml-15&quot; style=&quot;text-decoration: none;&quot;&gt;₹&lt;?php echo $totalGstPrice; ?&gt;&lt;/span&gt;
                                            &lt;/span&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                            &lt;/div&gt;


                            &lt;div class=&quot;short-desc mb-30 mt-30&quot;&gt;
                                &lt;p class=&quot;font-lg&quot;&gt;
                                    &lt;b style=&quot;color:#000000;&quot;&gt;FEATURES&lt;/b&gt;&lt;br&gt;
                                    &lt;?php echo $features ?&gt;
                                &lt;/p&gt;
                            &lt;/div&gt; 
                            &lt;div class=&quot;divider-2 mb-30&quot;&gt;&lt;/div&gt;
                            &lt;div class=&quot;short-desc mb-30&quot;&gt;
                                &lt;p class=&quot;font-lg&quot;&gt;
                                    &lt;b style=&quot;color:#000000;&quot;&gt;DESCRIPTION&lt;/b&gt;&lt;br&gt;
                                    &lt;?php echo $description ?&gt;
                                &lt;/p&gt;
                            &lt;/div&gt;
                            

                            &lt;div class=&quot;detail-extralink mb-50&quot;&gt;
                                    &lt;div class=&quot;product-extra-link2&quot;&gt;
                                        
                                        &lt;button class=&quot;add add-to-cart button button-add-to-cart&quot; data-bs-toggle=&quot;modal&quot; data-bs-target=&quot;#enquiryModal&quot; data-product-id=&quot;&lt;?php echo $product_id; ?&gt;&quot;&gt;
                                            &lt;i class=&quot;fi-rs-envelope&quot;&gt;&lt;/i&gt; Send Enquiry
                                        &lt;/button&gt;


                                        &lt;!-- Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;enquiryModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;enquiryModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog modal-lg&quot;&gt;
    &lt;div class=&quot;modal-content&quot;&gt;
      &lt;div class=&quot;modal-header&quot;&gt;
        &lt;h5 class=&quot;modal-title&quot; id=&quot;enquiryModalLabel&quot;&gt;Send Enquiry&lt;/h5&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;&lt;/button&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-body&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
          &lt;div class=&quot;col-md-4&quot;&gt;
            &lt;img src=&quot;admin/assets/imgs/combokits/&lt;?php echo $gmain; ?&gt;&quot; class=&quot;img-fluid&quot; alt=&quot;Product Image&quot;&gt;
            
          &lt;/div&gt;
          &lt;div class=&quot;col-md-8&quot;&gt;
            &lt;h5 class=&quot;title-detail mb-30&quot;&gt;Enquiry for &lt;?php echo $ptitle; ?&gt;&lt;/h5&gt;
            &lt;!-- Enquiry form --&gt;
            &lt;form action=&quot;process/submit_enquiry.php&quot; method=&quot;POST&quot;&gt;
              &lt;input type=&quot;hidden&quot; name=&quot;pid&quot; value=&quot;&lt;?php echo $product_id; ?&gt;&quot;&gt;
              &lt;input type=&quot;hidden&quot; name=&quot;ptitle&quot; value=&quot;&lt;?php echo $ptitle; ?&gt;&quot;&gt;
              &lt;input type=&quot;hidden&quot; name=&quot;type&quot; value=&quot;Combokit&quot;&gt;
              &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-sm-12 mb-3&quot;&gt;
                    
                    &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;nameInput&quot; placeholder=&quot;Name&quot; name=&quot;name&quot; required&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-sm-12 mb-3&quot;&gt;
                    
                    &lt;input type=&quot;email&quot; class=&quot;form-control&quot; id=&quot;emailInput&quot; placeholder=&quot;Email id&quot; name=&quot;email&quot; required&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-sm-6 mb-3&quot;&gt;
                    
                    &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;phoneInput&quot; placeholder=&quot;Phone&quot; name=&quot;phone&quot; required&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-sm-6 mb-3&quot;&gt;
                    
                    &lt;input type=&quot;text&quot; class=&quot;form-control&quot; id=&quot;pincodeInput&quot; placeholder=&quot;Pincode&quot; name=&quot;pincode&quot; maxlength=&quot;6&quot; required&gt;
                &lt;/div&gt;
              &lt;/div&gt;
              &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;Submit&lt;/button&gt;
            &lt;/form&gt;
          &lt;/div&gt;
        &lt;/div&gt;
        
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;





                                    &lt;/div&gt;
                                &lt;/div&gt;
          





                        &lt;/div&gt;
                        
                    &lt;/div&gt;
                    
                &lt;/div&gt;
            &lt;/div&gt;
            &lt;div class=&quot;row&quot;&gt;
                &lt;div class=&quot;col-lg-12&quot;&gt;
                    
                &lt;div class=&quot;table-responsive shopping-summery&quot;&gt;
                        &lt;table class=&quot;table table-wishlist&quot;&gt;
                            &lt;thead&gt;
                                &lt;tr class=&quot;main-heading&quot;&gt;
                                    
                                    &lt;th class=&quot;start pl-30&quot; scope=&quot;col&quot; colspan=&quot;2&quot; style=&quot;width:40%&quot;&gt;Product&lt;/th&gt;
                                    &lt;th scope=&quot;col&quot;&gt;Rate&lt;/th&gt;
                                    &lt;th scope=&quot;col&quot;&gt;Qty&lt;/th&gt;
                                    &lt;th scope=&quot;col&quot;&gt;Subtotal&lt;/th&gt;
                                    &lt;th scope=&quot;col&quot;&gt;Inc GST&lt;/th&gt;
                                &lt;/tr&gt;
                            &lt;/thead&gt;
                            &lt;tbody&gt;
                            &lt;?php
                                include 'admin/config.php';

                                // SQL query to fetch data from the table
                                $sql = &quot;SELECT cp.id, cp.changeqty, cp.combokitid, cp.productid, cp.pquantity, p.id as pid, p.ptitle, p.gmain, p.discounterprice, p.gstpercent FROM combokitproduct cp JOIN products p ON cp.productid = p.id WHERE cp.combokitid = $combokitid;&quot;;

                                $result = $conn-&gt;query($sql);

                                if (!$result) {
                                    die(&quot;Error executing query: &quot; . $conn-&gt;error);
                                }

                                if ($result-&gt;num_rows &gt; 0) {
                                    // Output data of each row
                                   
                                    while($row = $result-&gt;fetch_assoc()) {
                                        $quantity = $row['pquantity'];
                                        $changeQty = $row['changeqty'];
                                        $price=$row['pquantity'] * $row['discounterprice'];
                                        $gstpercent=$row['gstpercent'];
                                        $gstprice=(($price*$gstpercent)/100)+$price;


                                        echo '&lt;tr data-product-id=&quot;'.$row['id'].'&quot;&gt;
                                            
                                            &lt;td class=&quot;image product-thumbnail pl-30&quot;&gt;&lt;img src=&quot;admin/assets/imgs/products/'.$row['gmain'].'&quot; alt=&quot;#&quot; style=&quot;height:60px; width:60px;&quot;&gt;&lt;/td&gt;
                                            &lt;td class=&quot;product-des product-name&quot;&gt; 
                                                &lt;p class=&quot;mb-5&quot;&gt; &lt;a class=&quot;product-name mb-10 text-heading&quot; href=&quot;product-details.php?id='.$row['pid'].'&quot; target=&quot;_blank&quot; style=&quot;padding-left:3px;&quot;&gt; '.$row['ptitle'].'&lt;/a&gt;&lt;/p&gt;
                                               
                                            &lt;/td&gt;
                                            &lt;td class=&quot;price&quot; data-title=&quot;Rate&quot;&gt;
                                                &lt;h4 class=&quot;text-body&quot;&gt;₹'.$row['discounterprice'].' &lt;/h4&gt;
                                            &lt;/td&gt;
                                            &lt;td class=&quot;price&quot; data-title=&quot;Qty&quot;&gt;
                                                &lt;h4 class=&quot;text-body&quot;&gt;'.$row['pquantity'].'&lt;/h4&gt;
                                            &lt;/td&gt;
                                            &lt;td class=&quot;price&quot; data-title=&quot;Price&quot;&gt;
                                                &lt;h4 class=&quot;text-body&quot;&gt;₹'.$price.' &lt;/h4&gt;
                                            &lt;/td&gt;
                                            &lt;td class=&quot;price&quot; data-title=&quot;Inc GST&quot;&gt;
                                                &lt;h4 class=&quot;text-brand&quot;&gt;₹'.$gstprice.' &lt;span class=&quot;text-body&quot; style=&quot;font-weight:400; font-size:16px&quot;&gt;(Inc '.$gstpercent.' GST)&lt;/span&gt;&lt;/h4&gt;
                                            &lt;/td&gt;

                                    
                                        &lt;/tr&gt;';





                                     /*   echo '&lt;tr class=&quot;product-row ' . ($changeQty === 'no' ? 'non-changeable' : '') . '&quot; data-product-id=&quot;'.$row['id'].'&quot;&gt;
                                            
                                            &lt;td class=&quot;image product-thumbnail pl-30&quot;&gt;&lt;img src=&quot;admin/assets/imgs/products/'.$row['gmain'].'&quot; alt=&quot;#&quot; style=&quot;height:60px; width:60px;&quot;&gt;&lt;/td&gt;
                                            &lt;td class=&quot;product-des product-name&quot;&gt;
                                                &lt;p class=&quot;mb-5&quot;&gt;&lt;a class=&quot;product-name mb-10 text-heading&quot; href=&quot;#&quot;&gt;'.$row['ptitle'].'&lt;/a&gt;&lt;/p&gt;
                                               
                                            &lt;/td&gt;
                                            &lt;td class=&quot;price&quot; data-title=&quot;Price&quot;&gt;
                                                &lt;h4 class=&quot;text-body&quot;&gt;₹'.$row['discounterprice'].' &lt;/h4&gt;
                                            &lt;/td&gt;
                                            &lt;td class=&quot;text-center detail-info&quot; data-title=&quot;Stock&quot;&gt;
                                            &lt;div class=&quot;detail-extralink mr-15&quot;&gt;
                                                &lt;div class=&quot;detail-qty border radius&quot;&gt;
                                                    &lt;a href=&quot;#&quot; class=&quot;qty-down&quot; data-product-id=&quot;'.$row['id'].'&quot;&gt;&lt;i class=&quot;fi-rs-angle-small-down&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                                                    &lt;span class=&quot;qty-val&quot;&gt;'.$row['pquantity'].'&lt;/span&gt;
                                                    &lt;a href=&quot;#&quot; class=&quot;qty-up&quot; data-product-id=&quot;'.$row['id'].'&quot;&gt;&lt;i class=&quot;fi-rs-angle-small-up&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                                                &lt;/div&gt;
                                            &lt;/div&gt;
                                            &lt;/td&gt;
                                            &lt;td class=&quot;price&quot; data-title=&quot;Price&quot;&gt;
                                                &lt;h4 class=&quot;text-brand&quot;&gt;₹'.$row['pquantity'] * $row['discounterprice'].' &lt;/h4&gt;
                                            &lt;/td&gt;
                                    
                                        &lt;/tr&gt;';

                                        */


                                       
                                    }
                                    echo '&lt;/tbody&gt;&lt;/table&gt;';
                                } else {
                                    echo &quot;0 results&quot;;
                                }

                                // Close connection
                                $conn-&gt;close();
                            ?&gt;
                             
                            &lt;/tbody&gt;
                        &lt;/table&gt;
                    &lt;/div&gt;
                   
                &lt;/div&gt;
            &lt;/div&gt;
            
            
            &lt;!--============   FAQ Section   ===========--&gt;
            &lt;div class=&quot;row&quot;&gt;
                
                &lt;div class=&quot;col-sm-12&quot;&gt;
                    
                    
                    
                    &lt;div class=&quot;accordion&quot; id=&quot;faqAccordion&quot;&gt;

        &lt;?php
        // Database connection details
        include 'admin/config.php';
        
        // Query to fetch FAQs from the database
        $query = &quot;SELECT * FROM combokits WHERE combokitid = '$combokitid' &quot;;
        $result = $conn-&gt;query($query);
//        echo $query;

// After executing the query, add the following:
/*
if ($result === false) {
    die(&quot;Error in query: &quot; . $conn-&gt;error);
}
*/

// Before the closing brace of the script, add the following:


        // Check if there are results
        if ($result-&gt;num_rows &gt; 0) {
            while ($row = $result-&gt;fetch_assoc()) {
                
                
                $faqFound = false;
                $faqHeadingDisplayed = false; // Initializing the variable


for ($i = 1; $i &lt;= 10; $i++) {
    $fq_key = 'fq' . $i;
    $fa_key = 'fa' . $i;
    
    if (!empty($row[$fq_key]) &amp;&amp; !empty($row[$fa_key])) {
        $faqFound = true;

        // If at least one FAQ is found, display the heading for &quot;Frequently Asked Questions&quot;
        if (!$faqHeadingDisplayed) {
            echo '&lt;div class=&quot;col-sm-12 mb-20&quot;&gt;
            &lt;h2&gt;Frequently Asked Questions&lt;/h2&gt;
        &lt;/div&gt;';
            $faqHeadingDisplayed = true;
        }

        echo '
        &lt;div class=&quot;accordion-item&quot;&gt;
            &lt;h2 class=&quot;accordion-header&quot; id=&quot;heading' . $i . '&quot;&gt;
                &lt;button class=&quot;accordion-button&quot; type=&quot;button&quot; data-bs-toggle=&quot;collapse&quot; data-bs-target=&quot;#collapse' . $i . '&quot; aria-expanded=&quot;false&quot; aria-controls=&quot;collapse' . $i . '&quot;&gt;
                    ' . $row[$fq_key] . '
                &lt;/button&gt;
            &lt;/h2&gt;
            &lt;div id=&quot;collapse' . $i . '&quot; class=&quot;accordion-collapse collapse&quot; aria-labelledby=&quot;heading' . $i . '&quot; data-bs-parent=&quot;#faqAccordion&quot;&gt;
                &lt;div class=&quot;accordion-body&quot;&gt;
                    ' . $row[$fa_key] . '
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;';
    }
}

if (!$faqFound) {
 //   echo &quot;No FAQs found&quot;;
}


                
            }
         //   var_dump($result-&gt;num_rows); // Check the number of rows returned
        } else {
            echo '&lt;p&gt;No FAQs found.&lt;/p&gt;';
         //   var_dump($result-&gt;num_rows); // Check the number of rows returned
        }
        
        

        // Close the database connection
        $conn-&gt;close();
        ?&gt;





    &lt;/div&gt;
                    
                    
                &lt;/div&gt;



                &lt;div class=&quot;col-sm-12 mt-30&quot;&gt;
                &lt;?php
// Database connection details
include 'admin/config.php';

// Query to fetch files from the database
$query = &quot;SELECT * FROM combokits WHERE combokitid = '$combokitid'&quot;;
$result = $conn-&gt;query($query);

// Check if there are results
if ($result-&gt;num_rows &gt; 0) {
    $filesExist = false;

    // Check if any file exists
    while ($row = $result-&gt;fetch_assoc()) {
        for ($i = 1; $i &lt;= 8; $i++) {
            $nameKey = 's' . $i . 'name';
            $fileKey = 's' . $i . 'file';

            // Check if both name and file are set and not empty
            if (isset($row[$nameKey]) &amp;&amp; isset($row[$fileKey]) &amp;&amp; !empty($row[$nameKey]) &amp;&amp; !empty($row[$fileKey])) {
                $filesExist = true;
                break; // Exit the loop if any file is found
            }
        }

        if ($filesExist) {
            break; // Exit the loop if any file is found
        }
    }

    // If files exist, display the heading &quot;Documents&quot; and the table
    if ($filesExist) {
        echo '&lt;div class=&quot;col-sm-12 mb-20&quot;&gt;
        &lt;h2&gt;Documents&lt;/h2&gt;
    &lt;/div&gt;';
        echo '&lt;table&gt;';
        echo '&lt;tr&gt;
                &lt;th&gt;Document Name&lt;/th&gt;
                &lt;th&gt;Download&lt;/th&gt;
              &lt;/tr&gt;';

        // Display each file in the table
        foreach ($result as $row) {
            for ($i = 1; $i &lt;= 8; $i++) {
                $nameKey = 's' . $i . 'name';
                $fileKey = 's' . $i . 'file';

                // Check if both name and file are set and not empty
                if (isset($row[$nameKey]) &amp;&amp; isset($row[$fileKey]) &amp;&amp; !empty($row[$nameKey]) &amp;&amp; !empty($row[$fileKey])) {
                    echo '
                    &lt;tr&gt;
                        &lt;td&gt;'.$row[$nameKey].'&lt;/td&gt;
                        &lt;td&gt;&lt;a href=&quot;admin/assets/pdfs/combokits/'.$row[$fileKey].'&quot; class=&quot;btn btn-primary&quot;&gt;Download&lt;/a&gt;&lt;/td&gt;
                    &lt;/tr&gt;';
                }
            }
        }

        echo '&lt;/table&gt;';
    }
}
?&gt;

                &lt;/div&gt;



            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/main&gt;
    &lt;?php include 'includes/footer.php'; ?&gt;
    
    &lt;!-- Vendor JS--&gt;
    &lt;script src=&quot;assets/js/vendor/modernizr-3.6.0.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/vendor/jquery-3.6.0.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/vendor/jquery-migrate-3.3.0.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/vendor/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/slick.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/jquery.syotimer.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/wow.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/slider-range.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/perfect-scrollbar.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/magnific-popup.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/select2.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/waypoints.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/counterup.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/jquery.countdown.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/images-loaded.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/isotope.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/scrollup.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/jquery.vticker-min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/jquery.theia.sticky.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/js/plugins/jquery.elevatezoom.js&quot;&gt;&lt;/script&gt;
    &lt;!-- Template  JS --&gt;
    &lt;script src=&quot;./assets/js/main.js?v=5.6&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;./assets/js/shop.js?v=5.6&quot;&gt;&lt;/script&gt;
&lt;/body&gt;

&lt;/html&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fu885320773%2Fdomains%2Fsugatu.in%2F.trash'>⬅ Back to Directory</a>