Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.0.30

User:

u885320773

Directory:

/home/u885320773/domains/sugatu.in/public_html

Free Space:

2.65 TB

🔧 Quick Actions

✏️ Editing: products.php

<!DOCTYPE html>
<html class="no-js" lang="en">

<head>
     
<script async src="https://www.googletagmanager.com/gtag/js?id=G-ZR6RQCSW06"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

gtag('config', 'G-ZR6RQCSW06');
</script>

<?php
include 'admin/config.php';

$cname = '';
$metatitle = '';
$metakeywords = '';
$metadescription = '';

if (isset($_GET['catid']) && is_numeric($_GET['catid'])) {
    $catid = (int) $_GET['catid'];

$sql3 = "SELECT cname, metatitle, metakeywords, metadescription 
             FROM productcategory 
             WHERE id = $catid";

$result3 = $conn->query($sql3);

if ($result3 && $result3->num_rows > 0) {
        $row3 = $result3->fetch_assoc();
        $cname = $row3['cname'] ?? '';
        $metatitle = $row3['metatitle'] ?? '';
        $metakeywords = $row3['metakeywords'] ?? '';
        $metadescription = $row3['metadescription'] ?? '';
    }
}
?>

.product-img a {
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    bottom: 0;
}

.product-img img {
    width: 100%;
    height: 100%;
    object-fit: cover; /* Ensures the image covers the container without distortion */
    position: absolute;
    
}
.widget-category-2 ul li {
    padding: 5px;
    margin: 0 0 5px 0;}

.widget-category-2 ul li a {
        font-size:12px;
        text-transform: lowercase; /* Converts all text to lowercase first */
    text-transform: capitalize; /* Capitalizes the first letter of each word */
}
.product-cart-wrap .product-img-action-wrap {
    padding: 10px;
}

.product-cart-wrap .product-content-wrap h2 {
    font-size: 14px;
    font-weight: 600;
    height: 23px;
}

.product-cart-wrap .product-content-wrap .product-price span.old-price {
    font-size: 13px;
    margin: 0px 0 0 3px;
font-weight:600}
    .product-cart-wrap .product-content-wrap .product-price span {
        font-size: 15px;}
 h1{font-size:16px !important;}
 p{margin-bottom:10px;}
    </style>
</head>

<?php
                    if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_REQUEST['catid'])) {
  
                        $catid = $_REQUEST['catid'];

include 'admin/config.php';

// Fetch Parent Category Name
                        $sql2 = "SELECT cname FROM productcategory WHERE id = '$catid'";
                        $result2 = $conn->query($sql2);
                        if ($result2->num_rows > 0) {
                            while ($row = $result2->fetch_assoc()) {
                                $CategoryName = $row['cname'];
                            }
                        }

$sqll="SELECT 
    p.id AS pid, 
    p.gmain, 
    p.g1, 
    p.ptitle, 
    pc1.cname AS parentCategory, 
    pc2.cname AS subCategory, 
    p.discounterprice, 
    p.mrp 
FROM 
    products p
LEFT JOIN 
    productcategory pc1 ON p.parentCategory = pc1.id
LEFT JOIN 
    productcategory pc2 ON p.subCategory = pc2.id
WHERE 
    p.parentCategory = $catid 
    AND p.status = 'Published'
ORDER BY 
    RAND();
";

$sqlll="SELECT * FROM products WHERE parentCategory = $catid";
                    }

if ($_SERVER["REQUEST_METHOD"] == "GET" && isset($_REQUEST['subcatid'])) {
  
                        $subcatid = $_REQUEST['subcatid'];

include 'admin/config.php';

// Fetch Parent Category Name
                        $sql2 = "SELECT cname FROM productcategory WHERE id = '$subcatid'";
                        $result2 = $conn->query($sql2);
                        if ($result2->num_rows > 0) {
                            while ($row = $result2->fetch_assoc()) {
                                $CategoryName = $row['cname'];
                            }
                        }

$sqll="SELECT 
    p.id AS pid, 
    p.gmain, 
    p.g1, 
    p.ptitle, 
    pc1.cname AS parentCategory, 
    pc2.cname AS subCategory, 
    p.discounterprice, 
    p.mrp 
FROM 
    products p
LEFT JOIN 
    productcategory pc1 ON p.parentCategory = pc1.id
LEFT JOIN 
    productcategory pc2 ON p.subCategory = pc2.id
WHERE 
    p.subCategory = $subcatid 
    AND p.status = 'Published'
ORDER BY 
    RAND();
";

$sqlll="SELECT * FROM products WHERE subCategory = $subcatid";
                    }

