-
Notifications
You must be signed in to change notification settings - Fork 0
/
usa.php
59 lines (56 loc) · 1.81 KB
/
usa.php
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
<?php
session_start();
error_reporting(0);
include("connection.php");
$query = "SELECT * FROM collection WHERE country='United States'";
$data = mysqli_query($conn, $query);
$total = mysqli_num_rows($data);
include("inc/header.php");
?>
<li><a href="index.php">Home</a></li>
<li><a href="bangladesh.php">Bangladesh</a></li>
<li><a class="active" href="usa.php">USA</a></li>
<li><a href="australia.php">Australia</a></li>
<li><a href="london.php">London</a></li>
<li><a href="others.php">Other Countries</a></li>
<li class="right"><a href="indexadmin.php">Admin</a></li>
</ul>
</div>
<div class="row">
<div class="col-3 col-s-3 menu">
<ul class="sidenav">
<li style="background-color:#9933cc;">Sort By: </a></li>
<li><a href="yearissued.php">Year Issued</a></li>
<li><a href="stampno.php">Number Of Stamps</a></li>
<li><a href="glued.php">Glued</a></li>
<li><a href="notglued.php">Not Glued</a></li>
</ul>
</div>
<div class="col-6 col-s-9">
<h1>United States</h1>
<div id="rightnav">
<div class="product-list">
<ul>
<?php
if($total !=0){
while($result = mysqli_fetch_assoc($data)){
echo "
<li style='width: 260px;'>
<div class='image'>
<a href=".$result['image']."><img src='".$result['image']."' width='200' height='190'></a>
</div>
<div class='detail'>
<p class='name'>".$result['stamp_name']."</p>";
}
} else {
echo "No record found";
}
"
</div>
</li>";
?>
</ul>
</div>
</div>
</div>
<?php include "inc/footer.php"; ?>