-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathstore2.php
More file actions
128 lines (108 loc) · 6.19 KB
/
store2.php
File metadata and controls
128 lines (108 loc) · 6.19 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta http-equiv="X-UA-Compatible" content="ie=edge" />
<meta name="Description" content="Here you have all the PREVIEWS weekly Ads and deals of stores at your disposal. Adsadora provides Ads for Walgreens, Walmart, Aldi, Kroger and many others." />
<meta name="keywords" content="Latest special offers, weekly flyers, special buys, special offers, catalogues, weekly ads, weekly offers, adsadora, adsadora.com " />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.6.0/css/bootstrap.min.css" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/OwlCarousel2/2.3.4/assets/owl.carousel.min.css" integrity="sha512-tS3S5qG0BlhnQROyJXvNjeEM4UpMXHrQfTGmbQ1gKmelCxlSEBUaxhRBj/EFTzpbP4RVSrpEikbmdJobCvhE3g==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/OwlCarousel2/2.3.4/assets/owl.theme.default.min.css" integrity="sha512-sMXtMNL1zRzolHYKEujM2AqCLUR9F2C4/05cdbxjjLSRvMQIciEPCQZo++nk7go3BtSuK9kfa/s+a4f4i5pLkw==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.2/css/all.min.css" />
<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/Wruczek/Bootstrap-Cookie-Alert@gh-pages/cookiealert.css">
<script src="https://kit.fontawesome.com/595d13cf2d.js" crossorigin="anonymous"></script>
<script data-ad-client="ca-pub-4254949403223799" async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<link rel="icon" href="./assets/images/favicon.png" type="image/gif" sizes="32x32">
<link rel="stylesheet" href="assets/css/style.css" />
<?php
//require _dbconn.php
require('template/_dbconnect.php');
?>
<title>AdsAdora | Weekly Ads, Sales and Ads Preview</title>
<style>
/* Modal Style */
.form-title {
margin: -2rem 0rem 2rem;
}
.subscribe-form {
margin: 0rem 0rem 1rem;
}
/* Modal Style Ends */
</style>
</head>
<body>
<!-- Header Section -->
<header id="header">
<!-- Navigation Bar -->
<nav class="navbar navbar-expand-lg navbar-dark color-second-bg">
<a href="https://adsadora.com/"><img src="./assets/images/logon.png" style="width: 190px; height: 50px; object-fit:cover; margin-top: -7px;" class="img-fluid" alt="" width="100px"></a>
<!-- <a class="navbar-brand font-rale" href="https://adsadora.com/">AdsAdora</a> -->
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav m-auto font-rubik">
<li class="nav-item">
<a class="nav-link" href="https://adsadora.com/">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="category">Categories</a>
</li>
<li class="nav-item">
<a class="nav-link" href="stores">Stores</a>
</li>
<li class="nav-item">
<a class="nav-link" href="weekly-ads">Weekly Ads</a>
</li>
<li class="nav-item">
<a class="nav-link" href="blog/">Blogs</a>
</li>
</ul>
<form class="form-inline my-2 my-lg-0" action="search.php" method="GET">
<input class="form-control mr-sm-2" type="search" placeholder="Search for Stores" name="query" aria-label="Search" required>
<button class="btn btn-outline-dark search-store my-2 my-sm-0" type="submit">Search</button>
</form>
</div>
</nav>
<!-- <div class=" d-flex justify-content-end my-2" style="margin-right: 100px;">
<div class="list-group" id="show-list">
<a href="" class="list-group-item list-group-item-action">Search</a>
<a href="" class="list-group-item list-group-item-action border-1"></a>
<a href="" class="list-group-item list-group-item-action border-1"> </a>
</div>
</div> -->
<!-- Navigation Bar Ends -->
</header>
<!-- Header Section Ends -->
<!-- Main Section -->
<main id="main-site">
<div class="container mt-5">
<h4>Live Weekly Ads</h4>
<?php
include('./template/_dbconnect.php');
$sql = "SELECT * FROM flyers";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
for ($row['start_date']; $row['start_date'] > date('Y/m/d'); $row['start_date'] < date('Y/m/d')) {
$store_name = $row['store_name'];
$url = $store_name;
$url = str_replace("'", "-", $url);
$url = str_replace("&", "_", $url);
$start_date = date("d/m/Y", strtotime($row['start_date']));
$end_date = date("d/m/Y", strtotime($row['end_date']));
echo '<div class="card mt-3" style="width: 18rem; text-align:center;">
<img class="card-img-top" src="admin/image/' . $row['flyers_img'] . '" alt="Card image cap">
<div class="card-body">
<a href="' . $url . '" name="query">
<h5 class="card-title">' . $row['store_name'] . ' Weekly Ad</h5>
</a>
<p class="card-text">' . $start_date . ' - ' . $end_date . '</p>
<a href="#" class="btn btn-primary">View Offer</a>
</div>
</div>
';
}
}
?>
</div>