include 'admin/config.php';

$sql = $sqlll;
                    $result = $conn->query($sql);

if ($result->num_rows > 0) {
                        $row = $result->fetch_assoc();
                        // Populate variables with product details
                        $pid = $row['id'];
                        $ptitle = $row['ptitle'];
                        $features = $row['features'];
                        $description = $row['description'];
                        $technical = $row['technical'];
                        $gmain = $row['gmain'];
                        $g1 = $row['g1'];
                        $g2 = $row['g2'];
                        $g3 = $row['g3'];
                        $g4 = $row['g4'];
                        $g5 = $row['g5'];
                        $g6 = $row['g6'];
                        $costprice = $row['costprice'];
                        $marginpercent = $row['marginpercent'];
                        $mrp = $row['mrp'];
                        $discountpercent = $row['discountpercent'];
                        $discounterprice = $row['discounterprice'];
                        $category_id = $row['parentCategory'];
                        $sub_category_id = $row['subCategory'];
                        $status = $row['status'];
                        $vendor_id = $row['vendor'];
                        $manufacturer = $row['manufacturer'];
                        $warehouse_id = $row['warehouse'];
                        $sku = $row['sku'];
                        $hsn = $row['hsn'];
                    } else {
                        $productscount=0;
                    }

<?php
                        include 'admin/config.php';

// Fetching products from the database
                        $query = $sqll;

$result = mysqli_query($conn, $query);

if ($result && mysqli_num_rows($result) > 0) {
                            while ($row = mysqli_fetch_assoc($result)) {
                                $slug = createSlug($row['ptitle']);
                                // Outputting HTML with PHP variables
                                ?>
                                <div class="col-lg-3 col-md-4 col-6 col-sm-6">
                                    <div class="product-cart-wrap mb-30 wow animate__animated animate__fadeIn" data-wow-delay=".1s">
                                        <div class="product-img-action-wrap">
                                            <div class="product-img product-img-zoom">
                                                <a href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>">
                                                    <img class="default-img" src="admin/assets/imgs/products/<?php echo $row['gmain']; ?>" alt="" / >
                                                  
                                                </a>
                                            </div>
                                            <div class="product-action-1">
                                                <a aria-label="View Details" class="action-btn" href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>"><i class="fi-rs-eye"></i></a>
                                            </div>
                                        </div>
                                        <div class="product-content-wrap">
                                           
                                            <h2>
    <a href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>">
        <?php
        $title = $row['ptitle'];
        if (strlen($title) > 46) {
            echo substr($title, 0, 46) . '...';
        } else {
            echo $title;
        }
        ?>
    </a>
</h2>
                                            <div class="product-card-bottom">
                                                <div class="product-price">
                                                    <span>₹<?php echo $row['discounterprice']; ?></span>
                                                    <span class="old-price">₹<?php echo $row['mrp']; ?></span>
                                                </div>
                                                <div class="add-cart">
                                                    
                                                    <a href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>" class="add add-to-cart" data-product-id="<?php echo $row['pid']; ?>" href="#"><i class="fi-rs-eye mr-5"></i><span class="m-hide">Details</span></a>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <?php
                            }
                        } else {
                            // Handle no results found
                            echo "No products found";
                        }

// Close the database connection
                        mysqli_close($conn);
                        ?>

</div>
                    
                    
                    
                    
                    
                    
                    
                    
                    <section class="product-tabs section-padding position-relative" style="padding-top: 0px; margin-top:20px;">
            <div class="container">
                <div class="section-title style-2 wow animate__animated animate__fadeIn">
                    <h3>Popular Products</h3>
                    <ul class="nav nav-tabs links" id="myTab" role="tablist">
                        <li class="nav-item" role="presentation">
                           
                        </li>
                        
                    </ul>
                </div>
                
                <div class="tab-content" id="myTabContent">
                    <div class="tab-pane fade show active" id="tab-one" role="tabpanel" aria-labelledby="tab-one">
                        <div class="row product-grid-4">

<?php
                        include 'admin/config.php';

