-
Notifications
You must be signed in to change notification settings - Fork 0
/
displaytourismplace.php
218 lines (209 loc) · 14.3 KB
/
displaytourismplace.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
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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
<?php
include("header.php");
include("slider.php");
?>
<!-- iqoniq Contant Wrapper Start-->
<div class="iqoniq_contant_wrapper">
<section>
<div class="container">
<!-- iqoniq Heading Start -->
<div class="mg_hotel_hd1">
<h6>Book top Tourism destinations</h6>
<h4>PLACES TO VISIT</h4>
</div>
<!-- iqoniq Heading End -->
<!-- Destination Start -->
<div class="mg_hotel_destination_tab">
<!-- Nav tabs Start -->
<ul class="mg_hotel_nav2" role="tablist">
<?php
$i = 0;
$sqltourism_location = "SELECT * FROM tourism_location WHERE status='Active'";
$qsqltourism_location = mysqli_query($con, $sqltourism_location);
while ($rstourism_location = mysqli_fetch_array($qsqltourism_location)) {
?>
<li role="presentation" <?php if ($i == 0) {
echo " class='active' ";
$i = 1;
} ?>><a href="#tourloc<?php echo $rstourism_location['location_id']; ?>" aria-controls="tourloc<?php echo $rstourism_location['location_id']; ?>" role="tab" data-toggle="tab"><?php echo $rstourism_location['location_name']; ?></a></li>
<?php
}
?>
</ul>
<!-- Nav tabs End -->
<!-- Tab panes Start -->
<div class="tab-content">
<?php
$i = 0;
$sqltourism_location = "SELECT * FROM tourism_location WHERE status='Active'";
$qsqltourism_location = mysqli_query($con, $sqltourism_location);
while ($rstourism_location = mysqli_fetch_array($qsqltourism_location)) {
?>
<div role="tabpanel" class="tab-pane <?php if ($i == 0) {
echo " active ";
$i = 1;
} ?>" id="tourloc<?php echo $rstourism_location['location_id']; ?>">
<!-- Destination Tab Wrap Start -->
<div class="mg_hotel_destination_wrapper">
<div class="row">
<?php
$sqltourism_place = "SELECT tourism_place.*,tourism_location.location_name FROM tourism_place LEFT JOIN tourism_location ON tourism_location.location_id=tourism_place.location_id WHERE tourism_location.location_id='$rstourism_location[0]'";
$qsqltourism_place = mysqli_query($con, $sqltourism_place);
while ($rstourism_place = mysqli_fetch_array($qsqltourism_place)) {
$sqlgallery = "SELECT * FROM gallery WHERE gallerytype='Photo Gallery' AND tourism_placeid='$rstourism_place[0]' AND status='Active'";
$qsqlgallery = mysqli_query($con, $sqlgallery);
$rsgallery = mysqli_fetch_array($qsqlgallery);
if ($rsgallery['upload_file'] == "") {
$img = "images/nophoto.jpg";
} else if (file_exists("imggallery/" . $rsgallery['upload_file'])) {
$img = "imggallery/" . $rsgallery['upload_file'];
} else {
$img = "images/nophoto.jpg";
}
?>
<!-- Hotel Destination Start -->
<div class="col-md-4 col-sm-6">
<div class="mg_hotel_destination fancy-overlay">
<figure>
<img src="<?php echo $img; ?>" alt="" style="width: 358px; height: 224px;" />
<figcaption>
<a class="view_btn" href="" onclick="return false;" data-toggle="modal" data-target="#ModalLoadRecord<?php echo $rstourism_place['tourism_placeid']; ?>">View More</a>
</figcaption>
</figure>
<div class="text">
<div class="mg_destination_hd">
<h5><a href="#"><?php echo $rstourism_place['tourism_place']; ?></a></h5>
<?php /*<a class="no_hotel" href="#">1500 Hotels</a> */ ?>
</div>
<div class="mg_destination_review">
<p>Review Ratings</p>
<div class="rating_down">
<?php
$sqlratings = "SELECT SUM(ratings) as sumratings,count(ratings) as countratings FROM feedback WHERE tourism_placeid='$rstourism_place[0]'";
$qsqlratings = mysqli_query($con, $sqlratings);
$rsratings = mysqli_fetch_array($qsqlratings);
$sumratings = $rsratings['sumratings'];
$countratings = $rsratings['countratings'];
$totratings = 10 * $rsratings['countratings'];
if ($countratings == 0) {
$totpercentage = 0;
} else {
$totpercentage = (100 * $sumratings) / $totratings;
}
?>
<div class="rating_up" style="width:<?php echo $totpercentage; ?>%;"></div>
</div>
</div>
<?php /*
<div class="mg_destination_review">
<p>Egerton House Hotel</p>
<div class="rating_down">
<div class="rating_up" style="width:90%;"></div>
</div>
</div>
*/
?>
</div>
</div>
</div>
<!-- Hotel Destination End -->
<!-- ############################ -->
<!-- Load Records starts here -->
<div class="modal fade" id="ModalLoadRecord<?php echo $rstourism_place['tourism_placeid']; ?>" tabindex="-1" role="dialog">
<div class="modal-dialog login1 login5 login5-1">
<div class="modal-content">
<div class="user-box">
<!--FORM FIELD START-->
<h5><?php echo $rstourism_place['tourism_place']; ?></h5>
<hr>
<div class="mg_input_1">
<!-- iqoniq Mina Banner Start-->
<div class="mg_hotel_banner">
<div class="mg_slider1">
<?php
$sqlgallery = "SELECT * FROM gallery WHERE tourism_placeid='$rstourism_place[tourism_placeid]'";
$qgallery = mysqli_query($con, $sqlgallery);
while ($rsgallery = mysqli_fetch_array($qgallery)) {
?>
<div>
<figure>
<img src="imggallery/<?php echo $rsgallery['upload_file']; ?>" alt="" />
<b style="color: red;"><?php echo $rsgallery['note']; ?></b>
</figure>
</div>
<div>
<figure>
<img src="imggallery/<?php echo $rsgallery['upload_file']; ?>" alt="" />
<b style="color: red;"><?php echo $rsgallery['note']; ?></b>
</figure>
</div>
<?php
}
?>
</div>
</div>
<!-- iqoniq Mina Banner End-->
<p><?php echo $rstourism_place['description']; ?></p>
<p>
<?php
if ($rstourism_place['feature'] != "") {
?>
<b style="color: red;">FEATURES:</b><br>
<?php
}
?>
<?php echo $rstourism_place['feature']; ?>
</p>
</div>
<!--FORM FIELD END-->
</div>
</div>
</div>
</div>
<!-- Load detailed Records ends here -->
<?php
}
?>
</div>
<hr>
<div class="row">
<div class="col-md-12">
<div class="mg_input_1">
<center><a class="mg_btn1" HREF="displayhotel.php?location_id=<?php echo $rstourism_location[0]; ?>" style="cursor: pointer;"><i class="fa fa-hotel"></i>BOOK YOUR JOURNEY HERE...</a></center>
</div>
</div>
</div>
</div>
<!-- Destination Tab Wrap End -->
</div>
<?php
}
?>
</div>
<!-- Tab panes End -->
</div>
<!-- Destination End -->
</div>
</section>
<!-- Call to Action Section Start-->
<section class="mg_travelplan">
<div class="container">
<!-- iqoniq Heading Start -->
<div class="mg_hotel_hd1 white">
<h6>Create a Custom Plan based on your Taste</h6>
<h4>Start making your Travel Plans</h4>
</div>
<!-- iqoniq Heading End -->
<!-- Caption Start -->
<div class="mg_plan_caption">
<p>Visit Lanka, Sri Lanka's new online travel & Tourism promoting site, has a profound understanding of world wide consumers travel needs and preferences. It offers a wide range of holiday packages in Sri Lanka, catering to various segments of travellers. While the dynamic or customized tour and travel packages give consumers an option to create and design their own holiday, the fixed departure holiday packages have a pre-designed itinerary; thus ensuring there is something to meet the holiday needs of every kind of traveller.</p>
</div>
<!-- Caption End -->
</div>
</section>
<!-- Call to Action Section End-->
</div>
<!-- iqoniq Contant Wrapper End-->
<?php
include("footer.php");
?>