window.location.href='https://couponclap.com/';";
exit;
}
$query = mysqli_query($con, "
SELECT * FROM posts
WHERE LOWER(REPLACE(slug,' ','-')) = '$slug'
");
$details = mysqli_fetch_assoc($query);
if(empty($details)){
echo "";
exit;
}else{
$posted_id = $details['id'];
$query_used = "UPDATE posts SET usedno = usedno + 1 WHERE id = '$posted_id'";
mysqli_query($con, $query_used);
if(isset($_SESSION['logged']) && $_SESSION['logged'] == true){
$user_id = $_SESSION['user_id'];
$order_sql = "INSERT INTO `order` (user_id, posted_id) VALUES ('$user_id', '$posted_id') ON DUPLICATE KEY UPDATE user_id = user_id";
mysqli_query($con, $order_sql);
// click count
$click_sql = "INSERT INTO logged_click (user_id, posted_id, click_count) VALUES ('$user_id', '$posted_id', 1) ON DUPLICATE KEY UPDATE click_count = click_count + 1";
mysqli_query($con, $click_sql);
}
?>
<?php echo $details['title'];?>
![<?php echo $details['title'];?>](https://couponclap.com/images/blogs/coupon/<?php echo $details['image_big']; ?>)
![<?php echo $result_stores_d['store_name']; ?>](https://couponclap.com/images/uploads/stores/<?php echo $result_stores_d['store_image']; ?>)
![<?php echo $row_today_deails['title']; ?>](https://couponclap.com/images/blogs/coupon/<?php echo $row_today_deails['image_big']; ?>)