// Fetching products from the database
                        $query = "SELECT 
    p.id as pid, 
    p.gmain, 
    p.g1, 
    p.ptitle, 
    pc1.cname AS parentCategory, 
    pc2.cname AS subCategory, 
    p.discounterprice, 
    p.mrp 
FROM 
    products p
LEFT JOIN 
    productcategory pc1 ON p.parentCategory = pc1.id
LEFT JOIN 
    productcategory pc2 ON p.subCategory = pc2.id
WHERE 
    p.status = 'Published'
ORDER BY 
    RAND()
LIMIT 12;
";

$result = mysqli_query($conn, $query);

if ($result && mysqli_num_rows($result) > 0) {
                            while ($row = mysqli_fetch_assoc($result)) {
                                $slug = createSlug($row['ptitle']);
                                // Outputting HTML with PHP variables
                                ?>
                                <div class="col-lg-3 col-md-4 col-6 col-sm-6">
                                    <div class="product-cart-wrap mb-30 wow animate__animated animate__fadeIn" data-wow-delay=".1s">
                                        <div class="product-img-action-wrap">
                                            <div class="product-img product-img-zoom">
                                                <a href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>">
                                                    <img class="default-img" src="admin/assets/imgs/products/<?php echo $row['gmain']; ?>" alt="" / >
                                                    
                                                </a>
                                            </div>
                                            <div class="product-action-1">
                                                <a aria-label="View Details" class="action-btn" href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>"><i class="fi-rs-eye"></i></a>
                                            </div>
                                        </div>
                                        <div class="product-content-wrap">
                                            <div class="product-category">
                                               
                                            </div>
                                            <h2>
    <a href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>">
        <?php
        $title = $row['ptitle'];
        if (strlen($title) > 46) {
            echo substr($title, 0, 46) . '...';
        } else {
            echo $title;
        }
        ?>
    </a>
</h2>
                                            <div class="product-card-bottom">
                        <div class="product-price">
                            <span>₹<?php echo $row['discounterprice']; ?></span><br>
                            <span class="old-price">₹<?php echo $row['mrp']; ?></span>
                        </div>
                        <div class="add-cart" style="margin-top:15px;">
                                                    
                                                    <a href="product-details.php?<?php echo $slug; ?>&id=<?php echo $row['pid']; ?>" class="add add-to-cart" data-product-id="<?php echo $row['pid']; ?>" href="#"><i class="fi-rs-eye mr-5"></i><span class="m-hide">Details</span></a>
                                                </div>
                    </div>
                                        </div>
                                    </div>
                                </div>
                                <?php
                            }
                        } else {
                            // Handle no results found
                            echo "No products found";
                        }

// Close the database connection
                        mysqli_close($conn);
                        ?>
                            
                            
                           
                            
                        </div>
                        
                    </div>
                    
                </div>
                
            </div>
        </section>

</div>

<div class="col-lg-1-5 primary-sidebar sticky-sidebar">

<div class="sidebar-widget widget-category-2 mb-30">
        <?php
            include 'admin/config.php';

// Get the catid from the GET request
            $parentid = isset($_GET['catid']) && is_numeric($_GET['catid']) ? intval($_GET['catid']) : 0;

if (isset($_GET['catid'])) {
                $parentid = $_GET['catid'];
                $queryy="SELECT cname FROM productcategory WHERE id = $parentid";
            } elseif (isset($_GET['subcatid'])) {
                $parentid = $_GET['subcatid'];
                $queryy="SELECT cname FROM productcategory WHERE parentid = $parentid";
            } else {
                $parentid = null; // Optionally, you can assign a default value if neither is set.
            }

// Fetch the category name for the given catid
            $sqlName = $queryy;
            $resultName = $conn->query($sqlName);

// Default category name
            $categoryTitle = "Sub Category";

if ($resultName && $resultName->num_rows > 0) {
                $rowName = $resultName->fetch_assoc();
                $categoryTitle = $rowName['cname'];
            }

// Display the category name as the section title
            echo '<h5 class="section-title style-1 mb-30">' . htmlspecialchars($categoryTitle) . '</h5>';
        ?>
        <ul>
        <?php

if (isset($_GET['catid'])) {
    $parentid = $_GET['catid'];
    $query="SELECT id, cimage, cname FROM productcategory WHERE parentid=$parentid";
} elseif (isset($_GET['subcatid'])) {
    $parentid = $_GET['subcatid'];
    $query="SELECT id, cimage, cname FROM productcategory WHERE id=$parentid";
} else {
    $parentid = null; // Optionally, you can assign a default value if neither is set.
}

