<h2>File Contents: /home/u885320773/domains/sugatu.in/.trash/admin/combokit-products.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/.trash/admin/combokit-products.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php include 'includes/check-session.php'; ?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
    &lt;head&gt;
        &lt;meta charset=&quot;utf-8&quot; /&gt;
        &lt;title&gt;Add Combo Kit Products - Sugatu&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 href=&quot;assets/css/main.css?v=1.1&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&gt;
    &lt;/head&gt;

    &lt;body&gt;
        &lt;div class=&quot;screen-overlay&quot;&gt;&lt;/div&gt;
        &lt;!--==========  SIDEBAR LOGO AND MENU  =============--&gt;
        &lt;?php include 'includes/sidebar.php'; ?&gt;
        &lt;main class=&quot;main-wrap&quot;&gt;
            &lt;!--==========  HEADER  =============--&gt;
            &lt;?php include 'includes/header.php'; ?&gt;
            &lt;section class=&quot;content-main&quot;&gt;
                &lt;div class=&quot;content-header&quot;&gt;
                    &lt;div&gt;
                        &lt;?php	
                            if(isset($_GET['cktitle'])) {
                                $cktitle=$_GET['cktitle'];
                            } 
                        ?&gt;
                        &lt;?php	
                            if(isset($_GET['combokitid'])) {
                                $combokitid=$_GET['combokitid'];
                            } 
                        ?&gt;
                        &lt;h2 class=&quot;content-title card-title&quot;&gt;Add Combo Kit Products for &lt;?php echo $cktitle ?&gt;&lt;/h2&gt;
                        
                    &lt;/div&gt;
                    &lt;!--&lt;div&gt;
                        &lt;input type=&quot;text&quot; placeholder=&quot;Search Categories&quot; class=&quot;form-control bg-white&quot; /&gt;
                    &lt;/div&gt; --&gt;
                &lt;/div&gt;
                &lt;div class=&quot;card&quot;&gt;
                    
                    &lt;div class=&quot;card-body&quot;&gt;
                    &lt;?php	if(isset($_GET['add'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Saved Successfully.&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
        &lt;?php	if(isset($_GET['edit'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Successfully Edited&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
				&lt;?php	if(isset($_GET['delete'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Successfully Deleted&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
								&lt;?php	if(isset($_GET['error'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Error While Adding Customer&lt;/strong&gt;. Make sure you are entering unique ID and Email.
  &lt;/div&gt;';
				} ?&gt;

                        &lt;div class=&quot;row&quot;&gt;
                            &lt;div class=&quot;col-md-3&quot;&gt;
                                &lt;form method=&quot;post&quot; action=&quot;process/add-combokit-product.php&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;combokitid&quot; value=&quot;&lt;?php echo $combokitid ?&gt;&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;combokittitle&quot; value=&quot;&lt;?php echo $cktitle ?&gt;&quot;&gt;
                                    &lt;div class=&quot;mb-4&quot;&gt;
                                        &lt;label for=&quot;product_name&quot; class=&quot;form-label&quot;&gt;Select Product&lt;/label&gt;
                                        
                                        &lt;?php
                                        include 'config.php';
                                        $query = &quot;SELECT id, ptitle FROM products&quot;;
                                        $result = mysqli_query($conn, $query);
                                        
                                        // Check if the query was successful
                                        if ($result) {
                                            echo '&lt;select name=&quot;productid&quot; required class=&quot;form-control&quot; id=&quot;product_name&quot; /&gt;&lt;option&gt;&lt;/option&gt;';
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                echo '&lt;option value=&quot;' . htmlspecialchars($row['id']) . '&quot;&gt;' . htmlspecialchars($row['ptitle']) . '&lt;/option&gt;';
                                            }
                                            echo '&lt;/select&gt;';
                                            mysqli_free_result($result);
                                        } else {
                                            echo 'Error fetching product list: ' . mysqli_error($conn);
                                        }
                                        
                                        // Close the database connection when done
                                        mysqli_close($conn);
                                        ?&gt;
                                        &lt;/select&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;mb-4&quot;&gt;
                                        &lt;label for=&quot;pqty&quot; class=&quot;form-label&quot;&gt; Enter Quantity&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; placeholder=&quot;Type here&quot; name=&quot;pquantity&quot; required class=&quot;form-control&quot; id=&quot;pqty&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt; Can Customer Change Quantity?&lt;/label&gt;&lt;br&gt;
                                        &lt;div class=&quot;form-check&quot;&gt;
                                            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;changeqty&quot; id=&quot;flexRadioDefault1&quot; value=&quot;yes&quot;&gt;
                                            &lt;label class=&quot;form-check-label&quot; for=&quot;flexRadioDefault1&quot;&gt;
                                                Yes
                                            &lt;/label&gt;
                                        &lt;/div&gt;
                                        &lt;div class=&quot;form-check&quot;&gt;
                                            &lt;input class=&quot;form-check-input&quot; type=&quot;radio&quot; name=&quot;changeqty&quot; id=&quot;flexRadioDefault2&quot; checked value=&quot;no&quot;&gt;
                                            &lt;label class=&quot;form-check-label&quot; for=&quot;flexRadioDefault2&quot;&gt;
                                                No
                                            &lt;/label&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                   
                                   
                                    &lt;div class=&quot;d-grid&quot;&gt;
                                        &lt;button class=&quot;btn btn-primary&quot;&gt;Add Product&lt;/button&gt;
                                    &lt;/div&gt;
                                &lt;/form&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-md-9&quot;&gt;
                                &lt;div class=&quot;table-responsive&quot;&gt;
                                &lt;?php
include 'config.php';

// SQL query to fetch data from the table
$sql = &quot;SELECT cp.id, cp.changeqty, cp.combokitid, cp.productid, cp.pquantity, p.ptitle, p.gmain, p.discounterprice 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
    echo '&lt;table class=&quot;table table-hover&quot;&gt;
                &lt;thead&gt;
                    &lt;tr&gt;
                        &lt;th&gt;Image&lt;/th&gt;
                        &lt;th&gt;Product Name&lt;/th&gt;
                        &lt;th&gt;Price&lt;/th&gt;
                        &lt;th&gt;Quantity&lt;/th&gt;
                        &lt;th&gt;Customer Change Qty&lt;/th&gt;
                        &lt;th class=&quot;text-end&quot;&gt;Action&lt;/th&gt;
                    &lt;/tr&gt;
                &lt;/thead&gt;
                &lt;tbody&gt;';
    while($row = $result-&gt;fetch_assoc()) {
        echo '&lt;tr&gt;
                &lt;td&gt;&lt;img src=&quot;assets/imgs/products/' . $row['gmain'] . '&quot; style=&quot;height:70px; width:70px;&quot;&gt;&lt;/td&gt;
                &lt;td&gt;&lt;b&gt;' . $row['ptitle'] . '&lt;/b&gt;&lt;/td&gt;
                &lt;td&gt;' . $row['discounterprice'] . '&lt;/td&gt;
                &lt;td&gt;' . $row['pquantity'] . '&lt;/td&gt;
                &lt;td&gt;' . $row['changeqty'] . '&lt;/td&gt;
                &lt;td class=&quot;text-end&quot;&gt;
                    &lt;div class=&quot;dropdown&quot;&gt;
                        &lt;a href=&quot;#&quot; data-bs-toggle=&quot;dropdown&quot; class=&quot;btn btn-light rounded btn-sm font-sm&quot;&gt; &lt;i class=&quot;material-icons md-more_horiz&quot;&gt;&lt;/i&gt; &lt;/a&gt;
                        &lt;div class=&quot;dropdown-menu&quot;&gt;
                            &lt;a class=&quot;dropdown-item text-danger&quot; href=&quot;process/delete-combokit-product.php?id=' . $row[&quot;id&quot;] . '&amp;combokitid='.$combokitid.'&amp;combokittitle='.$cktitle.'&quot;&gt;Delete&lt;/a&gt;
                        &lt;/div&gt;
                    &lt;/div&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;/div&gt;
                            &lt;/div&gt;
                            &lt;!-- .col// --&gt;
                        &lt;/div&gt;
                        &lt;!-- .row // --&gt;
                    &lt;/div&gt;
                    &lt;!-- card body .// --&gt;
                &lt;/div&gt;
                &lt;!-- card .// --&gt;
            &lt;/section&gt;
            &lt;!-- content-main end// --&gt;
            &lt;footer class=&quot;main-footer font-xs&quot;&gt;
                &lt;div class=&quot;row pb-30 pt-15&quot;&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;script&gt;
                            document.write(new Date().getFullYear());
                        &lt;/script&gt;
                        &amp;copy; Sugatu.
                    &lt;/div&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;div class=&quot;text-sm-end&quot;&gt;All rights reserved&lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/footer&gt;
        &lt;/main&gt;
        &lt;script src=&quot;assets/js/vendors/jquery-3.6.0.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/select2.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/perfect-scrollbar.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/jquery.fullscreen.min.js&quot;&gt;&lt;/script&gt;
        &lt;!-- Main Script --&gt;
        &lt;script src=&quot;assets/js/main.js?v=1.1&quot; type=&quot;text/javascript&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%2Fadmin'>⬅ Back to Directory</a>