impetrator

Back Back Up Advanced Editor

<?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 &copy;</title>

<meta property="og:title" content="<?php echo $title; ?> | Tourism Fraternity Network &copy;">

<meta property="og:description" content="A premier online listing for businesses and travelers, discover more about <?php echo $title; ?>">

<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" />

<link rel="stylesheet" type="text/css" href="../../assets/css/animations/style.css">

<link href="../../assets/css/fontawesome/css/all.css" rel="stylesheet">

</head>

<body>

<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>

<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>&nbsp; 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 &nbsp;&nbsp;<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>

<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>
                            
                            <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>
                            
                        </div>
                        
                    </div>
                    
                </div>
                
            </div>
            
        </section>

<div class="session_handler">
<?php
        if(isset($_SESSION['error'])){
          echo "<div class='alert alert-danger text-center'>
            <button class='close'>&times;</button>
            ".$_SESSION['error']."
          </div>";
          unset($_SESSION['error']);
        }
        if(isset($_SESSION['success'])){
          echo "<div class='alert alert-success text-center'>
            <button class='close'>&times;</button>
            ".$_SESSION['success']."
          </div>";
          unset($_SESSION['success']);
        }
      ?>
</div>

<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>
                                    
                                    <div class="blog-content-box">
                                        <div class="meta-box">
                                            <div class="event-author-option">
                                                
                                                <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>
                                                
                                            </div>
                                            
                                            <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>
                                        
                                        <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>'; } 
                                            ?>
                                            
                                            <?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>
                                        
                                        
                                        <div class="blog-content">
                                            
                                            <?php 
                                              if ($reg_no || $phone1 || $phone2 || $facebook || $instagram || $twitter || $youtube || $website) {
                                                echo '<hr>'; 
                                               }
                                            ?>

<?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>
                                        
                                        <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>
                                            
                                            <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 &amp;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>
                                            
                                        </div>
                                        
                                    </div>
                                    
                                </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">

<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>

</div>
                                        
                                        <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>

</div>
                            <div class="col-lg-4">
                                <div class="sidebar">

<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>
                                        
                                    </div>

<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>
                                        
                                    </div>
                                    
                                    <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>
                                        
                                    </div>
                                    
                                    <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>
                                            
                                        </div>
                                        
                                    </div>
                                    
                                    <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>
                                            
                                        </div>
                                        
                                    </div>
                                    
                                </div>
                                
                            </div>
                        </div>
                        
                    </div>
                    
                </div>
                
            </div>
            
        </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>
                            
                            <div class="col-lg-4 col-sm-4 col-12">
                                <p class="text-center"><a href="#">Tourism Fraternity</a> &copy; <script>document.write(new Date().getFullYear());</script>, All Rights Reserved.</p>
                            </div>
                            
                            <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>
                            
                        </div>

</div>
                        
                    </div>
                    
                </div>
                
            </div>

</footer>

<div class="scroll-img"><i class="fa fa-angle-up" aria-hidden="true"></i></div>
        
    </div>

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>

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>

var newsletter = $('#newsletter').val();

//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>

//hide alert
    $(document).on('click', '.close', function(){
      $('.alert').hide();
    })
});
</script>