include 'admin/config.php';

// SQL query to fetch data from the table
                                $sql = $query;
                                // echo $sql;
                                $result = $conn->query($sql);

if ($result->num_rows > 0) {
                                    while($row = $result->fetch_assoc()) {
                                        $catidq=$row["id"];
                                        $cimage=$row["cimage"];
                                        $cname=$row["cname"];

echo '<li>
                                                <a href="products.php?subcatid='.$catidq.'"> <img src="admin/assets/imgs/productcategories/'.$cimage.'" alt="" / style="height:30px; width:30px;">' . $cname . '</a>
                                            </li>
                                            
                                        ';
                                    }
                                
                                } else {
                                    echo "0 results";
                                }

// Close connection
                                $conn->close();
                            ?>
        </ul>
    </div>

<div class="sidebar-widget widget-category-2 mb-30">
                        <h5 class="section-title style-1 mb-30">Category</h5>
                        <ul>

<?php
                                include 'admin/config.php';

// SQL query to fetch data from the table
                                $sql = "SELECT id, cimage, cname FROM productcategory WHERE parentid=0";

$result = $conn->query($sql);

$sqlq = "SELECT COUNT(*) as count_records FROM products WHERE parentCategory = $catidq";
                                        $resultq = $conn->query($sqlq);

if ($resultq) {
                                            $row = $resultq->fetch_assoc();
                                            $count_records = $row['count_records'];
                                            
                                        } else {
                                            // Handle query error
                                            echo "Error: " . $conn->error; // Output the specific error for debugging
                                        }

if($count_records==0){
                                            $catdisplay='style="display:none;"';
                                        } else {
                                            $catdisplay='';
                                        }
                                    
                                        echo '<li '.$catdisplay.'>
                                                <a href="products.php?catid='.$catidq.'"> <img src="admin/assets/imgs/productcategories/'.$cimage.'" alt="" / style="height:30px; width:30px;">' . $cname . '</a><span class="count">'.$count_records.'</span>
                                            </li>
                                            
                                        ';
                                    }
                                
                                } else {
                                    echo "0 results";
                                }

// Close connection
                                $conn->close();
                            ?>

</ul>
                    </div>
                    
                    
                   
                    <div class="banner-img mb-sm-0">
                                    <img src="assets/imgs/banner/banner-3.jpg" alt="" />
                                    <div class="banner-text">
                                        <h4 style="color:#1e2d7e">Solar Consultancy<br /> Services</h4>
                                        <a href="consultancy/index.php" class="btn btn-xs">Click Here <i class="fi-rs-arrow-small-right"></i></a>
                                    </div>
                                </div>
                </div>
            </div>
        </div>

</main>
    <?php include 'includes/footer.php'; ?>
    
    
    <script src="assets/js/vendor/modernizr-3.6.0.min.js"></script>
    <script src="assets/js/vendor/jquery-3.6.0.min.js"></script>
    <script src="assets/js/vendor/jquery-migrate-3.3.0.min.js"></script>
    <script src="assets/js/vendor/bootstrap.bundle.min.js"></script>
    <script src="assets/js/plugins/slick.js"></script>
    <script src="assets/js/plugins/jquery.syotimer.min.js"></script>
    <script src="assets/js/plugins/wow.js"></script>
    <script src="assets/js/plugins/slider-range.js"></script>
    <script src="assets/js/plugins/perfect-scrollbar.js"></script>
    <script src="assets/js/plugins/magnific-popup.js"></script>
    <script src="assets/js/plugins/select2.min.js"></script>
    <script src="assets/js/plugins/waypoints.js"></script>
    <script src="assets/js/plugins/counterup.js"></script>
    <script src="assets/js/plugins/jquery.countdown.min.js"></script>
    <script src="assets/js/plugins/images-loaded.js"></script>
    <script src="assets/js/plugins/isotope.js"></script>
    <script src="assets/js/plugins/scrollup.js"></script>
    <script src="assets/js/plugins/jquery.vticker-min.js"></script>
    <script src="assets/js/plugins/jquery.theia.sticky.js"></script>
    <script src="assets/js/plugins/jquery.elevatezoom.js"></script>
    
    <script src="./assets/js/main.js?v=5.6"></script>
    <script src="./assets/js/shop.js?v=5.6"></script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: products.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation