|
Server IP : 82.112.239.40 / Your IP : 216.73.216.81 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0777) : /home/u641149403/domains/uniformindia.co.in/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// Start output buffering
ob_start();
include('connect.php');
$slug = $_GET['slug'];
$subcategory_data = $con->query("SELECT * FROM parent_category WHERE parent_slug='$slug'");
$res_subcat=mysqli_query($con,$subcat);
$subcategory=mysqli_fetch_assoc($subcategory_data);
$cid=$subcategory['cat_id'];
$subid=$subcategory['id'];
$title=$subcategory['parent_name'];
$cookie_name = $subid.'school';
$cookie_value = $title;
$expires = time() + 86400;
setcookie($cookie_name, $cookie_value, $expires, "/");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title><?php echo htmlspecialchars($title); ?> - Buy Uniform Online</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="Buy <?php echo htmlspecialchars($title); ?> uniforms online from Uniform India. Get high-quality school uniforms delivered to your doorstep.">
<meta name="keywords" content="<?php echo htmlspecialchars($title); ?> uniform, buy school uniform online, school dress, online uniform store">
<meta property="og:title" content="<?php echo htmlspecialchars($title); ?> - Buy Uniform Online">
<meta property="og:description" content="Order your <?php echo htmlspecialchars($title); ?> uniforms online from Uniform India. Fast delivery & quality service.">
<meta property="og:type" content="website">
<meta property="og:url" content="https://uniformindia.co.in<?php echo htmlspecialchars($url); ?>">
<meta property="og:image" content="images/uniform_india.jpg">
<meta name="twitter:title" content="<?php echo htmlspecialchars($title); ?> - Buy Uniform Online">
<meta name="twitter:description" content="Shop <?php echo htmlspecialchars($title); ?> uniforms online. Order now and get doorstep delivery from Uniform India.">
<meta name="twitter:card" content="summary_large_image">
<meta name="twitter:url" content="https://uniformindia.co.in<?php echo htmlspecialchars($url); ?>">
<meta name="twitter:image" content="images/uniform_india.jpg">
<?php
include('header.php');
?>
<link rel="stylesheet" type="text/css" href="css/products.css">
<?php
$subcat="SELECT * FROM parent_category WHERE subcat_id='$cid'";
$res_subcat=mysqli_query($con,$subcat);
$num_count=mysqli_num_rows($res_subcat);
if ($num_count==0) { ?>
<div class="no_data text-center mb-3">
<img src="images/no_data_found.gif">
<h3><b>No Data Found</b></h3>
</div>
<?php }else{ ?>
<?php $q_sub_cat="SELECT * FROM parent_category WHERE cat_id='$cid'";
$sub_cat_id="SELECT * FROM parent_category WHERE id='$subid'";
$res_sub_cat=mysqli_query($con,$q_sub_cat);
$ressub_cat=mysqli_query($con,$sub_cat_id);
$parent_row=mysqli_fetch_array($ressub_cat);
$q_cat="SELECT * FROM subcategory WHERE category_id='$cid'";
$res_cat=mysqli_query($con,$q_cat);
$row_cat=mysqli_fetch_array($res_cat);
?>
<section class="ftco-section ftco-category ftco-no-pt " >
<div class="container-fluid">
<div class="heading text-center my-lg-4 mb-4">
<h3 class="font-weight-bold theme-color"><?php echo $row_cat['name']; ?> (<?php echo $parent_row['parent_name']; ?>) <img src="admin/<?=$parent_row['image']?>" class="school_logo"> </h3>
</div>
<div class="products_items">
<div class="row ">
<?php
if($subid){
$querycat="select * from products where products.parent_id=$subid";
}
else{
$querycat="select * from products where products.category_id=$cid";
}
$resp=mysqli_query($con,$querycat);
$num_count=mysqli_num_rows($resp);
if ($num_count==0) { ?>
<div class="no_data text-center mb-3 w-100">
<img src="images/no_data_found.gif">
<h3><b>No Data Found</b></h3>
</div><?php }else{
while($rowap=mysqli_fetch_array($resp))
{
$rvw=$con->query("SELECT SUM(rating) as total,count('rating') as total_rating FROM reviews WHERE product_id='".$rowap['id']."'");
$review_avg=mysqli_fetch_assoc($rvw);
$total_rating=$review_avg['total_rating'];
$total = $review_avg['total'];
$avg = $total/$total_rating;
if ($review_avg['total']==0) {
$avg = 0;
}
if ($avg==4) {
$badge = 'badge-warning';
}elseif($avg<=3){
$badge='badge-danger';
}else{
$badge='badge-success';
}
?>
<div class="col-lg-3">
<div class="card">
<?php
$prid=$rowap['id'];
$query="SELECT * FROM product_variant WHERE product_id='$prid'";
$res=mysqli_query($con,$query);
$query="SELECT * FROM product_variant WHERE product_id='$prid'";
$new_res=mysqli_query($con,$query);
$num=mysqli_num_rows($res);
$rowjoin=mysqli_fetch_assoc($res);
?>
<center>
<div id="ribbon">
<span class="ribbon3"><?php $dis=intval($rowjoin['price'])-intval($rowjoin['discounted_price']);
if($dis>0){ echo floor($dis*100/$rowjoin['price']);} else{ echo '0';} ?>% off</span>
</div>
<div class="wishlist">
<?php
if (isset($_SESSION['userid'])) {
$sql = "SELECT * FROM wishlist WHERE product_id='".$rowap['id']."' AND user_id='".$_SESSION['userid']."'";
$wish=mysqli_query($con,$sql);
$num_rows=mysqli_num_rows($wish);
if($num_rows > 0){
$rows=mysqli_fetch_assoc($wish);
echo '<span onclick="wishlist_del('.$rows["id"].')"><i style="color:red;" class="fa fa-heart" data-toggle="tooltip" data-placement="top" title="Remove Wishlist"></i></span>';
}else{
echo '<span onclick="wishlist('.$rowap["id"].')"><i class="fa fa-heart" data-toggle="tooltip" data-placement="top" title="Add To Wishlist"></i></span>';
}
}else{
echo '<a href="login.php" class="add_to_wishlist" data-toggle="tooltip" data-placement="top" title="Add To Wishlist"><i class="fa fa-heart"></i></a>';
}
?>
</div>
<a class="fr-img" href="product/<?=$rowap['slug'];?>">
<img src="admin/<?php echo $rowap['image']; ?>" alt="image" ></center>
<span class="ind-icon">
<?php if(intval($rowap['indicator'])==1){
echo '<span class=" veg-icon"><img src="images/vegicon.svg"></span>';
}
if(intval($rowap['indicator'])==2){
echo '<span class=" non-veg-icon"></span>';
} ?>
</span>
</a>
<div class="container">
<a href="product/<?=$rowap['slug'];?>">
<h4 class="prname" title="<?=$rowap['name'];?>">
<?php if (strlen($rowap['name']) <=30) {
echo $rowap['name'];
} else {
echo substr($rowap['name'], 0, 30) . '...';
} ?>
</h4>
</a>
<div class="cities text-left mb-2">
<?php
$cities=$con->query("SELECT * FROM city");
while($city=mysqli_fetch_array($cities)){
?>
<span><?=$city['name'];?></span>
<?php } ?>
</div>
<div class="rating text-left">
<span class="badge <?=$badge;?>"><?=round($avg,1);?> <i class="fa fa-star"></i></span>
<?php if($rowap['assured']==1){ ?><span class="float-right badge badge-primary"><img src="images/assured.png"> Assured</span><?php } ?>
</div>
<a class="fr-img" href="product/<?=$rowap['slug'];?>">
<div class="row mb-2">
<div class="dsc_price col-md-12"><span class="no-cut mr-2">₹<?php echo $rowjoin['discounted_price'];?> </span> <del class="cut-prc" style="color:gray;"><span style="color:gray;">₹<?php echo $rowjoin['price'];?> </span></del></div>
</div>
</a>
</div>
</div>
</div>
<?php
} }?>
</div>
</div>
</div>
</div>
</center>
</div>
</section>
<?php } ?>
<?php include('footer.php');?>
<script type="text/javascript">
function wishlist(e) {
var user_id=<?php echo $_SESSION['userid']?>;
$.ajax({
url: "add_wishlist.php",
type: "POST",
data: {
user_id: user_id,prod_id:e,
},
success: function(response){
alert(response);
location.reload();
},
})
}
function wishlist_del(e) {
$.ajax({
url: "add_wishlist.php",
type: "POST",
data: {
delete_id: e,
},
success: function(response){
alert(response);
location.reload();
},
})
}
</script>