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: search-results.php

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

<head>
    <meta charset="utf-8" />
    <title>Sugatu - Solar Products</title>
    <meta http-equiv="x-ua-compatible" content="ie=edge" />
    <meta name="description" content="" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <meta property="og:title" content="" />
    <meta property="og:type" content="" />
    <meta property="og:url" content="" />
    <meta property="og:image" content="" />
    
    <link rel="shortcut icon" type="image/x-icon" href="assets/imgs/theme/favicon.png" />
    
    <link rel="stylesheet" href="assets/css/plugins/slider-range.css" />
    <link rel="stylesheet" href="assets/css/main.css?v=5.6" />
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons/font/bootstrap-icons.css" rel="stylesheet">

<?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
                        ORDER BY RAND();";

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

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

$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 ptitle LIKE '%$q%'
                        ORDER BY RAND();";

$sqlll="SELECT * FROM products WHERE ptitle LIKE '%$q%'";
                    }

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;
                    }

<div class="container mb-30">
            <div class="row flex-row-reverse">
                <div class="col-lg-4-5">
                    <div class="shop-product-fillter">
                        <div class="totall-product">
                            <h4>Search Results for <?php echo $q; ?></h4>
                        </div>
                        
                    </div>

<?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)) {
                                // Outputting HTML with PHP variables
                                ?>
                                <div class="col-lg-1-5 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?id=<?php echo $row['pid']; ?>">
                                                    <img class="default-img" src="admin/assets/imgs/products/<?php echo $row['gmain']; ?>" alt="" / >
                                                    <img class="hover-img" src="admin/assets/imgs/products/<?php echo $row['g1']; ?>" alt="" />
                                                </a>
                                            </div>
                                            <div class="product-action-1">
                                                <a aria-label="View Details" class="action-btn" href="product-details.php?id=<?php echo $row['pid']; ?>"><i class="fi-rs-eye"></i></a>
                                            </div>
                                        </div>
                                        <div class="product-content-wrap">
                                            <div class="product-category">
                                                <a href="#"><?php echo $row['parentCategory']; ?></a>, <a href="#"><?php echo $row['subCategory']; ?></a>
                                            </div>
                                            <h2><a href="product-details.php?id=<?php echo $row['pid']; ?>"><?php echo $row['ptitle']; ?></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?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 class="col-lg-1-5 primary-sidebar sticky-sidebar">
                    <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);

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

$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="" />' . $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="#" 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: search-results.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation