1#@!#!123s

: / home / realadss / .trash /
Filename : listing.php
back
<?php include('admin/connection.php'); 
    $id2 = $_GET['category'] ?? "";
    if($id2 !='')
    {
        $fetch2 = mysqli_query($conn, "select * from decore_category where slug ='$id2'");
        $row2=mysqli_fetch_array($fetch2);
        
        if(!isset($row2['categoryName'])){
            // need to check if category id match

            $fetch2 = mysqli_query($conn, "select slug from decore_category where id ='$id2'");
            $row2 = mysqli_fetch_array($fetch2);
            if(isset($row2['slug']) && $row2['slug'] !='') {
                header("Location: $base_url"."decor-theme/".$row2['slug'], false, 302);
                exit();
            }
            header('location:'.$base_url);
            exit();
        }
    }
    else
    {
        header('location:'.$base_url);
        exit();
    }
?>
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <title><?php echo $row2['categoryName'];?> </title>
        <meta content="width=device-width, initial-scale=1.0" name="viewport">
        <meta content="<?php echo $row2['categoryName'];?>" name="keywords">
        <meta content="<?php echo $row2['categoryName'];?>" name="description">
        <link rel="canonical" href="<?php echo $base_url.$id2; ?>" />
         <?php include 'include/links.php'; ?>
        <?php include 'include/header.php'; ?>
<?php
    $id2 = $_GET['category'];
    $fetch2 = mysqli_query($conn, "select * from decore_category where slug ='$id2'");
    $row2=mysqli_fetch_array($fetch2);
?>
        <!-- Header Start -->
        <div class="container-fluid bg-breadcrumb">
            <div class="container text-center py-5" style="max-width: 900px;">
                <h3 class="text-white mb-2 wow fadeInDown" data-wow-delay="0.1s" style="text-transform: capitalize;"><?php echo $row2['categoryName'];?> </h1>
            </div>
        </div>
        <!-- Header End -->
        <div class="container-fluid service py-5">
            <div class="container-fluid mb-5">
                <div class="row ">
                    <?php 
                     $id = $_GET['category'];
                     $decore = "select * from decore_category where slug ='$id'";
                     $decoresql = mysqli_query($conn, $decore);
                     $decore_fetch = $row=mysqli_fetch_array($decoresql);
                     $decoreid = $row['id'];
                     
                     $cat = "select * from product where Category ='$decoreid'";
                     $catdata = mysqli_query($conn, $cat);
                     while ($row=mysqli_fetch_array($catdata)) { ?> 
                             
                    <div class="col-md-3 col-12 mb-4">
                    <div class="card bg-light shadow product-grid-box">
                        <div class="product-grid-image">
                                <a href="<?php echo $base_url.'decor/'.$row['slug']; ?>">
                                  <img src="<?php echo $base_url ?>admin/<?php echo $row['image'];?>" alt="<?php echo $row['title'];?>">
                            </a>
                        </div>
                        <div class="product-grid-content">
                            <h4 class="m-0 mb-2"><?php echo $row['title'];?> </h4>
                            <p class="m-0"><strong><?php
                                $price3 = $row['price'];
                                if ($price3 ==""){
                                    echo " ";
                                }else{
                                    echo '₹'.$price3.'/-';
                                }
                            ?></strong></p>
                        </div>
                    </div>
                </div>
          <?php }?>
                </div>
            </div>
        </div>
<?php include 'include/footer.php'; ?>