File "index.php"
Full Path: /home/custbahd/tourismfraternity.com/listings/1/index.php
File size: 56.7 KB
MIME-type: text/x-php
Charset: utf-8
<?php
session_start();
include_once('../../admin/db/saucerer.php');
if (empty($_GET['url'])) {
header('location:../');
} else {
$url = $_GET['url'];
}
$sql = "SELECT count(*) FROM listings WHERE url='$url'";
$result = $conn->query($sql);
while($row = mysqli_fetch_array($result)) {
if ($row['count(*)']==0) {
header('location:../');
}
}
//selecting data associated with this particular id
$result = mysqli_query($mysqli, "SELECT * FROM listings WHERE url='$url'");
while($row = mysqli_fetch_array($result))
{
$id = $row['id'];
$code = $row['code'];
$title = $row['title'];
$cat = $row['cat'];
$sub = $row['sub'];
$sub_type = $row['sub_type'];
$email = $row['email'];
$phone = $row['phone'];
$address = $row['address'];
$district = $row['district'];
$country = $row['country'];
$reg_no = $row['reg_no'];
$hr_open = $row['hr_open'];
$hr_close = $row['hr_close'];
$services = $row['services'];
$paragraph1 = $row['paragraph1'];
$phone1 = $row['phone1'];
$phone2 = $row['phone2'];
$facebook = $row['facebook'];
$instagram = $row['instagram'];
$twitter = $row['twitter'];
$youtube = $row['youtube'];
$website = $row['website'];
$image = $row['image'];
$image1 = $row['image1'];
$image2 = $row['image2'];
$image3 = $row['image3'];
$image4 = $row['image4'];
$image5 = $row['image5'];
$image6 = $row['image6'];
$summ1 = $row['summ1'];
$summ2 = $row['summ2'];
$summ3 = $row['summ3'];
$summ4 = $row['summ4'];
$summ5 = $row['summ5'];
$summ6 = $row['summ6'];
$url = $row['url'];
$timestamp = $row['timestamp'];
if ($row['g_maps']) {
$g_maps = $row['g_maps'];
} else {
$g_maps = '#!';
}
if ($row['cat']=="Tour Operator") {
$icon = '<i class="fa fa-user-tie"></i>';
$i_link = 'listings/tour-operators';
}
if ($row['cat']=="Tour Guide") {
$icon = '<i class="fa fa-person-hiking"></i>';
$i_link = 'listings/tour-guides';
}
if ($row['cat']=="Hospitality Facility") {
$icon = '<i class="fa fa-hotel"></i>';
$i_link = 'listings/hospitality-facilities';
}
if ($row['cat']=="Travel Agency") {
$icon = '<i class="fa fa-bus"></i>';
$i_link = 'listings/travel-agencies';
}
if ($row['cat']=="Tourist Attraction") {
$icon = '<i class="fa fa-dog"></i>';
$i_link = 'listings/tourist-attractions';
}
if ($row['cat']=="Important Stakeholder") {
$icon = '<i class="fa fa-institution"></i>';
$i_link = 'listings/important-stakeholders';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title><?php echo $title; ?> | Tourism Fraternity Network ©</title>
<meta name="description" content="A premier online listing for businesses and travelers, discover more about <?php echo $title; ?>">
<meta name="keywords" content="<?php echo $title; ?>, <?php echo $services; ?>">
<link rel="shortcut icon" type="image/x-icon" href="../../assets/images/favicon.png" />
<!-- Social Share Data -->
<meta content="text/html; charset=utf-8" name="Content-Type">
<meta property="og:type" content="article">
<meta property="og:image" content="https://tourismfraternity.com/admin/listings/images/<?php echo $image; ?>">
<!-- Less than 65 characters -->
<meta property="og:title" content="<?php echo $title; ?> | Tourism Fraternity Network ©">
<meta property="og:url" content="https://tourismfraternity.com/listings/1/?url=<?php echo $url; ?>">
<!-- Less than 300 characters -->
<meta property="og:description" content="A premier online listing for businesses and travelers, discover more about <?php echo $title; ?>">
<meta property="og:site_name" content="<?php echo $title; ?> | Tourism Fraternity Network ©">
<!-- Twitter Cards -->
<meta name="twitter:card" content="summary_large_image">
<meta name="twitter:url" content="https://tourismfraternity.com/listings/1/?url=<?php echo $url; ?>">
<meta name="twitter:title" content="<?php echo $title; ?> | Tourism Fraternity Network ©">
<meta name="twitter:description" content="A premier online listing for businesses and travelers, discover more about <?php echo $title; ?>">
<meta name="twitter:image" content="https://tourismfraternity.com/admin/listings/images/<?php echo $image; ?>">
<meta name="twitter:site" content="@tourism_fraternity_ug">
<meta name="twitter:creator" content="@iann_thecreator">
<!-- Plugin css -->
<link rel="stylesheet" type="text/css" href="../../assets/css/font-awesome.min.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/fonts/flaticon.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/bootstrap.min.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/animate.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/swiper.min.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/lightcase.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/jquery.nstSlider.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/flexslider.css" media="all" />
<!-- own style css -->
<link rel="stylesheet" type="text/css" href="../../assets/css/style.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/rtl.css" media="all" />
<link rel="stylesheet" type="text/css" href="../../assets/css/responsive.css" media="all" />
<!--Animations-->
<link rel="stylesheet" type="text/css" href="../../assets/css/animations/style.css">
<!--Fontawesome 6-->
<link href="../../assets/css/fontawesome/css/all.css" rel="stylesheet">
<link href="../../assets/css/datatable/dataTable.bootstrap.min.css" rel="stylesheet">
</head>
<body>
<!-- Start Pre-Loader-->
<div id="loading">
<div id="loading-center">
<div id="loading-center-absolute">
<div class="object" id="object_one"></div>
<div class="object" id="object_two"></div>
<div class="object" id="object_three"></div>
<div class="object" id="object_four"></div>
</div>
</div>
</div>
<!-- End Pre-Loader -->
<div class="box-layout">
<header class="header-style-1">
<div class="bg-header-top d-lg-none">
<div class="container">
<div class="row">
<div class="header-top">
<div class="row">
<div class="col-lg-3 col-12">
<div class="d-flex flex-wrap justify-content-between">
<a href="../../"><img src="../../assets/images/logo/2.png" alt="logo" class="img-responsive" /></a>
<button type="button" class="navbar-toggler collapsed d-lg-none" data-bs-toggle="collapse" data-bs-target="#bs-example-navbar-collapse-1" aria-controls="bs-example-navbar-collapse-1" aria-expanded="false">
<span class="navbar-toggler-icon">
<i class="fa fa-bars"></i>
</span>
</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- .bg-header-top -->
<!-- Start Menu -->
<div class="bg-main-menu menu-scroll">
<div class="container">
<div class="row">
<div class="main-menu p-0">
<div class="main-menu-bottom">
<div class="main-menu-area w-100">
<div class="navbar-collapse collapse" id="bs-example-navbar-collapse-1">
<a href="../../" class="d-none d-lg-block"><img src="../../assets/images/logo/1.png" alt="logo" class="img-responsive" /></a>
<ul>
<li><a href="../../" class="active">HOME</a></li>
<li>
<a href="#">Listings</a>
<ul class="sub-menu">
<li><a href="../../listings/tour-operators"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Operators/ Companies</a></li>
<li><a href="../../listings/tour-guides"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Guides</a></li>
<li>
<a href="#"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Hospitality Facilities</a>
<ul class="sub-sub-menu">
<li><a href="../../listings/hospitality-facilities/hotels"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Hotels</a></li>
<li><a href="../../listings/hospitality-facilities/motels"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Motels</a></li>
<li><a href="../../listings/hospitality-facilities/lodges"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Lodges</a></li>
<li><a href="../../listings/hospitality-facilities/restaurants"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Restaurants</a></li>
<li><a href="../../listings/hospitality-facilities/night-clubs"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Night Clubs</a></li>
</ul>
</li>
<li><a href="../../listings/travel-agencies"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Travel Agencies</a></li>
<li>
<a href="#"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tourist Attractions</a>
<ul class="sub-sub-menu">
<li><a href="../../listings/tourist-attractions/national-parks"><i class="fa fa-angle-double-right" aria-hidden="true"></i> National Parks</a></li>
<li><a href="../../listings/tourist-attractions/game-reserves"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Game Reserves</a></li>
<li><a href="../../listings/tourist-attractions/eco"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Eco</a></li>
<li><a href="../../listings/tourist-attractions/cultural"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Cultural</a></li>
<li><a href="../../listings/tourist-attractions/religious"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Religious</a></li>
<li><a href="../../listings/tourist-attractions/birding"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Birding</a></li>
<li><a href="../../listings/tourist-attractions/waters"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Waters</a></li>
<li><a href="../../listings/tourist-attractions/mountains"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Mountains</a></li>
<li><a href="../../listings/tourist-attractions/antiquities"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Antiquities</a></li>
<li><a href="../../listings/tourist-attractions/others"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Others</a></li>
</ul>
</li>
<li>
<a href="#"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Important Stakeholders</a>
<ul class="sub-sub-menu">
<li><a href="../../listings/important-stakeholders/ministries"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Ministries</a></li>
<li><a href="../../listings/important-stakeholders/regulators"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Regulators</a></li>
</ul>
</li>
</ul>
</li>
<li>
<a href="#">Categories</a>
<ul class="sub-menu">
<li><a href="../../listings/hospitality-facilities"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Hotels/ Lodges</a></li>
<li><a href="../../listings/tour-operators"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Operators</a></li>
<li><a href="../../listings/tour-guides"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Guides</a></li>
<li><a href="../../listings/travel-agencies"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Travel Agencies</a></li>
<li><a href="../../listings/tourist-attractions"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tourist Attractions</a></li>
<li><a href="../../events"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Events</a></li>
</ul>
</li>
<li><a href="../../blogs">Blogs</a></li>
<li><a href="../../about-us">About Us</a></li>
<li><a href="../../contact-us">contact Us</a></li>
</ul>
<div class="menu-right-option pull-right">
<div class="cart-option">
<div class="cart-icon">
<i class="fa fa-door-open" aria-hidden="true"></i>
</div>
<div class="cart-dropdown-menu">
<div class="cart-items">
<div class="cart-img">
<i class="fa fa-briefcase"></i>
</div>
<div class="cart-content">
<h6><a href="../../businesses">For businesses</a></h6>
</div>
<div class="cart-btn">
<a href="../../businesses"><i class="fa fa-angle-right" aria-hidden="true"></i></a>
</div>
<div class="clr"></div>
</div>
<div class="cart-items">
<div class="cart-img">
<i class="fa fa-car"></i>
</div>
<div class="cart-content">
<h6><a href="../../travelers">For Travelers</a></h6>
</div>
<div class="cart-btn">
<a href="../../travelers"><i class="fa fa-angle-right" aria-hidden="true"></i></a>
</div>
<div class="clr"></div>
</div>
<div class="checkout-btn">
<a href="../../add-listing" class="btn btn-default"><i class="fa fa-circle-plus"></i> Add Listing</a>
</div>
</div>
</div>
<div class="search-box">
<i class="fa fa-search first_click" aria-hidden="true" style="display: block;"></i>
<i class="fa fa-times second_click" aria-hidden="true" style="display: none;"></i>
</div>
<div class="donate-option">
<a href="../../add-listing">Add Listing <i class="fa fa-caret-right float-bounce-right" aria-hidden="true"></i></a>
</div>
<div class="search-box-text">
<form action="../../search/index.php" method="POST">
<input type="search" name="valueToSearch" id="all-search" placeholder="Search Here" required>
<input type="submit" name="search" class="username">
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</header>
<!-- Start Page Header Section -->
<section class="bg-page-header">
<div class="page-header-overlay">
<div class="container">
<div class="row">
<div class="page-header">
<div class="page-title">
<h2><?php echo $title; ?></h2>
</div>
<!-- .page-title -->
<div class="page-header-content">
<ol class="breadcrumb one">
<li><a href="../../">Home</a></li>
<li><a href="../">Listings</a></li>
<li><?php echo $title; ?></li>
</ol>
</div>
<!-- .page-header-content -->
</div>
<!-- .page-header -->
</div>
<!-- .row -->
</div>
<!-- .container -->
</div>
<!-- .page-header-overlay -->
</section>
<!-- End Page Header Section -->
<!--================ Session Handler Start =================-->
<div class="session_handler">
<?php
if(isset($_SESSION['error'])){
echo "<div class='alert alert-danger text-center'>
<button class='close'>×</button>
".$_SESSION['error']."
</div>";
unset($_SESSION['error']);
}
if(isset($_SESSION['success'])){
echo "<div class='alert alert-success text-center'>
<button class='close'>×</button>
".$_SESSION['success']."
</div>";
unset($_SESSION['success']);
}
?>
</div>
<!--================ Session Handler End =================-->
<!-- Start Single Events Section -->
<section class="bg-single-blog">
<div class="container">
<div class="row">
<div class="single-blog">
<div class="row">
<div class="col-lg-8">
<div class="blog-items">
<div class="blog-content">
<h4><?php echo $title; ?></h4>
</div>
<div class="blog-img">
<?php
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image.'" alt="'.$title.'">';
?>
</div>
<!-- .blog-img -->
<div class="blog-content-box">
<div class="meta-box">
<div class="event-author-option">
<!-- .author-img -->
<div class="author-icon">
<span class="work-icons">
<?php echo $icon; ?>
</span>
</div>
<div class="event-author-name">
<p>
<a href="../../<?php echo $i_link; ?>"><?php echo $cat; ?></a>
<a><?php if ($sub_type) { echo ' | '.$sub_type.''; } ?></a>
</p>
</div>
<!-- .author-name -->
</div>
<!-- .author-option -->
<ul class="meta-post one">
<li><a href="tel:<?php echo $phone; ?>"><i class="fa fa-phone" title="<?php echo $phone; ?>"></i></a></li>
<li><a href="mailto:<?php echo $email; ?>"><i class="fa fa-envelope" title="<?php echo $email; ?>"></i></a></li>
<li><a href="#review"><i class="fa fa-commenting-o" aria-hidden="true"></i></a> <span class="count-box" style="font-size: 8px;"></span></li>
</ul>
</div>
<!-- .contend start -->
<div class="single-blog-bottom">
<?php if ($reg_no) {
echo '<ul class="tags one">
<li><i class="fa fa-check-circle" aria-hidden="true"></i></li>
<li>'.$reg_no.'</li>
</ul>'; }
?>
<!-- .author-option -->
<?php if ($phone1 || $phone2) {
echo '<ul class="tags two" style="margin-left: 15px;">';
echo '<li><i class="fa fa-mobile" aria-hidden="true"></i></li>';
echo '<li style="font-size: 12px;font-weight: 500;">';
if ($phone1) {
echo '<a href="tel:'.$phone1.'" style="color: #F7970F; font-size: 12px;">'.$phone1.'</a>'; }
if ($phone1 & $phone2) {
echo ' | '; }
if ($phone2) {
echo '<a href="tel:'.$phone2.'" style="color: #F7970F; font-size: 12px;">'.$phone2.'</a>'; }
echo '</li>';
echo '</ul>';
}
?>
<?php
if ($facebook || $instagram || $twitter || $youtube || $website) {
echo '<div class="event-share-option">';
echo '<ul class="social-icon primary-icon">';
echo '<li><span>Socials :</span></li>';
if ($facebook) {
echo '<li><a href="https://facebook.com/'.$facebook.'" target="_blank"><i class="fab fa-facebook"></i></a></li>';
}
if ($instagram) {
echo '<li><a href="https://instagram.com/'.$instagram.'" target="_blank"><i class="fab fa-instagram"></i></a></li>';
}
if ($twitter) {
echo '<li><a href="https://x.com/'.$twitter.'" target="_blank"><i class="fab fa-x-twitter"></i></a></li>';
}
if ($youtube) {
echo '<li><a href="https://youtube.com/'.$youtube.'" target="_blank"><i class="fab fa-youtube-play"></i></a></li>';
}
if ($website) {
echo '<li><a href="'.$website.'" target="_blank"><i class="fa fa-globe"></i></a></li>';
}
echo '</ul>';
echo '</div>';
}
?>
</div>
<!-- .contend end -->
<!-- .meta-box -->
<div class="blog-content">
<?php
if ($reg_no || $phone1 || $phone2 || $facebook || $instagram || $twitter || $youtube || $website) {
echo '<hr>';
}
?>
<p class="quate-para"><?php echo stripslashes($services);?></p>
<?php if ($paragraph1) {
echo'<p>'.$paragraph1.'</p> <br>';
}
?>
<div class="row">
<?php
//Image 1
if ($image1) {
if (!empty($image1) & empty($image2)) {
echo '<div class="col-12">';
} elseif (!empty($image1) & !empty($image2) & empty($image3)) {
echo '<div class="col-6">';
} else {
echo '<div class="col-4">';
}
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image1.'" alt="'.$summ1.'">';
if ($summ1) {
echo '<p class="text-center"><i>'.$summ1.'</i></p>';
}
echo '</div>';
}
//Image 2
if ($image2) {
if (!empty($image2) & empty($image3)) {
echo '<div class="col-6">';
} else {
echo '<div class="col-4">';
}
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image2.'" alt="'.$summ2.'">';
if ($summ2) {
echo '<p class="text-center"><i>'.$summ2.'</i></p>';
}
echo '</div>';
}
//Image 3
if ($image3) {
echo '<div class="col-4">';
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image3.'" alt="'.$summ3.'">';
if ($summ3) {
echo '<p class="text-center"><i>'.$summ3.'</i></p>';
}
echo '</div>';
}
?>
<?php
//Image 4
if ($image4) {
if (!empty($image4) & empty($image5)) {
echo '<div class="col-12">';
} elseif (!empty($image4) & !empty($image5) & empty($image6)) {
echo '<div class="col-6">';
} else {
echo '<div class="col-4">';
}
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image4.'" alt="'.$summ4.'">';
if ($summ4) {
echo '<p class="text-center"><i>'.$summ4.'</i></p>';
}
echo '</div>';
}
//Image 5
if ($image5) {
if (!empty($image5) & empty($image6)) {
echo '<div class="col-6">';
} else {
echo '<div class="col-4">';
}
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image5.'" alt="'.$summ5.'">';
if ($summ5) {
echo '<p class="text-center"><i>'.$summ5.'</i></p>';
}
echo '</div>';
}
//Image 6
if ($image6) {
echo '<div class="col-4">';
echo '<img class="img-responsive" src="../../admin/listings/images/'.$image6.'" alt="'.$summ6.'">';
if ($summ6) {
echo '<p class="text-center"><i>'.$summ6.'</i></p>';
}
echo '</div>';
}
?>
</div>
</div>
<!-- .blog-content -->
<div class="single-blog-bottom">
<ul class="tags one">
<li><i class="fa fa-map-marker" aria-hidden="true"></i></li>
<li><a><?php echo ''.$address.', '.$district.' ('.$country.')'; ?></a></li>
</ul>
<!-- .author-option -->
<div class="event-share-option">
<ul class="social-icon share-icon">
<li><i class="fa fa-share-alt" aria-hidden="true"></i><span>share :</span></li>
<li><a href="https://facebook.com/sharer.php?u=https://tourismfraternity.com/listings/1/?url=<?php echo $url;?>&text=Checkout <?php echo $title;?> on the Tourism Fraternity Network" target="_blank"><i class="fab fa-facebook"></i></a></li>
<li><a href="https://twitter.com/intent/tweet?url=https://tourismfraternity.com/listings/1/?url=<?php echo $url;?>&text=Checkout <?php echo $title;?> on the Tourism Fraternity Network" target="_blank"><i class="fab fa-x-twitter"></i></a></li>
<li><a href="https://www.linkedin.com/shareArticle?mini=true &url=https://tourismfraternity.com/listings/1/?url=<?php echo $url;?>&text=Checkout <?php echo $title;?> on the Tourism Fraternity Network" target="_blank"><i class="fab fa-linkedin"></i></a></li>
<li><a href="whatsapp://send?text=<?php echo $title;?> %0D%0A Checkout <?php echo $title;?> on the Tourism Fraternity Network https://tourismfraternity.com/listings/1/?url=<?php echo $url;?>" target="_blank"><i class="fab fa-whatsapp"></i></a></li>
<li><a href="mailto:?subject=Checkout <?php echo $title;?> on the Tourism Fraternity Network&body=<?php echo $paragraph1;?> Checkout <?php echo $title;?> on the Tourism Fraternity Network https://tourismfraternity.com/listings/1/?url=<?php echo $url;?>"><i class="fa fa-envelope"></i></a></li>
</ul>
</div>
<!-- .share-option -->
</div>
<!-- .single-blog-bottom -->
</div>
<!-- .blog-content-box -->
</div>
<!-- .blog-items -->
<div id="review" class="review-box"></div>
<div class="comments-form">
<h4 class="comments-title">Leave A <span class="text-orange">Review</span></h4>
<form method="POST" action="reviews/index.php" enctype="multipart/form-data">
<input type="hidden" class="form-control" name="listing_id" value="<?php echo $code; ?>">
<input type="hidden" class="form-control" name="listing" value="<?php echo $listing; ?>">
<input type="hidden" class="form-control" name="url" value="<?php echo $url; ?>">
<div class="row">
<!--Star Rating Start-->
<div class="col-lg-12 col-md-12" align="center">
<div class="rating-form">
<ul>
<label for="one" class="one"><input type="radio" name="rate" class="filter"value="1" required><li><i class="fa fa-star"></i></li>
</label>
<label for="two" class="two"><input type="radio" name="rate" class="filter"value="2"><li><i class="fa fa-star"></i></li>
</label>
<label for="three" class="three"><input type="radio" name="rate" class="filter" value="3"><li><i class="fa fa-star"></i></li>
</label>
<label for="four" class="four"><input type="radio" name="rate" class="filter" value="4"><li><i class="fa fa-star"></i></li>
</label>
<label for="five" class="five"><input type="radio" name="rate" class="filter" value="5"><li><i class="fa fa-star"></i></li>
</label>
</ul>
</div> <br>
</div>
<!--Star Rating End-->
<div class="col-md-12 username">
<div class="form-group">
<input type="text" class="form-control" name="username" placeholder="Enter username">
</div>
</div>
<!-- .col-md-12 -->
<div class="col-md-6">
<div class="form-group">
<input type="text" class="form-control" name="name" placeholder="Enter Names" required>
</div>
</div>
<!-- .col-md-6 -->
<div class="col-md-6">
<div class="form-group">
<input type="email" class="form-control" name="email" placeholder="Enter Email Address" required>
</div>
</div>
<!-- .col-md-6 -->
</div>
<!-- .row -->
<textarea class="form-control comments-textarea" name="review" placeholder="Your Comment" required></textarea>
<button type="submit" name="submit" class="btn btn-default">Post Review</button>
</form>
<p class="comment_box"></p>
</div>
<!-- .comments-form -->
</div>
<div class="col-lg-4">
<div class="sidebar">
<!-- .widget
<div class="widget">
<div class="widget-content">
<form action="#" method="POST" class="sidebar-form">
<div class="form-group">
<input type="text" class="form-control" id="searchId" name="search" placeholder="Search...">
<i class="fa fa-search" aria-hidden="true"></i>
</div>
</form>
</div>
</div>
.widget -->
<div class="widget">
<h4 class="sidebar-widget-title">Latest <span class="text-orange">Listings</span></h4>
<div class="widget-content">
<ul class="popular-news-option">
<?php
//Image Blog
$sql = "SELECT * FROM listings WHERE code!='$code' AND deleted='' ORDER BY id DESC LIMIT 3";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
echo '<li class="latest-img"><a href="./?url='.$row["url"].'"><img src="../../admin/listings/images/'.$row["image"].'" alt="'.$row["title"].'"/> <b>'.$row["title"].'</b> - <span style="font-size: 10px;">'.$row["cat"].'</span></a></li>';
}
?>
</ul>
</div>
<!-- .widget-content -->
</div>
<!-- .widget -->
<div class="widget">
<h4 class="sidebar-widget-title">Top <span class="text-orange">Categories</span></h4>
<div class="widget-content">
<ul class="catagories">
<?php
$sql = "SELECT COUNT(*), cat FROM listings WHERE deleted='' GROUP BY cat ORDER BY id DESC";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
if ($row['cat']=="Tour Operator") {
$c_title = 'Tour Operators';
$c_link = 'listings/tour-operators';
}
if ($row['cat']=="Tour Guide") {
$c_title = 'Tour Guides';
$c_link = 'listings/tour-guides';
}
if ($row['cat']=="Hospitality Facility") {
$c_title = 'Hospitality Facilities';
$c_link = 'listings/hospitality-facilities';
}
if ($row['cat']=="Travel Agency") {
$c_title = 'Travel Agencies';
$c_link = 'listings/travel-agencies';
}
if ($row['cat']=="Tourist Attraction") {
$c_title = 'Tourist Attractions';
$c_link = 'listings/tourist-attractions';
}
if ($row['cat']=="Important Stakeholder") {
$c_title = 'Important Stakeholders';
$c_link = 'listings/important-stakeholders';
}
echo '<li><a href="../../'.$c_link.'"><i class="fa fa-angle-double-right" aria-hidden="true"></i> '.$c_title.' <span>'.number_format($row["COUNT(*)"]).'</span></a></li>';
}
?>
</ul>
</div>
<!-- .widget-content -->
</div>
<!-- .widget -->
<div class="widget">
<h4 class="sidebar-widget-title">Popular <span class="text-orange">Blogs</span></h4>
<div class="widget-content">
<ul class="popular-news-option">
<?php
//Image Blog
$sql = "SELECT * FROM blogs WHERE deleted='' ORDER BY id DESC LIMIT 4";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
echo '<li>';
echo '<div class="popular-news-img">';
echo '<a href="../../blogs/single/?blog='.$row["code"].'">';
if ($row["blog_type"]=='Image') {
echo '<img src="../../admin/blogs/images/'.$row['image1'].'" alt="'.$row['title'].'" />';
} elseif ($row["blog_type"]=='Video') {
echo '<video autoplay muted>
<source src="../../admin/blogs/video-blogs/videos/'.$row["vid1"].'" type="video/mp4">
</video>';
}
echo '</a>';
echo '</div>';
echo '<div class="popular-news-contant">';
echo '<h5><a href="../../blogs/single/?blog='.$row["code"].'">'.substr($row['title'], 0, 50).'.<span class="flash">.</span></a></h5>';
echo '<p>'.date("jS M, Y", strtotime($row["timestamp"])).'</p>';
echo '</div>';
echo '</li>';
}
?>
</ul>
</div>
<!-- .widget-content -->
</div>
<!-- .widget -->
<div class="widget">
<h4 class="sidebar-widget-title">Our <span class="text-orange">Media</span></h4>
<div class="widget-content">
<div class="gallery-instagram">
<?php
//Image Blog
$sql = "SELECT * FROM blogs WHERE deleted='' ORDER BY rand() LIMIT 12";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
if ($row["blog_type"]=='Image') {
echo '<a href="../../blogs/single/?blog='.$row["code"].'"><img src="../../admin/blogs/images/'.$row["image1"].'" alt="'.$title.'"></a>';
} elseif ($row["blog_type"]=='Video') {
echo '<a href="../../blogs/single/?blog='.$row["code"].'"><video autoplay muted><source src="../../admin/blogs/video-blogs/videos/'.$row["vid1"].'"></video></a>';
}
}
?>
</div>
<!-- .gallery-instagram -->
</div>
<!-- .widget-content -->
</div>
<!-- .widget -->
<div class="widget">
<h4 class="sidebar-widget-title">Popular <span class="text-orange">Tags</span></h4>
<div class="widget-content">
<div class="tag-cloud">
<?php
$sql = "SELECT * FROM blogs WHERE deleted='' GROUP BY topic ORDER BY id DESC LIMIT 12";
//use for MySQLi-OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
echo '<a href="../../blogs/single/?blog='.$row["code"].'" class="btn">'.$row["topic"].'</a>';
}
?>
</div>
<!-- .tag-cloud -->
</div>
<!-- .widget-content -->
</div>
<!-- .widget -->
</div>
<!-- .sidebar -->
</div>
</div>
<!-- .row -->
</div>
<!-- .single-blog -->
</div>
<!-- .row -->
</div>
<!-- .container -->
</section>
<!-- End Single Events Section -->
<!-- Start Footer Section -->
<footer>
<div class="bg-footer-bottom">
<div class="container">
<div class="row">
<div class="footer-bottom">
<div class="row">
<div class="col-lg-4 col-sm-4 col-12">
<ul class="social-icon-rounded">
<li><a href="#"><i class="fab fa-facebook" title="Facebook"></i></a></li>
<li><a href="#"><i class="fab fa-instagram" title="Instagram"></i></a></li>
<li><a href="#"><i class="fab fa-x-twitter" title="Twitter"></i></a></li>
<li><a href="#"><i class="fab fa-youtube-play" title="YouTube"></i></a></li>
</ul>
</div>
<!-- .social-box -->
<div class="col-lg-4 col-sm-4 col-12">
<p class="text-center"><a href="#">Tourism Fraternity</a> © <script>document.write(new Date().getFullYear());</script>, All Rights Reserved.</p>
</div>
<!-- .copyright-txt -->
<div class="col-lg-4 col-sm-4 col-12">
<p style="font-size: 12px;color: #777;text-align: right;">Powered By <a href="#!" style="color: #777;">Custom Assist Inc<span class="flash">.</span></a></p>
</div>
<!-- .copyright-txt -->
</div>
</div>
<!-- .footer-bottom -->
</div>
<!-- .row -->
</div>
<!-- .container -->
</div>
<!-- .bg-footer-bottom -->
</footer>
<!-- End Footer Section -->
<!-- Start Scrolling -->
<div class="scroll-img"><i class="fa fa-angle-up" aria-hidden="true"></i></div>
<!-- End Scrolling -->
</div>
<script type="text/javascript" src="../../assets/js/jquery-2.2.3.min.js"></script>
<script type="text/javascript" src="../../assets/js/bootstrap.min.js"></script>
<script type="text/javascript" src="../../assets/js/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="../../assets/js/jquery.waypoints.min.js"></script>
<script type="text/javascript" src="../../assets/js/jquery.counterup.min.js"></script>
<script type="text/javascript" src="../../assets/js/swiper.min.js"></script>
<script type="text/javascript" src="../../assets/js/plugins.isotope.js"></script>
<script type="text/javascript" src="../../assets/js/isotope.pkgd.min.js"></script>
<script type="text/javascript" src="../../assets/js/lightcase.js"></script>
<script type="text/javascript" src="../../assets/js/jquery.nstSlider.js"></script>
<script type="text/javascript" src="../../assets/js/jquery.flexslider.js"></script>
<script type="text/javascript" src="../../assets/js/custom.isotope.js"></script>
<script type="text/javascript" src="../../assets/js/custom.map.js"></script>
<script type="text/javascript" src="../../assets/js/custom.js"></script>
<script src="../../assets/js/datatable/jquery.dataTables.min.js"></script>
<script src="../../assets/js/datatable/dataTable.bootstrap.min.js"></script>
<script>
const reviewBox = document.querySelector(".review-box");
setInterval(() =>{
let xhr = new XMLHttpRequest();
xhr.open("GET", "../../admin/counter/get-review/?listing_id=<?php echo $code; ?>", true);
xhr.onload = ()=>{
if(xhr.readyState === XMLHttpRequest.DONE){
if(xhr.status === 200){
let data = xhr.response;
reviewBox.innerHTML = data;
}
}
}
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xhr.send();
}, 500);
</script>
<script>
const countBox = document.querySelector(".count-box");
setInterval(() =>{
let xhr = new XMLHttpRequest();
xhr.open("GET", "../../admin/counter/get-review-count/?listing_id=<?php echo $code; ?>", true);
xhr.onload = ()=>{
if(xhr.readyState === XMLHttpRequest.DONE){
if(xhr.status === 200){
let data = xhr.response;
countBox.innerHTML = data;
}
}
}
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xhr.send();
}, 500);
</script>
<script>
$(document).ready(function() {
var delay = 500;
$('#newsletter').click(function(e){
e.preventDefault();
var username = $('#username').val();
var newsletter = $('#newsletter').val();
var email = $('#email').val();
if(email == ''){
$('.message_box').html(
'<span style="color:#F7931D;">Enter an email address!</span>'
);
$('#email').focus();
return false;
}
if( $("#email").val()!='' ){
if( !isValidEmailAddress( $("#email").val() ) ){
$('.message_box').html(
'<span style="color:#F7931D;">Provided email address is incorrect!</span>'
);
$('#email').focus();
return false;
}
}
$.ajax
({
type: "POST",
url: "../../contact/newsletters/index.php",
data: "email="+email+"&username="+username+"&newsletter="+newsletter,
beforeSend: function() {
$('.message_box').html(
'<div align="center"><img src="../../image/ajax.gif" width="25" height="25"/></div>'
);
},
success: function(data)
{
setTimeout(function() {
$('.message_box').html(data);
}, delay);
}
});
});
});
//Email validation Function
function isValidEmailAddress(emailAddress) {
var pattern = /^([a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+(\.[a-z\d!#$%&'*+\-\/=?^_`{|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+)*|"((([ \t]*\r\n)?[ \t]+)?([\x01-\x08\x0b\x0c\x0e-\x1f\x7f\x21\x23-\x5b\x5d-\x7e\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|\\[\x01-\x09\x0b\x0c\x0d-\x7f\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))*(([ \t]*\r\n)?[ \t]+)?")@(([a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.)+([a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]|[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]*[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.?$/i;
return pattern.test(emailAddress);
};
</script>
<script>
$(document).ready(function(){
//inialize datatable
$('#myTable').DataTable();
//hide alert
$(document).on('click', '.close', function(){
$('.alert').hide();
})
});
</script>